APPS.AHL_VWP_VISITS_PVT dependencies on AHL_UTIL_UC_PKG

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

1714: ahl_unit_config_headers uc,
1715: csi_item_instances csis
1716: WHERE uc.name = p_unit_name
1717: AND uc.csi_item_instance_id=csis.instance_id
1718: AND AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID) in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1719: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)
1720: AND csis.inventory_item_id = mtl.inventory_item_id
1721: AND csis.inv_master_organization_id = mtl.inventory_org_id
1722: AND csis.serial_number IS NOT NULL

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

1732: ahl_unit_config_headers uc,
1733: csi_item_instances csis
1734: WHERE uc.name = p_unit_name
1735: AND uc.csi_item_instance_id=csis.instance_id
1736: AND upper(AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID))in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1737: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)
1738: AND csis.inventory_item_id = mtl.inventory_item_id
1739: AND csis.inv_master_organization_id = mtl.organization_id
1740: AND csis.serial_number IS NOT NULL

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

1756: csi_item_instances csis
1757: WHERE uc.name = p_unit_name
1758: AND uc.csi_item_instance_id=csis.instance_id
1759: -- Fix by jaramana on June 27, 2006 for Bug 5360066
1760: -- AND upper(AHL_UTIL_UC_PKG.GET_UC_STATUS(uc.UNIT_CONFIG_HEADER_ID))in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1761: AND AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID)in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1762: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)
1763: AND csis.inventory_item_id = mtl.inventory_item_id
1764: AND csis.inv_master_organization_id = mtl.organization_id

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

1757: WHERE uc.name = p_unit_name
1758: AND uc.csi_item_instance_id=csis.instance_id
1759: -- Fix by jaramana on June 27, 2006 for Bug 5360066
1760: -- AND upper(AHL_UTIL_UC_PKG.GET_UC_STATUS(uc.UNIT_CONFIG_HEADER_ID))in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1761: AND AHL_UTIL_UC_PKG.GET_UC_STATUS_CODE(uc.UNIT_CONFIG_HEADER_ID)in ('COMPLETE','INCOMPLETE','DEACTIVATE_QUARANTINE','QUARANTINE')
1762: AND (uc.active_end_date IS NULL OR uc.active_end_date > SYSDATE)
1763: AND csis.inventory_item_id = mtl.inventory_item_id
1764: AND csis.inv_master_organization_id = mtl.organization_id
1765: AND csis.serial_number IS NOT NULL

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

7713: END IF;
7714:
7715: IF item_instance_id IS NOT NULL THEN
7716: -- If the Visit header has an instance id, check for the corresponding Unit
7717: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,item_instance_id);
7718: IF l_quarantined = FND_API.G_TRUE THEN
7719: l_unit_name := ahl_util_uc_pkg.get_unit_name(item_instance_id);
7720: Fnd_Message.SET_NAME('AHL','AHL_VWP_CLOSE_HDR_UNIT_QRNT');
7721: -- The Unit for this Visit (UNIT_NAME-1) is quarantined.

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

7715: IF item_instance_id IS NOT NULL THEN
7716: -- If the Visit header has an instance id, check for the corresponding Unit
7717: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,item_instance_id);
7718: IF l_quarantined = FND_API.G_TRUE THEN
7719: l_unit_name := ahl_util_uc_pkg.get_unit_name(item_instance_id);
7720: Fnd_Message.SET_NAME('AHL','AHL_VWP_CLOSE_HDR_UNIT_QRNT');
7721: -- The Unit for this Visit (UNIT_NAME-1) is quarantined.
7722: Fnd_Message.Set_Token('UNIT_NAME',l_unit_name);
7723: Fnd_Msg_Pub.ADD;

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

7731: OPEN c_get_tasknumbers (p_visit_id);
7732: LOOP
7733: FETCH c_get_tasknumbers INTO l_task_number,l_instance_id;
7734: EXIT WHEN c_get_tasknumbers%NOTFOUND;
7735: l_quarantined := ahl_util_uc_pkg.is_unit_quarantined(null,l_instance_id);
7736: IF l_quarantined = FND_API.G_TRUE THEN
7737: Fnd_Message.SET_NAME('AHL','AHL_VWP_CLOSE_TSK_UNIT_QRNT');
7738: -- The Unit for the Task (UNIT_NAME-1) is quarantined.
7739: Fnd_Message.Set_Token('TASK_NUMBER',l_task_number);