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_NL_NSI_PROCESS dependencies on HR_GENERAL

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

140: v_label_desc hr_lookups.meaning%TYPE;
141: Begin
142: hr_utility.set_location('Checking Field '||p_field,425);
143: If p_value is null then
144: v_label_desc := hr_general.decode_lookup('HR_NL_REPORT_LABELS', p_field);
145: v_employee_dat :=RPAD(SUBSTR(g_assignment_number,1,20),20)
146: ||' '||RPAD(SUBSTR(g_full_name,1,25),25)
147: ||' '||RPAD(SUBSTR(v_label_desc,1,25),25)
148: ||' '||RPAD(SUBSTR(g_error_flag,1,15),15);

Line 174: ,hr_general.decode_lookup('HR_NL_CITY', hr_loc.town_or_city) city

170: ,hr_loc.loc_information14 House_Num
171: ,hr_loc.loc_information15 House_Num_Add
172: ,hr_loc.region_1 street_name
173: ,pay_nl_general.get_postal_code(hr_loc.postal_code) postal_code
174: ,hr_general.decode_lookup('HR_NL_CITY', hr_loc.town_or_city) city
175: FROM hr_organization_units hr_org
176: ,hr_locations hr_loc
177: WHERE hr_org.organization_id = p_organization_id
178: AND hr_org.location_id = hr_loc.location_id (+);

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

197: AND hoi.org_information4 = p_si_provider_id
198: AND hoi.org_information3 IN('ZFW','ZW','WW','WAO','AMI')
199: AND p_nsi_process_date between
200: FND_DATE.CANONICAL_TO_DATE(hoi.org_information1) and
201: nvl(FND_DATE.CANONICAL_TO_DATE(hoi.org_information2),hr_general.end_of_time)
202: ORDER BY ORG_INFORMATION7,DECODE(hoi.org_information3,'ZFW',1,'ZW',2,'WW',3,'WAO',4,'AMI',5,6) ;
203: v_csr_get_sender_det csr_get_sender_det%ROWTYPE;
204: --
205: --

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

424: END IF;
425: --
426: --
427: --Write to Log File
428: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
429: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
430: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
431: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
432: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);

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

425: --
426: --
427: --Write to Log File
428: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
429: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
430: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
431: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
432: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
433: Fnd_file.put_line(FND_FILE.LOG,v_log_header);

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

426: --
427: --Write to Log File
428: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
429: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
430: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
431: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
432: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
433: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
434:

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

427: --Write to Log File
428: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
429: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
430: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
431: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
432: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
433: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
434:
435: hr_utility.set_location('Leaving Range Code',350);

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

428: v_log_header := RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','NL_ASSIGNMENT_NUMBER'),1,20),20)
429: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FULL_NAME'),1,25),25)
430: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','FIELD_NAME'),1,25),25)
431: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR_TYPE'),1,15),15)
432: ||' '||RPAD(SUBSTR(hr_general.decode_lookup('HR_NL_REPORT_LABELS','MESSAGE'),1,70),70);
433: Fnd_file.put_line(FND_FILE.LOG,v_log_header);
434:
435: hr_utility.set_location('Leaving Range Code',350);
436:

Line 479: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date

475: SELECT
476: paa.person_id ,paa.assignment_id
477: ,paa.organization_id,paa.effective_start_date ,paa.effective_end_date
478: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
479: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
480: ,hr_general.start_of_time cad_eff_start_date
481: ,hr_general.end_of_time cad_eff_end_date
482: ,scl_flx.SEGMENT2 Employment_Type
483: ,scl_flx.SEGMENT3 Employment_SubType

Line 480: ,hr_general.start_of_time cad_eff_start_date

476: paa.person_id ,paa.assignment_id
477: ,paa.organization_id,paa.effective_start_date ,paa.effective_end_date
478: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
479: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
480: ,hr_general.start_of_time cad_eff_start_date
481: ,hr_general.end_of_time cad_eff_end_date
482: ,scl_flx.SEGMENT2 Employment_Type
483: ,scl_flx.SEGMENT3 Employment_SubType
484: ,scl_flx.SEGMENT6 Work_Pattern

Line 481: ,hr_general.end_of_time cad_eff_end_date

477: ,paa.organization_id,paa.effective_start_date ,paa.effective_end_date
478: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
479: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
480: ,hr_general.start_of_time cad_eff_start_date
481: ,hr_general.end_of_time cad_eff_end_date
482: ,scl_flx.SEGMENT2 Employment_Type
483: ,scl_flx.SEGMENT3 Employment_SubType
484: ,scl_flx.SEGMENT6 Work_Pattern
485: ,paa.assignment_status_type_id

Line 506: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)

502: AND ee_si.aei_information_category='NL_SII'
503: AND ee_si.aei_information3 IN('ZFW','ZW','WW','WAO','AMI')
504: AND paa.effective_start_date
505: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)
506: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)
507: and paa.effective_start_date BETWEEN lp_last_nsi_process_date AND lp_nsi_process_date
508: AND (lp_report_type = 'NL_GAK_NSI_ARCHIVE' ) /* Gak Asg Date Track Changes*/
509: UNION
510: SELECT

