DBA Data[Home] [Help]

APPS.PAY_GB_RTI_OUTPUT dependencies on FND_GLOBAL

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

24: --
25: --
26:
27: g_debug BOOLEAN := hr_utility.debug_enabled;
28: EOL VARCHAR2(5) := fnd_global.local_chr(10);
29:
30: TYPE act_info_rec IS RECORD
31: ( assignment_id number(20)
32: ,person_id number(20)

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

124: BEGIN
125: hr_utility.set_location('Entering: '||l_proc,1);
126:
127: SELECT
128: fnd_global.local_chr(13) || fnd_global.local_chr(10)
129: INTO EOL
130: FROM dual;
131: IF p_null_allowed = 'N'
132: AND (TRIM(p_data) IS NULL

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

198: l_test_indicator VARCHAR2(50);
199: l_header_value VARCHAR2(50);
200: l_system_date VARCHAR2(50);
201: l_system_time VARCHAR2(50);
202: EOL VARCHAR2(5) := fnd_global.local_chr(13)
203: || fnd_global.local_chr(10);
204: cursor csr_arch_payroll_action_id(c_mag_payroll_actid number) is
205: select
206: to_number(substr(pact.legislative_parameters,

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

199: l_header_value VARCHAR2(50);
200: l_system_date VARCHAR2(50);
201: l_system_time VARCHAR2(50);
202: EOL VARCHAR2(5) := fnd_global.local_chr(13)
203: || fnd_global.local_chr(10);
204: cursor csr_arch_payroll_action_id(c_mag_payroll_actid number) is
205: select
206: to_number(substr(pact.legislative_parameters,
207: instr(pact.legislative_parameters,'ARCHIVE_REQUEST_ID=') + 19,

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

347: l_test_indicator VARCHAR2(50);
348: l_header_value VARCHAR2(50);
349: l_system_date VARCHAR2(50);
350: l_system_time VARCHAR2(50);
351: EOL VARCHAR2(5) := fnd_global.local_chr(13)
352: || fnd_global.local_chr(10);
353:
354: cursor csr_arch_payroll_action_id(c_mag_payroll_actid number) is
355: select

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

348: l_header_value VARCHAR2(50);
349: l_system_date VARCHAR2(50);
350: l_system_time VARCHAR2(50);
351: EOL VARCHAR2(5) := fnd_global.local_chr(13)
352: || fnd_global.local_chr(10);
353:
354: cursor csr_arch_payroll_action_id(c_mag_payroll_actid number) is
355: select
356: to_number(substr(pact.legislative_parameters,

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

508: l_mag_payroll_actid number;
509: l_mag_asg_action_id number;
510: l_arch_asg_action_id number;
511: l_arch_pay_action_id number;
512: EOL varchar2(5) := fnd_global.local_chr(13)
513: || fnd_global.local_chr(10);
514:
515: l_other_asg_arch_id number;
516: l_other_asg_act_arch_id number;

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

509: l_mag_asg_action_id number;
510: l_arch_asg_action_id number;
511: l_arch_pay_action_id number;
512: EOL varchar2(5) := fnd_global.local_chr(13)
513: || fnd_global.local_chr(10);
514:
515: l_other_asg_arch_id number;
516: l_other_asg_act_arch_id number;
517:

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

905: l_mag_payroll_actid number;
906: l_mag_asg_action_id number;
907: l_arch_asg_action_id number;
908: l_arch_pay_action_id number;
909: EOL varchar2(5) := fnd_global.local_chr(13)
910: || fnd_global.local_chr(10);
911:
912: l_other_asg_arch_id number;
913: l_other_asg_act_arch_id number;

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

906: l_mag_asg_action_id number;
907: l_arch_asg_action_id number;
908: l_arch_pay_action_id number;
909: EOL varchar2(5) := fnd_global.local_chr(13)
910: || fnd_global.local_chr(10);
911:
912: l_other_asg_arch_id number;
913: l_other_asg_act_arch_id number;
914: