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 92: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

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

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

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

Line 99: l_dest_plan_type_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

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

Line 100: l_dest_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

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

Line 103: l_src_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

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

Line 352: p_source_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

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

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

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

Line 359: l_dest_plan_type_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

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

Line 360: l_dest_project_ids SYSTEM.pa_num_tbl_type := pji_empty_num_tbl;

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

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

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

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

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

Line 1053: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

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

Line 1389: l_plan_version_id SYSTEM.pa_num_tbl_type;

1385: l_count NUMBER;
1386: l_max_plnver_id NUMBER := NULL;
1387: /*l_per_analysis_flag varchar2(2); /* Added for bug 8708651
1388: Commented for bug 9048716 */
1389: l_plan_version_id SYSTEM.pa_num_tbl_type;
1390: l_resource_list_id SYSTEM.pa_num_tbl_type;
1391:
1392: CURSOR res_list IS
1393: SELECT /*+ ordered */ b.plan_version_id, decode(b.plan_type_code, 'C', a.cost_resource_list_id,

Line 1390: l_resource_list_id SYSTEM.pa_num_tbl_type;

1386: l_max_plnver_id NUMBER := NULL;
1387: /*l_per_analysis_flag varchar2(2); /* Added for bug 8708651
1388: Commented for bug 9048716 */
1389: l_plan_version_id SYSTEM.pa_num_tbl_type;
1390: l_resource_list_id SYSTEM.pa_num_tbl_type;
1391:
1392: CURSOR res_list IS
1393: SELECT /*+ ordered */ b.plan_version_id, decode(b.plan_type_code, 'C', a.cost_resource_list_id,
1394: 'R', a.revenue_resource_list_id,

Line 4294: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl

4290: END;
4291:
4292:
4293: PROCEDURE GET_PRI_SLICE_DATA(
4294: p_fp_version_ids IN SYSTEM.pa_num_tbl_type := pji_empty_num_tbl
4295: , p_commit IN VARCHAR2 := 'F') IS
4296: BEGIN
4297:
4298: FORALL I IN p_fp_version_ids.FIRST..p_fp_version_ids.LAST

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

8452: -- for dangling baselined financial plans.
8453: --
8454: PROCEDURE PULL_DANGLING_PLANS IS
8455:
8456: l_fp_wp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8457: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8458:
8459: /*
8460: CURSOR c_dangling_vers_cur IS

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

8453: --
8454: PROCEDURE PULL_DANGLING_PLANS IS
8455:
8456: l_fp_wp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8457: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();
8458:
8459: /*
8460: CURSOR c_dangling_vers_cur IS
8461: SELECT budget_version_id

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

8469:
8470: -- FOR c_dangling IN c_dangling_vers_cur LOOP
8471:
8472: -- print_time ( ' plan version id is ... ' || c_dangling.budget_version_id ) ;
8473: -- l_fp_wp_version_ids := SYSTEM.pa_num_tbl_type (c_dangling.budget_version_id);
8474:
8475: PJI_FM_PLAN_MAINT.CREATE_SECONDARY_T_PVT(
8476: p_fp_version_ids => l_fp_wp_version_ids
8477: , p_process_all => 'T'