Line 514: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date

510: SELECT
511: paa.person_id,paa.assignment_id
512: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
513: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
514: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
515: ,hr_general.start_of_time cad_eff_start_date
516: ,hr_general.end_of_time cad_eff_end_date
517: ,scl_flx.SEGMENT2 Employment_Type
518: ,scl_flx.SEGMENT3 Employment_SubType

Line 515: ,hr_general.start_of_time cad_eff_start_date

511: paa.person_id,paa.assignment_id
512: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
513: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
514: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
515: ,hr_general.start_of_time cad_eff_start_date
516: ,hr_general.end_of_time cad_eff_end_date
517: ,scl_flx.SEGMENT2 Employment_Type
518: ,scl_flx.SEGMENT3 Employment_SubType
519: ,scl_flx.SEGMENT6 Work_Pattern

Line 516: ,hr_general.end_of_time cad_eff_end_date

512: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
513: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
514: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
515: ,hr_general.start_of_time cad_eff_start_date
516: ,hr_general.end_of_time cad_eff_end_date
517: ,scl_flx.SEGMENT2 Employment_Type
518: ,scl_flx.SEGMENT3 Employment_SubType
519: ,scl_flx.SEGMENT6 Work_Pattern
520: ,paa.assignment_status_type_id

Line 547: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date

543: SELECT
544: paa.person_id,paa.assignment_id
545: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
546: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
547: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
548: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date
549: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date
550: ,scl_flx.SEGMENT2 Employment_Type
551: ,scl_flx.SEGMENT3 Employment_SubType

Line 549: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date

545: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
546: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
547: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
548: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date
549: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date
550: ,scl_flx.SEGMENT2 Employment_Type
551: ,scl_flx.SEGMENT3 Employment_SubType
552: ,scl_flx.SEGMENT6 Work_Pattern
553: ,paa.assignment_status_type_id

Line 575: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)

571: AND ee_si.aei_information_category='NL_SII'
572: AND ee_si.aei_information3 IN('ZFW','ZW','WW','WAO','AMI')
573: AND paa.effective_start_date
574: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)
575: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)
576: AND paa.assignment_id = ee_cadans.assignment_id(+)
577: AND ee_cadans.aei_information_category='NL_CADANS_INFO'
578: and paa.effective_start_date BETWEEN lp_last_nsi_process_date AND lp_nsi_process_date
579: AND paa.effective_start_date

Line 580: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time)

576: AND paa.assignment_id = ee_cadans.assignment_id(+)
577: AND ee_cadans.aei_information_category='NL_CADANS_INFO'
578: and paa.effective_start_date BETWEEN lp_last_nsi_process_date AND lp_nsi_process_date
579: AND paa.effective_start_date
580: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time)
581: AND (lp_report_type = 'NL_CAD_NSI_ARCHIVE' OR lp_report_type='NL_CADZ_NSI_ARCHIVE' ) /* Cadans Asg Date Track Changes*/
582: UNION
583: SELECT
584: paa.person_id,paa.assignment_id

Line 587: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date

583: SELECT
584: paa.person_id,paa.assignment_id
585: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
586: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
587: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
588: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date
589: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date
590: ,scl_flx.SEGMENT2 Employment_Type
591: ,scl_flx.SEGMENT3 Employment_SubType

Line 589: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date

585: ,paa.organization_id,paa.effective_start_date,paa.effective_end_date
586: ,FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1) si_eff_start_date
587: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time) si_eff_end_date
588: ,FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1) cad_eff_start_date
589: ,NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.end_of_time) cad_eff_end_date
590: ,scl_flx.SEGMENT2 Employment_Type
591: ,scl_flx.SEGMENT3 Employment_SubType
592: ,scl_flx.SEGMENT6 Work_Pattern
593: ,paa.assignment_status_type_id

Line 616: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)

612: AND ee_si.aei_information_category='NL_SII'
613: AND ee_si.aei_information3 IN('ZFW','ZW','WW','WAO','AMI')
614: AND paa.effective_start_date
615: BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information1)
616: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_si.aei_information2),hr_general.end_of_time)
617: AND FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)
618: BETWEEN paa.effective_start_date AND paa.effective_end_date
619: AND paa.assignment_id = ee_cadans.assignment_id
620: AND ee_cadans.aei_information_category='NL_CADANS_INFO'

Line 801: ,hr_general.decode_lookup('HR_NL_CITY', ee_addr.town_or_city) city

797: ,ee_addr.add_information13 House_Num
798: ,ee_addr.add_information14 House_Num_Add
799: ,ee_addr.region_1 street_name
800: ,pay_nl_general.get_postal_code(ee_addr.postal_code) postal_code
801: ,hr_general.decode_lookup('HR_NL_CITY', ee_addr.town_or_city) city
802: ,ee_addr.country country
803: FROM per_addresses ee_addr
804: WHERE ee_addr.person_id = lp_person_id
805: AND lp_effective_date between date_from and NVL(date_to,hr_general.end_of_time)

