8: p_project_id IN Number,
9: p_table_identifier Varchar ,
10: p_calendar_id IN Number default null) is
11:
12: tab_budget_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
13: tab_budget_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;
14: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
15: tab_budget_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
9: p_table_identifier Varchar ,
10: p_calendar_id IN Number default null) is
11:
12: tab_budget_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
13: tab_budget_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;
14: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
15: tab_budget_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_forecast_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;
10: p_calendar_id IN Number default null) is
11:
12: tab_budget_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
13: tab_budget_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;
14: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
15: tab_budget_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_forecast_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
11:
12: tab_budget_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
13: tab_budget_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;
14: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
15: tab_budget_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_forecast_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
19: tab_forecast_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
12: tab_budget_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
13: tab_budget_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;
14: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
15: tab_budget_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_forecast_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
19: tab_forecast_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
20: l_plan_version_id number;
13: tab_budget_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;
14: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
15: tab_budget_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_forecast_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
19: tab_forecast_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
20: l_plan_version_id number;
21:
14: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
15: tab_budget_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_forecast_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
19: tab_forecast_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
20: l_plan_version_id number;
21:
22: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;
15: tab_budget_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_forecast_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
19: tab_forecast_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
20: l_plan_version_id number;
21:
22: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;
23: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;
18: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
19: tab_forecast_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
20: l_plan_version_id number;
21:
22: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;
23: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;
24: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
25: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
26: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
19: tab_forecast_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;
20: l_plan_version_id number;
21:
22: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;
23: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;
24: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
25: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
26: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
27: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;
20: l_plan_version_id number;
21:
22: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;
23: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;
24: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
25: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
26: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
27: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;
28: ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp;
21:
22: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;
23: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;
24: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
25: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
26: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
27: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;
28: ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp;
29:
22: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;
23: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;
24: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
25: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
26: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
27: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;
28: ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp;
29:
30: ins_pltab_counter number :=0;
23: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;
24: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
25: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
26: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
27: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;
28: ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp;
29:
30: ins_pltab_counter number :=0;
31:
24: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
25: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
26: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
27: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;
28: ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp;
29:
30: ins_pltab_counter number :=0;
31:
32: /* Bug 4118904
381: p_ins_budget_forecast_flag => ins_budget_forecast_flag);
382:
383: end get_bgt_ver_period;
384:
385: procedure Bud_period_version_ins (p_ins_version_id PA_PLSQL_DATATYPES.IdTabTyp,
386: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,
387: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
388: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
389: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
382:
383: end get_bgt_ver_period;
384:
385: procedure Bud_period_version_ins (p_ins_version_id PA_PLSQL_DATATYPES.IdTabTyp,
386: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,
387: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
388: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
389: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
390: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,
383: end get_bgt_ver_period;
384:
385: procedure Bud_period_version_ins (p_ins_version_id PA_PLSQL_DATATYPES.IdTabTyp,
386: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,
387: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
388: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
389: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
390: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,
391: p_ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp) is
384:
385: procedure Bud_period_version_ins (p_ins_version_id PA_PLSQL_DATATYPES.IdTabTyp,
386: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,
387: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
388: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
389: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
390: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,
391: p_ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp) is
392: begin
385: procedure Bud_period_version_ins (p_ins_version_id PA_PLSQL_DATATYPES.IdTabTyp,
386: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,
387: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
388: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
389: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
390: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,
391: p_ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp) is
392: begin
393:
386: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,
387: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
388: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
389: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
390: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,
391: p_ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp) is
392: begin
393:
394: delete from pji_period_budget_ver_tmp;
387: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
388: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
389: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
390: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,
391: p_ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp) is
392: begin
393:
394: delete from pji_period_budget_ver_tmp;
395: FORALL j IN 1..p_ins_version_id.count