DBA Data[Home] [Help]

APPS.BEN_PD_RATE_AND_CVG_MODULE dependencies on BEN_PLAN_DESIGN_ELPRO_MODULE

Line 5516: if(ben_plan_design_elpro_module.g_copy_entity_txn_id <> p_copy_entity_txn_id) then

5512: begin
5513: l_number_of_copies := p_number_of_copies ;
5514:
5515: -- Bug 5059695 : Fetch the transaction category
5516: if(ben_plan_design_elpro_module.g_copy_entity_txn_id <> p_copy_entity_txn_id) then
5517:
5518: ben_plan_design_elpro_module.g_copy_entity_txn_id := p_copy_entity_txn_id;
5519:
5520: open ben_plan_design_elpro_module.g_trasaction_categories(p_copy_entity_txn_id) ;

Line 5518: ben_plan_design_elpro_module.g_copy_entity_txn_id := p_copy_entity_txn_id;

5514:
5515: -- Bug 5059695 : Fetch the transaction category
5516: if(ben_plan_design_elpro_module.g_copy_entity_txn_id <> p_copy_entity_txn_id) then
5517:
5518: ben_plan_design_elpro_module.g_copy_entity_txn_id := p_copy_entity_txn_id;
5519:
5520: open ben_plan_design_elpro_module.g_trasaction_categories(p_copy_entity_txn_id) ;
5521: fetch ben_plan_design_elpro_module.g_trasaction_categories into ben_plan_design_elpro_module.g_trasaction_category;
5522: close ben_plan_design_elpro_module.g_trasaction_categories;

Line 5520: open ben_plan_design_elpro_module.g_trasaction_categories(p_copy_entity_txn_id) ;

5516: if(ben_plan_design_elpro_module.g_copy_entity_txn_id <> p_copy_entity_txn_id) then
5517:
5518: ben_plan_design_elpro_module.g_copy_entity_txn_id := p_copy_entity_txn_id;
5519:
5520: open ben_plan_design_elpro_module.g_trasaction_categories(p_copy_entity_txn_id) ;
5521: fetch ben_plan_design_elpro_module.g_trasaction_categories into ben_plan_design_elpro_module.g_trasaction_category;
5522: close ben_plan_design_elpro_module.g_trasaction_categories;
5523:
5524: end if;

Line 5521: fetch ben_plan_design_elpro_module.g_trasaction_categories into ben_plan_design_elpro_module.g_trasaction_category;

5517:
5518: ben_plan_design_elpro_module.g_copy_entity_txn_id := p_copy_entity_txn_id;
5519:
5520: open ben_plan_design_elpro_module.g_trasaction_categories(p_copy_entity_txn_id) ;
5521: fetch ben_plan_design_elpro_module.g_trasaction_categories into ben_plan_design_elpro_module.g_trasaction_category;
5522: close ben_plan_design_elpro_module.g_trasaction_categories;
5523:
5524: end if;
5525: --End Bug 5059695

Line 5522: close ben_plan_design_elpro_module.g_trasaction_categories;

5518: ben_plan_design_elpro_module.g_copy_entity_txn_id := p_copy_entity_txn_id;
5519:
5520: open ben_plan_design_elpro_module.g_trasaction_categories(p_copy_entity_txn_id) ;
5521: fetch ben_plan_design_elpro_module.g_trasaction_categories into ben_plan_design_elpro_module.g_trasaction_category;
5522: close ben_plan_design_elpro_module.g_trasaction_categories;
5523:
5524: end if;
5525: --End Bug 5059695
5526: ---------------------------------------------------------------

Line 5626: if(ben_plan_design_elpro_module.g_trasaction_category = 'PQHGSP') then

5622:
5623: -- Create Eligibility Profiles and Criteria
5624:
5625: -- Bug 5059695
5626: if(ben_plan_design_elpro_module.g_trasaction_category = 'PQHGSP') then
5627: l_dummy_g_pdw_allow_dup_rslt := null;
5628: else
5629: l_dummy_g_pdw_allow_dup_rslt := ben_plan_design_program_module.g_pdw_no_dup_rslt;
5630: end if;

Line 5634: ben_plan_design_elpro_module.create_elig_prfl_results

5630: end if;
5631: -- End Bug 5059695
5632:
5633: for l_parent_rec in c_elp_from_parent(l_vrbl_rt_elig_prfl_id) loop
5634: ben_plan_design_elpro_module.create_elig_prfl_results
5635: (
5636: p_validate => p_validate
5637: ,p_mirror_src_entity_result_id => l_out_vep_result_id
5638: ,p_parent_entity_result_id => p_copy_entity_result_id -- Result id of Vapro