APPS.AHL_QA_RESULTS_PVT dependencies on AHL_PRD_UTIL_PKG

Line 95: SELECT WO.job_number,WO.job_status_code status_code,AHL_PRD_UTIL_PKG.Is_Unit_Locked(WO.workorder_id,null,null,null) UNIT_LOCKED

91: --rroy
92: -- ACL Changes
93: CURSOR get_wo_details(c_wo_id NUMBER)
94: IS
95: SELECT WO.job_number,WO.job_status_code status_code,AHL_PRD_UTIL_PKG.Is_Unit_Locked(WO.workorder_id,null,null,null) UNIT_LOCKED
96: FROM AHL_SEARCH_WORKORDERS_V WO
97: WHERE WO.workorder_id = c_wo_id;
98:
99: CURSOR get_op_details(c_op_id NUMBER)

Line 101: SELECT to_char(OPERATION_SEQUENCE_NUM) title,STATUS_CODE,AHL_PRD_UTIL_PKG.IS_UNIT_LOCKED(WOP.WORKORDER_ID,NULL,NULL,NULL) UNIT_LOCKED

97: WHERE WO.workorder_id = c_wo_id;
98:
99: CURSOR get_op_details(c_op_id NUMBER)
100: IS
101: SELECT to_char(OPERATION_SEQUENCE_NUM) title,STATUS_CODE,AHL_PRD_UTIL_PKG.IS_UNIT_LOCKED(WOP.WORKORDER_ID,NULL,NULL,NULL) UNIT_LOCKED
102: FROM ahl_workorder_operations_v WOP
103: WHERE WORKORDER_OPERATION_ID = c_op_id;
104: --rroy
105: -- ACL Changes

Line 112: SELECT MR.MR_TITLE TITLE, MR.STATUS_CODE,AHL_PRD_UTIL_PKG.IS_UNIT_LOCKED(NULL,MR.UNIT_EFFECTIVITY_ID,NULL,NULL) UNIT_LOCKED

108: --Cursor added to fetch UE Title to be passed as token
109:
110: CURSOR ue_details_csr( p_unit_effectivity_id IN NUMBER )
111: IS
112: SELECT MR.MR_TITLE TITLE, MR.STATUS_CODE,AHL_PRD_UTIL_PKG.IS_UNIT_LOCKED(NULL,MR.UNIT_EFFECTIVITY_ID,NULL,NULL) UNIT_LOCKED
113: FROM AHL_MR_INSTANCES_V MR
114: WHERE MR.UNIT_EFFECTIVITY_ID = p_unit_effectivity_id;
115:
116: