摘要：
1.目的：Use the SAVEPOINT statement to identify a point in a transaction to which you can later roll back.使用检查点语句标识一个事务点以便在后面可以回滚。2. 预备知识：无。3.语法：SAVEPOINT savepoint ;4.下面来看示例：1）首先看一下员工表中Banda的工资SQL> select employee_id, last_name, salary from employees where last_name='Banda';EMPLOYEE_ID LAST 阅读全文
摘要：
1. 建立SETfnd_flex_val_api.create_valueset_independent(v_set_name ,v_description ,v_security ,v_enable_longlist ,v_format_type... 阅读全文
摘要：
--更改职责fnd_user_resp_groups_api.update_assignment(user_id => v_user_id ,responsibility_id => v_resp_id ,responsibility_application_id => v_appl_id ... 阅读全文
摘要：
1.检查存在性，如没有则新增fnd_flex_keyval.validate_segs('CREATE_COMBINATION' ,'SQLGL' ,'GL#' ,lv_chart_of_accounts_id ,lv_concatenated_segments);fnd_flex_keyval.error_message 返回错误消息fnd_flex_keyval.combination_id 返回新生成的组合的code_combination_id 阅读全文