eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PJI_FM_PLAN_MAINT_T_PVT dependencies on PA_NUM_TBL_TYPE

Line 90: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

86: ------------------------------------------------------------------
87:
88: PROCEDURE COPY_PRIMARY
89: (
90: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
91: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
92: , p_source_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
93: , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
94: , p_commit IN VARCHAR2 := 'F'

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

87:
88: PROCEDURE COPY_PRIMARY
89: (
90: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
91: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
92: , p_source_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
93: , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
94: , p_commit IN VARCHAR2 := 'F'
95: ) IS

Line 97: l_dest_plan_type_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

93: , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
94: , p_commit IN VARCHAR2 := 'F'
95: ) IS
96:
97: l_dest_plan_type_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
98: l_dest_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
99: l_src_count NUMBER;
100: l_dest_count NUMBER;
101: l_src_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

Line 98: l_dest_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

94: , p_commit IN VARCHAR2 := 'F'
95: ) IS
96:
97: l_dest_plan_type_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
98: l_dest_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
99: l_src_count NUMBER;
100: l_dest_count NUMBER;
101: l_src_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
102:

Line 101: l_src_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

97: l_dest_plan_type_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
98: l_dest_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
99: l_src_count NUMBER;
100: l_dest_count NUMBER;
101: l_src_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
102:
103: BEGIN
104:
105: l_src_count := p_source_fp_version_ids.COUNT;

Line 350: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

346:
347:
348: PROCEDURE COPY_PLANS
349: (
350: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
351: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
352: , p_source_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
353: , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
354: , p_commit IN VARCHAR2 := 'F'

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

347:
348: PROCEDURE COPY_PLANS
349: (
350: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
351: , p_dest_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
352: , p_source_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
353: , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
354: , p_commit IN VARCHAR2 := 'F'
355: ) IS

Line 357: l_dest_plan_type_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

353: , p_dest_fp_version_status IN SYSTEM.pa_VARCHAR2_30_tbl_type := pji_empty_VARCHAR2_30_tbl
354: , p_commit IN VARCHAR2 := 'F'
355: ) IS
356:
357: l_dest_plan_type_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
358: l_dest_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
359: l_src_count NUMBER;
360: l_dest_count NUMBER;
361:

Line 358: l_dest_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

354: , p_commit IN VARCHAR2 := 'F'
355: ) IS
356:
357: l_dest_plan_type_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
358: l_dest_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;
359: l_src_count NUMBER;
360: l_dest_count NUMBER;
361:
362: BEGIN

Line 596: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

592: p_source_plan_ver_id IN NUMBER := NULL
593: , p_target_plan_ver_id IN NUMBER := NULL
594: , p_commit IN VARCHAR2 := 'F') IS
595:
596: l_dest_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
597:
598: l_dest_plan_type_id NUMBER := NULL;
599: l_dest_project_id NUMBER := NULL;
600:

Line 780: l_dest_fp_version_ids := SYSTEM.pa_num_tbl_type(p_target_plan_ver_id);

776:
777: print_time ( ' COPY_PRIMARY_SINGLE api 002 ' );
778:
779:
780: l_dest_fp_version_ids := SYSTEM.pa_num_tbl_type(p_target_plan_ver_id);
781:
782: EXTRACT_FIN_PLAN_VERSIONS(
783: p_fp_version_ids => l_dest_fp_version_ids
784: , p_slice_type => 'PRI'

Line 1051: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

1047: -- This is to set scope for extraction as well as track time/curr dangling records
1048: -- in the case of secondary slice creation.
1049: --
1050: PROCEDURE EXTRACT_FIN_PLAN_VERSIONS(
1051: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
1052: , p_slice_type IN VARCHAR2 := NULL -- 'PRI' or 'SEC' or 'SECRBS'
1053: ) IS
1054: l_count NUMBER;
1055: BEGIN

Line 4207: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

4203: END;
4204:
4205:
4206: PROCEDURE GET_PRI_SLICE_DATA(
4207: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
4208: , p_commit IN VARCHAR2 := 'F') IS
4209: BEGIN
4210:
4211: FORALL I IN p_fp_version_ids.FIRST..p_fp_version_ids.LAST

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

8304: -- for dangling baselined financial plans.
8305: --
8306: PROCEDURE PULL_DANGLING_PLANS IS
8307:
8308: l_fp_wp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8309: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8310:
8311: /*
8312: CURSOR c_dangling_vers_cur IS

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

8305: --
8306: PROCEDURE PULL_DANGLING_PLANS IS
8307:
8308: l_fp_wp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8309: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8310:
8311: /*
8312: CURSOR c_dangling_vers_cur IS
8313: SELECT budget_version_id

Line 8325: -- l_fp_wp_version_ids := SYSTEM.pa_num_tbl_type (c_dangling.budget_version_id);

8321:
8322: -- FOR c_dangling IN c_dangling_vers_cur LOOP
8323:
8324: -- print_time ( ' plan version id is ... ' || c_dangling.budget_version_id ) ;
8325: -- l_fp_wp_version_ids := SYSTEM.pa_num_tbl_type (c_dangling.budget_version_id);
8326:
8327: PJI_FM_PLAN_MAINT.CREATE_SECONDARY_T_PVT(
8328: p_fp_version_ids => l_fp_wp_version_ids
8329: , p_process_all => 'T'