DBA Data[Home] [Help]

APPS.PJI_REP_UTIL dependencies on PA_NUM_TBL_TYPE

Line 21: PROCEDURE Log_Struct_Change_Event(p_wbs_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE);

17: , p_token5 VARCHAR2 DEFAULT NULL
18: , p_token5_value VARCHAR2 DEFAULT NULL
19: );
20:
21: PROCEDURE Log_Struct_Change_Event(p_wbs_version_id_tbl SYSTEM.PA_NUM_TBL_TYPE);
22:
23: PROCEDURE Populate_WBS_Hierarchy_Cache(p_project_id NUMBER
24: , p_element_version_id NUMBER
25: , p_prg_flag VARCHAR2 DEFAULT 'N'

Line 323: , p_plan_version_id_tbl SYSTEM.pa_num_tbl_type

319: , x_msg_data IN OUT NOCOPY VARCHAR2);
320:
321: PROCEDURE Derive_VP_Period(
322: p_project_id NUMBER
323: , p_plan_version_id_tbl SYSTEM.pa_num_tbl_type
324: , x_from_period OUT NOCOPY NUMBER
325: , x_to_period OUT NOCOPY NUMBER
326: , x_return_status IN OUT NOCOPY VARCHAR2
327: , x_msg_count IN OUT NOCOPY NUMBER

Line 332: , p_plan_version_id_tbl SYSTEM.pa_num_tbl_type

328: , x_msg_data IN OUT NOCOPY VARCHAR2);
329:
330: PROCEDURE Derive_Perf_Period(
331: p_project_id NUMBER
332: , p_plan_version_id_tbl SYSTEM.pa_num_tbl_type
333: , x_from_period OUT NOCOPY NUMBER
334: , x_to_period OUT NOCOPY NUMBER
335: , x_return_status IN OUT NOCOPY VARCHAR2
336: , x_msg_count IN OUT NOCOPY NUMBER

Line 344: p_plan_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()

340: * Added this procedure for bug 3842347. This procedure will give max and min date for a given plan version
341: * id and proejct_id. It is being used in get default api
342: */
343: PROCEDURE Get_Default_Period_Dates (
344: p_plan_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
345: , p_project_id IN NUMBER
346: , x_min_julian_date OUT NOCOPY NUMBER
347: , x_max_julian_date OUT NOCOPY NUMBER);
348:

Line 575: p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

571: the processing page. But if the processing is Deferred
572: then launch concurrent program */
573: PROCEDURE Is_Smart_Slice_Created(
574: p_rbs_version_id IN NUMBER,
575: p_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
576: p_wbs_element_id IN NUMBER,
577: p_rbs_element_id IN NUMBER,
578: p_prg_rollup_flag IN VARCHAR2,
579: p_curr_record_type_id IN NUMBER,

Line 599: p_fin_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),

595: + RBS is attached with context plan version
596: + Additional Plan versions are selected
597: */
598: PROCEDURE Chk_plan_vers_have_same_RBS(
599: p_fin_plan_version_id_tbl IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type(),
600: x_R_PlanVers_HavSame_RBS_Flag OUT NOCOPY VARCHAR2,
601: x_msg_count OUT NOCOPY NUMBER,
602: x_msg_data OUT NOCOPY VARCHAR2,
603: x_return_status OUT NOCOPY VARCHAR2);