DBA Data[Home] [Help]

APPS.PO_SHIPMENTS_SV4 dependencies on PO_DOCUMENT_ACTION_PVT

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

979: SELECT line_location_id
980: INTO l_dummy
981: FROM po_line_locations_all
982: WHERE po_line_id = p_po_line_id
983: AND nvl(closed_code, PO_DOCUMENT_ACTION_PVT.g_doc_action_OPEN) <> PO_DOCUMENT_ACTION_PVT.g_doc_closed_sts_FIN_CLOSED
984: AND nvl(cancel_flag, 'N') <> 'Y';
985:
986: --If we reach here then we have only one valid shipment and shopuld not allow its deletion
987: x_message_text := PO_CORE_S.get_translated_text('PO_CANT_DELETE_ONLY_SCHEDULE');