DBA Data[Home] [Help]

APPS.PAY_NL_TAXOFFICE_ARCHIVE dependencies on HR_GENERAL

Line 140: v_label_desc := hr_general.decode_lookup('HR_NL_REPORT_LABELS', p_field);

136: hr_utility.set_location('Checking Field '||p_field,425);
137: end if;
138:
139: If p_value is null then
140: v_label_desc := hr_general.decode_lookup('HR_NL_REPORT_LABELS', p_field);
141: v_employee_dat :=RPAD(SUBSTR(g_assignment_number,1,20),20)
142: ||' '||RPAD(SUBSTR(g_full_name,1,25),25)
143: ||' '||RPAD(SUBSTR(v_label_desc,1,25),25)
144: ||' '||RPAD(SUBSTR(g_error_flag,1,15),15);

Line 184: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)

180: ORDER BY ppf.person_id';
181:
182:
183: --Write to Log File
184: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
185: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
186: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
187: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
188: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);

Line 185: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)

181:
182:
183: --Write to Log File
184: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
185: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
186: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
187: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
188: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
189: Fnd_file.put_line(FND_FILE.LOG,v_log_header);

Line 186: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)

182:
183: --Write to Log File
184: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
185: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
186: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
187: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
188: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
189: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
190:

Line 187: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)

183: --Write to Log File
184: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
185: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
186: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
187: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
188: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
189: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
190:
191: if g_debug then

Line 188: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);

184: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
185: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
186: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
187: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
188: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
189: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
190:
191: if g_debug then
192: hr_utility.set_location('Leaving Range Code',350);

Line 346: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');

342: l_tax_year_start_date := to_date('01/01/'||l_tax_year_date,'DD/MM/YYYY');
343:
344: populate_UserBal(l_business_group_id,l_tax_year_end_date);
345:
346: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');
347:
348: if g_debug then
349: hr_utility.set_location('l_tax_year_date'||l_tax_year_date,425);
350: hr_utility.set_location('l_tax_year_end_date'||l_tax_year_end_date,425);

Line 2844: and p_tax_year_end_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);

2840: per_organization_structures pos,
2841: per_org_structure_versions posv
2842: where pos.organization_structure_id = posv.organization_structure_id
2843: and to_char(pos.organization_structure_id) = p_org_struct_id
2844: and p_tax_year_end_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);
2845:
2846: l_org_structure_version_id number;
2847:
2848: BEGIN