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 774: /* DELETE FROM pji_rollup_level_status

770: END IF;
771:
772: IF (p_online_flag = 'Y') THEN
773:
774: /* DELETE FROM pji_rollup_level_status
775: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver3_t);
776: Bug No .4538102*/
777:
778: DELETE FROM pji_rollup_level_status

Line 778: DELETE FROM pji_rollup_level_status

774: /* DELETE FROM pji_rollup_level_status
775: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver3_t);
776: Bug No .4538102*/
777:
778: DELETE FROM pji_rollup_level_status
779: WHERE (project_id,plan_version_id,plan_type_code) IN
780: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver3_t); /*4771527 */
781:
782: IF (SQL%ROWCOUNT > 0) THEN

Line 807: /* DELETE FROM pji_rollup_level_status

803: END IF;
804:
805: ELSIF (p_online_flag = 'N') THEN
806:
807: /* DELETE FROM pji_rollup_level_status
808: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver4);
809: Bug No. 4538102*/
810: DELETE FROM pji_rollup_level_status
811: WHERE (project_id,plan_version_id,plan_type_code ) IN

Line 810: DELETE FROM pji_rollup_level_status

806:
807: /* DELETE FROM pji_rollup_level_status
808: WHERE plan_version_id IN (SELECT plan_version_id FROM pji_fm_extr_plnver4);
809: Bug No. 4538102*/
810: DELETE FROM pji_rollup_level_status
811: WHERE (project_id,plan_version_id,plan_type_code ) IN
812: (SELECT project_id,plan_version_id,plan_type_code FROM pji_fm_extr_plnver4); /*4771527 */
813:
814: IF (SQL%ROWCOUNT > 0) THEN

Line 5600: FROM pji_rollup_level_status rst

5596: BEGIN
5597:
5598: SELECT 'Y' -- , 'Y'
5599: INTO l_exists -- , l_rollup_status_exists
5600: FROM pji_rollup_level_status rst
5601: WHERE rst.RBS_VERSION_ID = l_rbs_version_id_tbl(k) AND
5602: rst.PLAN_VERSION_ID = l_prg_plan_version_id_tbl(i) AND
5603: rst.PLAN_TYPE_CODE = l_prg_plan_type_code_tbl(i) AND
5604: rst.project_id = l_prg_project_id_tbl(i);

Line 5632: INSERT INTO pji_rollup_level_status (

5628: end if;
5629: l_count := l_count + 1;
5630:
5631: --Populate rollup level status table
5632: INSERT INTO pji_rollup_level_status (
5633: PROJECT_ID,
5634: RBS_VERSION_ID,
5635: PLAN_VERSION_ID,
5636: WBS_ELEMENT_ID,