DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT dependencies on PA_NUM_TBL_TYPE

Line 6: pji_empty_num_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

2: /* $Header: PJIPP01S.pls 120.4 2005/09/10 19:19:43 appldev noship $ */
3:
4: -- This line is could be deleted, for reference only: pji_empty_num_tbl is a sql type of nested table of numbers. Source: $PA_TOP/.../par1tt20.sql
5:
6: pji_empty_num_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7: pji_empty_varchar2_30_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
8:
9:
10: ------------------------------------------------------------------

Line 17: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

13: ------------------------------------------------------------------
14: ------------------------------------------------------------------
15:
16: PROCEDURE MAP_RESOURCE_LIST (
17: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
18: , p_context IN VARCHAR2 := 'BULK');
19:
20:
21: ------------------------------------------------------------------

Line 32: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

28: ( p_context IN VARCHAR2 := 'FPM_UPGRADE' -- Valid values: 'FPM_UPGRADE' and 'TRUNCATE'
29: ) ;
30:
31: PROCEDURE CREATE_PRIMARY_PVT(
32: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
33: , p_is_primary_rbs IN VARCHAR2 -- Valid values are T/F
34: , p_commit IN VARCHAR2 := 'F'
35: , p_fp_src_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
36: ,p_copy_mode IN VARCHAR2 :=NULL

Line 35: , p_fp_src_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

31: PROCEDURE CREATE_PRIMARY_PVT(
32: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
33: , p_is_primary_rbs IN VARCHAR2 -- Valid values are T/F
34: , p_commit IN VARCHAR2 := 'F'
35: , p_fp_src_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
36: ,p_copy_mode IN VARCHAR2 :=NULL
37: );
38:
39:

Line 41: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

37: );
38:
39:
40: PROCEDURE DELETE_ALL_PVT (
41: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
42: , p_commit IN VARCHAR2 := 'F');
43:
44:
45: PROCEDURE CREATE_SECONDARY_PVT(

Line 46: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

42: , p_commit IN VARCHAR2 := 'F');
43:
44:
45: PROCEDURE CREATE_SECONDARY_PVT(
46: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
47: , p_commit IN VARCHAR2 := 'F'
48: , p_process_all IN VARCHAR2 := 'F');
49:
50:

Line 52: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

48: , p_process_all IN VARCHAR2 := 'F');
49:
50:
51: PROCEDURE CREATE_SECONDARY_T_PVT(
52: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
53: , p_commit IN VARCHAR2 := 'F'
54: , p_process_all IN VARCHAR2 := 'F');
55:
56:

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

54: , p_process_all IN VARCHAR2 := 'F');
55:
56:
57: PROCEDURE UPDATE_PRIMARY_PVT(
58: p_plan_version_ids IN SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type()
59: , p_commit IN VARCHAR2 := 'F');
60:
61:
62: PROCEDURE UPDATE_PRIMARY_PVT_ACT_ETC (