DBA Data[Home] [Help]

APPS.AHL_QA_RESULTS_PVT dependencies on AHL_WORKORDER_OPERATIONS

Line 102: FROM ahl_workorder_operations_v WOP

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
106:

Line 389: UPDATE AHL_WORKORDER_OPERATIONS

385: FND_MSG_PUB.add;
386: RETURN FND_API.G_RET_STS_ERROR;
387: END IF;
388:
389: UPDATE AHL_WORKORDER_OPERATIONS
390: SET collection_id = p_collection_id,
391: object_version_number = object_version_number + 1,
392: last_update_date = SYSDATE,
393: last_updated_by = FND_GLOBAL.user_id,