DBA Data[Home] [Help]

APPS.PAY_CA_T4_CANCEL_MAG dependencies on FND_GLOBAL

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

554: /* if p_data is null then
555: return null;
556: end if; */
557: SELECT
558: fnd_global.local_chr(13) || fnd_global.local_chr(10)
559: INTO EOL
560: FROM dual;
561: IF p_null_allowed = 'N'
562: AND (TRIM(p_data) IS NULL

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

657: DECLARE
658:
659: l_final_xml VARCHAR2(32000);
660: l_context1 ff_archive_items.context1%TYPE;
661: EOL VARCHAR2(5) := fnd_global.local_chr(13)
662: || fnd_global.local_chr(10);
663: l_return ff_archive_items.value%TYPE;
664: l_status BOOLEAN := TRUE;
665: l_field_name VARCHAR2(250);

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

658:
659: l_final_xml VARCHAR2(32000);
660: l_context1 ff_archive_items.context1%TYPE;
661: EOL VARCHAR2(5) := fnd_global.local_chr(13)
662: || fnd_global.local_chr(10);
663: l_return ff_archive_items.value%TYPE;
664: l_status BOOLEAN := TRUE;
665: l_field_name VARCHAR2(250);
666:

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

901: PROCEDURE t4_cancel_employer_start IS
902: BEGIN
903: DECLARE
904: l_final_xml_string VARCHAR2(32000);
905: EOL VARCHAR2(5) := fnd_global.local_chr(13)
906: || fnd_global.local_chr(10);
907:
908: BEGIN
909: hr_utility.trace('+==========================================================+');

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

902: BEGIN
903: DECLARE
904: l_final_xml_string VARCHAR2(32000);
905: EOL VARCHAR2(5) := fnd_global.local_chr(13)
906: || fnd_global.local_chr(10);
907:
908: BEGIN
909: hr_utility.trace('+==========================================================+');
910: hr_utility.trace('Entering t4_cancel_employer_start');

Line 926: EOL VARCHAR2(5) := fnd_global.local_chr(13) || fnd_global.local_chr(10);

922: DECLARE
923: l_final_xml_string VARCHAR2(32000);
924: l_context1 ff_archive_items.context1%TYPE;
925: l_return ff_archive_items.value%TYPE;
926: EOL VARCHAR2(5) := fnd_global.local_chr(13) || fnd_global.local_chr(10);
927: l_transfer_pact_id VARCHAR2(15);
928: l_transfer_tax_unit_id VARCHAR2(15);
929: l_transfer_ei_er_rate VARCHAR2(15);
930: lv_ppreg_no1 pay_action_information.action_information4%TYPE;

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

1146: lv_ei_display_flag NUMBER :=1;
1147: l_payroll_actid NUMBER;
1148: l_mag_asg_action_id NUMBER;
1149: l_jurisdiction_code ff_archive_items.value%TYPE;
1150: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1151: || fnd_global.local_chr(10);
1152: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1153: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1154: l_arch_report_type pay_payroll_actions.report_type%TYPE;

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

1147: l_payroll_actid NUMBER;
1148: l_mag_asg_action_id NUMBER;
1149: l_jurisdiction_code ff_archive_items.value%TYPE;
1150: EOL VARCHAR2(5) := fnd_global.local_chr(13)
1151: || fnd_global.local_chr(10);
1152: l_arch_action_id pay_assignment_actions.assignment_action_id%TYPE;
1153: l_arch_pay_actid pay_assignment_actions.payroll_action_id%TYPE;
1154: l_arch_report_type pay_payroll_actions.report_type%TYPE;
1155: -- l_asg_id NUMBER;