APPS.AHL_VWP_VISITS_PVT dependencies on AHL_UTIL_UC_PKG

Line 1446: AND AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID) in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')

1442: ahl_unit_config_headers uc,
1443: csi_item_instances csis
1444: WHERE uc.name = p_unit_name
1445: AND uc.csi_item_instance_id=csis.instance_id
1446: AND AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID) in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1447: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)
1448: AND csis.inventory_item_id = mtl.inventory_item_id
1449: AND csis.inv_master_organization_id = mtl.inventory_org_id
1450: AND csis.serial_number IS NOT NULL

Line 1464: AND upper(AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID))in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')

1460: ahl_unit_config_headers uc,
1461: csi_item_instances csis
1462: WHERE uc.name = p_unit_name
1463: AND uc.csi_item_instance_id=csis.instance_id
1464: AND upper(AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID))in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1465: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)
1466: AND csis.inventory_item_id = mtl.inventory_item_id
1467: AND csis.inv_master_organization_id = mtl.organization_id
1468: AND csis.serial_number IS NOT NULL

Line 1488: -- AND upper(AHL_UTIL_UC_PKG.GET_UC_STATUS(uc.UNIT_CONFIG_HEADER_ID))in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')

1484: csi_item_instances csis
1485: WHERE uc.name = p_unit_name
1486: AND uc.csi_item_instance_id=csis.instance_id
1487: -- Fix by jaramana on June 27, 2006 for Bug 5360066
1488: -- AND upper(AHL_UTIL_UC_PKG.GET_UC_STATUS(uc.UNIT_CONFIG_HEADER_ID))in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1489: AND AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID)in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1490: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)
1491: AND csis.inventory_item_id = mtl.inventory_item_id
1492: AND csis.inv_master_organization_id = mtl.organization_id

Line 1489: AND AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID)in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')

1485: WHERE uc.name = p_unit_name
1486: AND uc.csi_item_instance_id=csis.instance_id
1487: -- Fix by jaramana on June 27, 2006 for Bug 5360066
1488: -- AND upper(AHL_UTIL_UC_PKG.GET_UC_STATUS(uc.UNIT_CONFIG_HEADER_ID))in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1489: AND AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID)in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1490: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)
1491: AND csis.inventory_item_id = mtl.inventory_item_id
1492: AND csis.inv_master_organization_id = mtl.organization_id
1493: AND csis.serial_number IS NOT NULL

Line 5956: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,item_instance_id);

5952: END IF;
5953:
5954: IF item_instance_id IS NOT NULL THEN
5955: -- If the Visit header has an instance id, check for the corresponding Unit
5956: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,item_instance_id);
5957: IF l_quarantined = FND_API.G_TRUE THEN
5958: l_unit_name := ahl_util_uc_pkg.get_unit_name(item_instance_id);
5959: Fnd_Message.SET_NAME('AHL','AHL_VWP_CLOSE_HDR_UNIT_QRNT');
5960: -- The Unit for this Visit (UNIT_NAME-1) is quarantined.

Line 5958: l_unit_name := ahl_util_uc_pkg.get_unit_name(item_instance_id);

5954: IF item_instance_id IS NOT NULL THEN
5955: -- If the Visit header has an instance id, check for the corresponding Unit
5956: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,item_instance_id);
5957: IF l_quarantined = FND_API.G_TRUE THEN
5958: l_unit_name := ahl_util_uc_pkg.get_unit_name(item_instance_id);
5959: Fnd_Message.SET_NAME('AHL','AHL_VWP_CLOSE_HDR_UNIT_QRNT');
5960: -- The Unit for this Visit (UNIT_NAME-1) is quarantined.
5961: Fnd_Message.Set_Token('UNIT_NAME',l_unit_name);
5962: Fnd_Msg_Pub.ADD;

Line 5974: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,l_instance_id);

5970: OPEN c_get_tasknumbers (p_visit_id);
5971: LOOP
5972: FETCH c_get_tasknumbers INTO l_task_number,l_instance_id;
5973: EXIT WHEN c_get_tasknumbers%NOTFOUND;
5974: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,l_instance_id);
5975: IF l_quarantined = FND_API.G_TRUE THEN
5976: Fnd_Message.SET_NAME('AHL','AHL_VWP_CLOSE_TSK_UNIT_QRNT');
5977: -- The Unit for the Task (UNIT_NAME-1) is quarantined.
5978: Fnd_Message.Set_Token('TASK_NUMBER',l_task_number);