APPS.BEN_PDW_COPY_BEN_TO_STG dependencies on BEN_PD_RATE_AND_CVG_MODULE

Line 1876: ben_pd_rate_and_cvg_module.create_vapro_results

1872: --
1873: FOR l_rec in csr_txn_prfl
1874: LOOP
1875: l_rate_vpf_exits:='Y';
1876: ben_pd_rate_and_cvg_module.create_vapro_results
1877: (
1878: P_COPY_ENTITY_RESULT_ID => l_rec.copy_entity_result_id
1879: ,P_COPY_ENTITY_TXN_ID => p_copy_entity_txn_id
1880: ,P_VRBL_RT_PRFL_ID => l_rec.VRBL_RT_PRFL_ID

Line 2043: ben_pd_rate_and_cvg_module.create_vapro_results

2039: begin
2040: hr_utility.set_location('Entering: '||l_proc,10);
2041: copy_extra_mappings := 'N';
2042:
2043: ben_pd_rate_and_cvg_module.create_vapro_results
2044: (
2045: P_VALIDATE => 1
2046: ,P_COPY_ENTITY_RESULT_ID => null
2047: ,P_COPY_ENTITY_TXN_ID => p_copy_entity_txn_id

Line 2242: ben_pd_rate_and_cvg_module.create_drpar_results

2238: );
2239: For l_rec in csr_dep_elig_criteria(p_parent_entity_result_id)
2240: LOOP
2241: IF l_rec.table_alias='EAC' THEN
2242: ben_pd_rate_and_cvg_module.create_drpar_results
2243: (
2244: p_copy_entity_result_id =>null
2245: ,p_copy_entity_txn_id => p_copy_entity_txn_id
2246: ,p_comp_lvl_fctr_id => null

Line 2381: ben_pd_rate_and_cvg_module.create_bnft_group_results

2377: copy_drvd_factor(p_copy_entity_txn_id ,l_table_alias ,l_information1);
2378: ELSIF l_rec.table_alias='EBN' THEN
2379: -- modified the table alias from BRG to BNG since rows of BRG are not created/copied
2380: IF (NOT staged_record_exists('BNG',l_rec.information222,p_copy_entity_txn_id)) THEN
2381: ben_pd_rate_and_cvg_module.create_bnft_group_results
2382: (
2383: p_copy_entity_result_id => null
2384: ,p_copy_entity_txn_id =>p_copy_entity_txn_id
2385: ,p_benfts_grp_id =>l_rec.information222

Line 2396: ben_pd_rate_and_cvg_module.create_service_results

2392: --
2393: ELSIF l_rec.table_alias='ESA' THEN
2394: -- modified the table alias from SAR to SVA since rows of SAR are not created/copied
2395: IF (NOT staged_record_exists('SVA',l_rec.information241,p_copy_entity_txn_id)) THEN
2396: ben_pd_rate_and_cvg_module.create_service_results
2397: (
2398: p_copy_entity_result_id => null
2399: ,p_copy_entity_txn_id =>p_copy_entity_txn_id
2400: ,p_svc_area_id =>l_rec.information241

Line 2410: ben_pd_rate_and_cvg_module.create_postal_results

2406: END IF;
2407: --
2408: ELSIF l_rec.table_alias='EPZ' THEN
2409: IF (NOT staged_record_exists('RZR',l_rec.information245,p_copy_entity_txn_id)) THEN
2410: ben_pd_rate_and_cvg_module.create_postal_results
2411: (
2412: p_copy_entity_result_id => null
2413: ,p_copy_entity_txn_id =>p_copy_entity_txn_id
2414: ,p_pstl_zip_rng_id =>l_rec.information245

Line 2441: ben_pd_rate_and_cvg_module.create_bnft_bal_results

2437: BEGIN
2438: hr_utility.set_location('Entering: '||l_proc,10);
2439: IF NOT staged_record_exists('BNB',p_information1,p_copy_entity_txn_id) THEN
2440: get_txn_details (p_copy_entity_txn_id ,l_business_group_id,l_effective_date);
2441: ben_pd_rate_and_cvg_module.create_bnft_bal_results
2442: (
2443: p_copy_entity_result_id => null
2444: ,p_copy_entity_txn_id =>p_copy_entity_txn_id
2445: ,p_bnfts_bal_id =>p_information1

Line 3542: ben_pd_rate_and_cvg_module.create_postal_results(

3538:
3539: FOR l_RZR in c_RZR(l_business_group_id)
3540: Loop
3541: IF (NOT staged_record_exists('RZR',l_RZR.PSTL_ZIP_RNG_ID,p_copy_entity_txn_id)) THEN
3542: ben_pd_rate_and_cvg_module.create_postal_results(
3543: p_copy_entity_result_id => null
3544: ,p_copy_entity_txn_id =>p_copy_entity_txn_id
3545: ,p_pstl_zip_rng_id =>l_RZR.PSTL_ZIP_RNG_ID
3546: ,p_business_group_id =>l_business_group_id

Line 3557: ben_pd_rate_and_cvg_module.create_bnft_group_results(

3553:
3554: FOR l_BNG in c_BNG(l_business_group_id)
3555: Loop
3556: IF (NOT staged_record_exists('BNG',l_BNG.BENFTS_GRP_ID,p_copy_entity_txn_id)) THEN
3557: ben_pd_rate_and_cvg_module.create_bnft_group_results(
3558: p_copy_entity_result_id => null
3559: ,p_copy_entity_txn_id =>p_copy_entity_txn_id
3560: ,p_benfts_grp_id =>l_BNG.BENFTS_GRP_ID
3561: ,p_business_group_id =>l_business_group_id

Line 4005: ben_pd_rate_and_cvg_module.create_bnft_group_results

4001: );
4002:
4003: IF p_table_alias='BNG' THEN
4004: IF (NOT staged_record_exists('BNG',p_information1,p_copy_entity_txn_id)) THEN
4005: ben_pd_rate_and_cvg_module.create_bnft_group_results
4006: (
4007: p_copy_entity_result_id => null
4008: ,p_copy_entity_txn_id =>p_copy_entity_txn_id
4009: ,p_benfts_grp_id =>p_information1

Line 4022: ben_pd_rate_and_cvg_module.create_service_results

4018: ELSIF p_table_alias='SVA' THEN
4019: IF (NOT staged_record_exists('SVA',p_information1,p_copy_entity_txn_id)) THEN
4020: -- setting g_pdw_allow_dup_rlst to ensure that duplicat Postal Zip values are not copied in to staging
4021: ben_plan_design_program_module.g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
4022: ben_pd_rate_and_cvg_module.create_service_results
4023: (
4024: p_copy_entity_result_id => null
4025: ,p_copy_entity_txn_id =>p_copy_entity_txn_id
4026: ,p_svc_area_id =>p_information1

Line 4038: ben_pd_rate_and_cvg_module.create_postal_results

4034: END IF;
4035: --
4036: ELSIF p_table_alias='RZR' THEN
4037: IF (NOT staged_record_exists('RZR',p_information1,p_copy_entity_txn_id)) THEN
4038: ben_pd_rate_and_cvg_module.create_postal_results
4039: (
4040: p_copy_entity_result_id => null
4041: ,p_copy_entity_txn_id =>p_copy_entity_txn_id
4042: ,p_pstl_zip_rng_id =>p_information1

Line 4075: ben_pd_rate_and_cvg_module.create_drpar_results

4071: elsif p_table_alias='LSF' THEN l_los_fctr_id :=p_information1;
4072: elsif p_table_alias='PFF' THEN l_pct_fl_tm_fctr_id :=p_information1;
4073: end if;
4074: --
4075: ben_pd_rate_and_cvg_module.create_drpar_results
4076: (
4077: p_copy_entity_result_id =>null
4078: ,p_copy_entity_txn_id => p_copy_entity_txn_id
4079: ,p_comp_lvl_fctr_id => l_comp_lvl_fctr_id