[Home] [Help]
76: hr_utility.set_location('HR_PPVOL.ins_opm',1);
77: --
78: select pay_org_payment_methods_s.nextval
79: into method_id
80: from dual;
81: --
82: -- Now do the insert
83: --
84: hr_utility.set_location('HR_PPVOL.ins_opm',2);
141: -- First get the UID
142: --
143: select pay_external_accounts_s.nextval
144: into account_id
145: from dual;
146: --
147: -- Now insert the new row
148: --
149: insert into pay_external_accounts(
229: if existing = false then
230: --
231: select pay_org_pay_method_usages_s.nextval
232: into pmu_id
233: from sys.dual;
234: --
235: insert into pay_org_pay_method_usages_f
236: (org_pay_method_usage_id,
237: effective_start_date,
302: end loop;
303: --
304: if v_insert_record then
305: --
306: select pay_org_pay_method_usages_s.nextval into pmu_id from sys.dual;
307: -- Create opmu to represent the default payment method selected for the
308: -- payroll.
309: insert into pay_org_pay_method_usages_f
310: (org_pay_method_usage_id,
367: begin
368: --
369: select pay_personal_payment_methods_s.nextval
370: into ppm_id
371: from dual;
372: --
373: insert into pay_personal_payment_methods_f(
374: personal_payment_method_id,
375: effective_start_date,
462: begin
463: --
464: select pay_payroll_actions_s.nextval
465: into action_id
466: from dual;
467: --
468: -- Now do the insert
469: --
470: insert into pay_payroll_actions(
513: begin
514: --
515: select pay_assignment_actions_s.nextval
516: into action_id
517: from dual;
518: --
519: insert into pay_assignment_actions(
520: assignment_action_id,
521: assignment_id,
574: hr_utility.set_location('HR_PPVOL.ins_payroll',1);
575: --
576: select pay_payrolls_s.nextval
577: into payroll_id
578: from dual;
579: --
580: hr_utility.set_location('HR_PPVOL.ins_payroll',2);
581: --
582: insert into pay_payrolls_f