APPS.PQH_GSP_STAGE_TO_BEN dependencies on PQH_GSP_STAGE_TO_BEN

Line 1: package body pqh_gsp_stage_to_ben as

1: package body pqh_gsp_stage_to_ben as
2: /* $Header: pqgspsbe.pkb 120.9 2006/05/19 22:35:47 hmehta noship $ */
3: function get_scl_name(p_scl_id in number) return varchar2 is
4: l_scl_name varchar2(30);
5: begin

Line 933: l_peit_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PGM_EXTRA_INFO',

929: ,p_object_version_number => l_peit_ovn
930: );
931: else
932: hr_utility.set_location('update pgm extra info',10);
933: l_peit_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PGM_EXTRA_INFO',
934: p_key_column_name => 'PGM_EXTRA_INFO_ID',
935: p_key_column_value => r_pgi.information174);
936: hr_utility.set_location(' ovn is '||l_peit_ovn,30);
937: ben_pgm_extra_info_api.update_pgm_extra_info

Line 3859: hr_utility.set_location('Entering pqh_gsp_stage_to_ben.upd_stg_elig_prfl_id',99);

3855: ,p_effective_date date
3856: )
3857: is
3858: begin
3859: hr_utility.set_location('Entering pqh_gsp_stage_to_ben.upd_stg_elig_prfl_id',99);
3860:
3861: update ben_copy_entity_results cer
3862: set information263 =
3863: ( select ELIGY_PRFL_ID

Line 3882: hr_utility.set_location('Leaving pqh_gsp_stage_to_ben.upd_stg_elig_prfl_id',99);

3878: and p_effective_date between
3879: elp.effective_start_date and elp.effective_end_date);
3880:
3881: hr_utility.set_location('No of staging rows updated :'||sql%rowcount||':',99);
3882: hr_utility.set_location('Leaving pqh_gsp_stage_to_ben.upd_stg_elig_prfl_id',99);
3883: end upd_stg_elig_prfl_id ;
3884:
3885: procedure cre_update_elig_prfl(
3886: p_copy_entity_txn_id in number

Line 3893: hr_utility.set_location('Entering pqh_gsp_stage_to_ben.cre_update_elig_prfl ',999);

3889: ,p_business_area in varchar2 default 'PQH_GSP_TASK_LIST')
3890: is
3891: l_delete_failed varchar2(10);
3892: begin
3893: hr_utility.set_location('Entering pqh_gsp_stage_to_ben.cre_update_elig_prfl ',999);
3894: hr_utility.set_location('Copy_Entity_Txn_Id passed is:'||p_copy_entity_txn_id,800);
3895: hr_utility.set_location('Effective Date Passed is:'||p_effective_date,801);
3896: hr_utility.set_location('Business Group Id passed is:'||p_business_group_id,902);
3897: hr_utility.set_location('Business Area Passed is:'||p_business_area,903);

Line 4043: hr_utility.set_location('Leaving pqh_gsp_stage_to_ben.cre_update_elig_prfl ',999);

4039: set dml_operation = 'DELETE'
4040: where cer.copy_entity_txn_id = p_copy_entity_txn_id
4041: and cer.dml_operation = 'GSPDEL';
4042:
4043: hr_utility.set_location('Leaving pqh_gsp_stage_to_ben.cre_update_elig_prfl ',999);
4044: end cre_update_elig_prfl ;
4045:
4046:
4047: end pqh_gsp_stage_to_ben;

Line 4047: end pqh_gsp_stage_to_ben;

4043: hr_utility.set_location('Leaving pqh_gsp_stage_to_ben.cre_update_elig_prfl ',999);
4044: end cre_update_elig_prfl ;
4045:
4046:
4047: end pqh_gsp_stage_to_ben;