eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_FR_DADS_F_PKG dependencies on HR_GENERAL

Line 33: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '||hr_general.decode_lookup

29: --#3553620 printing the sort_order meaning instead of sort_order code
30: IF p_sort_order_1 IS NULL THEN
31: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '|| p_sort_order_1);
32: ELSE
33: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '||hr_general.decode_lookup
34: ('FR_DADS_SORT_ORDER',p_sort_order_1));
35: END IF;
36: IF p_sort_order_2 IS NULL THEN
37: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '|| p_sort_order_2);

Line 39: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '||hr_general.decode_lookup

35: END IF;
36: IF p_sort_order_2 IS NULL THEN
37: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '|| p_sort_order_2);
38: ELSE
39: fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '||hr_general.decode_lookup
40: ('FR_DADS_SORT_ORDER',p_sort_order_2));
41: END IF;
42: -- fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_1 '|| p_sort_order_1);
43: -- fnd_file.put_line(FND_FILE.OUTPUT, 'p_sort_order_2 '|| p_sort_order_2);

Line 155: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,

151: --
152: -- Cursor for fetching S10 values
153: Cursor csr_get_S10_rec(c_payroll_action_id number) IS
154: Select action_information1 rubric_code,
155: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
156: action_information4 file_value,
157: action_information5 user_value,
158: action_information9 usage
159: from pay_action_information

Line 183: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,

179: -- Cursor for fetching S20 records
180: Cursor csr_get_S20_data(c_payroll_action_id number,
181: c_company_id number)is
182: Select action_information1 rubric_code,
183: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
184: action_information4 file_value,
185: action_information5 user_value,
186: action_information7 extra_info,
187: action_information9 usage

Line 200: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,

196: -- Cursor for fetching S30 records
197: Cursor csr_get_s30_data(c_asg_action_id number,
198: c_company_id number)is
199: Select action_information1 rubric_code,
200: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
201: action_information4 file_value,
202: action_information5 user_value,
203: action_information9 usage
204: from pay_action_information

Line 230: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,

226: Cursor csr_get_s41_data(c_asg_action_id number,
227: c_company_id number,
228: c_s41_id2 number) is
229: Select action_information1 rubric_code,
230: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
231: action_information4 file_value,
232: action_information5 user_value,
233: action_information9 usage
234: from pay_action_information

Line 256: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,

252: -- Cursor to get S80 data
253: Cursor csr_get_s80_data(c_payroll_action_id number,
254: c_estab_id number)is
255: Select action_information1 rubric_code,
256: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
257: action_information4 file_value,
258: action_information5 user_value,
259: action_information9 usage
260: from pay_action_information

Line 271: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,

267: --
268: -- Cursor to get S90 data
269: Cursor csr_get_s90_data(c_payroll_action_id number)is
270: Select action_information1 rubric_code,
271: hr_general.decode_lookup ('FR_DADS_RUBRICS',action_information1) rubric_meaning,
272: action_information4 file_value,
273: action_information5 user_value,
274: action_information9 usage
275: from pay_action_information

Line 488: l_s10_heading_text :=hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_INFO');

484: OPEN csr_s10_header_data(l_payroll_action_id);
485: FETCH csr_s10_header_data INTO l_header_issue_estab, l_s10_cre_estab;
486: CLOSE csr_s10_header_data;
487: -- get lookup meanings
488: l_s10_heading_text :=hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_INFO');
489: l_issuing_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_NAME');
490: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
491: --
492: fnd_file.new_line(fnd_file.output,2);

Line 489: l_issuing_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_NAME');

485: FETCH csr_s10_header_data INTO l_header_issue_estab, l_s10_cre_estab;
486: CLOSE csr_s10_header_data;
487: -- get lookup meanings
488: l_s10_heading_text :=hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_INFO');
489: l_issuing_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_NAME');
490: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
491: --
492: fnd_file.new_line(fnd_file.output,2);
493: fnd_file.put_line(fnd_file.output,l_s10_heading_text);

Line 490: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');