Line 805: AND lp_effective_date between date_from and NVL(date_to,hr_general.end_of_time)

801: ,hr_general.decode_lookup('HR_NL_CITY', ee_addr.town_or_city) city
802: ,ee_addr.country country
803: FROM per_addresses ee_addr
804: WHERE ee_addr.person_id = lp_person_id
805: AND lp_effective_date between date_from and NVL(date_to,hr_general.end_of_time)
806: AND ((ee_addr.primary_flag ='Y' AND lp_address_type IS NULL)
807: OR (lp_address_type IS NOT NULL AND ee_addr.address_type = lp_address_type));
808: v_csr_ee_addr csr_ee_addr%ROWTYPE;
809: v_csr_ee_addr1 csr_ee_addr%ROWTYPE;

Line 817: hr_general.decode_lookup('NL_GAK_OCCUPATION_DESCRIPTION',ee_gak.aei_information3) Occupation_Desc

813: CURSOR csr_ee_gak (lp_person_id NUMBER
814: ,lp_assignment_id NUMBER
815: ,lp_process_date DATE) IS
816: SELECT
817: hr_general.decode_lookup('NL_GAK_OCCUPATION_DESCRIPTION',ee_gak.aei_information3) Occupation_Desc
818: ,ee_gak.aei_information4 Weekly_4_Exp_SI_Days
819: FROM per_assignment_extra_info ee_gak
820: WHERE ee_gak.assignment_id = lp_assignment_id
821: AND ee_gak.aei_information_category='NL_GAK_INFO'

Line 823: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_gak.aei_information2),hr_general.END_OF_TIME) ;

819: FROM per_assignment_extra_info ee_gak
820: WHERE ee_gak.assignment_id = lp_assignment_id
821: AND ee_gak.aei_information_category='NL_GAK_INFO'
822: AND lp_process_date BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_gak.aei_information1)
823: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_gak.aei_information2),hr_general.END_OF_TIME) ;
824: v_csr_ee_gak csr_ee_gak%ROWTYPE;
825:
826: --Select EE Cadans Info
827: CURSOR csr_ee_cadans (lp_person_id NUMBER

Line 840: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.END_OF_TIME) ;

836: FROM per_assignment_extra_info ee_cadans
837: WHERE ee_cadans.assignment_id = lp_assignment_id
838: AND ee_cadans.aei_information_category='NL_CADANS_INFO'
839: AND lp_process_date BETWEEN FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information1)
840: AND NVL(FND_DATE.CANONICAL_TO_DATE(ee_cadans.aei_information2),hr_general.END_OF_TIME) ;
841: v_csr_ee_cadans csr_ee_cadans%ROWTYPE;
842:
843: l_last_nsi_min_notify_date DATE;
844:

Line 947: ,NVL(l_last_nsi_min_notify_date,hr_general.START_OF_TIME),p_cur_nsi_process_date );

943:
944: OPEN csr_ee_asg_si_info(p_report_type
945: ,p_person_id,p_assignment_id
946: ,p_si_provider_id
947: ,NVL(l_last_nsi_min_notify_date,hr_general.START_OF_TIME),p_cur_nsi_process_date );
948: LOOP
949: FETCH csr_ee_asg_si_info INTO csr_ee_asg_nsi;
950: EXIT WHEN (csr_ee_asg_si_info%NOTFOUND OR g_error_count>0);
951: hr_utility.set_location(' Date Track ee_nsi.Eff_St_Date '||csr_ee_asg_nsi.Effective_Start_Date,350);

Line 1856: and lp_process_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);

1852: where pos.organization_structure_id = posv.organization_structure_id
1853: and to_char(pos.organization_structure_id) IN (select org_information1
1854: from hr_organization_information hoi where hoi.org_information_context='NL_BG_INFO'
1855: and hoi.organization_id=lp_business_group_id)
1856: and lp_process_date between posv.date_from and nvl(posv.date_to,hr_general.End_of_time);
1857: v_csr_org_hierarchy csr_org_hierarchy%ROWTYPE;
1858: -- Cursor to retrieve All Employee SI Records.
1859: -- as on Process Date
1860: CURSOR csr_employee_si_info(lp_business_group_id number

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

2004: --hr_utility.trace_on(NULL,'NL_NSI');
2005:
2006: hr_utility.set_location('Entering Assignment Action Code',400);
2007: --
2008: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');
2009: g_warning_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','WARNING');
2010:
2011: PAY_NL_NSI_PROCESS.get_all_parameters
2012: (p_payroll_action_id => p_payroll_action_id

Line 2009: g_warning_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','WARNING');

2005:
2006: hr_utility.set_location('Entering Assignment Action Code',400);
2007: --
2008: g_error_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','ERROR');
2009: g_warning_flag := hr_general.decode_lookup('HR_NL_REPORT_LABELS','WARNING');
2010:
2011: PAY_NL_NSI_PROCESS.get_all_parameters
2012: (p_payroll_action_id => p_payroll_action_id
2013: ,p_business_group_id => l_business_group_id