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.AHL_VWP_PROJ_PROD_PVT dependencies on AHL_VWP_STAGES_B

Line 6280: FROM ahl_visit_tasks_b task, ahl_vwp_stages_b stage, ahl_workorders wo

6276: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063
6277: -- Get all the planning stages' tasks and duplicate tasks of the visit
6278: CURSOR get_visit_tasks_to_cancel (c_visit_id IN NUMBER) IS
6279: SELECT wo.workorder_id, stage.stage_id, task.task_type_code
6280: FROM ahl_visit_tasks_b task, ahl_vwp_stages_b stage, ahl_workorders wo
6281: WHERE task.visit_id = c_visit_id
6282: AND task.stage_id = stage.stage_id(+)
6283: -- do not select the default stage task
6284: AND ((task.task_type_code = 'STAGE' AND task.stage_id IS NOT NULL)

Line 7434: UPDATE AHL_VWP_STAGES_B

7430: IF (fnd_log.level_statement >= fnd_log.g_current_runtime_level) THEN
7431: fnd_log.string(fnd_log.level_statement,L_DEBUG_KEY,' c_visit_rec.IS_OLD_VISIT= '||c_visit_rec.IS_OLD_VISIT);
7432: END IF;
7433: IF c_visit_rec.IS_OLD_VISIT <> 'Y' THEN -- VWPE 12730539:: PRAKKUM :: 15-JUL-2011
7434: UPDATE AHL_VWP_STAGES_B
7435: SET STAGE_STATUS_CODE = 'RELEASED',
7436: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
7437: LAST_UPDATE_DATE = SYSDATE,
7438: LAST_UPDATED_BY = Fnd_Global.USER_ID,

Line 9418: FROM ahl_vwp_stages_b stage

9414: -- SKPATHAK :: 02-MAY-2011 :: VWPE: ER:12424063
9415: -- Get the stage id of the visit stages that are in planning and some of their tasks are released
9416: CURSOR get_stage_id (c_visit_id IN NUMBER) IS
9417: SELECT stage.stage_id
9418: FROM ahl_vwp_stages_b stage
9419: WHERE stage.visit_id = c_visit_id
9420: AND EXISTS (SELECT 1
9421: FROM ahl_visit_tasks_b task
9422: WHERE stage.stage_id = task.stage_id

Line 10117: UPDATE ahl_vwp_stages_b

10113: L_DEBUG_KEY,'c_visit_dtl_rec.IS_OLD_VISIT = ' || c_visit_dtl_rec.IS_OLD_VISIT );
10114: END IF;
10115: IF c_visit_dtl_rec.IS_OLD_VISIT<>'Y' THEN --VWPE 12730539:: PRAKKUM :: 15-JUL-2011
10116: FOR l_stage_rec IN get_stage_id (p_visit_id) LOOP
10117: UPDATE ahl_vwp_stages_b
10118: SET stage_status_code = 'PARTIALLY RELEASED',
10119: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
10120: LAST_UPDATE_DATE = SYSDATE,
10121: LAST_UPDATED_BY = Fnd_Global.USER_ID,

Line 15173: UPDATE ahl_vwp_stages_b

15169:
15170: --Now update the stage status to released
15171: FOR i in p_stages_tbl.FIRST..p_stages_tbl.LAST LOOP --for stages
15172:
15173: UPDATE ahl_vwp_stages_b
15174: SET STAGE_STATUS_CODE = 'RELEASED',
15175: OBJECT_VERSION_NUMBER = OBJECT_VERSION_NUMBER + 1,
15176: LAST_UPDATE_DATE = SYSDATE,
15177: LAST_UPDATED_BY = Fnd_Global.USER_ID,

Line 15423: WHERE EXISTS (SELECT 'X' FROM ahl_vwp_stages_b WHERE stage_id = link.object_id and stage_status_code = 'PLANNING')

15419: -- Get the passed stage child id and all its successive child stages
15420: CURSOR c_get_child_stages(p_subject_id IN NUMBER)
15421: IS
15422: SELECT 'X' FROM ahl_stage_links link
15423: WHERE EXISTS (SELECT 'X' FROM ahl_vwp_stages_b WHERE stage_id = link.object_id and stage_status_code = 'PLANNING')
15424: START WITH link.subject_id = p_subject_id
15425: CONNECT BY PRIOR link.object_id = link.subject_id;
15426: l_dummy VARCHAR2(1);
15427: