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.PQP_NL_EXT_FUNCTIONS dependencies on BEN_EXT_CHG_EVT_LOG

Line 31: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;

27: ,p_org_information6 varchar2
28: ,p_effective_date date
29: ) IS
30:
31: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
32: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
33: l_business_group_id ben_ext_chg_evt_log.business_group_id%TYPE;
34: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
35: l_enabled varchar2(1) := 'N';

Line 32: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;

28: ,p_effective_date date
29: ) IS
30:
31: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
32: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
33: l_business_group_id ben_ext_chg_evt_log.business_group_id%TYPE;
34: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
35: l_enabled varchar2(1) := 'N';
36:

Line 33: l_business_group_id ben_ext_chg_evt_log.business_group_id%TYPE;

29: ) IS
30:
31: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
32: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
33: l_business_group_id ben_ext_chg_evt_log.business_group_id%TYPE;
34: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
35: l_enabled varchar2(1) := 'N';
36:
37: CURSOR c_get_bgid IS

Line 104: FROM ben_ext_chg_evt_log

100:
101: CURSOR c_get_chg_evt_log IS
102: SELECT ext_chg_evt_log_id,chg_evt_cd,chg_eff_dt,prmtr_01,
103: prmtr_02,prmtr_04,prmtr_05,business_group_id,object_version_number
104: FROM ben_ext_chg_evt_log
105: WHERE new_val1 = p_org_information1_o
106: AND new_val2 = nvl(p_org_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))
107: AND prmtr_01 = 'ORG'
108: AND prmtr_02 = p_org_information3_o

Line 117: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;

113: SELECT business_group_id
114: FROM hr_all_organization_units
115: WHERE organization_id = p_organization_id;
116:
117: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
118: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
119: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
120: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
121: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;

Line 118: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;

114: FROM hr_all_organization_units
115: WHERE organization_id = p_organization_id;
116:
117: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
118: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
119: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
120: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
121: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
122: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;

Line 119: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;

115: WHERE organization_id = p_organization_id;
116:
117: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
118: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
119: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
120: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
121: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
122: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;
123: l_prmtr4 ben_ext_chg_evt_log.prmtr_04%TYPE;

Line 120: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;

116:
117: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
118: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
119: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
120: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
121: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
122: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;
123: l_prmtr4 ben_ext_chg_evt_log.prmtr_04%TYPE;
124: l_prmtr5 ben_ext_chg_evt_log.prmtr_05%TYPE;

Line 121: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;

117: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
118: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
119: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
120: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
121: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
122: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;
123: l_prmtr4 ben_ext_chg_evt_log.prmtr_04%TYPE;
124: l_prmtr5 ben_ext_chg_evt_log.prmtr_05%TYPE;
125: l_bgid ben_ext_chg_evt_log.business_group_id%TYPE;

Line 122: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;

118: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
119: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
120: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
121: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
122: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;
123: l_prmtr4 ben_ext_chg_evt_log.prmtr_04%TYPE;
124: l_prmtr5 ben_ext_chg_evt_log.prmtr_05%TYPE;
125: l_bgid ben_ext_chg_evt_log.business_group_id%TYPE;
126: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;

Line 123: l_prmtr4 ben_ext_chg_evt_log.prmtr_04%TYPE;

119: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
120: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
121: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
122: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;
123: l_prmtr4 ben_ext_chg_evt_log.prmtr_04%TYPE;
124: l_prmtr5 ben_ext_chg_evt_log.prmtr_05%TYPE;
125: l_bgid ben_ext_chg_evt_log.business_group_id%TYPE;
126: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
127: l_enabled varchar2(1) := 'N';

Line 124: l_prmtr5 ben_ext_chg_evt_log.prmtr_05%TYPE;

120: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
121: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
122: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;
123: l_prmtr4 ben_ext_chg_evt_log.prmtr_04%TYPE;
124: l_prmtr5 ben_ext_chg_evt_log.prmtr_05%TYPE;
125: l_bgid ben_ext_chg_evt_log.business_group_id%TYPE;
126: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
127: l_enabled varchar2(1) := 'N';
128:

Line 125: l_bgid ben_ext_chg_evt_log.business_group_id%TYPE;