486: CLOSE csr_s10_header_data;
487: -- get lookup meanings
488: l_s10_heading_text :=hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_INFO');
489: l_issuing_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_NAME');
490: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
491: --
492: fnd_file.new_line(fnd_file.output,2);
493: fnd_file.put_line(fnd_file.output,l_s10_heading_text);
494: fnd_file.put_line(fnd_file.output,l_issuing_estab_text ||' : '||l_header_issue_estab);

Line 528: l_s20_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_INFO');

524: IF P_REPORT_INCLUSIONS ='ORG' OR P_REPORT_INCLUSIONS='ALL' THEN
525: -- WRITE S20 DATA
526: -- print header for S20
527: -- get lookup meanings
528: l_s20_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_INFO');
529: l_comp_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_NAME');
530: l_hq_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_HQ_ESTAB_NAME');
531: l_fisc_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_FISC_ESTAB_NAME');
532: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');

Line 529: l_comp_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_NAME');

525: -- WRITE S20 DATA
526: -- print header for S20
527: -- get lookup meanings
528: l_s20_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_INFO');
529: l_comp_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_NAME');
530: l_hq_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_HQ_ESTAB_NAME');
531: l_fisc_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_FISC_ESTAB_NAME');
532: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
533: -- get cursor values

Line 530: l_hq_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_HQ_ESTAB_NAME');

526: -- print header for S20
527: -- get lookup meanings
528: l_s20_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_INFO');
529: l_comp_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_NAME');
530: l_hq_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_HQ_ESTAB_NAME');
531: l_fisc_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_FISC_ESTAB_NAME');
532: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
533: -- get cursor values
534: OPEN csr_s20_header_data(l_payroll_action_id,comp_rec.company_id);

Line 531: l_fisc_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_FISC_ESTAB_NAME');

527: -- get lookup meanings
528: l_s20_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_INFO');
529: l_comp_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_NAME');
530: l_hq_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_HQ_ESTAB_NAME');
531: l_fisc_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_FISC_ESTAB_NAME');
532: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
533: -- get cursor values
534: OPEN csr_s20_header_data(l_payroll_action_id,comp_rec.company_id);
535: FETCH csr_s20_header_data INTO l_comp_name, l_s20_cre_estab, l_hq_name, l_fisc_name;

Line 532: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');

528: l_s20_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_INFO');
529: l_comp_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_NAME');
530: l_hq_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_HQ_ESTAB_NAME');
531: l_fisc_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_FISC_ESTAB_NAME');
532: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
533: -- get cursor values
534: OPEN csr_s20_header_data(l_payroll_action_id,comp_rec.company_id);
535: FETCH csr_s20_header_data INTO l_comp_name, l_s20_cre_estab, l_hq_name, l_fisc_name;
536: CLOSE csr_s20_header_data;

Line 573: p_user_value => hr_general.decode_lookup('FR_DADS_DECL_NATURE_CODE',p_declaration_nature));

569: write_into_file (p_report_type => p_report_type,
570: p_rubric_code => S20_data_rec.rubric_code,
571: p_rubric_desc => S20_data_rec.rubric_meaning,
572: p_file_value => p_declaration_nature,
573: p_user_value => hr_general.decode_lookup('FR_DADS_DECL_NATURE_CODE',p_declaration_nature));
574: --
575: ELSIF S20_data_rec.rubric_code = 'S20.G01.00.004.002' THEN
576: -- Write the value as obtained from report parameter
577: write_into_file (p_report_type => p_report_type,

Line 581: p_user_value => hr_general.decode_lookup('FR_DADS_DECL_TYPE_CODE',p_declaration_type));

577: write_into_file (p_report_type => p_report_type,
578: p_rubric_code => S20_data_rec.rubric_code,
579: p_rubric_desc => S20_data_rec.rubric_meaning,
580: p_file_value => p_declaration_type,
581: p_user_value => hr_general.decode_lookup('FR_DADS_DECL_TYPE_CODE',p_declaration_type));
582: --
583: ELSIF S20_data_rec.rubric_code = 'S20.G01.00.006' THEN
584: -- check the declaration type
585: IF p_declaration_type = 53 THEN -- if the type is 'correction'

