296: r_input_38 varchar2(300);
297: r_input_39 varchar2(300);
298:
299: BEGIN
300: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
301: hr_utility.trace('RA Record Formatting started ');
302: hr_utility.trace('Format_SQWL_RA_Record Begin for Company '|| p_input_7);
303: -- Initializing local variables with parameter value
304: --{
819: r_input_39 varchar2(300);
820:
821: p_end_of_rec varchar2(20);
822: BEGIN
823: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
824: hr_utility.trace('RE Record Formatting started ');
825: -- Initializing local variables with parameter value
826: --{
827: r_input_2 := p_input_2;
1540: r_input_38 varchar2(300);
1541: r_input_39 varchar2(300);
1542:
1543: BEGIN
1544: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
1545: hr_utility.trace('Formatting RS record for SQWL ');
1546: hr_utility.trace('p_report_qualifier = '||p_report_qualifier);
1547: -- Initializing local variables with parameter value
1548: --{
2655: INDEX BY BINARY_INTEGER;
2656: parameter_record input_parameter_record;
2657:
2658: BEGIN
2659: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
2660: hr_utility.trace('RT Record Formatting started for SQWL reporting ');
2661:
2662: -- Validation Starts
2663: If p_input_40='FLAT' THEN
2980: INDEX BY BINARY_INTEGER;
2981: parameter_record input_parameter_record;
2982:
2983: BEGIN
2984: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
2985: hr_utility.trace('RSSUMM Record Formatting started for SQWL reporting ');
2986:
2987: l_emp_ein := p_input_4;
2988: l_other_ein := p_input_5;
3341: p_end_of_rec varchar2(20);
3342: l_end_of_rec varchar2(20) ;
3343:
3344: BEGIN
3345: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3346: hr_utility.trace('Formatting RU Record');
3347: hr_utility.trace('RU Record Format Mode '||p_record_format_mode);
3348: l_no_of_rs_record := lpad(substr(nvl(p_number_of_RS_record,'0'),1,7),7,0);
3349:
3408: p_end_of_rec varchar2(20);
3409: l_end_of_rec varchar2(20) ;
3410:
3411: BEGIN
3412: p_end_of_rec := fnd_global.local_chr(13)||fnd_global.local_chr(10);
3413: -- Formatting RF Record
3414: hr_utility.trace('Report Qualifier before Formatting RF Record '
3415: ||p_report_qualifier);
3416: