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_ROLLUP_LEVEL_STATUS

Line 1052: /* DELETE FROM pji_rollup_level_status

1048: END IF;
1049:
1050: IF (p_online_flag = 'Y') THEN
1051:
1052: /* DELETE FROM pji_rollup_level_status
1053: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver3_t);
1054: Bug No .4538102*/
1055:
1056: DELETE FROM pji_rollup_level_status

Line 1056: DELETE FROM pji_rollup_level_status

1052: /* DELETE FROM pji_rollup_level_status
1053: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver3_t);
1054: Bug No .4538102*/
1055:
1056: DELETE FROM pji_rollup_level_status
1057: WHERE (project_id,plan_version_id,plan_type_code) IN
1058: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t); /*4771527 */
1059:
1060: IF (SQL%ROWCOUNT > 0) THEN

Line 1085: /* DELETE FROM pji_rollup_level_status

1081: END IF;
1082:
1083: ELSIF (p_online_flag = 'N') THEN
1084:
1085: /* DELETE FROM pji_rollup_level_status
1086: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver4);
1087: Bug No. 4538102*/
1088: DELETE FROM pji_rollup_level_status
1089: WHERE (project_id,plan_version_id,plan_type_code ) IN

Line 1088: DELETE FROM pji_rollup_level_status

1084:
1085: /* DELETE FROM pji_rollup_level_status
1086: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver4);
1087: Bug No. 4538102*/
1088: DELETE FROM pji_rollup_level_status
1089: WHERE (project_id,plan_version_id,plan_type_code ) IN
1090: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver4); /*4771527 */
1091:
1092: IF (SQL%ROWCOUNT > 0) THEN

Line 6120: FROM pji_rollup_level_status rst

6116: BEGIN
6117:
6118: SELECT 'Y' -- , 'Y'
6119: INTO l_exists -- , l_rollup_status_exists
6120: FROM pji_rollup_level_status rst
6121: WHERE rst.RBS_VERSION_ID = l_rbs_version_id_tbl(k) AND
6122: rst.PLAN_VERSION_ID = l_prg_plan_version_id_tbl(i) AND
6123: rst.PLAN_TYPE_CODE = l_prg_plan_type_code_tbl(i) AND
6124: rst.project_id = l_prg_project_id_tbl(i);

Line 6152: INSERT INTO pji_rollup_level_status (

6148: end if;
6149: l_count := l_count + 1;
6150:
6151: --Populate rollup level status table
6152: INSERT INTO pji_rollup_level_status (
6153: PROJECT_ID,
6154: RBS_VERSION_ID,
6155: PLAN_VERSION_ID,
6156: WBS_ELEMENT_ID,