Line 652: l_s30_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_INFO');

648: EXIT WHEN ref_csr_asg_action%NOTFOUND;
649: -- WRITE S30 DATA
650: -- print header for S30
651: -- get the lookup values
652: l_s30_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_INFO');
653: l_emp_name_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NAME');
654: l_emp_number_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NUMBER');
655: -- fetch the header values
656: OPEN csr_s30_header_data(l_asg_action_id,

Line 653: l_emp_name_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NAME');

649: -- WRITE S30 DATA
650: -- print header for S30
651: -- get the lookup values
652: l_s30_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_INFO');
653: l_emp_name_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NAME');
654: l_emp_number_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NUMBER');
655: -- fetch the header values
656: OPEN csr_s30_header_data(l_asg_action_id,
657: comp_rec.company_id);

Line 654: l_emp_number_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NUMBER');

650: -- print header for S30
651: -- get the lookup values
652: l_s30_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_INFO');
653: l_emp_name_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NAME');
654: l_emp_number_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NUMBER');
655: -- fetch the header values
656: OPEN csr_s30_header_data(l_asg_action_id,
657: comp_rec.company_id);
658: FETCH csr_s30_header_data INTO l_header_emp_title,

Line 694: l_s41_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_FISCAL_INFO');

690: comp_rec.company_id) LOOP
691: -- WRITE S41 DATA
692: -- print header for S41
693: -- get lookup values
694: l_s41_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_FISCAL_INFO');
695: l_emp_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_EMP_ESTAB');
696: l_start_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_START_DATE');
697: l_end_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_END_DATE');
698: -- fetch header values

Line 695: l_emp_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_EMP_ESTAB');

691: -- WRITE S41 DATA
692: -- print header for S41
693: -- get lookup values
694: l_s41_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_FISCAL_INFO');
695: l_emp_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_EMP_ESTAB');
696: l_start_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_START_DATE');
697: l_end_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_END_DATE');
698: -- fetch header values
699: OPEN csr_s41_header_data(l_asg_action_id,

Line 696: l_start_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_START_DATE');

692: -- print header for S41
693: -- get lookup values
694: l_s41_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_FISCAL_INFO');
695: l_emp_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_EMP_ESTAB');
696: l_start_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_START_DATE');
697: l_end_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_END_DATE');
698: -- fetch header values
699: OPEN csr_s41_header_data(l_asg_action_id,
700: comp_rec.company_id,

Line 697: l_end_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_END_DATE');

693: -- get lookup values
694: l_s41_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_FISCAL_INFO');
695: l_emp_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_EMP_ESTAB');
696: l_start_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_START_DATE');
697: l_end_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_END_DATE');
698: -- fetch header values
699: OPEN csr_s41_header_data(l_asg_action_id,
700: comp_rec.company_id,
701: count_s41_rec.id2);

Line 760: l_s80_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S80_ESTAB_INFO');

756: IF P_REPORT_INCLUSIONS= 'ALL' THEN
757: -- WRITE S80 DATA
758: -- print header for S80
759: -- get lookup values
760: l_s80_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S80_ESTAB_INFO');
761: l_s80_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S80_ESTAB_NAME');
762: -- fetch header data
763: OPEN csr_s80_header_data(l_payroll_action_id,count_s80_rec.estab_id);
764: FETCH csr_s80_header_data INTO l_s80_header_estab_name;

Line 761: l_s80_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S80_ESTAB_NAME');

757: -- WRITE S80 DATA
758: -- print header for S80
759: -- get lookup values
760: l_s80_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S80_ESTAB_INFO');
761: l_s80_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S80_ESTAB_NAME');
762: -- fetch header data
763: OPEN csr_s80_header_data(l_payroll_action_id,count_s80_rec.estab_id);
764: FETCH csr_s80_header_data INTO l_s80_header_estab_name;
765: CLOSE csr_s80_header_data;

Line 795: l_s90_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S90_TOTALS');

791: -- END OF WRITING S80 DATA
792: END LOOP;
793: -- WRITE S90 DATA
794: -- print header for S90
795: l_s90_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S90_TOTALS');
796: fnd_file.new_line(fnd_file.output,2);
797: fnd_file.put_line(fnd_file.output,l_s90_heading_text);
798: fnd_file.new_line(fnd_file.output, 1);
799: --

Line 1215: 'VALUE1:'||hr_general.decode_lookup

1211: -- Retreive the error message for Declaration Type Code
1212: IF (P_DECLARATION_NATURE = '02' OR P_DECLARATION_NATURE = '01') AND
1213: P_DECLARATION_TYPE = '55' THEN
1214: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_DATA',
1215: 'VALUE1:'||hr_general.decode_lookup
1216: ('FR_DADS_RUBRICS','S20.G01.00.004.001'),
1217: 'VALUE2:'||hr_general.decode_lookup
1218: ('FR_DADS_RUBRICS','S20.G01.00.004.002'), null);
1219: ELSIF P_DECLARATION_NATURE = '05' AND P_DECLARATION_TYPE <> '55' THEN

Line 1217: 'VALUE2:'||hr_general.decode_lookup

1213: P_DECLARATION_TYPE = '55' THEN
1214: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_DATA',
1215: 'VALUE1:'||hr_general.decode_lookup
1216: ('FR_DADS_RUBRICS','S20.G01.00.004.001'),
1217: 'VALUE2:'||hr_general.decode_lookup
1218: ('FR_DADS_RUBRICS','S20.G01.00.004.002'), null);
1219: ELSIF P_DECLARATION_NATURE = '05' AND P_DECLARATION_TYPE <> '55' THEN
1220: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_DATA',
1221: 'VALUE1:'||hr_general.decode_lookup