121: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
122: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;
123: l_prmtr4 ben_ext_chg_evt_log.prmtr_04%TYPE;
124: l_prmtr5 ben_ext_chg_evt_log.prmtr_05%TYPE;
125: l_bgid ben_ext_chg_evt_log.business_group_id%TYPE;
126: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
127: l_enabled varchar2(1) := 'N';
128:
129: BEGIN

Line 328: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;

324: AND effective_end_date;
325:
326: l_person_id per_all_assignments_f.person_id%TYPE;
327: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
328: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
329: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
330: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
331: l_enabled VARCHAR2(1) := 'N';
332:

Line 329: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;

325:
326: l_person_id per_all_assignments_f.person_id%TYPE;
327: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
328: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
329: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
330: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
331: l_enabled VARCHAR2(1) := 'N';
332:
333: BEGIN

Line 409: FROM ben_ext_chg_evt_log

405: CURSOR c_chk_log_exists (c_person_id IN NUMBER) IS
406: SELECT object_version_number
407: ,ext_chg_evt_log_id
408: ,chg_eff_dt
409: FROM ben_ext_chg_evt_log
410: WHERE person_id = c_person_id
411: AND chg_evt_cd = 'COAPP'
412: AND prmtr_03 = fnd_number.number_to_canonical(p_assignment_extra_info_id);
413:

Line 416: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;

412: AND prmtr_03 = fnd_number.number_to_canonical(p_assignment_extra_info_id);
413:
414: l_person_id per_all_assignments_f.person_id%TYPE;
415: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
416: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
417: l_sub_cat pqp_pension_types_f.pension_sub_category%TYPE;
418: l_enabled VARCHAR2(1) := 'N';
419: l_log_xst_ovn NUMBER;
420: l_xst_log_id NUMBER;

Line 503: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;

499: ,p_org_information3 varchar2
500: ,p_effective_date date
501: ) IS
502:
503: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
504: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
505: l_business_group_id ben_ext_chg_evt_log.business_group_id%TYPE;
506: l_enabled varchar2(1) := 'N';
507:

Line 504: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;

500: ,p_effective_date date
501: ) IS
502:
503: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
504: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
505: l_business_group_id ben_ext_chg_evt_log.business_group_id%TYPE;
506: l_enabled varchar2(1) := 'N';
507:
508: CURSOR c_get_bgid IS

Line 505: l_business_group_id ben_ext_chg_evt_log.business_group_id%TYPE;

501: ) IS
502:
503: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
504: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
505: l_business_group_id ben_ext_chg_evt_log.business_group_id%TYPE;
506: l_enabled varchar2(1) := 'N';
507:
508: CURSOR c_get_bgid IS
509: SELECT business_group_id

Line 564: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;

560: SELECT business_group_id
561: FROM hr_all_organization_units
562: WHERE organization_id = p_organization_id;
563:
564: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
565: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
566: l_bgid ben_ext_chg_evt_log.business_group_id%TYPE;
567: l_enabled varchar2(1) := 'N';
568:

Line 565: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;

561: FROM hr_all_organization_units
562: WHERE organization_id = p_organization_id;
563:
564: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
565: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
566: l_bgid ben_ext_chg_evt_log.business_group_id%TYPE;
567: l_enabled varchar2(1) := 'N';
568:
569: BEGIN

Line 566: l_bgid ben_ext_chg_evt_log.business_group_id%TYPE;

562: WHERE organization_id = p_organization_id;
563:
564: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
565: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
566: l_bgid ben_ext_chg_evt_log.business_group_id%TYPE;
567: l_enabled varchar2(1) := 'N';
568:
569: BEGIN
570:

Line 624: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;

620: AND effective_end_date;
621:
622: l_person_id per_all_assignments_f.person_id%TYPE;
623: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
624: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
625: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
626: l_enabled varchar2(1) := 'N';
627:
628: BEGIN

Line 625: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;

621:
622: l_person_id per_all_assignments_f.person_id%TYPE;
623: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
624: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
625: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
626: l_enabled varchar2(1) := 'N';
627:
628: BEGIN
629:

Line 683: CURSOR c_get_chg_evt_log(c_person_id IN ben_ext_chg_evt_log.person_id%TYPE) IS

