[Home] [Help]
908: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
909:
910: -- To find visit related information
911: CURSOR c_visit (x_id IN NUMBER) IS
912: SELECT * FROM AHL_VISITS_VL
913: WHERE VISIT_ID = x_id;
914: c_visit_rec c_visit%ROWTYPE;
915:
916: BEGIN
1079: l_init_msg_list VARCHAR2(1) := 'F';
1080:
1081: -- To find visit related information
1082: CURSOR c_visit (x_id IN NUMBER) IS
1083: SELECT * FROM AHL_VISITS_VL
1084: WHERE VISIT_ID = x_id;
1085: c_visit_rec c_visit%ROWTYPE;
1086:
1087: -- To find tasks information for visit
1086:
1087: -- To find tasks information for visit
1088: CURSOR c_task (x_id IN NUMBER) IS
1089: SELECT T1.PROJECT_ID, T1.VISIT_NUMBER, T2.*
1090: FROM AHL_VISITS_VL T1, AHL_VISIT_TASKS_VL T2
1091: WHERE VISIT_TASK_ID = x_id
1092: AND T1.VISIT_ID = T2.VISIT_ID;
1093:
1094: c_task_rec c_task%ROWTYPE;
1426: c_task_rec c_Task%ROWTYPE;
1427:
1428: -- To find visit related information
1429: CURSOR c_visit (x_id IN NUMBER) IS
1430: SELECT * FROM AHL_VISITS_VL
1431: WHERE VISIT_ID = x_id;
1432: c_visit_rec c_visit%ROWTYPE;
1433:
1434: --VWPE: ER:12424063 :: SKPATHAK :: 07-JUN-2012
1739:
1740: -- Define local Cursors
1741: -- To find visit related information
1742: CURSOR c_visit (x_id IN NUMBER) IS
1743: SELECT * FROM AHL_VISITS_VL
1744: WHERE VISIT_ID = x_id;
1745: c_visit_rec c_visit%ROWTYPE;
1746:
1747: -- To find count for tasks for visit
2483:
2484: -- Define local Cursors
2485: -- To find visit related information
2486: CURSOR c_visit (x_id IN NUMBER) IS
2487: SELECT * FROM AHL_VISITS_VL
2488: WHERE VISIT_ID = x_id;
2489: c_visit_rec c_visit%ROWTYPE;
2490:
2491: -- To find count for tasks for visit
3874:
3875: -- Define local Cursors
3876: -- To find visit related information
3877: CURSOR c_visit (x_id IN NUMBER) IS
3878: SELECT * FROM AHL_VISITS_VL
3879: WHERE VISIT_ID = x_id;
3880: c_visit_rec c_visit%ROWTYPE;
3881:
3882: -- To find whether the visit project occurs in PJM_PROJECT_PARAMETERS table
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:
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;
7764: --salogan::Modified the cursor to handle both request id from P2P and Cost Estimation CP ER 9299910::01-JUN-2009::END
7765:
7766: -- To find visit related information
7767: CURSOR c_visit (x_id IN NUMBER) IS
7768: SELECT * FROM AHL_VISITS_VL
7769: WHERE VISIT_ID = x_id
7770: -- TCHIMIRA :: Bug 8594339 :: 19-NOV-2009
7771: -- Lock the visit record
7772: FOR UPDATE OF OBJECT_VERSION_NUMBER;
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:
10408: l_visit_end_time DATE;
10409:
10410: -- To find visit related information
10411: CURSOR c_visit (x_id IN NUMBER) IS
10412: SELECT * FROM AHL_VISITS_VL
10413: WHERE VISIT_ID = x_id;
10414: c_visit_rec c_visit%ROWTYPE;
10415:
10416: CURSOR get_wo(c_visit_id NUMBER, c_unit_effectivity_id NUMBER) IS
11142: --l_temp_msg_count NUMBER:=0; -- Added by skpathak for bug #9445455 fix
11143:
11144: -- To find visit related information
11145: CURSOR c_visit (x_visit_id IN NUMBER) IS
11146: SELECT * FROM AHL_VISITS_VL
11147: WHERE VISIT_ID = x_visit_id;
11148:
11149: c_visit_rec c_visit%ROWTYPE;
11150:
11808: l_init_msg_list VARCHAR2(1) := 'F';
11809:
11810: -- To find visit related information
11811: CURSOR c_visit (x_id IN NUMBER) IS
11812: SELECT * FROM AHL_VISITS_VL
11813: WHERE VISIT_ID = x_id;
11814: c_visit_rec c_visit%ROWTYPE;
11815:
11816: -- To get all the tasks for the given UE
13036: WHERE MR_ROUTE_ID = x_id;
13037:
13038: -- To find visit related information
13039: CURSOR c_visit (x_id IN NUMBER) IS
13040: SELECT * FROM AHL_VISITS_VL
13041: WHERE VISIT_ID = x_id;
13042: c_visit_rec c_visit%ROWTYPE;
13043:
13044: -- To find task related information
14515: l_mst_wo_visit_rec c_visit_master_wo%ROWTYPE;
14516:
14517: --fetch visit details
14518: CURSOR c_visit_dtl (c_visit_id IN NUMBER) IS
14519: SELECT * FROM ahl_visits_vl
14520: WHERE visit_id = c_visit_id;
14521:
14522: l_visit_dtl_rec c_visit_dtl%ROWTYPE;
14523: