DBA Data[Home] [Help]

APPS.PAY_NL_ANNUAL_SI_FILE dependencies on HR_GENERAL

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

30: hr_utility.set_location('Checking Field '||p_field,425);
31: end if;
32:
33: If p_value is null then
34: v_label_desc := hr_general.decode_lookup('HR_NL_REPORT_LABELS', p_field);
35: v_employee_dat :=RPAD(SUBSTR(g_assignment_number,1,20),20)
36: ||' '||RPAD(SUBSTR(g_full_name,1,25),25)
37: ||' '||RPAD(SUBSTR(v_label_desc,1,30),30)
38: ||' '||RPAD(SUBSTR(g_error_flag,1,15),15);

Line 363: nvl(FND_DATE.CANONICAL_TO_DATE(org_information2),hr_general.end_of_time)

359: and org_information_context = 'NL_SIP'
360: and org_information4 = p_si_provider_id
361: AND p_process_date between
362: FND_DATE.CANONICAL_TO_DATE(org_information1) and
363: nvl(FND_DATE.CANONICAL_TO_DATE(org_information2),hr_general.end_of_time)
364: ORDER BY ORG_INFORMATION7,DECODE(org_information3,'ZFW',1,'ZW',2,'WW',3,'WAO',4,'AMI',5,6) ;
365:
366: l_number NUMBER;
367: l_si_type number;

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

575: AND ppa.business_group_id = ppf.business_group_id
576: ORDER BY ppf.person_id';
577:
578: --Write to Log File
579: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
580: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
581: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
582: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
583: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);

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

576: ORDER BY ppf.person_id';
577:
578: --Write to Log File
579: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
580: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
581: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
582: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
583: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
584: Fnd_file.put_line(FND_FILE.LOG,v_log_header);

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

577:
578: --Write to Log File
579: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
580: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
581: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
582: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
583: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
584: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
585:

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

578: --Write to Log File
579: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
580: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
581: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
582: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
583: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
584: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
585:
586: if g_debug then

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

579: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
580: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
581: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
582: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
583: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
584: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
585:
586: if g_debug then
587: hr_utility.set_location('Leaving Range Code',350);

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

707:
708:
709: BEGIN
710:
711: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');
712:
713: get_all_parameters
714: (
715: p_payroll_action_id,