APPS.PQH_PTX_UTL dependencies on PQH_BUDGET_PERIODS

Line 3917: FROM pqh_budget_periods

3913: WHERE budget_detail_id = p_budget_detail_id;
3914: --
3915: CURSOR l_bpr_ovn_cur(p_budget_period_id number) IS
3916: SELECT object_version_number
3917: FROM pqh_budget_periods
3918: WHERE budget_period_id = p_budget_period_id;
3919: --
3920: l_proc varchar2(72) := g_package||'apply_ptx_budgets';
3921: l_budget_style_cd pqh_budgets.budget_style_cd%type;

Line 3931: l_bpr_object_version_number pqh_budget_periods.object_version_number%TYPE;

3927: l_budget_unit1_percent number;
3928: l_budget_unit2_percent number;
3929: l_budget_unit3_percent number;
3930: l_object_version_number pqh_budget_details.object_version_number%TYPE;
3931: l_bpr_object_version_number pqh_budget_periods.object_version_number%TYPE;
3932: l_propagate varchar2(15);
3933: l_bpr_budget_unit1_available number;
3934: l_bpr_budget_unit2_available number;
3935: l_bpr_budget_unit3_available number;

Line 4092: pqh_budget_periods_api.update_budget_period

4088: CLOSE l_bpr_ovn_cur;
4089:
4090: hr_utility.set_location('Update API OVN : '||l_bpr_object_version_number, 8);
4091:
4092: pqh_budget_periods_api.update_budget_period
4093: (
4094: p_validate => false
4095: ,p_budget_period_id => l_budget_period_id
4096: ,p_budget_detail_id => l_budget_detail_id

Line 4118: pqh_budget_periods_api.create_budget_period

4114: -- for others i.e new rows call the insert API
4115:
4116: hr_utility.set_location('Create API in update mode : ', 9);
4117:
4118: pqh_budget_periods_api.create_budget_period
4119: (
4120: p_validate => false
4121: ,p_budget_period_id => l_budget_period_id
4122: ,p_budget_detail_id => l_budget_detail_id