DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PA_NUM_TBL_TYPE

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

5: --
6: -- This line is for reference only: pji_empty_num_tbl is a sql type
7: -- of nested table of numbers. Source: $PA_TOP/.../par1tt20.sql
8: --
9: pji_empty_num_tbl SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
10: pji_empty_varchar2_30_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();
11:
12:
13:

Line 26: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

22: --- Copy apis
23: ----------------------------------------------
24:
25: PROCEDURE COPY_PRIMARY(
26: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
27: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
28: , p_source_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
29: , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
30: , p_commit IN VARCHAR2 := 'F'

Line 27: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

23: ----------------------------------------------
24:
25: PROCEDURE COPY_PRIMARY(
26: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
27: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
28: , p_source_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
29: , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
30: , p_commit IN VARCHAR2 := 'F'
31: );

Line 35: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

31: );
32:
33:
34: PROCEDURE COPY_PLANS(
35: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
36: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
37: , p_source_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
38: , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
39: , p_commit IN VARCHAR2 := 'F'

Line 36: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

32:
33:
34: PROCEDURE COPY_PLANS(
35: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
36: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
37: , p_source_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
38: , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
39: , p_commit IN VARCHAR2 := 'F'
40: );

Line 59: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

55: p_slice_type IN VARCHAR2 := NULL -- 'PRI' or 'SEC'
56: );
57:
58: PROCEDURE EXTRACT_FIN_PLAN_VERSIONS(
59: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
60: , p_slice_type IN VARCHAR2 := NULL -- 'PRI' or 'SEC'
61: );
62:
63: PROCEDURE EXTRACT_CB_CO_PLAN_VERSIONS;

Line 141: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

137: --- Misc extraction/secondary creation helper apis
138: ----------------------------------------------
139:
140: PROCEDURE GET_PRI_SLICE_DATA(
141: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
142: , p_commit IN VARCHAR2 := 'F');
143:
144: PROCEDURE GET_GLOBAL_EXCHANGE_RATES;
145: