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.HR_DE_ORGANIZATION_UPLOAD dependencies on HR_GENERAL

Line 9: SELECT hr_general.decode_lookup('DE_FED_STATE', bundesland) bundesland_description

5: -- Cursor to return tax office definitions.
6: --
7: CURSOR c_tax_office_defs
8: (p_bundesland VARCHAR2) IS
9: SELECT hr_general.decode_lookup('DE_FED_STATE', bundesland) bundesland_description
10: ,bundesland
11: ,tax_office_no
12: ,tax_office_name
13: FROM hr_de_tax_office_definition_v

Line 15: ORDER BY hr_general.decode_lookup('DE_FED_STATE', bundesland) ASC;

11: ,tax_office_no
12: ,tax_office_name
13: FROM hr_de_tax_office_definition_v
14: WHERE bundesland = NVL(p_bundesland, bundesland)
15: ORDER BY hr_general.decode_lookup('DE_FED_STATE', bundesland) ASC;
16: --
17: --
18: -- Cursor to return social insurance provider definitions.
19: --

Line 23: ,hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', provider_type) provider_type_description

19: --
20: CURSOR c_soc_ins_prov_defs
21: (p_provider_type VARCHAR2) IS
22: SELECT provider_name
23: ,hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', provider_type) provider_type_description
24: ,provider_type
25: ,health_insurance_type
26: ,LPAD(east_betriebesnumber, 8, '0') east_betriebesnumber
27: ,LPAD(west_betriebesnumber, 8, '0') west_betriebesnumber

Line 31: ORDER BY hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', provider_type);

27: ,LPAD(west_betriebesnumber, 8, '0') west_betriebesnumber
28: ,pension_insurance_type
29: FROM hr_de_socins_prov_definition_v
30: WHERE provider_type = NVL(p_provider_type, provider_type)
31: ORDER BY hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', provider_type);
32: --
33: --
34: -- Cursor to return organization information.
35: --

Line 432: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')

428: -- Bundesland : <>
429: -- Tax Office Name : <>
430: -- Tax Office Code : <>
431: --
432: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')
433: || ': ' || p_tax_office_rec.bundesland_description);
434: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
435: || ': ' || p_tax_office_rec.tax_office_name);
436: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')

Line 434: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')

430: -- Tax Office Code : <>
431: --
432: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')
433: || ': ' || p_tax_office_rec.bundesland_description);
434: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
435: || ': ' || p_tax_office_rec.tax_office_name);
436: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')
437: || ': ' || NVL(p_tax_office_rec.tax_office_no, ' '));
438: fnd_file.put_line(fnd_file.output, ' ');

Line 436: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')

432: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')
433: || ': ' || p_tax_office_rec.bundesland_description);
434: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
435: || ': ' || p_tax_office_rec.tax_office_name);
436: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')
437: || ': ' || NVL(p_tax_office_rec.tax_office_no, ' '));
438: fnd_file.put_line(fnd_file.output, ' ');
439: --
440: --

Line 608: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')

604: --
605: -- Provider Type : <>
606: -- Provider Name : <>
607: --
608: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
609: || ': ' || p_soc_ins_prov_rec.provider_type_description);
610: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
611: || ': ' || p_soc_ins_prov_rec.provider_name);
612: fnd_file.put_line(fnd_file.output, ' ');

Line 610: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')

606: -- Provider Name : <>
607: --
608: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
609: || ': ' || p_soc_ins_prov_rec.provider_type_description);
610: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
611: || ': ' || p_soc_ins_prov_rec.provider_name);
612: fnd_file.put_line(fnd_file.output, ' ');
613: --
614: --

Line 730: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')

726: -- Provider Name : <>
727: -- East Betriebsnummer : <>
728: -- West Betriebsnummer : <>
729: --
730: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
731: || ': ' || p_soc_ins_prov_rec.provider_type_description);
732: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
733: || ': ' || p_soc_ins_prov_rec.provider_name);
734: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')

Line 732: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')

728: -- West Betriebsnummer : <>
729: --
730: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
731: || ': ' || p_soc_ins_prov_rec.provider_type_description);
732: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
733: || ': ' || p_soc_ins_prov_rec.provider_name);
734: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
735: || ': ' || NVL(p_soc_ins_prov_rec.east_betriebesnumber, ' '));
736: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')

Line 734: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')

730: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
731: || ': ' || p_soc_ins_prov_rec.provider_type_description);
732: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
733: || ': ' || p_soc_ins_prov_rec.provider_name);
734: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
735: || ': ' || NVL(p_soc_ins_prov_rec.east_betriebesnumber, ' '));
736: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')
737: || ': ' || NVL(p_soc_ins_prov_rec.west_betriebesnumber, ' '));
738: fnd_file.put_line(fnd_file.output, ' ');

Line 736: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')

