DBA Data[Home] [Help]

APPS.PAY_US_W2C_RPT dependencies on FND_GLOBAL

Line 2351: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);

2347: raw_data RAW(32767);
2348:
2349: begin
2350: hr_utility.trace('In create XML string ' );
2351: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
2352: IF (g_print_instr IS NULL) OR (g_print_instr = '') THEN
2353: g_print_instr := 'Y';
2354: END IF;
2355:

Line 3484: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);

3480: l_box14_tab.delete;
3481:
3482: l_w2c_fields_c.amended := '';
3483: l_w2c_fields_c.amended_date := '';
3484: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3485:
3486: p_xml_blob := fetch_w2c_xml(p_assignment_action_id ,
3487: p_prev_assignment_action_id,
3488: p_tax_unit_id ,

Line 3634: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);

3630: and paa.assignment_action_id = pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID');
3631:
3632: BEGIN
3633: --hr_utility.trace_on(null,'w2');
3634: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3635: hr_utility.trace('In fetch_w2c_xm');
3636:
3637: hr_utility.trace('Deleting PL/SQL tables');
3638: l_state_local_tab.delete;

Line 3796: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);

3792: l_footer_xml CLOB;
3793: l_last_xml_string VARCHAR2(32000);
3794: l_is_temp_final_xml VARCHAR2(2);
3795: BEGIN
3796: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3797: l_last_xml_string :=
3798: ''||EOL;
3799: l_is_temp_final_xml := dbms_lob.istemporary(l_footer_xml);
3800: hr_utility.trace('Istemporary(l_footer_xml) ' ||l_is_temp_final_xml );

Line 3825: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);

3821: l_final_xml CLOB;
3822: l_final_xml_string VARCHAR2(32000);
3823: l_is_temp_final_xml VARCHAR2(2);
3824: BEGIN
3825: EOL := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3826: l_final_xml_string :=
3827: -- ''|| EOL|| Bug 6712851
3828: ''||EOL;
3829: