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 dependencies on PJI_PJP_WBS_HEADER

Line 1134: SELECT /+ index(wbs_hdr PJI_PJP_WBS_HEADER_N1) / project_id,wbs_version_id, wp_flag

1130: l_wp_flags.EXTEND(p_fp_version_ids.COUNT);
1131:
1132: FOR i IN 1..p_fp_version_ids.COUNT LOOP
1133: BEGIN --bug#4100852
1134: SELECT /*+ index(wbs_hdr PJI_PJP_WBS_HEADER_N1) */ project_id,wbs_version_id, wp_flag
1135: INTO l_project_ids(i),l_wbs_version_ids(i),l_wp_flags(i)
1136: FROM PJI_PJP_WBS_HEADER wbs_hdr
1137: WHERE plan_version_id = p_fp_version_ids(i);
1138:

Line 1136: FROM PJI_PJP_WBS_HEADER wbs_hdr

1132: FOR i IN 1..p_fp_version_ids.COUNT LOOP
1133: BEGIN --bug#4100852
1134: SELECT /*+ index(wbs_hdr PJI_PJP_WBS_HEADER_N1) */ project_id,wbs_version_id, wp_flag
1135: INTO l_project_ids(i),l_wbs_version_ids(i),l_wp_flags(i)
1136: FROM PJI_PJP_WBS_HEADER wbs_hdr
1137: WHERE plan_version_id = p_fp_version_ids(i);
1138:
1139: print_time ( ' i = ' || i || ' p_fp_version_ids(i) = ' || p_fp_version_ids(i) || ' l_project_ids(i) ' || l_project_ids(i)
1140: ||' l_wbs_version_id(i)= '||l_wbs_version_ids(i) ||' l_wp_flag(i) = '||l_wp_flags(i) );

Line 1162: DELETE FROM PJI_PJP_WBS_HEADER

1158:
1159: print_time ( 'deleted from fact. # rows = ' || SQL%ROWCOUNT ) ;
1160:
1161: FORALL i IN 1..p_fp_version_ids.COUNT
1162: DELETE FROM PJI_PJP_WBS_HEADER
1163: WHERE plan_version_id = p_fp_version_ids(i)
1164: AND project_id = l_project_ids(i);
1165:
1166: print_time ( 'deleted from wbs hdr table. # rows = ' || SQL%ROWCOUNT ) ;

Line 1363: SELECT /+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) /

1359: print_time('plan version id.. ' || p_fp_version_ids(i) );
1360:
1361: BEGIN
1362:
1363: SELECT /*+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) */
1364: DISTINCT PROJECT_ID
1365: INTO l_project_id
1366: FROM pji_pjp_wbs_header wbs_hdr
1367: WHERE plan_version_id = p_fp_version_ids(i);

Line 1366: FROM pji_pjp_wbs_header wbs_hdr

1362:
1363: SELECT /*+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) */
1364: DISTINCT PROJECT_ID
1365: INTO l_project_id
1366: FROM pji_pjp_wbs_header wbs_hdr
1367: WHERE plan_version_id = p_fp_version_ids(i);
1368:
1369: IF (p_is_primary_rbs = 'T') THEN
1370: RAISE excp_plan_already_summarized;