APPS.BEN_DETERMINE_ELCT_CHC_FLX_IMP dependencies on FND_GLOBAL

Line 120: and nvl(epe.request_id,-1) = fnd_global.conc_request_id

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

Line 135: and nvl(epe.request_id,-1) = fnd_global.conc_request_id

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

Line 149: and nvl(epe.request_id,-1) = fnd_global.conc_request_id

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

Line 164: and nvl(epe.request_id,-1) = fnd_global.conc_request_id

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

Line 672: p_program_application_id => fnd_global.prog_appl_id,

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,

Line 673: p_program_id => fnd_global.conc_program_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,
677: p_effective_date => p_effective_date);

Line 674: p_request_id => fnd_global.conc_request_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);
678: hr_utility.set_location('Dn BEPECAPI_CRE 1: '||l_proc,10);

Line 831: p_program_application_id => fnd_global.prog_appl_id,

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,

Line 832: p_program_id => fnd_global.conc_program_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,
836: p_effective_date => p_effective_date);

Line 833: p_request_id => fnd_global.conc_request_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);
837: hr_utility.set_location('Dn BEPECAPI_CRE 2: ',10);

Line 997: p_program_application_id => fnd_global.prog_appl_id,

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,

Line 998: p_program_id => fnd_global.conc_program_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,
1002: p_effective_date => p_effective_date);

Line 999: p_request_id => fnd_global.conc_request_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);
1003: hr_utility.set_location('Dn BEPECAPI_CRE 5: ',10);

Line 1133: p_program_application_id => fnd_global.prog_appl_id,

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,

Line 1134: p_program_id => fnd_global.conc_program_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,
1138: p_effective_date => p_effective_date);

Line 1135: p_request_id => fnd_global.conc_request_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);
1139: hr_utility.set_location('Dn BEPECAPI_CRE 3: ',10);

Line 1269: p_program_application_id => fnd_global.prog_appl_id,

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,

Line 1270: p_program_id => fnd_global.conc_program_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,
1274: p_effective_date => p_effective_date);

Line 1271: p_request_id => fnd_global.conc_request_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);
1275: hr_utility.set_location('Dn BEPECAPI_CRE 4: ',10);

Line 1471: p_program_application_id => fnd_global.prog_appl_id,

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,

Line 1472: p_program_id => fnd_global.conc_program_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,
1476: p_effective_date => p_effective_date);

Line 1473: p_request_id => fnd_global.conc_request_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);
1477: --

Line 1674: p_program_application_id => fnd_global.prog_appl_id,

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,

Line 1675: p_program_id => fnd_global.conc_program_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,
1679: p_effective_date => p_effective_date);

Line 1676: p_request_id => fnd_global.conc_request_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);
1680: hr_utility.set_location('Dn BEPECAPI_CRE 6: ',10);