APPS.PQH_WKS_BUDGET dependencies on PQH_BUDGET_DETAILS

Line 888: pqh_budget_details_api.create_budget_detail(

884: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);
885: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);
886: for i in c1 loop
887: l_rows_inserted := l_rows_inserted + 1;
888: pqh_budget_details_api.create_budget_detail(
889: p_validate => FALSE
890: ,p_budget_detail_id => l_budget_detail_id
891: ,p_budget_version_id => p_budget_version_id
892: ,p_organization_id => ''

Line 947: pqh_budget_details_api.create_budget_detail(

943: hr_utility.set_location('budget_start_date is'||to_char(l_budget_start_date,'DD/MM/RRRR')||l_proc,11);
944: hr_utility.set_location('budget_end_date is'||to_char(l_budget_end_date,'DD/MM/RRRR')||l_proc,12);
945: for i in c1 loop
946: l_rows_inserted := l_rows_inserted + 1;
947: pqh_budget_details_api.create_budget_detail(
948: p_validate => FALSE
949: ,p_budget_detail_id => l_budget_detail_id
950: ,p_budget_version_id => p_budget_version_id
951: ,p_organization_id => ''

Line 1028: pqh_budget_details_api.create_budget_detail(

1024: if p_org_hier_ver is null then
1025: hr_utility.set_location('Business group cursor selected '||l_proc,20);
1026: for i in c1 loop
1027: l_rows_inserted := l_rows_inserted + 1;
1028: pqh_budget_details_api.create_budget_detail(
1029: p_validate => FALSE
1030: ,p_budget_detail_id => l_budget_detail_id
1031: ,p_budget_version_id => p_budget_version_id
1032: ,p_organization_id => i.organization_id

Line 1057: pqh_budget_details_api.create_budget_detail(

1053: else
1054: hr_utility.set_location('Org hierarchy cursor selected '||l_proc,45);
1055: for i in c2 loop
1056: l_rows_inserted := l_rows_inserted + 1;
1057: pqh_budget_details_api.create_budget_detail(
1058: p_validate => FALSE
1059: ,p_budget_detail_id => l_budget_detail_id
1060: ,p_budget_version_id => p_budget_version_id
1061: ,p_organization_id => i.organization_id

Line 1154: pqh_budget_details_api.create_budget_detail(

1150: hr_utility.set_location('bg is used '||l_proc,20);
1151: for i in c1 loop
1152: hr_utility.set_location('in loop for '||i.organization_id||l_proc,25);
1153: l_rows_inserted := l_rows_inserted + 1;
1154: pqh_budget_details_api.create_budget_detail(
1155: p_validate => FALSE
1156: ,p_budget_detail_id => l_budget_detail_id
1157: ,p_budget_version_id => p_budget_version_id
1158: ,p_organization_id => i.organization_id

Line 1183: pqh_budget_details_api.create_budget_detail(

1179: else
1180: hr_utility.set_location('oh is used '||l_proc,40);
1181: for i in c2 loop
1182: l_rows_inserted := l_rows_inserted + 1;
1183: pqh_budget_details_api.create_budget_detail(
1184: p_validate => FALSE
1185: ,p_budget_detail_id => l_budget_detail_id
1186: ,p_budget_version_id => p_budget_version_id
1187: ,p_organization_id => i.organization_id

Line 1239: from pqh_budget_versions bgv, pqh_budget_details bgd

1235: return l_budget_id;
1236: end get_wkd_budget;
1237: function get_bgd_budget( p_budget_detail_id in number) return number is
1238: cursor c1 is select budget_id
1239: from pqh_budget_versions bgv, pqh_budget_details bgd
1240: where bgd.budget_detail_id = p_budget_detail_id
1241: and bgd.budget_version_id = bgv.budget_version_id ;
1242: l_budget_id number;
1243: begin