[Home] [Help]
1100: visit_rec c_visit_details%ROWTYPE;
1101:
1102: -- Cursor to find master workorder name for the given visit
1103: CURSOR c_workorder_csr (x_id IN NUMBER) IS
1104: SELECT WORKORDER_NAME, WORKORDER_ID FROM AHL_WORKORDERS
1105: WHERE MASTER_WORKORDER_FLAG = 'Y' AND VISIT_ID = x_id
1106: /*B6512777 - sowsubra - there is no task associated with visit master wo, hence included the check below to get the visit master wo name*/
1107: AND VISIT_TASK_ID IS NULL;
1108:
2850: c_Task_rec c_Task%ROWTYPE;
2851:
2852: -- To find if WIP job in Draft Status is created for the Visit
2853: CURSOR c_job(x_id IN NUMBER) IS
2854: SELECT count(*) FROM AHL_WORKORDERS
2855: WHERE VISIT_ID = x_id
2856: AND MASTER_WORKORDER_FLAG = 'Y'
2857: AND STATUS_CODE = 17;
2858:
2856: AND MASTER_WORKORDER_FLAG = 'Y'
2857: AND STATUS_CODE = 17;
2858:
2859: CURSOR c_Visit_WO(x_id IN NUMBER) IS
2860: SELECT * FROM AHL_WORKORDERS
2861: WHERE VISIT_ID = x_id
2862: AND MASTER_WORKORDER_FLAG = 'Y'
2863: AND STATUS_CODE = 17;
2864:
2864:
2865: l_workrec c_Visit_WO%ROWTYPE;
2866:
2867: CURSOR c_Task_WO(x_task_id IN NUMBER) IS
2868: SELECT * FROM AHL_WORKORDERS
2869: WHERE VISIT_TASK_ID = x_task_id
2870: AND STATUS_CODE = 17;
2871:
2872: l_task_workrec c_Task_WO%ROWTYPE;
4014:
4015: -- To find Master Workorder associated with the given Visit in production
4016: CURSOR c_workorder_csr(x_visit_id IN NUMBER) IS
4017: SELECT workorder_id, object_version_number, status_code
4018: FROM AHL_WORKORDERS
4019: WHERE VISIT_ID = x_visit_id
4020: AND MASTER_WORKORDER_FLAG = 'Y'
4021: AND VISIT_TASK_ID IS NULL;
4022:
4024:
4025: -- To find active Master Workorder associated with the given Visit in production
4026: CURSOR c_active_workorder(x_visit_id IN NUMBER) IS
4027: SELECT workorder_id, object_version_number, status_code
4028: FROM AHL_WORKORDERS
4029: WHERE VISIT_ID = x_visit_id
4030: AND MASTER_WORKORDER_FLAG = 'Y'
4031: AND VISIT_TASK_ID IS NULL
4032: AND STATUS_CODE not in ('22','7'); -- deleted, cancelled
4736: -- Filter out all Summary tasks, because Master WO will not have statuses updated
4737: --If found, then can not close job.
4738: CURSOR get_open_job_task_csr (p_visit_id IN NUMBER) IS
4739: SELECT A.VISIT_TASK_ID
4740: FROM AHL_VISIT_TASKS_VL A, AHL_WORKORDERS B
4741: WHERE A.VISIT_TASK_ID = B.VISIT_TASK_ID
4742: AND A.VISIT_ID = p_visit_id
4743: AND NVL(A.STATUS_CODE,'X') <> 'DELETED'
4744: -- Balaji added statuses complete_no_charge and deleted to the list of statuses to be
4767:
4768: --Added by Srini
4769: CURSOR c_wip_entity(c_visit_id IN NUMBER) IS
4770: SELECT A.visit_task_id,workorder_id,wip_entity_id,a.object_version_number
4771: FROM ahl_visit_tasks_vl a, ahl_workorders b
4772: WHERE a.visit_task_id = b.visit_task_id
4773: AND a.visit_id = C_VISIT_ID
4774: AND NVL(A.STATUS_CODE,'X') <> 'DELETED'
4775: AND B.STATUS_CODE <> '7';