Line 1221: 'VALUE1:'||hr_general.decode_lookup

1217: 'VALUE2:'||hr_general.decode_lookup
1218: ('FR_DADS_RUBRICS','S20.G01.00.004.002'), null);
1219: ELSIF P_DECLARATION_NATURE = '05' AND P_DECLARATION_TYPE <> '55' THEN
1220: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_DATA',
1221: 'VALUE1:'||hr_general.decode_lookup
1222: ('FR_DADS_RUBRICS','S20.G01.00.004.001'),
1223: 'VALUE2:'||hr_general.decode_lookup
1224: ('FR_DADS_RUBRICS','S20.G01.00.004.002'), null);
1225: ELSE

Line 1223: 'VALUE2:'||hr_general.decode_lookup

1219: ELSIF P_DECLARATION_NATURE = '05' AND P_DECLARATION_TYPE <> '55' THEN
1220: l_value := pay_fr_general.get_payroll_message('PAY_75191_INCOMPAT_DATA',
1221: 'VALUE1:'||hr_general.decode_lookup
1222: ('FR_DADS_RUBRICS','S20.G01.00.004.001'),
1223: 'VALUE2:'||hr_general.decode_lookup
1224: ('FR_DADS_RUBRICS','S20.G01.00.004.002'), null);
1225: ELSE
1226: l_value := null;
1227: END IF;

Line 1243: l_s10_heading_text :=hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_INFO');

1239: OPEN csr_s10_header_data(l_payroll_action_id);
1240: FETCH csr_s10_header_data INTO l_header_issue_estab, l_s10_cre_estab;
1241: CLOSE csr_s10_header_data;
1242: -- get lookup meanings
1243: l_s10_heading_text :=hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_INFO');
1244: l_issuing_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_NAME');
1245: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
1246: --
1247: fnd_file.new_line(fnd_file.output,2);

Line 1244: l_issuing_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_NAME');

1240: FETCH csr_s10_header_data INTO l_header_issue_estab, l_s10_cre_estab;
1241: CLOSE csr_s10_header_data;
1242: -- get lookup meanings
1243: l_s10_heading_text :=hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_INFO');
1244: l_issuing_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_NAME');
1245: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
1246: --
1247: fnd_file.new_line(fnd_file.output,2);
1248: fnd_file.put_line(fnd_file.output,l_s10_heading_text);

Line 1245: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');

1241: CLOSE csr_s10_header_data;
1242: -- get lookup meanings
1243: l_s10_heading_text :=hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_INFO');
1244: l_issuing_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S10_ISSUE_ESTAB_NAME');
1245: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
1246: --
1247: fnd_file.new_line(fnd_file.output,2);
1248: fnd_file.put_line(fnd_file.output,l_s10_heading_text);
1249: fnd_file.put_line(fnd_file.output,l_issuing_estab_text ||' : '||l_header_issue_estab);

Line 1277: l_s20_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_INFO');

1273: hr_utility.set_location('Entered into the company procedure ',5);
1274: -- WRITE S20 DATA
1275: -- print header for S20
1276: -- get lookup meanings
1277: l_s20_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_INFO');
1278: l_comp_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_NAME');
1279: l_hq_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_HQ_ESTAB_NAME');
1280: l_fisc_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_FISC_ESTAB_NAME');
1281: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');

Line 1278: l_comp_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_NAME');

1274: -- WRITE S20 DATA
1275: -- print header for S20
1276: -- get lookup meanings
1277: l_s20_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_INFO');
1278: l_comp_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_NAME');
1279: l_hq_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_HQ_ESTAB_NAME');
1280: l_fisc_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_FISC_ESTAB_NAME');
1281: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
1282: -- get cursor values

Line 1279: l_hq_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_HQ_ESTAB_NAME');

1275: -- print header for S20
1276: -- get lookup meanings
1277: l_s20_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_INFO');
1278: l_comp_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_NAME');
1279: l_hq_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_HQ_ESTAB_NAME');
1280: l_fisc_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_FISC_ESTAB_NAME');
1281: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
1282: -- get cursor values
1283: OPEN csr_s20_header_data(l_payroll_action_id,comp_rec.company_id);

Line 1280: l_fisc_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_FISC_ESTAB_NAME');

1276: -- get lookup meanings
1277: l_s20_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_INFO');
1278: l_comp_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_NAME');
1279: l_hq_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_HQ_ESTAB_NAME');
1280: l_fisc_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_FISC_ESTAB_NAME');
1281: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
1282: -- get cursor values
1283: OPEN csr_s20_header_data(l_payroll_action_id,comp_rec.company_id);
1284: FETCH csr_s20_header_data INTO l_comp_name, l_s20_cre_estab, l_hq_name, l_fisc_name;

Line 1281: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');

1277: l_s20_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_INFO');
1278: l_comp_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_COMP_NAME');
1279: l_hq_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_HQ_ESTAB_NAME');
1280: l_fisc_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S20_FISC_ESTAB_NAME');
1281: l_cre_estab_text:= hr_general.decode_lookup('FR_DADS_HEADINGS','S10_CRE_ESTAB_NAME');
1282: -- get cursor values
1283: OPEN csr_s20_header_data(l_payroll_action_id,comp_rec.company_id);
1284: FETCH csr_s20_header_data INTO l_comp_name, l_s20_cre_estab, l_hq_name, l_fisc_name;
1285: CLOSE csr_s20_header_data;

Line 1368: l_s30_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_INFO');

