eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PQH_BUDGET dependencies on PQH_WKS_BUDGET

Line 664: l_code := pqh_wks_budget.get_parent_value(p_worksheet_detail_id,l_wks_propagation_method);

660: when others then
661: hr_utility.set_message(8302,'PQH_INVALID_WKD_PASSED');
662: hr_utility.raise_error;
663: end;
664: l_code := pqh_wks_budget.get_parent_value(p_worksheet_detail_id,l_wks_propagation_method);
665: else
666: l_code := p_change_mode;
667: end if;
668: if l_code not in ('RP','RV','UE') then

Line 2622: and pqh_wks_budget.get_position_budget_flag(i.availability_status_id) = 'Y' then

2618: if p_org_hier_ver is null then
2619: hr_utility.set_location('Business group cursor selected '||l_proc,20);
2620: for i in c1 loop
2621: if pqh_budget.already_budgeted_pos(i.position_id) = 'FALSE'
2622: and pqh_wks_budget.get_position_budget_flag(i.availability_status_id) = 'Y' then
2623: l_rows_inserted := l_rows_inserted + 1;
2624: insert_worksheet_detail (
2625: p_worksheet_detail_id => l_worksheet_detail_id
2626: ,p_worksheet_id => p_worksheet_id

Line 2646: and pqh_wks_budget.get_position_budget_flag(i.availability_status_id) = 'Y' then

2642: for k in csr_orgs loop
2643: hr_utility.set_location('Org is'||k.organization_id_child,46);
2644: for i in csr_pos(k.organization_id_child) loop
2645: if pqh_budget.already_budgeted_pos(i.position_id) = 'FALSE'
2646: and pqh_wks_budget.get_position_budget_flag(i.availability_status_id) = 'Y' then
2647: l_rows_inserted := l_rows_inserted + 1;
2648: insert_worksheet_detail ( p_worksheet_detail_id => l_worksheet_detail_id
2649: ,p_worksheet_id => p_worksheet_id
2650: ,p_organization_id => i.organization_id

Line 2838: pqh_wks_budget.get_wks_unit_aggregate(p_worksheet_id => p_worksheet_id ,

2834: l_unit2_precision number;
2835: l_unit3_precision number;
2836: begin
2837: hr_utility.set_location('entering '||l_proc,10);
2838: pqh_wks_budget.get_wks_unit_aggregate(p_worksheet_id => p_worksheet_id ,
2839: p_unit1_aggregate => l_unit1_aggregate,
2840: p_unit2_aggregate => l_unit2_aggregate,
2841: p_unit3_aggregate => l_unit3_aggregate);
2842: pqh_wks_budget.get_wks_unit_precision(p_worksheet_id => p_worksheet_id ,

Line 2842: pqh_wks_budget.get_wks_unit_precision(p_worksheet_id => p_worksheet_id ,

2838: pqh_wks_budget.get_wks_unit_aggregate(p_worksheet_id => p_worksheet_id ,
2839: p_unit1_aggregate => l_unit1_aggregate,
2840: p_unit2_aggregate => l_unit2_aggregate,
2841: p_unit3_aggregate => l_unit3_aggregate);
2842: pqh_wks_budget.get_wks_unit_precision(p_worksheet_id => p_worksheet_id ,
2843: p_unit1_precision => l_unit1_precision,
2844: p_unit2_precision => l_unit2_precision,
2845: p_unit3_precision => l_unit3_precision);
2846: for i in c1 loop

Line 3791: pqh_wks_budget.get_wkd_unit_precision(p_worksheet_detail_id => p_worksheet_detail_id,

3787: l_unit1_precision number;
3788: l_unit2_precision number;
3789: l_unit3_precision number;
3790: begin
3791: pqh_wks_budget.get_wkd_unit_precision(p_worksheet_detail_id => p_worksheet_detail_id,
3792: p_unit1_precision => l_unit1_precision,
3793: p_unit2_precision => l_unit2_precision,
3794: p_unit3_precision => l_unit3_precision);
3795: for i in c1 loop

Line 3808: pqh_wks_budget.wkd_propagation_method(i.worksheet_detail_id,l_change_mode);

3804: else
3805: l_propagate := 'FALSE' ;
3806: end if;
3807: if l_propagate ='TRUE' then
3808: pqh_wks_budget.wkd_propagation_method(i.worksheet_detail_id,l_change_mode);
3809: l_budget_unit1_available := i.budget_unit1_available;
3810: l_budget_unit2_available := i.budget_unit2_available;
3811: l_budget_unit3_available := i.budget_unit3_available;
3812: l_object_version_number := i.object_version_number;

Line 4111: l_budget_id := pqh_wks_budget.get_wkd_budget(p_worksheet_detail_id => p_worksheet_detail_id);

4107: l_proc varchar2(51) := g_package||'add_budgetrow';
4108: l_budget_id number;
4109: begin
4110: hr_utility.set_location('entering'||l_proc,10);
4111: l_budget_id := pqh_wks_budget.get_wkd_budget(p_worksheet_detail_id => p_worksheet_detail_id);
4112: init_prd_tab(p_budget_id => l_budget_id);
4113: for i in c1 loop
4114: add_prd(p_prd_start_date => i.prd_start_date,
4115: p_prd_end_date => i.prd_end_date,

Line 4167: l_budget_id := pqh_wks_budget.get_bgd_budget(p_budget_detail_id => p_budget_detail_id);

4163: l_proc varchar2(51) := g_package||'add_budgetrow';
4164: l_budget_id number;
4165: begin
4166: hr_utility.set_location('entering'||l_proc,10);
4167: l_budget_id := pqh_wks_budget.get_bgd_budget(p_budget_detail_id => p_budget_detail_id);
4168: init_prd_tab(p_budget_id => l_budget_id);
4169: for i in c1 loop
4170: add_prd(p_prd_start_date => i.prd_start_date,
4171: p_prd_end_date => i.prd_end_date,

Line 4570: pqh_wks_budget.get_wkd_unit_aggregate(p_worksheet_detail_id => p_worksheet_detail_id,

4566: hr_utility.set_location('called with copy_budget_periods '||p_copy_budget_periods||l_proc,15);
4567: if nvl(p_copy_budget_periods,'X') = 'Y' then
4568: hr_utility.set_location('going to copy prds from bud_det'||p_budget_detail_id||l_proc,20);
4569: hr_utility.set_location('going to copy prds to wks_det'||p_worksheet_detail_id||l_proc,30);
4570: pqh_wks_budget.get_wkd_unit_aggregate(p_worksheet_detail_id => p_worksheet_detail_id,
4571: p_unit1_aggregate => l_unit1_aggregate,
4572: p_unit2_aggregate => l_unit2_aggregate,
4573: p_unit3_aggregate => l_unit3_aggregate);
4574: pqh_wks_budget.get_wkd_unit_precision(p_worksheet_detail_id => p_worksheet_detail_id,

Line 4574: pqh_wks_budget.get_wkd_unit_precision(p_worksheet_detail_id => p_worksheet_detail_id,

4570: pqh_wks_budget.get_wkd_unit_aggregate(p_worksheet_detail_id => p_worksheet_detail_id,
4571: p_unit1_aggregate => l_unit1_aggregate,
4572: p_unit2_aggregate => l_unit2_aggregate,
4573: p_unit3_aggregate => l_unit3_aggregate);
4574: pqh_wks_budget.get_wkd_unit_precision(p_worksheet_detail_id => p_worksheet_detail_id,
4575: p_unit1_precision => l_unit1_precision,
4576: p_unit2_precision => l_unit2_precision,
4577: p_unit3_precision => l_unit3_precision);
4578: hr_utility.set_location('unit aggregate fetched'||l_proc,40);

Line 5122: l_budget_id := pqh_wks_budget.get_bgd_budget(p_budget_detail_id => p_budget_detail_id);

5118: hr_utility.set_location('entering'||l_proc,10);
5119: if p_budget_id is not null then
5120: l_budget_id := p_budget_id;
5121: else
5122: l_budget_id := pqh_wks_budget.get_bgd_budget(p_budget_detail_id => p_budget_detail_id);
5123: end if;
5124: init_prd_tab(p_budget_id => l_budget_id);
5125: for i in c1 loop
5126: add_prd(p_prd_start_date => i.prd_start_date,

Line 5157: l_budget_id := pqh_wks_budget.get_wkd_budget(p_worksheet_detail_id => p_worksheet_detail_id);

5153: hr_utility.set_location('entering'||l_proc,10);
5154: if p_budget_id is not null then
5155: l_budget_id := p_budget_id;
5156: else
5157: l_budget_id := pqh_wks_budget.get_wkd_budget(p_worksheet_detail_id => p_worksheet_detail_id);
5158: end if;
5159: init_prd_tab(p_budget_id => l_budget_id);
5160: for i in c1 loop
5161: add_prd(p_prd_start_date => i.prd_start_date,