732: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
733: || ': ' || p_soc_ins_prov_rec.provider_name);
734: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
735: || ': ' || NVL(p_soc_ins_prov_rec.east_betriebesnumber, ' '));
736: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')
737: || ': ' || NVL(p_soc_ins_prov_rec.west_betriebesnumber, ' '));
738: fnd_file.put_line(fnd_file.output, ' ');
739: --
740: --

Line 946: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_UPLOAD'), 41, ' '));

942: --
943: -- Write heading for output file.
944: --
945: fnd_file.put_line(fnd_file.output, ' ');
946: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_UPLOAD'), 41, ' '));
947: fnd_file.put_line(fnd_file.output, ' ');
948: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
949: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
950: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 29, ' ') || ' : '

Line 948: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '

944: --
945: fnd_file.put_line(fnd_file.output, ' ');
946: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_UPLOAD'), 41, ' '));
947: fnd_file.put_line(fnd_file.output, ' ');
948: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
949: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
950: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 29, ' ') || ' : '
951: || LOCAL_DECODE(p_bundesland IS NOT NULL
952: ,hr_general.decode_lookup('DE_FED_STATE', p_bundesland)

Line 949: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));

945: fnd_file.put_line(fnd_file.output, ' ');
946: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_UPLOAD'), 41, ' '));
947: fnd_file.put_line(fnd_file.output, ' ');
948: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
949: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
950: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 29, ' ') || ' : '
951: || LOCAL_DECODE(p_bundesland IS NOT NULL
952: ,hr_general.decode_lookup('DE_FED_STATE', p_bundesland)
953: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));

Line 950: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 29, ' ') || ' : '

946: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_UPLOAD'), 41, ' '));
947: fnd_file.put_line(fnd_file.output, ' ');
948: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
949: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
950: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 29, ' ') || ' : '
951: || LOCAL_DECODE(p_bundesland IS NOT NULL
952: ,hr_general.decode_lookup('DE_FED_STATE', p_bundesland)
953: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));
954: fnd_file.put_line(fnd_file.output, ' ');

Line 952: ,hr_general.decode_lookup('DE_FED_STATE', p_bundesland)

948: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
949: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
950: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 29, ' ') || ' : '
951: || LOCAL_DECODE(p_bundesland IS NOT NULL
952: ,hr_general.decode_lookup('DE_FED_STATE', p_bundesland)
953: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));
954: fnd_file.put_line(fnd_file.output, ' ');
955: fnd_file.put_line(fnd_file.output, ' ');
956: --

Line 953: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));

949: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
950: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 29, ' ') || ' : '
951: || LOCAL_DECODE(p_bundesland IS NOT NULL
952: ,hr_general.decode_lookup('DE_FED_STATE', p_bundesland)
953: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));
954: fnd_file.put_line(fnd_file.output, ' ');
955: fnd_file.put_line(fnd_file.output, ' ');
956: --
957: --

Line 1008: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')

1004: -- Bundesland : <>
1005: -- Tax Office Name : <>
1006: -- Tax Office Code : <>
1007: --
1008: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')
1009: || ': ' || l_tax_office_rec.bundesland_description);
1010: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
1011: || ': ' || l_tax_office_rec.tax_office_name);
1012: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')

Line 1010: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')

1006: -- Tax Office Code : <>
1007: --
1008: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')
1009: || ': ' || l_tax_office_rec.bundesland_description);
1010: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
1011: || ': ' || l_tax_office_rec.tax_office_name);
1012: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')
1013: || ': ' || NVL(l_tax_office_rec.tax_office_no, ' '));
1014: fnd_file.put_line(fnd_file.output, ' ');

Line 1012: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')

1008: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'BUNDESLAND'), 30, ' ')
1009: || ': ' || l_tax_office_rec.bundesland_description);
1010: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_NAME'), 30, ' ')
1011: || ': ' || l_tax_office_rec.tax_office_name);
1012: fnd_file.put_line(fnd_file.output, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'TAX_OFFICE_CODE'), 30, ' ')
1013: || ': ' || NVL(l_tax_office_rec.tax_office_no, ' '));
1014: fnd_file.put_line(fnd_file.output, ' ');
1015: --
1016: --

Line 1100: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'SOCINS_PROV_UPLOAD'), 47, ' '));

1096: --
1097: -- Write heading for output file.
1098: --
1099: fnd_file.put_line(fnd_file.output, ' ');
1100: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'SOCINS_PROV_UPLOAD'), 47, ' '));
1101: fnd_file.put_line(fnd_file.output, ' ');
1102: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
1103: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
1104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 29, ' ') || ' : '

Line 1102: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '

1098: --
1099: fnd_file.put_line(fnd_file.output, ' ');
1100: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'SOCINS_PROV_UPLOAD'), 47, ' '));
1101: fnd_file.put_line(fnd_file.output, ' ');
1102: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
1103: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
1104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 29, ' ') || ' : '
1105: || LOCAL_DECODE(p_provider_type IS NOT NULL
1106: ,hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', p_provider_type)

Line 1103: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));

1099: fnd_file.put_line(fnd_file.output, ' ');
1100: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'SOCINS_PROV_UPLOAD'), 47, ' '));
1101: fnd_file.put_line(fnd_file.output, ' ');
1102: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
1103: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
1104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 29, ' ') || ' : '
1105: || LOCAL_DECODE(p_provider_type IS NOT NULL
1106: ,hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', p_provider_type)
1107: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));

Line 1104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 29, ' ') || ' : '

1100: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'SOCINS_PROV_UPLOAD'), 47, ' '));
1101: fnd_file.put_line(fnd_file.output, ' ');
1102: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
1103: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
1104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 29, ' ') || ' : '
1105: || LOCAL_DECODE(p_provider_type IS NOT NULL
1106: ,hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', p_provider_type)
1107: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));
1108: fnd_file.put_line(fnd_file.output, ' ');

Line 1106: ,hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', p_provider_type)

1102: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'UPLOAD_MODE'), 29, ' ') || ' : '
1103: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
1104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 29, ' ') || ' : '
1105: || LOCAL_DECODE(p_provider_type IS NOT NULL
1106: ,hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', p_provider_type)
1107: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));
1108: fnd_file.put_line(fnd_file.output, ' ');
1109: fnd_file.put_line(fnd_file.output, ' ');
1110: --

Line 1107: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));

1103: || hr_general.decode_lookup('DE_ORG_UPLOAD_MODE', p_upload_mode));
1104: fnd_file.put_line(fnd_file.output, LPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 29, ' ') || ' : '
1105: || LOCAL_DECODE(p_provider_type IS NOT NULL
1106: ,hr_general.decode_lookup('DE_ORG_UPLOAD_PROV_TYPES', p_provider_type)
1107: ,hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'ALL')));
1108: fnd_file.put_line(fnd_file.output, ' ');
1109: fnd_file.put_line(fnd_file.output, ' ');
1110: --
1111: --

Line 1179: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')

1175: -- Provider Name : <>
1176: -- East Betriebsnummer : <>
1177: -- West Betriebsnummer : <>
1178: --
1179: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
1180: || ': ' || l_soc_ins_prov_rec.provider_type_description);
1181: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
1182: || ': ' || l_soc_ins_prov_rec.provider_name);
1183: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')

Line 1181: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')

1177: -- West Betriebsnummer : <>
1178: --
1179: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
1180: || ': ' || l_soc_ins_prov_rec.provider_type_description);
1181: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
1182: || ': ' || l_soc_ins_prov_rec.provider_name);
1183: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
1184: || ': ' || NVL(l_soc_ins_prov_rec.east_betriebesnumber, ' '));
1185: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')

Line 1183: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')

1179: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
1180: || ': ' || l_soc_ins_prov_rec.provider_type_description);
1181: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
1182: || ': ' || l_soc_ins_prov_rec.provider_name);
1183: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
1184: || ': ' || NVL(l_soc_ins_prov_rec.east_betriebesnumber, ' '));
1185: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')
1186: || ': ' || NVL(l_soc_ins_prov_rec.west_betriebesnumber, ' '));
1187: fnd_file.put_line(fnd_file.log, ' ');

Line 1185: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')

1181: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
1182: || ': ' || l_soc_ins_prov_rec.provider_name);
1183: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'EAST_BETRIEBS'), 30, ' ')
1184: || ': ' || NVL(l_soc_ins_prov_rec.east_betriebesnumber, ' '));
1185: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'WEST_BETRIEBS'), 30, ' ')
1186: || ': ' || NVL(l_soc_ins_prov_rec.west_betriebesnumber, ' '));
1187: fnd_file.put_line(fnd_file.log, ' ');
1188: ELSE
1189: --

Line 1196: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')

1192: --
1193: -- Provider Type : <>
1194: -- Provider Name : <>
1195: --
1196: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
1197: || ': ' || l_soc_ins_prov_rec.provider_type_description);
1198: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
1199: || ': ' || l_soc_ins_prov_rec.provider_name);
1200: fnd_file.put_line(fnd_file.output, ' ');

Line 1198: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')

1194: -- Provider Name : <>
1195: --
1196: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_TYPE'), 30, ' ')
1197: || ': ' || l_soc_ins_prov_rec.provider_type_description);
1198: fnd_file.put_line(fnd_file.log, RPAD(hr_general.decode_lookup('DE_ORG_UPLOAD_LABELS', 'PROV_NAME'), 30, ' ')
1199: || ': ' || l_soc_ins_prov_rec.provider_name);
1200: fnd_file.put_line(fnd_file.output, ' ');
1201: END IF;
1202: --