DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_NUM_TBL_TYPE

Line 110: l_fp_version_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl ;

106: l_rbs_version_id NUMBER := NULL;
107: l_rbs_header_id NUMBER := NULL; --Added for bug#5728852
108: -- l_count NUMBER;
109: l_return_status VARCHAR2(1) := NULL;
110: l_fp_version_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl ;
111: l_msg_code VARCHAR2(10) := NULL;
112: l_refresh_code NUMBER; -- Bug#5099574
113: l_process varchar2(30); -- Bug#5099574
114:

Line 2819: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

2815: -- This is to set scope for extraction as well as track time/curr dangling records
2816: -- in the case of secondary slice creation.
2817: --
2818: PROCEDURE EXTRACT_FIN_PLAN_VERSIONS(
2819: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
2820: , p_slice_type IN VARCHAR2 := NULL -- 'PRI' or 'SEC' or 'SECRBS'
2821: ) IS
2822: l_count NUMBER;
2823: BEGIN

Line 4582: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

4578: END;
4579:
4580:
4581: PROCEDURE GET_PRI_SLICE_DATA(
4582: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
4583: , p_commit IN VARCHAR2 := 'F') IS
4584: BEGIN
4585:
4586: FORALL I IN p_fp_version_ids.FIRST..p_fp_version_ids.LAST

Line 6579: l_fp_wp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

6575: -- for dangling baselined financial plans.
6576: --
6577: PROCEDURE PULL_DANGLING_PLANS IS
6578:
6579: l_fp_wp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6580: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6581:
6582: BEGIN
6583:

Line 6580: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

6576: --
6577: PROCEDURE PULL_DANGLING_PLANS IS
6578:
6579: l_fp_wp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6580: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
6581:
6582: BEGIN
6583:
6584: NULL; -- Pull dangling calls bulk "create secondary private" directly.