DBA Data[Home] [Help]

APPS.PO_SHIPMENTS_SV4 dependencies on PO_DOCUMENT_ACTION_PVT

Line 1003: AND nvl(closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN) <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED

999: SELECT line_location_id
1000: INTO l_dummy
1001: FROM po_line_locations_all
1002: WHERE po_line_id = p_po_line_id
1003: AND nvl(closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN) <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
1004: AND nvl(cancel_flag, 'N') <> 'Y';
1005:
1006: --If we reach here then we have only one valid shipment and shopuld not allow its deletion
1007: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_ONLY_SCHEDULE');