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_WORKSHEET_PERIODS

Line 1049: from pqh_worksheet_periods

1045: cursor c1 is select worksheet_period_id,budget_unit1_value,budget_unit2_value,budget_unit3_value,
1046: budget_unit1_value_type_cd,budget_unit2_value_type_cd,budget_unit3_value_type_cd,
1047: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1048: budget_unit1_available,budget_unit2_available,budget_unit3_available
1049: from pqh_worksheet_periods
1050: where worksheet_detail_id = p_worksheet_detail_id
1051: for update of budget_unit1_value,budget_unit2_value,budget_unit3_value,
1052: budget_unit1_percent,budget_unit2_percent,budget_unit3_percent,
1053: budget_unit1_available,budget_unit2_available,budget_unit3_available ;

Line 1234: update pqh_worksheet_periods

1230: hr_utility.set_location('after period changes values '||l_proc,130);
1231: hr_utility.set_location('unit1_available is '||l_period_unit1_available||l_proc,133);
1232: hr_utility.set_location('unit2_available is '||l_period_unit2_available||l_proc,134);
1233: hr_utility.set_location('unit3_available is '||l_period_unit3_available||l_proc,135);
1234: update pqh_worksheet_periods
1235: set budget_unit1_value = l_period_unit1_value,
1236: budget_unit2_value = l_period_unit2_value,
1237: budget_unit3_value = l_period_unit3_value,
1238: budget_unit1_percent = l_period_unit1_percent,

Line 2936: from pqh_worksheet_periods where worksheet_detail_id = p_worksheet_detail_id;

2932: of the worksheet_details are to be changed too
2933: */
2934: hr_utility.set_location('entering '||l_proc,10);
2935: select count(*) into l_count
2936: from pqh_worksheet_periods where worksheet_detail_id = p_worksheet_detail_id;
2937: if l_count = 0 then
2938: hr_utility.set_location('no periods found '||l_proc,20);
2939: for i in c1(p_budget_detail_id) loop
2940: hr_utility.set_location('for each pos '||l_proc,30);

Line 2951: pqh_worksheet_periods_api.create_worksheet_period(

2947: if nvl(p_budget_unit3_value,0) <> 0 then
2948: l_budget_unit3_percent := round(nvl(i.budget_unit3_value,0) * 100 / p_budget_unit3_value,2) ;
2949: end if;
2950: hr_utility.set_location('% figures changed '||l_proc,35);
2951: pqh_worksheet_periods_api.create_worksheet_period(
2952: p_validate => FALSE
2953: ,p_effective_date => trunc(sysdate)
2954: ,p_worksheet_detail_id => p_worksheet_detail_id
2955: ,p_worksheet_period_id => l_worksheet_period_id

Line 4103: from pqh_worksheet_periods prd, per_time_periods tps, per_time_periods tpe

4099: p_unit3_aggregate in varchar2) as
4100: cursor c1 is select tps.start_date prd_start_date,tpe.end_date prd_end_date,
4101: prd.budget_unit1_value unit1_value,prd.budget_unit2_value unit2_value,
4102: prd.budget_unit3_value unit3_value
4103: from pqh_worksheet_periods prd, per_time_periods tps, per_time_periods tpe
4104: where prd.worksheet_detail_id = p_worksheet_detail_id
4105: and prd.start_time_period_id = tps.time_period_id
4106: and prd.end_time_period_id = tpe.time_period_id;
4107: l_proc varchar2(51) := g_package||'add_budgetrow';

Line 4132: from pqh_worksheet_periods prd, per_time_periods tps, per_time_periods tpe

4128: p_unit3_aggregate in varchar2) as
4129: cursor c1 is select tps.start_date prd_start_date,tpe.end_date prd_end_date,
4130: prd.budget_unit1_value unit1_value,prd.budget_unit2_value unit2_value,
4131: prd.budget_unit3_value unit3_value
4132: from pqh_worksheet_periods prd, per_time_periods tps, per_time_periods tpe
4133: where prd.worksheet_detail_id = p_worksheet_detail_id
4134: and prd.start_time_period_id = tps.time_period_id
4135: and prd.end_time_period_id = tpe.time_period_id;
4136: l_proc varchar2(51) := g_package||'sub_budgetrow';

Line 4647: from pqh_worksheet_periods where worksheet_detail_id = p_worksheet_detail_id;

4643: l_proc varchar2(100) := g_package||'copy_budget_details' ;
4644: begin
4645: hr_utility.set_location('entering '||l_proc,10);
4646: select count(*) into l_count
4647: from pqh_worksheet_periods where worksheet_detail_id = p_worksheet_detail_id;
4648: if l_count = 0 then
4649: hr_utility.set_location('no periods found '||l_proc,20);
4650: for i in c1(p_budget_detail_id) loop
4651: hr_utility.set_location('for each budget_detail '||l_proc,30);

Line 4652: pqh_worksheet_periods_api.create_worksheet_period(

4648: if l_count = 0 then
4649: hr_utility.set_location('no periods found '||l_proc,20);
4650: for i in c1(p_budget_detail_id) loop
4651: hr_utility.set_location('for each budget_detail '||l_proc,30);
4652: pqh_worksheet_periods_api.create_worksheet_period(
4653: p_validate => FALSE
4654: ,p_effective_date => trunc(sysdate)
4655: ,p_worksheet_detail_id => p_worksheet_detail_id
4656: ,p_worksheet_period_id => l_worksheet_period_id

Line 5146: from pqh_worksheet_periods prd, per_time_periods tps, per_time_periods tpe

5142: p_budget_id in number) as
5143: cursor c1 is select tps.start_date prd_start_date,tpe.end_date prd_end_date,
5144: prd.budget_unit1_value unit1_value,prd.budget_unit2_value unit2_value,
5145: prd.budget_unit3_value unit3_value
5146: from pqh_worksheet_periods prd, per_time_periods tps, per_time_periods tpe
5147: where prd.worksheet_detail_id = p_worksheet_detail_id
5148: and prd.start_time_period_id = tps.time_period_id
5149: and prd.end_time_period_id = tpe.time_period_id;
5150: l_proc varchar2(51) := g_package||'add_budgetrow';