DBA Data[Home] [Help]

APPS.WSH_DOC_SEQ_CTG_S dependencies on WSH_DOC_SEQUENCE_CATEGORIES_S

Line 175: SELECT wsh_doc_sequence_categories_s.nextval

171: WHERE doc_sequence_category_id = p_doc_sequence_category_id;
172:
173: -- cursor selects a sequence for the primary key
174: CURSOR sequence_csr IS
175: SELECT wsh_doc_sequence_categories_s.nextval
176: FROM dual;
177:
178: -- cursor selects a sequence for category code
179: CURSOR category_code_csr IS

Line 550: UPDATE wsh_doc_sequence_categories SET

546: ------------------------------------------------------
547: -- update the shipping document category repository --
548: ------------------------------------------------------
549:
550: UPDATE wsh_doc_sequence_categories SET
551: doc_sequence_category_id = x_doc_sequence_category_id
552: , location_id = x_location_id
553: , document_type = x_document_type
554: , document_code = x_document_code