DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PA_VARCHAR2_30_TBL_TYPE

Line 10: pji_empty_varchar2_30_tbl SYSTEM.pa_varchar2_30_tbl_type := SYSTEM.pa_varchar2_30_tbl_type();

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:
14: ------------------------------------------------------------------

Line 28: , p_source_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl

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: );
32:

Line 29: , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl

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: );
32:
33:

Line 37: , p_source_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl

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: );
41:

Line 38: , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl

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: );
41:
42: