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.12010000.2 2009/03/13 09:48:12 lbodired ship $ */
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 3860: hr_utility.set_location('Entering pqh_gsp_stage_to_ben.upd_stg_elig_prfl_id',99);

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

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

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

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

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

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

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

Line 4048: end pqh_gsp_stage_to_ben;

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