DBA Data[Home] [Help]

APPS.PAY_GB_RTI_FPS_OUTPUT dependencies on FND_GLOBAL

Line 23: EOL VARCHAR2(5) := fnd_global.local_chr(10);

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: /**************************************************************************/

Line 67: fnd_global.local_chr(13) || fnd_global.local_chr(10)

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

Line 124: EOL VARCHAR2(5) := fnd_global.local_chr(13)

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

Line 125: || fnd_global.local_chr(10);

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,

Line 265: EOL VARCHAR2(5) := fnd_global.local_chr(13)

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

Line 266: || fnd_global.local_chr(10);

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,

Line 422: EOL varchar2(5) := fnd_global.local_chr(13)

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;

Line 423: || fnd_global.local_chr(10);

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: