[Home] [Help]
3854: l_prd_start_date date;
3855: l_prd_end_date date;
3856: k number := 1;
3857: cursor c2 is select start_date
3858: from per_time_periods
3859: where period_set_name = l_period_set_name
3860: and start_date >= l_prd_start_date
3861: and end_date <= l_prd_end_date ;
3862: l_proc varchar2(51) := g_package||'init_prd_tab';
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';
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';
4155: p_unit3_aggregate in varchar2) as
4156: cursor c1 is select tps.start_date prd_start_date,tpe.end_date prd_end_date,
4157: prd.budget_unit1_value unit1_value,prd.budget_unit2_value unit2_value,
4158: prd.budget_unit3_value unit3_value
4159: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe
4160: where prd.budget_detail_id = p_budget_detail_id
4161: and prd.start_time_period_id = tps.time_period_id
4162: and prd.end_time_period_id = tpe.time_period_id;
4163: l_proc varchar2(51) := g_package||'add_budgetrow';
4184: p_unit3_aggregate in varchar2) as
4185: cursor c1 is select tps.start_date prd_start_date,tpe.end_date prd_end_date,
4186: prd.budget_unit1_value unit1_value,prd.budget_unit2_value unit2_value,
4187: prd.budget_unit3_value unit3_value
4188: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe
4189: where prd.budget_detail_id = p_budget_detail_id
4190: and prd.start_time_period_id = tps.time_period_id
4191: and prd.end_time_period_id = tpe.time_period_id;
4192: l_proc varchar2(51) := g_package||'sub_budgetrow';
5107: p_budget_id in number) as
5108: cursor c1 is select tps.start_date prd_start_date,tpe.end_date prd_end_date,
5109: prd.budget_unit1_value unit1_value,prd.budget_unit2_value unit2_value,
5110: prd.budget_unit3_value unit3_value
5111: from pqh_budget_periods prd, per_time_periods tps, per_time_periods tpe
5112: where prd.budget_detail_id = p_budget_detail_id
5113: and prd.start_time_period_id = tps.time_period_id
5114: and prd.end_time_period_id = tpe.time_period_id;
5115: l_proc varchar2(51) := g_package||'add_budgetrow';
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';