DBA Data[Home] [Help]

APPS.PJI_FM_PLAN_MAINT_PVT dependencies on PA_NUM_TBL_TYPE

Line 207: l_fp_version_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl ;

203: l_rbs_version_id NUMBER := NULL;
204: l_rbs_header_id NUMBER := NULL; --Added for bug#5728852
205: -- l_count NUMBER;
206: l_return_status VARCHAR2(1) := NULL;
207: l_fp_version_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl ;
208: l_msg_code VARCHAR2(10) := NULL;
209: l_refresh_code NUMBER; -- Bug#5099574
210: l_process varchar2(30); -- Bug#5099574
211:

Line 3959: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

3955: -- This is to set scope for extraction as well as track time/curr dangling records
3956: -- in the case of secondary slice creation.
3957: --
3958: PROCEDURE EXTRACT_FIN_PLAN_VERSIONS(
3959: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
3960: , p_slice_type IN VARCHAR2 := NULL -- 'PRI' or 'SEC' or 'SECRBS'
3961: ) IS
3962: l_count NUMBER;
3963: BEGIN

Line 5766: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

5762: END;
5763:
5764:
5765: PROCEDURE GET_PRI_SLICE_DATA(
5766: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
5767: , p_commit IN VARCHAR2 := 'F') IS
5768: BEGIN
5769:
5770: FORALL I IN p_fp_version_ids.FIRST..p_fp_version_ids.LAST

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

7779: -- for dangling baselined financial plans.
7780: --
7781: PROCEDURE PULL_DANGLING_PLANS IS
7782:
7783: l_fp_wp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7784: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7785:
7786: BEGIN
7787:

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

7780: --
7781: PROCEDURE PULL_DANGLING_PLANS IS
7782:
7783: l_fp_wp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7784: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
7785:
7786: BEGIN
7787:
7788: NULL; -- Pull dangling calls bulk "create secondary private" directly.