[Home] [Help]
351: L_DEBUG_KEY CONSTANT VARCHAR2(100) := 'ahl.plsql.' || G_PKG_NAME || '.' || L_API_NAME;
352:
353: -- To find visit related information
354: CURSOR c_visit (x_id IN NUMBER) IS
355: SELECT * FROM AHL_VISITS_VL
356: WHERE VISIT_ID = x_id;
357: c_visit_rec c_visit%ROWTYPE;
358:
359: BEGIN
519: l_init_msg_list VARCHAR2(1) := 'F';
520:
521: -- To find visit related information
522: CURSOR c_visit (x_id IN NUMBER) IS
523: SELECT * FROM AHL_VISITS_VL
524: WHERE VISIT_ID = x_id;
525: c_visit_rec c_visit%ROWTYPE;
526:
527: -- To find tasks information for visit
526:
527: -- To find tasks information for visit
528: CURSOR c_task (x_id IN NUMBER) IS
529: SELECT T1.PROJECT_ID, T1.VISIT_NUMBER, T2.*
530: FROM AHL_VISITS_VL T1, AHL_VISIT_TASKS_VL T2
531: WHERE VISIT_TASK_ID = x_id
532: AND T1.VISIT_ID = T2.VISIT_ID;
533:
534: c_task_rec c_task%ROWTYPE;
859: c_task_rec c_Task%ROWTYPE;
860:
861: -- To find visit related information
862: CURSOR c_visit (x_id IN NUMBER) IS
863: SELECT * FROM AHL_VISITS_VL
864: WHERE VISIT_ID = x_id;
865: c_visit_rec c_visit%ROWTYPE;
866:
867: BEGIN
1063:
1064: -- Define local Cursors
1065: -- To find visit related information
1066: CURSOR c_visit (x_id IN NUMBER) IS
1067: SELECT * FROM AHL_VISITS_VL
1068: WHERE VISIT_ID = x_id;
1069: c_visit_rec c_visit%ROWTYPE;
1070:
1071: -- To find count for tasks for visit
1573:
1574: -- Define local Cursors
1575: -- To find visit related information
1576: CURSOR c_visit (x_id IN NUMBER) IS
1577: SELECT * FROM AHL_VISITS_VL
1578: WHERE VISIT_ID = x_id;
1579: c_visit_rec c_visit%ROWTYPE;
1580:
1581: -- To find count for tasks for visit
2029:
2030: -- Define local Cursors
2031: -- To find visit related information
2032: CURSOR c_visit (x_id IN NUMBER) IS
2033: SELECT * FROM AHL_VISITS_VL
2034: WHERE VISIT_ID = x_id;
2035: c_visit_rec c_visit%ROWTYPE;
2036:
2037: -- To find whether the visit project occurs in PJM_PROJECT_PARAMETERS table
2423:
2424: -- To find visit related information
2425: -- Added where condition for checking DELETED status in 11.5.10
2426: CURSOR c_visit (x_id IN NUMBER) IS
2427: SELECT * FROM AHL_VISITS_VL
2428: WHERE VISIT_ID = x_id
2429: AND NVL(STATUS_CODE,'X') <> 'DELETED';
2430: c_visit_rec c_visit%ROWTYPE;
2431:
3988: l_init_msg_list VARCHAR2(1) := 'F';
3989:
3990: -- To find visit related information
3991: CURSOR c_visit (x_id IN NUMBER) IS
3992: SELECT * FROM AHL_VISITS_VL
3993: WHERE VISIT_ID = x_id;
3994:
3995: c_visit_rec c_visit%ROWTYPE;
3996: c_orig_visit_rec c_visit%ROWTYPE;
5097: -- RROY
5098:
5099: -- To find visit related information
5100: CURSOR c_visit (x_id IN NUMBER) IS
5101: SELECT * FROM AHL_VISITS_VL
5102: WHERE VISIT_ID = x_id;
5103: c_visit_rec c_visit%ROWTYPE;
5104: BEGIN
5105:
6230: c_mst_wo_visit_rec c_visit_master_wo%ROWTYPE;
6231:
6232: --fetch visit details
6233: CURSOR c_visit_dtl (x_visit_id IN NUMBER) IS
6234: SELECT * FROM ahl_visits_vl
6235: WHERE visit_id = x_visit_id;
6236:
6237: c_visit_dtl_rec c_visit_dtl%ROWTYPE;
6238:
7087: l_visit_end_time DATE;
7088:
7089: -- To find visit related information
7090: CURSOR c_visit (x_id IN NUMBER) IS
7091: SELECT * FROM AHL_VISITS_VL
7092: WHERE VISIT_ID = x_id;
7093: c_visit_rec c_visit%ROWTYPE;
7094:
7095: CURSOR get_wo(c_visit_id NUMBER, c_unit_effectivity_id NUMBER) IS
7741: l_dummy VARCHAR2(1);
7742:
7743: -- To find visit related information
7744: CURSOR c_visit (x_visit_id IN NUMBER) IS
7745: SELECT * FROM AHL_VISITS_VL
7746: WHERE VISIT_ID = x_visit_id;
7747:
7748: c_visit_rec c_visit%ROWTYPE;
7749:
8198: l_init_msg_list VARCHAR2(1) := 'F';
8199:
8200: -- To find visit related information
8201: CURSOR c_visit (x_id IN NUMBER) IS
8202: SELECT * FROM AHL_VISITS_VL
8203: WHERE VISIT_ID = x_id;
8204: c_visit_rec c_visit%ROWTYPE;
8205:
8206: -- To get all the tasks for the given UE
9067: WHERE MR_ROUTE_ID = x_id;
9068:
9069: -- To find visit related information
9070: CURSOR c_visit (x_id IN NUMBER) IS
9071: SELECT * FROM AHL_VISITS_VL
9072: WHERE VISIT_ID = x_id;
9073: c_visit_rec c_visit%ROWTYPE;
9074:
9075: -- To find task related information