116: and pgm.pgm_typ_cd in ('COBRAFLX', 'FLEX', 'FPC')
117: and nvl(p_lf_evt_ocrd_dt,p_effective_date)
118: between pgm.effective_start_date
119: and pgm.effective_end_date
120: and nvl(epe.request_id,-1) = fnd_global.conc_request_id
121: order by 1;
122:
123: -- Used for PLIP and Combo PLIP
124: cursor c_epe_plip is
131: and pgm.pgm_typ_cd in ('COBRAFLX', 'FLEX', 'FPC')
132: and nvl(p_lf_evt_ocrd_dt,p_effective_date)
133: between pgm.effective_start_date
134: and pgm.effective_end_date
135: and nvl(epe.request_id,-1) = fnd_global.conc_request_id
136: order by 1, 2;
137:
138: -- Used for PTIP and Combo PTIP
139: cursor c_epe_ptip is
145: and pgm.pgm_typ_cd in ('COBRAFLX', 'FLEX', 'FPC')
146: and nvl(p_lf_evt_ocrd_dt,p_effective_date)
147: between pgm.effective_start_date
148: and pgm.effective_end_date
149: and nvl(epe.request_id,-1) = fnd_global.conc_request_id
150: order by 1, 2;
151:
152: -- Used for OIPLIP and Combo PTIP Option
153: cursor c_epe_oipl is
160: and pgm.pgm_typ_cd in ('COBRAFLX', 'FLEX', 'FPC')
161: and nvl(p_lf_evt_ocrd_dt,p_effective_date)
162: between pgm.effective_start_date
163: and pgm.effective_end_date
164: and nvl(epe.request_id,-1) = fnd_global.conc_request_id
165: order by 1, 2,3,4;
166:
167: -- Get Flex Credits at PGM level
168: cursor c_abr1 is
668: p_bnft_prvdr_pool_id => l_bnft_prvdr_pool_id,
669: p_per_in_ler_id => p_per_in_ler_id,
670: p_yr_perd_id => l_yr_perd_id,
671: p_business_group_id => p_business_group_id,
672: p_program_application_id => fnd_global.prog_appl_id,
673: p_program_id => fnd_global.conc_program_id,
674: p_request_id => fnd_global.conc_request_id,
675: p_program_update_date => sysdate,
676: p_object_version_number => l_object_version_number,
669: p_per_in_ler_id => p_per_in_ler_id,
670: p_yr_perd_id => l_yr_perd_id,
671: p_business_group_id => p_business_group_id,
672: p_program_application_id => fnd_global.prog_appl_id,
673: p_program_id => fnd_global.conc_program_id,
674: p_request_id => fnd_global.conc_request_id,
675: p_program_update_date => sysdate,
676: p_object_version_number => l_object_version_number,
677: p_effective_date => p_effective_date);
670: p_yr_perd_id => l_yr_perd_id,
671: p_business_group_id => p_business_group_id,
672: p_program_application_id => fnd_global.prog_appl_id,
673: p_program_id => fnd_global.conc_program_id,
674: p_request_id => fnd_global.conc_request_id,
675: p_program_update_date => sysdate,
676: p_object_version_number => l_object_version_number,
677: p_effective_date => p_effective_date);
678: hr_utility.set_location('Dn BEPECAPI_CRE 1: '||l_proc,10);
827: p_bnft_prvdr_pool_id => l_bnft_prvdr_pool_id,
828: p_per_in_ler_id => p_per_in_ler_id,
829: p_yr_perd_id => l_yr_perd_id,
830: p_business_group_id => p_business_group_id,
831: p_program_application_id => fnd_global.prog_appl_id,
832: p_program_id => fnd_global.conc_program_id,
833: p_request_id => fnd_global.conc_request_id,
834: p_program_update_date => sysdate,
835: p_object_version_number => l_object_version_number,
828: p_per_in_ler_id => p_per_in_ler_id,
829: p_yr_perd_id => l_yr_perd_id,
830: p_business_group_id => p_business_group_id,
831: p_program_application_id => fnd_global.prog_appl_id,
832: p_program_id => fnd_global.conc_program_id,
833: p_request_id => fnd_global.conc_request_id,
834: p_program_update_date => sysdate,
835: p_object_version_number => l_object_version_number,
836: p_effective_date => p_effective_date);
829: p_yr_perd_id => l_yr_perd_id,
830: p_business_group_id => p_business_group_id,
831: p_program_application_id => fnd_global.prog_appl_id,
832: p_program_id => fnd_global.conc_program_id,
833: p_request_id => fnd_global.conc_request_id,
834: p_program_update_date => sysdate,
835: p_object_version_number => l_object_version_number,
836: p_effective_date => p_effective_date);
837: hr_utility.set_location('Dn BEPECAPI_CRE 2: ',10);
993: p_bnft_prvdr_pool_id => l_bnft_prvdr_pool_id,
994: p_per_in_ler_id => p_per_in_ler_id,
995: p_yr_perd_id => l_yr_perd_id,
996: p_business_group_id => p_business_group_id,
997: p_program_application_id => fnd_global.prog_appl_id,
998: p_program_id => fnd_global.conc_program_id,
999: p_request_id => fnd_global.conc_request_id,
1000: p_program_update_date => sysdate,
1001: p_object_version_number => l_object_version_number,
994: p_per_in_ler_id => p_per_in_ler_id,
995: p_yr_perd_id => l_yr_perd_id,
996: p_business_group_id => p_business_group_id,
997: p_program_application_id => fnd_global.prog_appl_id,
998: p_program_id => fnd_global.conc_program_id,
999: p_request_id => fnd_global.conc_request_id,
1000: p_program_update_date => sysdate,
1001: p_object_version_number => l_object_version_number,
1002: p_effective_date => p_effective_date);
995: p_yr_perd_id => l_yr_perd_id,
996: p_business_group_id => p_business_group_id,
997: p_program_application_id => fnd_global.prog_appl_id,
998: p_program_id => fnd_global.conc_program_id,
999: p_request_id => fnd_global.conc_request_id,
1000: p_program_update_date => sysdate,
1001: p_object_version_number => l_object_version_number,
1002: p_effective_date => p_effective_date);
1003: hr_utility.set_location('Dn BEPECAPI_CRE 5: ',10);
1129: p_per_in_ler_id => p_per_in_ler_id,
1130: p_yr_perd_id => l_yr_perd_id,
1131: p_ptip_ordr_num => l_epe_ptip.ptip_ordr_num,
1132: p_business_group_id => p_business_group_id,
1133: p_program_application_id => fnd_global.prog_appl_id,
1134: p_program_id => fnd_global.conc_program_id,
1135: p_request_id => fnd_global.conc_request_id,
1136: p_program_update_date => sysdate,
1137: p_object_version_number => l_object_version_number,
1130: p_yr_perd_id => l_yr_perd_id,
1131: p_ptip_ordr_num => l_epe_ptip.ptip_ordr_num,
1132: p_business_group_id => p_business_group_id,
1133: p_program_application_id => fnd_global.prog_appl_id,
1134: p_program_id => fnd_global.conc_program_id,
1135: p_request_id => fnd_global.conc_request_id,
1136: p_program_update_date => sysdate,
1137: p_object_version_number => l_object_version_number,
1138: p_effective_date => p_effective_date);
1131: p_ptip_ordr_num => l_epe_ptip.ptip_ordr_num,
1132: p_business_group_id => p_business_group_id,
1133: p_program_application_id => fnd_global.prog_appl_id,
1134: p_program_id => fnd_global.conc_program_id,
1135: p_request_id => fnd_global.conc_request_id,
1136: p_program_update_date => sysdate,
1137: p_object_version_number => l_object_version_number,
1138: p_effective_date => p_effective_date);
1139: hr_utility.set_location('Dn BEPECAPI_CRE 3: ',10);
1265: p_bnft_prvdr_pool_id => l_bnft_prvdr_pool_id,
1266: p_per_in_ler_id => p_per_in_ler_id,
1267: p_yr_perd_id => l_yr_perd_id,
1268: p_business_group_id => p_business_group_id,
1269: p_program_application_id => fnd_global.prog_appl_id,
1270: p_program_id => fnd_global.conc_program_id,
1271: p_request_id => fnd_global.conc_request_id,
1272: p_program_update_date => sysdate,
1273: p_object_version_number => l_object_version_number,
1266: p_per_in_ler_id => p_per_in_ler_id,
1267: p_yr_perd_id => l_yr_perd_id,
1268: p_business_group_id => p_business_group_id,
1269: p_program_application_id => fnd_global.prog_appl_id,
1270: p_program_id => fnd_global.conc_program_id,
1271: p_request_id => fnd_global.conc_request_id,
1272: p_program_update_date => sysdate,
1273: p_object_version_number => l_object_version_number,
1274: p_effective_date => p_effective_date);
1267: p_yr_perd_id => l_yr_perd_id,
1268: p_business_group_id => p_business_group_id,
1269: p_program_application_id => fnd_global.prog_appl_id,
1270: p_program_id => fnd_global.conc_program_id,
1271: p_request_id => fnd_global.conc_request_id,
1272: p_program_update_date => sysdate,
1273: p_object_version_number => l_object_version_number,
1274: p_effective_date => p_effective_date);
1275: hr_utility.set_location('Dn BEPECAPI_CRE 4: ',10);
1467: p_bnft_prvdr_pool_id => l_bnft_prvdr_pool_id,
1468: p_per_in_ler_id => p_per_in_ler_id,
1469: p_yr_perd_id => l_yr_perd_id,
1470: p_business_group_id => p_business_group_id,
1471: p_program_application_id => fnd_global.prog_appl_id,
1472: p_program_id => fnd_global.conc_program_id,
1473: p_request_id => fnd_global.conc_request_id,
1474: p_program_update_date => sysdate,
1475: p_object_version_number => l_object_version_number,
1468: p_per_in_ler_id => p_per_in_ler_id,
1469: p_yr_perd_id => l_yr_perd_id,
1470: p_business_group_id => p_business_group_id,
1471: p_program_application_id => fnd_global.prog_appl_id,
1472: p_program_id => fnd_global.conc_program_id,
1473: p_request_id => fnd_global.conc_request_id,
1474: p_program_update_date => sysdate,
1475: p_object_version_number => l_object_version_number,
1476: p_effective_date => p_effective_date);
1469: p_yr_perd_id => l_yr_perd_id,
1470: p_business_group_id => p_business_group_id,
1471: p_program_application_id => fnd_global.prog_appl_id,
1472: p_program_id => fnd_global.conc_program_id,
1473: p_request_id => fnd_global.conc_request_id,
1474: p_program_update_date => sysdate,
1475: p_object_version_number => l_object_version_number,
1476: p_effective_date => p_effective_date);
1477: --
1670: p_bnft_prvdr_pool_id => l_bnft_prvdr_pool_id,
1671: p_per_in_ler_id => p_per_in_ler_id,
1672: p_yr_perd_id => l_yr_perd_id,
1673: p_business_group_id => p_business_group_id,
1674: p_program_application_id => fnd_global.prog_appl_id,
1675: p_program_id => fnd_global.conc_program_id,
1676: p_request_id => fnd_global.conc_request_id,
1677: p_program_update_date => sysdate,
1678: p_object_version_number => l_object_version_number,
1671: p_per_in_ler_id => p_per_in_ler_id,
1672: p_yr_perd_id => l_yr_perd_id,
1673: p_business_group_id => p_business_group_id,
1674: p_program_application_id => fnd_global.prog_appl_id,
1675: p_program_id => fnd_global.conc_program_id,
1676: p_request_id => fnd_global.conc_request_id,
1677: p_program_update_date => sysdate,
1678: p_object_version_number => l_object_version_number,
1679: p_effective_date => p_effective_date);
1672: p_yr_perd_id => l_yr_perd_id,
1673: p_business_group_id => p_business_group_id,
1674: p_program_application_id => fnd_global.prog_appl_id,
1675: p_program_id => fnd_global.conc_program_id,
1676: p_request_id => fnd_global.conc_request_id,
1677: p_program_update_date => sysdate,
1678: p_object_version_number => l_object_version_number,
1679: p_effective_date => p_effective_date);
1680: hr_utility.set_location('Dn BEPECAPI_CRE 6: ',10);