DBA Data[Home] [Help]

APPS.PJI_COMPLETION_GRAPH dependencies on PA_PLSQL_DATATYPES

Line 12: tab_budget_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 13: tab_budget_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;

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;

Line 14: tab_budget_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 15: tab_budget_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;

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;

Line 16: tab_forecast_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 17: tab_forecast_blined_cost_date PA_PLSQL_DATATYPES.DateTabTyp;

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:

Line 18: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 19: tab_forecast_blined_rev_date PA_PLSQL_DATATYPES.DateTabTyp;

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;

Line 22: ins_version_id PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 23: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 24: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;

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;

Line 25: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;

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:

Line 26: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;

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;

Line 27: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;

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:

Line 28: ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp;

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

Line 385: procedure Bud_period_version_ins (p_ins_version_id PA_PLSQL_DATATYPES.IdTabTyp,

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,

Line 386: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 387: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,

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

Line 388: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,

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

Line 389: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,

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:

Line 390: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,

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;

Line 391: p_ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp) is

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