34: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd,
35: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
36: budget_unit1_available,budget_unit2_available,budget_unit3_available,
37: object_version_number,gl_status
38: from pqh_budget_details
39: where budget_version_id = p_budget_version_id
40: for update of budget_unit1_value,budget_unit2_value,budget_unit3_value,
41: budget_unit1_available,budget_unit2_available,budget_unit3_available,
42: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent ;
737: p_budget_detail_id out nocopy number
738: ) is
739: l_object_version_number number;
740: begin
741: pqh_budget_details_api.create_budget_detail(
742: p_validate => FALSE
743: ,p_budget_detail_id => p_budget_detail_id
744: ,p_budget_version_id => p_budget_version_id
745: ,p_organization_id => p_organization_id
794: begin
795: hr_utility.set_location('entering'||l_proc,10);
796: hr_utility.set_location('bgd id is'||p_budget_detail_id||l_proc,11);
797: hr_utility.set_location('ovn is'||p_object_version_number||l_proc,12);
798: pqh_budget_details_api.update_budget_detail(
799: p_validate => FALSE
800: ,p_budget_detail_id => p_budget_detail_id
801: ,p_budget_version_id => p_budget_version_id
802: ,p_organization_id => p_organization_id