19: =============================================================================*/
20: --
21: --
22: g_package CONSTANT VARCHAR2(30):= 'pay_gb_rti_fps_output.';
23: EOL VARCHAR2(5) := fnd_global.local_chr(10);
24:
25: /*------------- PRIVATE PROCEDURE -----------------*/
26:
27: /**************************************************************************/
63: BEGIN
64: hr_utility.set_location('Entering: '||l_proc,1);
65:
66: SELECT
67: fnd_global.local_chr(13) || fnd_global.local_chr(10)
68: INTO EOL
69: FROM dual;
70: IF p_null_allowed = 'N'
71: AND (TRIM(p_data) IS NULL
120: l_pay_to_someone VARCHAR2(50);
121: l_p11d_due VARCHAR2(50);
122: l_service_company VARCHAR2(50);
123:
124: EOL VARCHAR2(5) := fnd_global.local_chr(13)
125: || fnd_global.local_chr(10);
126:
127: cursor csr_arch_payroll_action_id(c_mag_payroll_actid number) is
128: select
121: l_p11d_due VARCHAR2(50);
122: l_service_company VARCHAR2(50);
123:
124: EOL VARCHAR2(5) := fnd_global.local_chr(13)
125: || fnd_global.local_chr(10);
126:
127: cursor csr_arch_payroll_action_id(c_mag_payroll_actid number) is
128: select
129: to_number(substr(pact.legislative_parameters,
261: l_employer_ao_ref VARCHAR2(50);
262: l_hmrc_office_no VARCHAR2(50);
263: l_tax_year VARCHAR2(50);
264:
265: EOL VARCHAR2(5) := fnd_global.local_chr(13)
266: || fnd_global.local_chr(10);
267:
268: cursor csr_arch_payroll_action_id(c_mag_payroll_actid number) is
269: select
262: l_hmrc_office_no VARCHAR2(50);
263: l_tax_year VARCHAR2(50);
264:
265: EOL VARCHAR2(5) := fnd_global.local_chr(13)
266: || fnd_global.local_chr(10);
267:
268: cursor csr_arch_payroll_action_id(c_mag_payroll_actid number) is
269: select
270: to_number(substr(pact.legislative_parameters,
418: l_mag_payroll_actid number;
419: l_mag_asg_action_id number;
420: l_arch_asg_action_id number;
421: l_arch_pay_action_id number;
422: EOL varchar2(5) := fnd_global.local_chr(13)
423: || fnd_global.local_chr(10);
424:
425: l_other_asg_arch_id number;
426: l_other_asg_act_arch_id number;
419: l_mag_asg_action_id number;
420: l_arch_asg_action_id number;
421: l_arch_pay_action_id number;
422: EOL varchar2(5) := fnd_global.local_chr(13)
423: || fnd_global.local_chr(10);
424:
425: l_other_asg_arch_id number;
426: l_other_asg_act_arch_id number;
427: