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_VISITS_PVT

Line 4479: SELECT AHL_VISITS_VL.*,AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT FROM AHL_VISITS_VL

4475: -- To find visit related information
4476: -- Added where condition for checking DELETED status in 11.5.10
4477: -- PRAKKUM :: VWPE: ER:12673125 :: 23-JUN-2011 :: Upgrade Changes
4478: CURSOR c_visit (x_id IN NUMBER) IS
4479: SELECT AHL_VISITS_VL.*,AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT FROM AHL_VISITS_VL
4480: WHERE VISIT_ID = x_id
4481: AND NVL(STATUS_CODE,'X') <> 'DELETED';
4482: c_visit_rec c_visit%ROWTYPE;
4483:

Line 6128: SELECT AHL_VISITS_VL.*, AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT FROM AHL_VISITS_VL

6124:
6125:
6126: -- To find visit related information
6127: CURSOR c_visit (x_id IN NUMBER) IS
6128: SELECT AHL_VISITS_VL.*, AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT FROM AHL_VISITS_VL
6129: WHERE VISIT_ID = x_id;
6130:
6131: c_visit_rec c_visit%ROWTYPE;
6132: c_orig_visit_rec c_visit%ROWTYPE;

Line 7596: IF AHL_VWP_VISITS_PVT.Is_Old_Visit(p_visit_id) = 'N' THEN -- PRAKKUM :: VWPE: ER:12856858 :: 10-AUG-2011 :: Upgrade Changes

7592:
7593: -- TCHIMIRA :: 28-JUN-2011 :: VWP: ER:12673125 :: START
7594: -- We need to delete materials of default stage task when a visit is P2Ped
7595: IF ( p_module_type <> 'CST' ) THEN
7596: IF AHL_VWP_VISITS_PVT.Is_Old_Visit(p_visit_id) = 'N' THEN -- PRAKKUM :: VWPE: ER:12856858 :: 10-AUG-2011 :: Upgrade Changes
7597: IF (l_log_statement >= l_log_current_level) THEN
7598: fnd_log.string(l_log_statement,
7599: L_DEBUG_KEY,
7600: 'Before calling AHL_LTP_REQST_MATRL_PVT.Delete_Default_Stage_Materials');

Line 9261: SELECT ahl_visits_vl.*,AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT FROM ahl_visits_vl

9257: c_mst_wo_visit_rec c_visit_master_wo%ROWTYPE;
9258:
9259: --fetch visit details
9260: CURSOR c_visit_dtl (x_visit_id IN NUMBER) IS
9261: SELECT ahl_visits_vl.*,AHL_VWP_VISITS_PVT.Is_Old_Visit(VISIT_ID) IS_OLD_VISIT FROM ahl_visits_vl
9262: WHERE visit_id = x_visit_id;
9263:
9264: c_visit_dtl_rec c_visit_dtl%ROWTYPE;
9265:

Line 14682: select AHL_VWP_VISITS_PVT.Is_Old_Visit(p_visit_id) IS_OLD_VISIT FROM DUAL;

14678: l_has_pre_in_planning VARCHAR2(1);
14679:
14680: -- PRAKKUM :: VWPE: ER:12673125 :: 23-JUN-2011 :: Upgrade Changes - To find visit is old or new
14681: CURSOR c_is_old_visit(p_visit_id IN NUMBER) IS
14682: select AHL_VWP_VISITS_PVT.Is_Old_Visit(p_visit_id) IS_OLD_VISIT FROM DUAL;
14683:
14684: l_is_old_visit_dets c_is_old_visit%RowType;
14685:
14686: l_max_schedule_start_date DATE; --BUG 13373947 :: PRAKKUM :: 10/02/2012