APPS.PQH_BDGT dependencies on PQH_BUDGET

Line 7: from pqh_budget_versions

3: g_package varchar2(100) := 'PQH_BDGT.' ;
4:
5: function get_bgv_budget( p_budget_version_id in number) return number is
6: cursor c1 is select budget_id
7: from pqh_budget_versions
8: where budget_version_id = p_budget_version_id ;
9: l_budget_id number;
10: begin
11: open c1;

Line 38: from pqh_budget_details

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 ;

Line 269: from pqh_budget_periods

265: cursor c1 is select budget_period_id,budget_unit1_value,budget_unit2_value,budget_unit3_value,
266: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd,
267: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
268: budget_unit1_available,budget_unit2_available,budget_unit3_available
269: from pqh_budget_periods
270: where budget_detail_id = p_budget_detail_id
271: for update of budget_unit1_value,budget_unit2_value,budget_unit3_value,
272: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
273: budget_unit1_available,budget_unit2_available,budget_unit3_available ;

Line 305: pqh_budget.sub_budgetrow(p_budget_detail_id => p_budget_detail_id,

301: hr_utility.raise_error;
302: end if;
303:
304: /* make a call to sub_budgetrow to subtract the all period info. from the table*/
305: pqh_budget.sub_budgetrow(p_budget_detail_id => p_budget_detail_id,
306: p_unit1_aggregate => p_unit1_aggregate,
307: p_unit2_aggregate => p_unit2_aggregate,
308: p_unit3_aggregate => p_unit3_aggregate);
309:

Line 453: update pqh_budget_periods

449: hr_utility.set_location('after period changes values '||l_proc,130);
450: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,133);
451: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,134);
452: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,135);
453: update pqh_budget_periods
454: set budget_unit1_value = l_period_unit1_value,
455: budget_unit2_value = l_period_unit2_value,
456: budget_unit3_value = l_period_unit3_value,
457: budget_unit1_percent = l_period_unit1_percent,

Line 470: pqh_budget.add_budgetrow(p_budget_detail_id => p_budget_detail_id,

466:
467: /* make a call to add_budgetrow to add the all period info. from the table
468: and then get the available figures using each unit to be passed on to budget*/
469:
470: pqh_budget.add_budgetrow(p_budget_detail_id => p_budget_detail_id,
471: p_unit1_aggregate => p_unit1_aggregate,
472: p_unit2_aggregate => p_unit2_aggregate,
473: p_unit3_aggregate => p_unit3_aggregate);
474: pqh_budget.chk_unit_sum(p_unit1_sum_value => x_unit1_sum,

Line 474: pqh_budget.chk_unit_sum(p_unit1_sum_value => x_unit1_sum,

470: pqh_budget.add_budgetrow(p_budget_detail_id => p_budget_detail_id,
471: p_unit1_aggregate => p_unit1_aggregate,
472: p_unit2_aggregate => p_unit2_aggregate,
473: p_unit3_aggregate => p_unit3_aggregate);
474: pqh_budget.chk_unit_sum(p_unit1_sum_value => x_unit1_sum,
475: p_unit2_sum_value => x_unit2_sum,
476: p_unit3_sum_value => x_unit3_sum);
477: pqh_budget.chk_unit_max(p_unit1_max_value => x_unit1_max,
478: p_unit2_max_value => x_unit2_max,

Line 477: pqh_budget.chk_unit_max(p_unit1_max_value => x_unit1_max,

473: p_unit3_aggregate => p_unit3_aggregate);
474: pqh_budget.chk_unit_sum(p_unit1_sum_value => x_unit1_sum,
475: p_unit2_sum_value => x_unit2_sum,
476: p_unit3_sum_value => x_unit3_sum);
477: pqh_budget.chk_unit_max(p_unit1_max_value => x_unit1_max,
478: p_unit2_max_value => x_unit2_max,
479: p_unit3_max_value => x_unit3_max);
480: pqh_budget.chk_unit_avg(p_unit1_avg_value => x_unit1_avg,
481: p_unit2_avg_value => x_unit2_avg,

Line 480: pqh_budget.chk_unit_avg(p_unit1_avg_value => x_unit1_avg,

476: p_unit3_sum_value => x_unit3_sum);
477: pqh_budget.chk_unit_max(p_unit1_max_value => x_unit1_max,
478: p_unit2_max_value => x_unit2_max,
479: p_unit3_max_value => x_unit3_max);
480: pqh_budget.chk_unit_avg(p_unit1_avg_value => x_unit1_avg,
481: p_unit2_avg_value => x_unit2_avg,
482: p_unit3_avg_value => x_unit3_avg);
483: if p_unit1_aggregate ='ACCUMULATE' then
484: p_bgt_unit1_available := nvl(p_new_bgt_unit1_value,0) - nvl(x_unit1_sum,0);

Line 535: from pqh_budget_sets

531: cursor c1 is select budget_unit1_value,budget_unit2_value,budget_unit3_value,
532: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd,
533: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
534: budget_unit1_available,budget_unit2_available,budget_unit3_available
535: from pqh_budget_sets
536: where budget_period_id = p_budget_period_id
537: for update of budget_unit1_value,budget_unit2_value,budget_unit3_value,
538: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
539: budget_unit1_available,budget_unit2_available,budget_unit3_available ;

Line 691: update pqh_budget_sets

687: hr_utility.set_location('unit3_percent '||l_budgetset_unit3_percent||l_proc,125);
688: hr_utility.set_location('unit1_available '||l_budgetset_unit1_available||l_proc,126);
689: hr_utility.set_location('unit2_available '||l_budgetset_unit2_available||l_proc,127);
690: hr_utility.set_location('unit3_available '||l_budgetset_unit3_available||l_proc,128);
691: update pqh_budget_sets
692: set budget_unit1_value = l_budgetset_unit1_value,
693: budget_unit2_value = l_budgetset_unit2_value,
694: budget_unit3_value = l_budgetset_unit3_value,
695: budget_unit1_percent = l_budgetset_unit1_percent,

Line 741: pqh_budget_details_api.create_budget_detail(

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

Line 798: pqh_budget_details_api.update_budget_detail(

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

Line 837: cursor c0 is select max(version_number) from pqh_budget_versions

833: p_bgv_ul_date out nocopy date,
834: p_status out nocopy varchar2) is
835: l_max_version number;
836: l_min_version number;
837: cursor c0 is select max(version_number) from pqh_budget_versions
838: where budget_id = p_budget_id ;
839: cursor c1 is select min(version_number) from pqh_budget_versions
840: where budget_id = p_budget_id ;
841: -- cursor to fetch the end_date of the last_version

Line 839: cursor c1 is select min(version_number) from pqh_budget_versions

835: l_max_version number;
836: l_min_version number;
837: cursor c0 is select max(version_number) from pqh_budget_versions
838: where budget_id = p_budget_id ;
839: cursor c1 is select min(version_number) from pqh_budget_versions
840: where budget_id = p_budget_id ;
841: -- cursor to fetch the end_date of the last_version
842: cursor c2 is select date_to from pqh_budget_versions
843: where version_number = l_max_version

Line 842: cursor c2 is select date_to from pqh_budget_versions

838: where budget_id = p_budget_id ;
839: cursor c1 is select min(version_number) from pqh_budget_versions
840: where budget_id = p_budget_id ;
841: -- cursor to fetch the end_date of the last_version
842: cursor c2 is select date_to from pqh_budget_versions
843: where version_number = l_max_version
844: and budget_id = p_budget_id;
845: -- cursor to fetch next version from the current version
846: cursor c5 is select date_from from pqh_budget_versions

Line 846: cursor c5 is select date_from from pqh_budget_versions

842: cursor c2 is select date_to from pqh_budget_versions
843: where version_number = l_max_version
844: and budget_id = p_budget_id;
845: -- cursor to fetch next version from the current version
846: cursor c5 is select date_from from pqh_budget_versions
847: where budget_id = p_budget_id
848: and version_number = (select min(version_number)
849: from pqh_budget_versions
850: where budget_id = p_budget_id

Line 849: from pqh_budget_versions

845: -- cursor to fetch next version from the current version
846: cursor c5 is select date_from from pqh_budget_versions
847: where budget_id = p_budget_id
848: and version_number = (select min(version_number)
849: from pqh_budget_versions
850: where budget_id = p_budget_id
851: and version_number > p_version_number) ;
852: -- cursor to fetch previous version from the current version
853: cursor c6 is select date_to from pqh_budget_versions

Line 853: cursor c6 is select date_to from pqh_budget_versions

849: from pqh_budget_versions
850: where budget_id = p_budget_id
851: and version_number > p_version_number) ;
852: -- cursor to fetch previous version from the current version
853: cursor c6 is select date_to from pqh_budget_versions
854: where budget_id = p_budget_id
855: and version_number = (select max(version_number)
856: from pqh_budget_versions
857: where budget_id = p_budget_id

Line 856: from pqh_budget_versions

852: -- cursor to fetch previous version from the current version
853: cursor c6 is select date_to from pqh_budget_versions
854: where budget_id = p_budget_id
855: and version_number = (select max(version_number)
856: from pqh_budget_versions
857: where budget_id = p_budget_id
858: and version_number < p_version_number) ;
859: l_max_end_date date;
860: l_min_start_date date;