APPS.AHL_PRD_PRINT_PVT dependencies on AHL_UTIL_UC_PKG

Line 311: AND AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(VTS.INSTANCE_ID) = PCA.UNIT_ITEM_ID

307: AHL_VISIT_TASKS_B VTS,
308: AHL_DOCUMENT_ASSOS_V DOC
309: WHERE
310: WO.VISIT_TASK_ID=VTS.VISIT_TASK_ID
311: AND AHL_UTIL_UC_PKG.GET_UC_HEADER_ID(VTS.INSTANCE_ID) = PCA.UNIT_ITEM_ID
312: AND PCA.PC_NODE_ID = DOC.ASO_OBJECT_ID
313: AND DOC.ASO_OBJECT_TYPE_CODE = ''PC''
314: AND WO.WORKORDER_ID = ';
315:

Line 8550: l_relationship_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(wo_details_rec.item_instance_id);

8546: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');
8547: ELSE
8548: dbms_lob.write(l_merged_lob, LENGTH(''),LENGTH(l_merged_lob)+1, '');
8549: END IF;
8550: l_relationship_id := AHL_UTIL_UC_PKG.Map_Instance_to_RelID(wo_details_rec.item_instance_id);
8551: IF (l_relationship_id IS NOT NULL) THEN
8552: BEGIN
8553: SELECT FLV.meaning
8554: INTO l_position_meaning