1364: l_total_employees := l_total_employees + 1;
1365: -- WRITE S30 DATA
1366: -- print header for S30
1367: -- get the lookup values
1368: l_s30_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_INFO');
1369: l_emp_name_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NAME');
1370: l_emp_number_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NUMBER');
1371: -- fetch the header values
1372: OPEN csr_s30_header_data(l_asg_action_id,

Line 1369: l_emp_name_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NAME');

1365: -- WRITE S30 DATA
1366: -- print header for S30
1367: -- get the lookup values
1368: l_s30_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_INFO');
1369: l_emp_name_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NAME');
1370: l_emp_number_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NUMBER');
1371: -- fetch the header values
1372: OPEN csr_s30_header_data(l_asg_action_id,
1373: comp_rec.company_id);

Line 1370: l_emp_number_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NUMBER');

1366: -- print header for S30
1367: -- get the lookup values
1368: l_s30_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_INFO');
1369: l_emp_name_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NAME');
1370: l_emp_number_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S30_EMP_NUMBER');
1371: -- fetch the header values
1372: OPEN csr_s30_header_data(l_asg_action_id,
1373: comp_rec.company_id);
1374: FETCH csr_s30_header_data INTO l_header_emp_title,

Line 1401: l_s41_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_FISCAL_INFO');

1397: comp_rec.company_id) LOOP
1398: -- WRITE S41 DATA
1399: -- print header for S41
1400: -- get lookup values
1401: l_s41_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_FISCAL_INFO');
1402: l_emp_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_EMP_ESTAB');
1403: l_start_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_START_DATE');
1404: l_end_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_END_DATE');
1405: -- fetch header values

Line 1402: l_emp_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_EMP_ESTAB');

1398: -- WRITE S41 DATA
1399: -- print header for S41
1400: -- get lookup values
1401: l_s41_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_FISCAL_INFO');
1402: l_emp_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_EMP_ESTAB');
1403: l_start_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_START_DATE');
1404: l_end_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_END_DATE');
1405: -- fetch header values
1406: OPEN csr_s41_header_data(l_asg_action_id,

Line 1403: l_start_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_START_DATE');

1399: -- print header for S41
1400: -- get lookup values
1401: l_s41_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_FISCAL_INFO');
1402: l_emp_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_EMP_ESTAB');
1403: l_start_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_START_DATE');
1404: l_end_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_END_DATE');
1405: -- fetch header values
1406: OPEN csr_s41_header_data(l_asg_action_id,
1407: comp_rec.company_id,

Line 1404: l_end_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_END_DATE');

1400: -- get lookup values
1401: l_s41_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_FISCAL_INFO');
1402: l_emp_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_EMP_ESTAB');
1403: l_start_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_START_DATE');
1404: l_end_date_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S41_END_DATE');
1405: -- fetch header values
1406: OPEN csr_s41_header_data(l_asg_action_id,
1407: comp_rec.company_id,
1408: count_s41_rec.id2);

Line 1470: l_s80_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S80_ESTAB_INFO');

1466: IF P_REPORT_INCLUSIONS= 'ALL' THEN
1467: -- WRITE S80 DATA
1468: -- print header for S80
1469: -- get lookup values
1470: l_s80_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S80_ESTAB_INFO');
1471: l_s80_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S80_ESTAB_NAME');
1472: -- fetch header data
1473: OPEN csr_s80_header_data(l_payroll_action_id,count_s80_rec.estab_id);
1474: FETCH csr_s80_header_data INTO l_s80_header_estab_name;

Line 1471: l_s80_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S80_ESTAB_NAME');

1467: -- WRITE S80 DATA
1468: -- print header for S80
1469: -- get lookup values
1470: l_s80_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S80_ESTAB_INFO');
1471: l_s80_estab_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S80_ESTAB_NAME');
1472: -- fetch header data
1473: OPEN csr_s80_header_data(l_payroll_action_id,count_s80_rec.estab_id);
1474: FETCH csr_s80_header_data INTO l_s80_header_estab_name;
1475: CLOSE csr_s80_header_data;

Line 1497: l_s90_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S90_TOTALS');

1493: -- END OF WRITING S80 DATA
1494: END LOOP;
1495: -- WRITE S90 DATA
1496: -- print header for S90
1497: l_s90_heading_text := hr_general.decode_lookup('FR_DADS_HEADINGS','S90_TOTALS');
1498: fnd_file.new_line(fnd_file.output,2);
1499: fnd_file.put_line(fnd_file.output,l_s90_heading_text);
1500: fnd_file.new_line(fnd_file.output,1);
1501: --