[Home] [Help]
1301: conc_req_rec c_conc_req_details%ROWTYPE;
1302:
1303: -- Cursor to find master workorder name for the given visit
1304: CURSOR c_workorder_csr (x_id IN NUMBER) IS
1305: SELECT WORKORDER_NAME, WORKORDER_ID FROM AHL_WORKORDERS
1306: WHERE MASTER_WORKORDER_FLAG = 'Y' AND VISIT_ID = x_id
1307: /*B6512777 - sowsubra - there is no task associated with visit master wo, hence included the check below to get the visit master wo name*/
1308: AND VISIT_TASK_ID IS NULL;
1309:
3430: c_Task_rec c_Task%ROWTYPE;
3431:
3432: -- To find if WIP job in Draft Status is created for the Visit
3433: CURSOR c_job(x_id IN NUMBER) IS
3434: SELECT count(*) FROM AHL_WORKORDERS
3435: WHERE VISIT_ID = x_id
3436: AND MASTER_WORKORDER_FLAG = 'Y'
3437: AND STATUS_CODE = 17;
3438:
3436: AND MASTER_WORKORDER_FLAG = 'Y'
3437: AND STATUS_CODE = 17;
3438:
3439: CURSOR c_Visit_WO(x_id IN NUMBER) IS
3440: SELECT * FROM AHL_WORKORDERS
3441: WHERE VISIT_ID = x_id
3442: AND MASTER_WORKORDER_FLAG = 'Y'
3443: AND STATUS_CODE = 17;
3444:
3444:
3445: l_workrec c_Visit_WO%ROWTYPE;
3446:
3447: CURSOR c_Task_WO(x_task_id IN NUMBER) IS
3448: SELECT * FROM AHL_WORKORDERS
3449: WHERE VISIT_TASK_ID = x_task_id
3450: AND STATUS_CODE = 17;
3451:
3452: l_task_workrec c_Task_WO%ROWTYPE;
3536: -- TCHIMIRA :: 17-DEC-2011 :: bug# 13000673 :: commenting the below cursor
3537: /*CURSOR get_latest_wo_end_date (c_visit_id IN NUMBER)
3538: IS
3539: SELECT max (wip.scheduled_completion_date)
3540: FROM wip_discrete_jobs wip, ahl_workorders wo
3541: WHERE wo.visit_id = c_visit_id
3542: AND wo.wip_entity_id = wip.wip_entity_id;
3543: l_latest_wo_end_date DATE; */
3544:
5256:
5257: -- To find Master Workorder associated with the given Visit in production
5258: CURSOR c_workorder_csr(x_visit_id IN NUMBER) IS
5259: SELECT workorder_id, object_version_number, status_code
5260: FROM AHL_WORKORDERS
5261: WHERE VISIT_ID = x_visit_id
5262: AND MASTER_WORKORDER_FLAG = 'Y'
5263: AND VISIT_TASK_ID IS NULL;
5264:
5266:
5267: -- To find active Master Workorder associated with the given Visit in production
5268: CURSOR c_active_workorder(x_visit_id IN NUMBER) IS
5269: SELECT workorder_id, object_version_number, status_code
5270: FROM AHL_WORKORDERS
5271: WHERE VISIT_ID = x_visit_id
5272: AND MASTER_WORKORDER_FLAG = 'Y'
5273: AND VISIT_TASK_ID IS NULL
5274: AND STATUS_CODE not in ('22','7'); -- deleted, cancelled
6313: -- Filter out all Summary tasks, because Master WO will not have statuses updated
6314: --If found, then can not close job.
6315: CURSOR get_open_job_task_csr (p_visit_id IN NUMBER) IS
6316: SELECT A.VISIT_TASK_ID
6317: FROM AHL_VISIT_TASKS_VL A, AHL_WORKORDERS B
6318: WHERE A.VISIT_TASK_ID = B.VISIT_TASK_ID
6319: AND A.VISIT_ID = p_visit_id
6320: AND NVL(A.STATUS_CODE,'X') <> 'DELETED'
6321: -- Balaji added statuses complete_no_charge and deleted to the list of statuses to be
6346:
6347: --Added by Srini
6348: CURSOR c_wip_entity(c_visit_id IN NUMBER) IS
6349: SELECT A.visit_task_id,workorder_id,wip_entity_id,a.object_version_number
6350: FROM ahl_visit_tasks_vl a, ahl_workorders b
6351: WHERE a.visit_task_id = b.visit_task_id
6352: AND a.visit_id = C_VISIT_ID
6353: AND NVL(A.STATUS_CODE,'X') <> 'DELETED'
6354: AND B.STATUS_CODE <> '7';
6365: -- SKPATHAK :: 20-JUN-2011 :: VWPE: ER:12673125
6366: CURSOR get_default_stage_wo (c_visit_id IN NUMBER)
6367: IS
6368: SELECT wo.workorder_id
6369: FROM ahl_workorders wo, ahl_visit_tasks_b task
6370: WHERE task.visit_task_id = wo.visit_task_id
6371: AND task.visit_id = c_visit_id
6372: AND task.task_type_code = 'STAGE'
6373: AND task.stage_id IS NULL;