9: p_table_identifier Varchar ,
10: p_calendar_id IN Number default null) is
11:
12: /* Modified for bug 9557889 */
13: tab_budget_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
14: tab_budget_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
15: tab_budget_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_budget_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
10: p_calendar_id IN Number default null) is
11:
12: /* Modified for bug 9557889 */
13: tab_budget_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
14: tab_budget_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
15: tab_budget_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_budget_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_budget_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
11:
12: /* Modified for bug 9557889 */
13: tab_budget_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
14: tab_budget_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
15: tab_budget_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_budget_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_budget_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
19: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
12: /* Modified for bug 9557889 */
13: tab_budget_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
14: tab_budget_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
15: tab_budget_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_budget_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_budget_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
19: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
20: tab_forecast_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
13: tab_budget_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
14: tab_budget_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
15: tab_budget_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_budget_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_budget_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
19: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
20: tab_forecast_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
21: tab_forecast_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
14: tab_budget_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
15: tab_budget_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_budget_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_budget_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
19: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
20: tab_forecast_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
21: tab_forecast_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
22: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
15: tab_budget_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_budget_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_budget_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
19: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
20: tab_forecast_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
21: tab_forecast_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
22: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
23: tab_forecast_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
16: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
17: tab_budget_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_budget_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
19: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
20: tab_forecast_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
21: tab_forecast_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
22: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
23: tab_forecast_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
24: tab_forecast_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
17: tab_budget_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
18: tab_budget_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
19: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
20: tab_forecast_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
21: tab_forecast_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
22: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
23: tab_forecast_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
24: tab_forecast_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
25: l_plan_version_id number;
18: tab_budget_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
19: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
20: tab_forecast_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
21: tab_forecast_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
22: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
23: tab_forecast_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
24: tab_forecast_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
25: l_plan_version_id number;
26: /* Modified for bug 9557889 */
19: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;
20: tab_forecast_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
21: tab_forecast_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
22: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
23: tab_forecast_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
24: tab_forecast_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
25: l_plan_version_id number;
26: /* Modified for bug 9557889 */
27:
20: tab_forecast_cost_str_date PA_PLSQL_DATATYPES.DateTabTyp;
21: tab_forecast_cost_end_date PA_PLSQL_DATATYPES.DateTabTyp;
22: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;
23: tab_forecast_rev_str_date PA_PLSQL_DATATYPES.DateTabTyp;
24: tab_forecast_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
25: l_plan_version_id number;
26: /* Modified for bug 9557889 */
27:
28: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;
24: tab_forecast_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;
25: l_plan_version_id number;
26: /* Modified for bug 9557889 */
27:
28: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;
29: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;
30: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
31: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
32: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
25: l_plan_version_id number;
26: /* Modified for bug 9557889 */
27:
28: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;
29: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;
30: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
31: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
32: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
33: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;
26: /* Modified for bug 9557889 */
27:
28: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;
29: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;
30: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
31: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
32: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
33: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;
34: ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp;
27:
28: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;
29: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;
30: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
31: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
32: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
33: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;
34: ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp;
35:
28: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;
29: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;
30: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
31: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
32: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
33: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;
34: ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp;
35:
36: ins_pltab_counter number :=0;
29: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;
30: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
31: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
32: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
33: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;
34: ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp;
35:
36: ins_pltab_counter number :=0;
37:
30: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;
31: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;
32: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;
33: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;
34: ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp;
35:
36: ins_pltab_counter number :=0;
37:
38: /* Bug 4118904
401: p_ins_budget_forecast_flag => ins_budget_forecast_flag);
402:
403: end get_bgt_ver_period;
404:
405: procedure Bud_period_version_ins (p_ins_version_id PA_PLSQL_DATATYPES.IdTabTyp,
406: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,
407: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
408: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
409: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
402:
403: end get_bgt_ver_period;
404:
405: procedure Bud_period_version_ins (p_ins_version_id PA_PLSQL_DATATYPES.IdTabTyp,
406: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,
407: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
408: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
409: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
410: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,
403: end get_bgt_ver_period;
404:
405: procedure Bud_period_version_ins (p_ins_version_id PA_PLSQL_DATATYPES.IdTabTyp,
406: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,
407: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
408: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
409: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
410: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,
411: p_ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp) is
404:
405: procedure Bud_period_version_ins (p_ins_version_id PA_PLSQL_DATATYPES.IdTabTyp,
406: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,
407: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
408: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
409: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
410: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,
411: p_ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp) is
412: begin
405: procedure Bud_period_version_ins (p_ins_version_id PA_PLSQL_DATATYPES.IdTabTyp,
406: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,
407: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
408: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
409: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
410: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,
411: p_ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp) is
412: begin
413:
406: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,
407: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
408: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
409: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
410: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,
411: p_ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp) is
412: begin
413:
414: delete from pji_period_budget_ver_tmp;
407: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,
408: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,
409: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,
410: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,
411: p_ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp) is
412: begin
413:
414: delete from pji_period_budget_ver_tmp;
415: FORALL j IN 1..p_ins_version_id.count