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 1098: SELECT /+ index(wbs_hdr PJI_PJP_WBS_HEADER_N1) / project_id,wbs_version_id, wp_flag

1094: l_wp_flags.EXTEND(p_fp_version_ids.COUNT);
1095:
1096: FOR i IN 1..p_fp_version_ids.COUNT LOOP
1097: BEGIN --bug#4100852
1098: SELECT /*+ index(wbs_hdr PJI_PJP_WBS_HEADER_N1) */ project_id,wbs_version_id, wp_flag
1099: INTO l_project_ids(i),l_wbs_version_ids(i),l_wp_flags(i)
1100: FROM PJI_PJP_WBS_HEADER wbs_hdr
1101: WHERE plan_version_id = p_fp_version_ids(i);
1102:

Line 1100: FROM PJI_PJP_WBS_HEADER wbs_hdr

1096: FOR i IN 1..p_fp_version_ids.COUNT LOOP
1097: BEGIN --bug#4100852
1098: SELECT /*+ index(wbs_hdr PJI_PJP_WBS_HEADER_N1) */ project_id,wbs_version_id, wp_flag
1099: INTO l_project_ids(i),l_wbs_version_ids(i),l_wp_flags(i)
1100: FROM PJI_PJP_WBS_HEADER wbs_hdr
1101: WHERE plan_version_id = p_fp_version_ids(i);
1102:
1103: print_time ( ' i = ' || i || ' p_fp_version_ids(i) = ' || p_fp_version_ids(i) || ' l_project_ids(i) ' || l_project_ids(i)
1104: ||' l_wbs_version_id(i)= '||l_wbs_version_ids(i) ||' l_wp_flag(i) = '||l_wp_flags(i) );

Line 1119: DELETE FROM PJI_PJP_WBS_HEADER

1115:
1116: print_time ( 'deleted from fact. # rows = ' || SQL%ROWCOUNT ) ;
1117:
1118: FORALL i IN 1..p_fp_version_ids.COUNT
1119: DELETE FROM PJI_PJP_WBS_HEADER
1120: WHERE plan_version_id = p_fp_version_ids(i)
1121: AND project_id = l_project_ids(i);
1122:
1123: print_time ( 'deleted from wbs hdr table. # rows = ' || SQL%ROWCOUNT ) ;

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

1306: print_time('plan version id.. ' || p_fp_version_ids(i) );
1307:
1308: BEGIN
1309:
1310: SELECT /*+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) */
1311: DISTINCT PROJECT_ID
1312: INTO l_project_id
1313: FROM pji_pjp_wbs_header wbs_hdr
1314: WHERE plan_version_id = p_fp_version_ids(i);

Line 1313: FROM pji_pjp_wbs_header wbs_hdr

1309:
1310: SELECT /*+ index_ffs(wbs_hdr PJI_PJP_WBS_HEADER_N1) */
1311: DISTINCT PROJECT_ID
1312: INTO l_project_id
1313: FROM pji_pjp_wbs_header wbs_hdr
1314: WHERE plan_version_id = p_fp_version_ids(i);
1315:
1316: IF (p_is_primary_rbs = 'T') THEN
1317: RAISE excp_plan_already_summarized;