APPS.PQH_CPD_HR_TO_STAGE dependencies on BEN_PGM_EXTRA_INFO

Line 52: ben_pgm_extra_info_api.create_pgm_extra_info

48: begin
49: hr_utility.set_location('inside pgm_extra_info_update',10);
50: if p_pgm_extra_info_id is null then
51: hr_utility.set_location('insert pgm extra info ',10);
52: ben_pgm_extra_info_api.create_pgm_extra_info
53: ( p_pgm_id => p_pgm_id
54: ,p_information_type => 'PQH_FR_CORP_INFO'
55: ,p_pgi_information_category => 'PQH_FR_CORP_INFO'
56: ,p_pgi_information1 => p_quota_flag

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

60: ,p_object_version_number => l_peit_ovn
61: );
62: else
63: hr_utility.set_location('update pgm extra info',10);
64: l_peit_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PGM_EXTRA_INFO',
65: p_key_column_name => 'PGM_EXTRA_INFO_ID',
66: p_key_column_value => p_pgm_extra_info_id);
67: hr_utility.set_location(' ovn is '||l_peit_ovn,30);
68: ben_pgm_extra_info_api.update_pgm_extra_info

Line 68: ben_pgm_extra_info_api.update_pgm_extra_info

64: l_peit_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PGM_EXTRA_INFO',
65: p_key_column_name => 'PGM_EXTRA_INFO_ID',
66: p_key_column_value => p_pgm_extra_info_id);
67: hr_utility.set_location(' ovn is '||l_peit_ovn,30);
68: ben_pgm_extra_info_api.update_pgm_extra_info
69: ( p_pgm_extra_info_id => p_pgm_extra_info_id
70: ,p_object_version_number => l_peit_ovn
71: ,p_pgi_information1 => p_quota_flag
72: ,p_pgi_information2 => p_appraisal_type

Line 90: FROM ben_pgm_extra_info

86: p_pgm_extra_info_id out nocopy number) is
87:
88: cursor c1 is
89: SELECT pgm_extra_info_id,pgi_information1,pgi_information2,pgi_information3
90: FROM ben_pgm_extra_info
91: where information_type ='PQH_FR_CORP_INFO'
92: and pgm_id = p_pgm_id;
93: begin
94: hr_utility.set_location('pgm id is'||p_pgm_id,10);