679: WHERE assignment_id = p_assignment_id
680: AND p_effective_date BETWEEN effective_start_date
681: AND effective_end_date;
682:
683: CURSOR c_get_chg_evt_log(c_person_id IN ben_ext_chg_evt_log.person_id%TYPE) IS
684: SELECT ext_chg_evt_log_id,chg_evt_cd,chg_eff_dt,prmtr_01,
685: prmtr_02,business_group_id,object_version_number
686: FROM ben_ext_chg_evt_log
687: WHERE new_val1 = p_aei_information1_o

Line 686: FROM ben_ext_chg_evt_log

682:
683: CURSOR c_get_chg_evt_log(c_person_id IN ben_ext_chg_evt_log.person_id%TYPE) IS
684: SELECT ext_chg_evt_log_id,chg_evt_cd,chg_eff_dt,prmtr_01,
685: prmtr_02,business_group_id,object_version_number
686: FROM ben_ext_chg_evt_log
687: WHERE new_val1 = p_aei_information1_o
688: AND new_val2 = nvl(p_aei_information2_o,fnd_date.date_to_canonical(hr_api.g_eot))
689: AND prmtr_01 = 'ASG'
690: AND prmtr_02 = p_aei_information3_o

Line 696: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;

692: AND chg_evt_cd = 'COSIPD';
693:
694: l_person_id per_all_assignments_f.person_id%TYPE;
695: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
696: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
697: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
698: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
699: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
700: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;

Line 697: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;

693:
694: l_person_id per_all_assignments_f.person_id%TYPE;
695: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
696: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
697: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
698: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
699: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
700: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;
701: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;

Line 698: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;

694: l_person_id per_all_assignments_f.person_id%TYPE;
695: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
696: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
697: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
698: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
699: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
700: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;
701: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
702: l_enabled varchar2(1) := 'N';

Line 699: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;

695: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
696: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
697: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
698: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
699: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
700: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;
701: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
702: l_enabled varchar2(1) := 'N';
703:

Line 700: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;

696: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
697: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
698: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
699: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
700: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;
701: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
702: l_enabled varchar2(1) := 'N';
703:
704: BEGIN

Line 701: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;

697: l_cd ben_ext_chg_evt_log.chg_evt_cd%TYPE;
698: l_eff_dt ben_ext_chg_evt_log.chg_eff_dt%TYPE;
699: l_prmtr1 ben_ext_chg_evt_log.prmtr_01%TYPE;
700: l_prmtr2 ben_ext_chg_evt_log.prmtr_02%TYPE;
701: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
702: l_enabled varchar2(1) := 'N';
703:
704: BEGIN
705:

Line 815: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;

811: AND end_date;
812:
813: l_person_id per_all_assignments_f.person_id%TYPE;
814: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
815: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
816: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
817: l_date Date;
818: l_payroll_id Number;
819: l_eff_date Date;

Line 816: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;

812:
813: l_person_id per_all_assignments_f.person_id%TYPE;
814: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
815: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
816: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
817: l_date Date;
818: l_payroll_id Number;
819: l_eff_date Date;
820: l_enabled varchar2(1) := 'N';

Line 984: FROM ben_ext_chg_evt_log

980: CURSOR c_chk_log_exists (c_person_id IN NUMBER) IS
981: SELECT object_version_number
982: ,ext_chg_evt_log_id
983: ,chg_eff_dt
984: FROM ben_ext_chg_evt_log
985: WHERE person_id = c_person_id
986: AND chg_evt_cd = 'COAPKOP'
987: AND prmtr_03 = fnd_number.number_to_canonical(p_assignment_extra_info_id);
988:

Line 991: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;

987: AND prmtr_03 = fnd_number.number_to_canonical(p_assignment_extra_info_id);
988:
989: l_person_id per_all_assignments_f.person_id%TYPE;
990: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
991: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
992: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
993: l_date Date;
994: l_payroll_id Number;
995: l_eff_date Date;

Line 992: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;

988:
989: l_person_id per_all_assignments_f.person_id%TYPE;
990: l_business_group_id per_all_assignments_f.business_group_id%TYPE;
991: l_log_id ben_ext_chg_evt_log.ext_chg_evt_log_id%TYPE;
992: l_ovn ben_ext_chg_evt_log.object_version_number%TYPE;
993: l_date Date;
994: l_payroll_id Number;
995: l_eff_date Date;
996: l_enabled varchar2(1) := 'N';