APPS.PQH_RBC_STAGE_TO_RBC dependencies on PQH_GSP_STAGE_TO_BEN

Line 615: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RT_MATRIX_NODE_VALUES',

611: and l_rmv_id is not null then
612: hr_utility.set_location('Rate Node Value is being updated'||l_rmv_id,60);
613: -- hr_utility.set_location('plan ovn'||grd_rec.information222,60);
614:
615: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RT_MATRIX_NODE_VALUES',
616: p_key_column_name => 'NODE_VALUE_ID',
617: p_key_column_value => l_rmv_id);
618:
619: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 873: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'PQH_RATE_MATRIX_RATES_F',

869: and l_rmr_id is not null then
870: hr_utility.set_location('Rate Matrix node is being updated'||l_rmr_id,60);
871: hr_utility.set_location('Rate Matrix rate dt mode '||p_datetrack_mode,60);
872: if p_datetrack_mode <> 'CORRECTION' then
873: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'PQH_RATE_MATRIX_RATES_F',
874: p_key_column_name => 'RATE_MATRIX_RATE_ID',
875: p_key_column_value => l_rmr_id,
876: p_effective_date => p_effective_date);
877: hr_utility.set_location(' dt mode is '||l_dt_mode,30);

Line 882: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RATE_MATRIX_RATES_F',

878: else
879: l_dt_mode := p_datetrack_mode;
880: end if;
881: -- hr_utility.set_location('plan ovn'||grd_rec.information222,60);
882: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RATE_MATRIX_RATES_F',
883: p_key_column_name => 'RATE_MATRIX_RATE_ID',
884: p_key_column_value => l_rmr_id,
885: p_effective_date => p_effective_date);
886: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 1098: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'BEN_PL_F',

1094: and l_plan_id is not null then
1095: hr_utility.set_location('Plan is being updated'||l_plan_id,60);
1096: -- hr_utility.set_location('plan ovn'||grd_rec.information222,60);
1097: if p_datetrack_mode <> 'CORRECTION' then
1098: l_dt_mode := pqh_gsp_stage_to_ben.get_update_mode(p_table_name => 'BEN_PL_F',
1099: p_key_column_name => 'PL_ID',
1100: p_key_column_value => l_plan_id,
1101: p_effective_date => p_effective_date);
1102: hr_utility.set_location(' dt mode is '||l_dt_mode,30);

Line 1106: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PL_F',

1102: hr_utility.set_location(' dt mode is '||l_dt_mode,30);
1103: else
1104: l_dt_mode := p_datetrack_mode;
1105: end if;
1106: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'BEN_PL_F',
1107: p_key_column_name => 'PL_ID',
1108: p_key_column_value => l_plan_id,
1109: p_effective_date => p_effective_date);
1110: hr_utility.set_location(' ovn is '||l_db_ovn,30);

Line 1249: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RATE_MATRIX_NODES',

1245: elsif rmn_rec.dml_operation in ('UPDATE')
1246: and l_ovn is not null
1247: and l_rmn_id is not null then
1248: hr_utility.set_location('Rate Matrix Node is being updated'||l_rmn_id,60);
1249: l_db_ovn := pqh_gsp_stage_to_ben.get_ovn(p_table_name => 'PQH_RATE_MATRIX_NODES',
1250: p_key_column_name => 'RATE_MATRIX_NODE_ID',
1251: p_key_column_value => l_rmn_id
1252: );
1253: hr_utility.set_location(' ovn is '||l_db_ovn,30);