[Home] [Help]
446:
447: -- Define local cursors
448: -- To find visit related information
449: CURSOR c_visit (x_id IN NUMBER) IS
450: SELECT * FROM AHL_VISITS_VL
451: WHERE VISIT_ID = x_id;
452: c_visit_rec c_visit%ROWTYPE;
453:
454: -- To find task related information when its for a visit
700: ORIGTSK.VISIT_TASK_NAME ORIGINATING_TASK_NAME,
701: to_number(null) MR_ID,
702: ATSK.UNIT_EFFECTIVITY_ID UNIT_EFFECTIVITY_ID,
703: to_char(NULL) MR_DESCRIPTION
704: FROM AHL_VISITS_VL AVTS,
705: AHL_VISIT_TASKS_VL ATSK,
706: AHL_VISIT_TASKS_VL ORIGTSK,
707: CSI_ITEM_INSTANCES CSIS,
708: CS_INCIDENTS_ALL_B SR,
736:
737: -- To find all task related information which is not in visit/template search views
738: CURSOR c_task_data(p_task_id IN NUMBER) IS
739: SELECT T1.*, T2.TEMPLATE_FLAG, T2.ORGANIZATION_ID
740: FROM AHL_VISIT_TASKS_VL T1, AHL_VISITS_VL T2
741: WHERE T1.visit_task_id = p_task_id
742: AND T1.VISIT_ID = T2.VISIT_ID;
743: c_task_data_rec c_task_data%ROWTYPE;
744:
1137: l_task_rec AHL_VWP_RULES_PVT.Task_Rec_Type := p_x_task_rec;
1138:
1139: -- To find visit related information
1140: CURSOR c_visit(x_id IN NUMBER) IS
1141: SELECT * FROM AHL_VISITS_VL
1142: WHERE VISIT_ID = x_id;
1143: c_visit_rec c_visit%ROWTYPE;
1144: BEGIN
1145: IF (l_log_procedure >= l_log_current_level) THEN
1403: l_department_id NUMBER;
1404:
1405: -- To find visit related information
1406: CURSOR c_visit(x_id IN NUMBER) IS
1407: SELECT * FROM AHL_VISITS_VL
1408: WHERE VISIT_ID = x_id;
1409: c_visit_rec c_visit%ROWTYPE;
1410:
1411: -- To find Item ID and Item OrgID for Instance Id
2124: l_department_id NUMBER;
2125:
2126: -- To find visit related information
2127: CURSOR c_visit(x_id IN NUMBER) IS
2128: SELECT * FROM AHL_VISITS_VL
2129: WHERE VISIT_ID = x_id;
2130: c_visit_rec c_visit%ROWTYPE;
2131:
2132: -- bug fix #4181411
2967: ATTRIBUTE12 ,
2968: ATTRIBUTE13 ,
2969: ATTRIBUTE14 ,
2970: ATTRIBUTE15
2971: FROM Ahl_Visits_VL
2972: WHERE VISIT_ID = p_visit_id;
2973:
2974: l_Visit_rec c_Visit%ROWTYPE;
2975: l_Task_rec AHL_VWP_RULES_PVT.Task_Rec_Type default p_x_task_rec;
3840: c_upd_Task_rec c_Task%ROWTYPE;
3841:
3842: -- To find visit related information
3843: CURSOR c_Visit (x_id IN NUMBER) IS
3844: SELECT * FROM Ahl_Visits_VL
3845: WHERE VISIT_ID = x_id;
3846: c_Visit_rec c_Visit%ROWTYPE;
3847:
3848: BEGIN
4420: c_Task_rec c_Task%ROWTYPE;
4421:
4422: -- To find visit related information
4423: CURSOR c_Visit (x_id IN NUMBER) IS
4424: SELECT * FROM Ahl_Visits_VL
4425: WHERE VISIT_ID = x_id;
4426: c_Visit_rec c_Visit%ROWTYPE;
4427:
4428: BEGIN
4910: c_Task_rec c_Task%ROWTYPE;
4911:
4912: -- To find visit related information
4913: CURSOR c_Visit (x_id IN NUMBER) IS
4914: SELECT * FROM Ahl_Visits_VL
4915: WHERE VISIT_ID = x_id;
4916: c_Visit_rec c_Visit%ROWTYPE;
4917:
4918: CURSOR c_sr_ovn(c_sr_id IN NUMBER) IS
5383:
5384: -- To find visit related information
5385: CURSOR c_Visit (x_id IN NUMBER) IS
5386: SELECT *
5387: FROM Ahl_Visits_VL
5388: WHERE VISIT_ID = x_id;
5389: c_visit_rec c_Visit%ROWTYPE;
5390:
5391: -- To find any task which have primary visit task id as deleted task id
5782:
5783: -- To find visit related information
5784: CURSOR c_Visit (x_id IN NUMBER) IS
5785: SELECT *
5786: FROM Ahl_Visits_VL
5787: WHERE VISIT_ID = x_id;
5788: c_visit_rec c_Visit%ROWTYPE;
5789:
5790: -- To find any task which have primary visit task id as deleted task id
6227: l_task_rec c_Task%ROWTYPE;
6228: -- To find visit related information
6229: CURSOR c_Visit (x_id IN NUMBER) IS
6230: SELECT *
6231: FROM Ahl_Visits_VL
6232: WHERE VISIT_ID = x_id;
6233: c_visit_rec c_Visit%ROWTYPE;
6234:
6235: -- To find any task which have primary visit task id as deleted task id
6929: z NUMBER:=0;
6930:
6931: -- To find the task's related visit information
6932: CURSOR c_visit (x_id IN NUMBER) IS
6933: SELECT * FROM AHL_VISITS_VL
6934: WHERE VISIT_ID = x_id;
6935: c_visit_rec c_visit%ROWTYPE;
6936:
6937: -- To find task type code, start, end time of a task
7506: -- End changes by rnahata for Issue 105
7507:
7508: -- To find visit related information
7509: CURSOR c_visit(x_id IN NUMBER) IS
7510: SELECT * FROM AHL_VISITS_VL
7511: WHERE VISIT_ID = x_id;
7512: c_visit_rec c_visit%ROWTYPE;
7513:
7514: -- Begin changes by rnahata for Issue 105