***The following will use to run the 'Payroll Run' program from the back end.
declare
l_req_id number;
BEGIN
fnd_global.apps_initialize (user_id => fnd_global.user_id,
--1130
resp_id => fnd_global.resp_id,
--50419
resp_appl_id => fnd_global.resp_appl_id
);
dbms_output.put_line('Calling Payroll Run Program for Payroll ID:' || i.payroll_id);
l_req_id :=
fnd_request.submit_request (application => 'PAY',
program => 'PAYROLL_RUN',
argument1 => 'RUN',
argument2 => i.payroll_id,
argument3 => i.consolidation_set_id,
argument4 => p_payroll_period,
argument5 => p_payroll_period,
argument6 => NULL,
argument7 => NULL,
argument8 => NULL,
argument9 => NULL
);
dbms_output.put_line('REQUEST_ID = ' || l_req_id);
COMMIT;
END;
declare
l_req_id number;
BEGIN
fnd_global.apps_initialize (user_id => fnd_global.user_id,
--1130
resp_id => fnd_global.resp_id,
--50419
resp_appl_id => fnd_global.resp_appl_id
);
dbms_output.put_line('Calling Payroll Run Program for Payroll ID:' || i.payroll_id);
l_req_id :=
fnd_request.submit_request (application => 'PAY',
program => 'PAYROLL_RUN',
argument1 => 'RUN',
argument2 => i.payroll_id,
argument3 => i.consolidation_set_id,
argument4 => p_payroll_period,
argument5 => p_payroll_period,
argument6 => NULL,
argument7 => NULL,
argument8 => NULL,
argument9 => NULL
);
dbms_output.put_line('REQUEST_ID = ' || l_req_id);
COMMIT;
END;
No comments:
Post a Comment