APPS.PA_PPR_SMART_SLICE_PVT dependencies on PA_NUM_TBL_TYPE

Line 28: p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type :=

24:
25:
26: PROCEDURE maintain_smart_slice (
27: p_rbs_version_id IN NUMBER :=NULL,
28: p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type :=
29: SYSTEM.pa_num_tbl_type(),
30: p_wbs_element_id IN NUMBER,
31: p_rbs_element_id IN NUMBER,
32: p_prg_rollup_flag IN VARCHAR2,

Line 29: SYSTEM.pa_num_tbl_type(),

25:
26: PROCEDURE maintain_smart_slice (
27: p_rbs_version_id IN NUMBER :=NULL,
28: p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type :=
29: SYSTEM.pa_num_tbl_type(),
30: p_wbs_element_id IN NUMBER,
31: p_rbs_element_id IN NUMBER,
32: p_prg_rollup_flag IN VARCHAR2,
33: p_curr_record_type_id IN NUMBER,

Line 37: p_rbs_version_id_tbl IN SYSTEM.pa_num_tbl_type :=

33: p_curr_record_type_id IN NUMBER,
34: p_calendar_type IN VARCHAR2,
35: p_wbs_version_id IN NUMBER,
36: p_commit IN VARCHAR2 := 'Y',
37: p_rbs_version_id_tbl IN SYSTEM.pa_num_tbl_type :=
38: SYSTEM.pa_num_tbl_type(),
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: x_return_status OUT NOCOPY VARCHAR2,

Line 38: SYSTEM.pa_num_tbl_type(),

34: p_calendar_type IN VARCHAR2,
35: p_wbs_version_id IN NUMBER,
36: p_commit IN VARCHAR2 := 'Y',
37: p_rbs_version_id_tbl IN SYSTEM.pa_num_tbl_type :=
38: SYSTEM.pa_num_tbl_type(),
39: x_msg_count OUT NOCOPY NUMBER,
40: x_msg_data OUT NOCOPY VARCHAR2,
41: x_return_status OUT NOCOPY VARCHAR2,
42: p_fact_slice varchar2 default 'NULL' ) IS

Line 49: l_proj_element_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

45: -- l_rollup_status_exists VARCHAR2(1) := 'N';
46: l_exists VARCHAR2(1) := 'N';
47: l_struct_element_id NUMBER := -1;
48: l_project_id NUMBER := 1;
49: l_proj_element_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
50: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
51: l_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type :=
52: SYSTEM.pa_varchar2_1_tbl_type();
53: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 50: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

46: l_exists VARCHAR2(1) := 'N';
47: l_struct_element_id NUMBER := -1;
48: l_project_id NUMBER := 1;
49: l_proj_element_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
50: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
51: l_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type :=
52: SYSTEM.pa_varchar2_1_tbl_type();
53: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
54: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 53: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

49: l_proj_element_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
50: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
51: l_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type :=
52: SYSTEM.pa_varchar2_1_tbl_type();
53: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
54: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
55: l_count NUMBER := 1;
56:
57:

Line 54: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

50: l_plan_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
51: l_plan_type_code_tbl SYSTEM.pa_varchar2_1_tbl_type :=
52: SYSTEM.pa_varchar2_1_tbl_type();
53: l_project_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
54: l_wbs_version_id_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
55: l_count NUMBER := 1;
56:
57:
58: -- OLAP START