APPS.PQH_BUDGET dependencies on PQH_WORKSHEET_BUDGET_SETS

Line 1316: from pqh_worksheet_budget_sets

1312: cursor c1 is select budget_unit1_value,budget_unit2_value,budget_unit3_value,
1313: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd,
1314: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1315: budget_unit1_available,budget_unit2_available,budget_unit3_available
1316: from pqh_worksheet_budget_sets
1317: where worksheet_period_id = p_worksheet_period_id
1318: for update of budget_unit1_value,budget_unit2_value,budget_unit3_value,
1319: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1320: budget_unit1_available,budget_unit2_available,budget_unit3_available ;

Line 1472: update pqh_worksheet_budget_sets

1468: hr_utility.set_location('unit3_percent '||l_budgetset_unit3_percent||l_proc,125);
1469: hr_utility.set_location('unit1_available '||l_budgetset_unit1_available||l_proc,126);
1470: hr_utility.set_location('unit2_available '||l_budgetset_unit2_available||l_proc,127);
1471: hr_utility.set_location('unit3_available '||l_budgetset_unit3_available||l_proc,128);
1472: update pqh_worksheet_budget_sets
1473: set budget_unit1_value = l_budgetset_unit1_value,
1474: budget_unit2_value = l_budgetset_unit2_value,
1475: budget_unit3_value = l_budgetset_unit3_value,
1476: budget_unit1_percent = l_budgetset_unit1_percent,

Line 2975: pqh_worksheet_budget_sets_api.create_worksheet_budget_set(

2971: );
2972: hr_utility.set_location('period inserted '||l_proc,37);
2973: for j in c2(i.budget_period_id) loop
2974: hr_utility.set_location('for each period '||l_proc,40);
2975: pqh_worksheet_budget_sets_api.create_worksheet_budget_set(
2976: p_validate => FALSE
2977: ,p_effective_date => trunc(sysdate)
2978: ,p_worksheet_budget_set_id => l_worksheet_budget_set_id
2979: ,p_worksheet_period_id => l_worksheet_period_id

Line 4664: pqh_worksheet_budget_sets_api.create_worksheet_budget_set(

4660: );
4661: hr_utility.set_location('period inserted '||l_proc,37);
4662: for j in c2(i.budget_period_id) loop
4663: hr_utility.set_location('for each period '||l_proc,40);
4664: pqh_worksheet_budget_sets_api.create_worksheet_budget_set(
4665: p_validate => FALSE
4666: ,p_effective_date => trunc(sysdate)
4667: ,p_worksheet_budget_set_id => l_worksheet_budget_set_id
4668: ,p_worksheet_period_id => l_worksheet_period_id