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_XBS_ACCUM_MAINT dependencies on PJI_FP_RMAP_FPR_UPDATE_T

Line 812: AND ROWID IN ( SELECT extr_lines_rowid FROM pji_fp_rmap_fpr_update_t)

808: CURSOR GET_MAINT_SMART_SLICE_PARAMS
809: IS SELECT DISTINCT rbs_version_id,plan_version_id,struct_ver_id
810: FROM pji_fm_extr_plan_lines
811: WHERE plan_version_id = NVL(p_plan_version_id,plan_version_id)
812: AND ROWID IN ( SELECT extr_lines_rowid FROM pji_fp_rmap_fpr_update_t)
813: ORDER BY rbs_version_id,struct_ver_id;
814:
815: l_num_rows_extr_lines NUMBER := NULL;
816: l_fp_version_ids SYSTEM.pa_num_tbl_type := SYSTEM.pa_num_tbl_type();

Line 853: INSERT INTO pji_fp_rmap_fpr_update_t (EXTR_LINES_ROWID)

849:
850: CLEANUP_TEMP_TABLES;
851:
852: IF (p_plan_version_id IS NULL) THEN
853: INSERT INTO pji_fp_rmap_fpr_update_t (EXTR_LINES_ROWID)
854: SELECT ROWID FROM pji_fm_extr_plan_lines;
855: ELSE
856: INSERT INTO pji_fp_rmap_fpr_update_t (EXTR_LINES_ROWID)
857: SELECT ROWID FROM pji_fm_extr_plan_lines

Line 856: INSERT INTO pji_fp_rmap_fpr_update_t (EXTR_LINES_ROWID)

852: IF (p_plan_version_id IS NULL) THEN
853: INSERT INTO pji_fp_rmap_fpr_update_t (EXTR_LINES_ROWID)
854: SELECT ROWID FROM pji_fm_extr_plan_lines;
855: ELSE
856: INSERT INTO pji_fp_rmap_fpr_update_t (EXTR_LINES_ROWID)
857: SELECT ROWID FROM pji_fm_extr_plan_lines
858: WHERE plan_version_id = p_plan_version_id;
859: END IF;
860:

Line 938: in maintain_smart_slice which nulls out pji_fp_rmap_fpr_update_t */

934: , x_return_status => x_return_status ) ;
935: end */
936: /* We get the list of rbs_version,wbs_version and plan_version for which smart slice needs to be created.
937: The PJI_FM_EXTR_PLAN_LINES needs to be deleted before calling maintain_smart_slice as there is a commit
938: in maintain_smart_slice which nulls out pji_fp_rmap_fpr_update_t */
939: /* commenting as the incremental smart slice will be created */
940: /*start
941: OPEN GET_MAINT_SMART_SLICE_PARAMS;
942:

Line 952: AND ROWID IN ( SELECT extr_lines_rowid FROM pji_fp_rmap_fpr_update_t)

948:
949:
950: DELETE FROM PJI_FM_EXTR_PLAN_LINES
951: WHERE 1 = 1
952: AND ROWID IN ( SELECT extr_lines_rowid FROM pji_fp_rmap_fpr_update_t)
953: AND TXN_CURRENCY_CODE IS NOT NULL
954: AND prj_currency_code IS NOT NULL
955: AND pfc_currency_code IS NOT NULL;
956:

Line 1282: INSERT INTO pji_fp_rmap_fpr_update_t (EXTR_LINES_ROWID)

1278: IF (p_plan_version_id IS NULL) THEN
1279: print_time ( 'PLAN_UPDATE_PVT_ACT_ETC 1 plan version id is null.. returning ' );
1280: RETURN;
1281: ELSE
1282: INSERT INTO pji_fp_rmap_fpr_update_t (EXTR_LINES_ROWID)
1283: SELECT ROWID FROM pji_fm_extr_plan_lines
1284: WHERE plan_version_id = p_plan_version_id;
1285: END IF;
1286:

Line 1300: FROM pji_fp_rmap_fpr_update_t

1296: print_time ( 'PLAN_UPDATE_PVT_ACT_ETC 1 number of rows in plan lines is .. ' || l_temp);
1297:
1298: SELECT COUNT(1)
1299: INTO l_num_rows_extr_lines
1300: FROM pji_fp_rmap_fpr_update_t
1301: WHERE ROWNUM=1; /*Added for bug 3928020*/
1302:
1303: print_time ( 'PLAN_UPDATE_PVT_ACT_ETC 1.5 number of rows in rowid table is.. ' || l_num_rows_extr_lines );
1304:

Line 1380: AND ROWID IN ( SELECT extr_lines_rowid FROM pji_fp_rmap_fpr_update_t)

1376: debug_plan_lines ; /* bug#3993830 */
1377:
1378: DELETE FROM PJI_FM_EXTR_PLAN_LINES
1379: WHERE 1 = 1
1380: AND ROWID IN ( SELECT extr_lines_rowid FROM pji_fp_rmap_fpr_update_t)
1381: AND TXN_CURRENCY_CODE IS NOT NULL
1382: AND prj_currency_code IS NOT NULL
1383: AND pfc_currency_code IS NOT NULL;
1384:

Line 3330: FROM pji_fp_rmap_fpr_update_t)

3326: SELECT project_id
3327: FROM pji_fm_extr_plan_lines
3328: WHERE ROWID IN
3329: ( SELECT extr_lines_rowid
3330: FROM pji_fp_rmap_fpr_update_t)
3331: FOR UPDATE NOWAIT;
3332:
3333: BEGIN
3334:

Line 3400: FROM pji_fp_rmap_fpr_update_t);

3396: SELECT DISTINCT plan_version_id
3397: FROM PJI_FM_EXTR_PLAN_LINES
3398: WHERE ROWID IN
3399: ( SELECT extr_lines_rowid
3400: FROM pji_fp_rmap_fpr_update_t);
3401:
3402: BEGIN
3403:
3404: Pji_Pjp_Fp_Curr_Wrap.INIT_ERR_STACK

Line 7018: DELETE FROM pji_fp_rmap_fpr_update_t;

7014: , x_return_status => l_return_status );
7015:
7016: DELETE FROM pji_fp_aggr_pjp1_t;
7017: DELETE FROM PJI_FM_EXTR_PLNVER3_T;
7018: DELETE FROM pji_fp_rmap_fpr_update_t;
7019: EXCEPTION
7020: WHEN OTHERS THEN
7021: Pji_Pjp_Fp_Curr_Wrap.EXCP_HANDLER
7022: ( p_package_name => g_package_name