APPS.PQH_PTX_UTL dependencies on PQH_BUDGET_DETAILS

Line 3666: FROM pqh_budget_details

3662: cursor c_total_bdt(p_budget_version_id number) is
3663: SELECT sum(nvl(BUDGET_UNIT1_VALUE,0)) ,
3664: sum(nvl(BUDGET_UNIT2_VALUE,0)) ,
3665: sum(nvl(BUDGET_UNIT3_VALUE,0))
3666: FROM pqh_budget_details
3667: WHERE budget_version_id = p_budget_version_id;
3668: --
3669: l_budget_unit1_available number;
3670: l_budget_unit2_available number;

Line 3912: FROM pqh_budget_details

3908: and bvr.budget_id = bgt.budget_id;
3909: --
3910: CURSOR l_object_version_number_cur(p_budget_detail_id number) IS
3911: SELECT object_version_number
3912: FROM pqh_budget_details
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

Line 3930: l_object_version_number pqh_budget_details.object_version_number%TYPE;

3926: l_version_unit3_value number;
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;

Line 3988: pqh_budget_details_api.update_budget_detail

3984: CLOSE l_object_version_number_cur;
3985:
3986: hr_utility.set_location('Update API OVN : '||l_object_version_number, 8);
3987:
3988: pqh_budget_details_api.update_budget_detail
3989: (
3990: p_validate => false
3991: ,p_budget_detail_id => p_worksheet_details_rec.budget_detail_id
3992: ,p_organization_id => p_worksheet_details_rec.organization_id

Line 4017: pqh_budget_details_api.create_budget_detail

4013: -- for others i.e new rows call the insert API
4014:
4015: hr_utility.set_location('Create API in update mode : ', 9);
4016:
4017: pqh_budget_details_api.create_budget_detail
4018: (
4019: p_validate => false
4020: ,p_budget_detail_id => l_budget_detail_id
4021: ,p_organization_id => p_worksheet_details_rec.organization_id