44: c_insertion_record2 ame_util.insertionRecord2;
45: lv_parameter varchar2(650);
46: BEGIN
47:
48: hr_utility.set_location('Entering: insert_ame_approver', 1);
49: hr_utility.trace('p_application_id=' || p_application_id);
50: hr_utility.trace('p_transaction_type=' || p_transaction_type);
51: hr_utility.trace('p_transaction_id=' || p_transaction_id);
52: hr_utility.trace('inserting approver ' || p_approverIn(1).name);
45: lv_parameter varchar2(650);
46: BEGIN
47:
48: hr_utility.set_location('Entering: insert_ame_approver', 1);
49: hr_utility.trace('p_application_id=' || p_application_id);
50: hr_utility.trace('p_transaction_type=' || p_transaction_type);
51: hr_utility.trace('p_transaction_id=' || p_transaction_id);
52: hr_utility.trace('inserting approver ' || p_approverIn(1).name);
53: hr_utility.trace('inserting approver id= ' || p_approverIn(1).orig_system_id);
46: BEGIN
47:
48: hr_utility.set_location('Entering: insert_ame_approver', 1);
49: hr_utility.trace('p_application_id=' || p_application_id);
50: hr_utility.trace('p_transaction_type=' || p_transaction_type);
51: hr_utility.trace('p_transaction_id=' || p_transaction_id);
52: hr_utility.trace('inserting approver ' || p_approverIn(1).name);
53: hr_utility.trace('inserting approver id= ' || p_approverIn(1).orig_system_id);
54:
47:
48: hr_utility.set_location('Entering: insert_ame_approver', 1);
49: hr_utility.trace('p_application_id=' || p_application_id);
50: hr_utility.trace('p_transaction_type=' || p_transaction_type);
51: hr_utility.trace('p_transaction_id=' || p_transaction_id);
52: hr_utility.trace('inserting approver ' || p_approverIn(1).name);
53: hr_utility.trace('inserting approver id= ' || p_approverIn(1).orig_system_id);
54:
55: --Copy details from p_approverIn/p_insertionIn to c_approver_rec2
48: hr_utility.set_location('Entering: insert_ame_approver', 1);
49: hr_utility.trace('p_application_id=' || p_application_id);
50: hr_utility.trace('p_transaction_type=' || p_transaction_type);
51: hr_utility.trace('p_transaction_id=' || p_transaction_id);
52: hr_utility.trace('inserting approver ' || p_approverIn(1).name);
53: hr_utility.trace('inserting approver id= ' || p_approverIn(1).orig_system_id);
54:
55: --Copy details from p_approverIn/p_insertionIn to c_approver_rec2
56: c_approver_rec2.name := p_approverIn(1).name;
49: hr_utility.trace('p_application_id=' || p_application_id);
50: hr_utility.trace('p_transaction_type=' || p_transaction_type);
51: hr_utility.trace('p_transaction_id=' || p_transaction_id);
52: hr_utility.trace('inserting approver ' || p_approverIn(1).name);
53: hr_utility.trace('inserting approver id= ' || p_approverIn(1).orig_system_id);
54:
55: --Copy details from p_approverIn/p_insertionIn to c_approver_rec2
56: c_approver_rec2.name := p_approverIn(1).name;
57: c_approver_rec2.orig_system := p_approverIn(1).orig_system ;
111: transactionTypeIn=>p_transaction_type );
112: end;
113: end if;
114:
115: hr_utility.set_location('Leaving: insert_ame_approver', 2);
116: commit;
117: EXCEPTION
118: WHEN OTHERS THEN
119: rollback;
138: l_proc constant varchar2(100) := 'delete_ame_approver';
139: c_approver_rec2 ame_util.approverRecord2;
140: BEGIN
141:
142: hr_utility.set_location('Entering: delete_ame_approver', 1);
143: hr_utility.trace('p_application_id=' || p_application_id);
144: hr_utility.trace('p_transaction_type=' || p_transaction_type);
145: hr_utility.trace('p_transaction_id=' || p_transaction_id);
146: hr_utility.trace('deleting approver ' || p_approverIn(1).name);
139: c_approver_rec2 ame_util.approverRecord2;
140: BEGIN
141:
142: hr_utility.set_location('Entering: delete_ame_approver', 1);
143: hr_utility.trace('p_application_id=' || p_application_id);
144: hr_utility.trace('p_transaction_type=' || p_transaction_type);
145: hr_utility.trace('p_transaction_id=' || p_transaction_id);
146: hr_utility.trace('deleting approver ' || p_approverIn(1).name);
147:
140: BEGIN
141:
142: hr_utility.set_location('Entering: delete_ame_approver', 1);
143: hr_utility.trace('p_application_id=' || p_application_id);
144: hr_utility.trace('p_transaction_type=' || p_transaction_type);
145: hr_utility.trace('p_transaction_id=' || p_transaction_id);
146: hr_utility.trace('deleting approver ' || p_approverIn(1).name);
147:
148: -- copy details from p_approverIn to c_approver_rec2
141:
142: hr_utility.set_location('Entering: delete_ame_approver', 1);
143: hr_utility.trace('p_application_id=' || p_application_id);
144: hr_utility.trace('p_transaction_type=' || p_transaction_type);
145: hr_utility.trace('p_transaction_id=' || p_transaction_id);
146: hr_utility.trace('deleting approver ' || p_approverIn(1).name);
147:
148: -- copy details from p_approverIn to c_approver_rec2
149: c_approver_rec2.name := p_approverIn(1).name;
142: hr_utility.set_location('Entering: delete_ame_approver', 1);
143: hr_utility.trace('p_application_id=' || p_application_id);
144: hr_utility.trace('p_transaction_type=' || p_transaction_type);
145: hr_utility.trace('p_transaction_id=' || p_transaction_id);
146: hr_utility.trace('deleting approver ' || p_approverIn(1).name);
147:
148: -- copy details from p_approverIn to c_approver_rec2
149: c_approver_rec2.name := p_approverIn(1).name;
150: c_approver_rec2.item_class := p_approverIn(1).item_class;
175: );
176:
177: end;
178: end if;
179: hr_utility.set_location('Leaving: delete_ame_approver', 2);
180: commit;
181: EXCEPTION
182: WHEN OTHERS THEN
183: rollback;
267:
268:
269: BEGIN
270:
271: hr_utility.set_location('Entering: get_ame_apprs_and_ins_list', 1);
272: hr_utility.trace('p_application_id=' || p_application_id);
273: hr_utility.trace('p_transaction_type=' || p_transaction_type);
274: hr_utility.trace('p_transaction_id=' || p_transaction_id);
275:
268:
269: BEGIN
270:
271: hr_utility.set_location('Entering: get_ame_apprs_and_ins_list', 1);
272: hr_utility.trace('p_application_id=' || p_application_id);
273: hr_utility.trace('p_transaction_type=' || p_transaction_type);
274: hr_utility.trace('p_transaction_id=' || p_transaction_id);
275:
276: -- set flag based on user selection for Active or All Approvers
269: BEGIN
270:
271: hr_utility.set_location('Entering: get_ame_apprs_and_ins_list', 1);
272: hr_utility.trace('p_application_id=' || p_application_id);
273: hr_utility.trace('p_transaction_type=' || p_transaction_type);
274: hr_utility.trace('p_transaction_id=' || p_transaction_id);
275:
276: -- set flag based on user selection for Active or All Approvers
277: -- zero means active approver
270:
271: hr_utility.set_location('Entering: get_ame_apprs_and_ins_list', 1);
272: hr_utility.trace('p_application_id=' || p_application_id);
273: hr_utility.trace('p_transaction_type=' || p_transaction_type);
274: hr_utility.trace('p_transaction_id=' || p_transaction_id);
275:
276: -- set flag based on user selection for Active or All Approvers
277: -- zero means active approver
278: if(p_apprs_view_type = '0' or p_apprs_view_type is null) then
493: end if;
494:
495: <
496: -- this statement included just for above End_of_Insertions_Loop label
497: hr_utility.trace('end of insertion records for loop');
498: END LOOP; -- insertions loop
499: -- end of the reading insertion records
500:
501: -- set out parameters for approvers and insertion records
501: -- set out parameters for approvers and insertion records
502: p_ame_order_type_list := l_default_insertions_list;
503: p_ame_approvers_list := l_default_approvers_list;
504:
505: hr_utility.set_location('Leaving: get_ame_apprs_and_ins_list', 2);
506:
507: EXCEPTION
508: WHEN OTHERS THEN
509: ame_util.runtimeException(packageNameIn => 'ame_dynamic_approval_pkg',