426:
427: Return;
428:
429: End If;
430: hr_utility.set_location('qu 1'||substr(l_sql,1,40),10);
431: hr_utility.set_location('qu 2'||substr(l_sql,41,40),10);
432: hr_utility.set_location('qu 3'||substr(l_sql,81,40),10);
433:
434: /* for l_parent_rec in c_epa_from_parent( p_pgm_id,p_ptip_id,p_plip_id,p_pl_id,p_oipl_id ) loop */
427: Return;
428:
429: End If;
430: hr_utility.set_location('qu 1'||substr(l_sql,1,40),10);
431: hr_utility.set_location('qu 2'||substr(l_sql,41,40),10);
432: hr_utility.set_location('qu 3'||substr(l_sql,81,40),10);
433:
434: /* for l_parent_rec in c_epa_from_parent( p_pgm_id,p_ptip_id,p_plip_id,p_pl_id,p_oipl_id ) loop */
435:
428:
429: End If;
430: hr_utility.set_location('qu 1'||substr(l_sql,1,40),10);
431: hr_utility.set_location('qu 2'||substr(l_sql,41,40),10);
432: hr_utility.set_location('qu 3'||substr(l_sql,81,40),10);
433:
434: /* for l_parent_rec in c_epa_from_parent( p_pgm_id,p_ptip_id,p_plip_id,p_pl_id,p_oipl_id ) loop */
435:
436: --
443: Loop
444:
445: Fetch c_Parent_rec into l_prtn_elig_id;
446:
447: hr_utility.set_location('data pulled '||l_prtn_elig_id,10);
448:
449: If c_Parent_Rec%NOTFOUND Then
450: Close c_Parent_Rec;
451: Exit;
890: end if;
891: --
892: end loop;
893: --
894: hr_utility.set_location('end of per',10);
895: end loop;
896: ---------------------------------------------------------------
897: -- END OF BEN_PRTN_ELIGY_RL_F ----------------------
898: ---------------------------------------------------------------
895: end loop;
896: ---------------------------------------------------------------
897: -- END OF BEN_PRTN_ELIGY_RL_F ----------------------
898: ---------------------------------------------------------------
899: hr_utility.set_location('end of pe',10);
900: end loop;
901: ---------------------------------------------------------------
902: -- END OF BEN_PRTN_ELIG_F ----------------------
903: ---------------------------------------------------------------
900: end loop;
901: ---------------------------------------------------------------
902: -- END OF BEN_PRTN_ELIG_F ----------------------
903: ---------------------------------------------------------------
904: hr_utility.set_location('out of routine',10);
905: end ;
906: --
907: procedure create_dep_elpro_result
908: (
5197: end if;
5198: --
5199: end loop;
5200: --
5201: hr_utility.set_location('Before create_drpar_results '||p_copy_entity_txn_id,11);
5202: hr_utility.set_location(' l_out_ecl_result_id '||l_out_ecl_result_id,11);
5203: for l_ecl_rec in c_ecl_drp(l_parent_rec.elig_comp_lvl_prte_id,l_mirror_src_entity_result_id,'ECL' ) loop
5204: hr_utility.set_location(' l_ecl_rec.comp_lvl_fctr_id '||l_ecl_rec.comp_lvl_fctr_id,12);
5205: ben_pd_rate_and_cvg_module.create_drpar_results
5198: --
5199: end loop;
5200: --
5201: hr_utility.set_location('Before create_drpar_results '||p_copy_entity_txn_id,11);
5202: hr_utility.set_location(' l_out_ecl_result_id '||l_out_ecl_result_id,11);
5203: for l_ecl_rec in c_ecl_drp(l_parent_rec.elig_comp_lvl_prte_id,l_mirror_src_entity_result_id,'ECL' ) loop
5204: hr_utility.set_location(' l_ecl_rec.comp_lvl_fctr_id '||l_ecl_rec.comp_lvl_fctr_id,12);
5205: ben_pd_rate_and_cvg_module.create_drpar_results
5206: (
5200: --
5201: hr_utility.set_location('Before create_drpar_results '||p_copy_entity_txn_id,11);
5202: hr_utility.set_location(' l_out_ecl_result_id '||l_out_ecl_result_id,11);
5203: for l_ecl_rec in c_ecl_drp(l_parent_rec.elig_comp_lvl_prte_id,l_mirror_src_entity_result_id,'ECL' ) loop
5204: hr_utility.set_location(' l_ecl_rec.comp_lvl_fctr_id '||l_ecl_rec.comp_lvl_fctr_id,12);
5205: ben_pd_rate_and_cvg_module.create_drpar_results
5206: (
5207: p_validate => p_validate
5208: ,p_copy_entity_result_id => l_out_ecl_result_id
7501: l_mapping_column_name1,
7502: l_mapping_column_name2,
7503: p_copy_entity_txn_id);
7504: --
7505: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
7506: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
7507: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
7508: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
7509: --
7502: l_mapping_column_name2,
7503: p_copy_entity_txn_id);
7504: --
7505: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
7506: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
7507: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
7508: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
7509: --
7510:
7503: p_copy_entity_txn_id);
7504: --
7505: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
7506: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
7507: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
7508: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
7509: --
7510:
7511: l_copy_entity_result_id := null;
7504: --
7505: hr_utility.set_location('l_mapping_id '||l_mapping_id,100);
7506: hr_utility.set_location('l_mapping_name '||l_mapping_name,100);
7507: hr_utility.set_location('l_mapping_id1 '||l_mapping_id1,100);
7508: hr_utility.set_location('l_mapping_name1 '||l_mapping_name1,100);
7509: --
7510:
7511: l_copy_entity_result_id := null;
7512: l_object_version_number := null;