DBA Data[Home] [Help]

APPS.PJI_COMPLETION_GRAPH dependencies on PA_PLSQL_DATATYPES

Line 13: tab_budget_cost_version_id PA_PLSQL_DATATYPES.IdTabTyp;

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;

Line 14: tab_budget_cost_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;

Line 15: tab_budget_cost_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;

Line 16: tab_budget_rev_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;

Line 17: tab_budget_rev_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;

Line 18: tab_budget_rev_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;

Line 19: tab_forecast_cost_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;

Line 20: tab_forecast_cost_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;

Line 21: tab_forecast_cost_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;

Line 22: tab_forecast_rev_version_id PA_PLSQL_DATATYPES.IdTabTyp;

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 */

Line 23: tab_forecast_rev_str_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 */
27:

Line 24: tab_forecast_rev_end_date PA_PLSQL_DATATYPES.DateTabTyp;

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;

Line 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;

Line 29: ins_name PA_PLSQL_DATATYPES.Char30TabTyp;

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;

Line 30: ins_period_id PA_PLSQL_DATATYPES.NumTabTyp;

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;

Line 31: ins_start_date PA_PLSQL_DATATYPES.DateTabTyp;

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:

Line 32: ins_end_date PA_PLSQL_DATATYPES.DateTabTyp;

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;

Line 33: ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp;

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:

Line 34: ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp;

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

Line 405: procedure Bud_period_version_ins (p_ins_version_id PA_PLSQL_DATATYPES.IdTabTyp,

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,

Line 406: p_ins_name PA_PLSQL_DATATYPES.Char30TabTyp,

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,

Line 407: p_ins_period_id PA_PLSQL_DATATYPES.NumTabTyp,

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

Line 408: p_ins_start_date PA_PLSQL_DATATYPES.DateTabTyp,

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

Line 409: p_ins_end_date PA_PLSQL_DATATYPES.DateTabTyp,

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:

Line 410: p_ins_cst_rev_flag PA_PLSQL_DATATYPES.Char1TabTyp,

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;

Line 411: p_ins_budget_forecast_flag PA_PLSQL_DATATYPES.Char1TabTyp) is

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