APPS.PQH_CPD_HR_TO_STAGE dependencies on PQH_GSP_STAGE_TO_BEN

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 739: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PER_GEN_HIERARCHY_NODES',

735: and l_pth_ovn is not null
736: and l_entity_id is not null
737: and l_cpd_id is not null then
738: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
739: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PER_GEN_HIERARCHY_NODES',
740: p_key_column_name => 'HIERARCHY_NODE_ID',
741: p_key_column_value => l_pth_id);
742: hr_utility.set_location(' ovn is '||l_db_ovn,30);
743: if l_db_ovn <> l_pth_ovn then

Line 850: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_CORPS_EXTRA_INFO',

846: and l_cdd_id is not null
847: and l_cdd_ovn is not null
848: and l_cpd_id is not null then
849: hr_utility.set_location(' dt mode is '||p_datetrack_mode,30);
850: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_CORPS_EXTRA_INFO',
851: p_key_column_name => 'CORPS_EXTRA_INFO_ID',
852: p_key_column_value => l_cdd_id);
853: hr_utility.set_location(' ovn is '||l_db_ovn,30);
854: if l_db_ovn <> l_cdd_ovn then

Line 1228: pqh_gsp_stage_to_ben.get_ovn

1224: AND l_pgm_id IS NOT NULL
1225: THEN
1226: hr_utility.set_location (' dt mode is ' || p_datetrack_mode, 30);
1227: l_db_ovn :=
1228: pqh_gsp_stage_to_ben.get_ovn
1229: (p_table_name => 'PQH_CORPS_DEFINITIONS',
1230: p_key_column_name => 'CORPS_DEFINITION_ID',
1231: p_key_column_value => l_cpd_id
1232: );

Line 1408: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_CORPS_EXTRA_INFO',

1404: ,p_object_version_number => l_db_ovn
1405: );
1406: else
1407: hr_utility.set_location('update grd quota',10);
1408: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_CORPS_EXTRA_INFO',
1409: p_key_column_name => 'CORPS_EXTRA_INFO_ID',
1410: p_key_column_value => p_corps_extra_info_id);
1411: hr_utility.set_location(' ovn is '||l_db_ovn,30);
1412: pqh_corps_extra_info_api.update_corps_extra_info(