APPS.WSH_DOC_SEQ_CTG_S dependencies on WSH_DOC_SEQUENCE_CATEGORIES

Line 52: wsh_doc_sequence_categories

48: IS
49: SELECT
50: doc_sequence_category_id
51: FROM
52: wsh_doc_sequence_categories
53: WHERE ((p_rowid IS NULL) OR (p_rowid <> rowid))
54: AND document_type = p_document_type
55: AND NVL(enabled_flag,'N') = 'Y'
56: AND NVL(p_enabled_flag,'N') = 'Y'

Line 170: wsh_doc_sequence_categories

166: CURSOR insert_csr (p_doc_sequence_category_id NUMBER) IS
167: SELECT
168: rowid
169: FROM
170: wsh_doc_sequence_categories
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

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 184: l_category_code wsh_doc_sequence_categories.category_code%type;

180: SELECT wsh_doc_categories_s.nextval category_code
181: FROM dual;
182:
183: l_doc_sequence_category_id NUMBER;
184: l_category_code wsh_doc_sequence_categories.category_code%type;
185: category_code_rec category_code_csr%rowtype;
186:
187: --
188: l_debug_on BOOLEAN;

Line 303: INSERT INTO wsh_doc_sequence_categories

299: OPEN sequence_csr;
300: FETCH sequence_csr INTO l_doc_sequence_category_id;
301: CLOSE sequence_csr;
302:
303: INSERT INTO wsh_doc_sequence_categories
304: ( doc_sequence_category_id
305: , location_id
306: , document_type
307: , document_code

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

Line 717: wsh_doc_sequence_categories

713: , attribute13
714: , attribute14
715: , attribute15
716: FROM
717: wsh_doc_sequence_categories
718: WHERE rowid = x_rowid
719: FOR UPDATE OF doc_sequence_category_id NOWAIT;
720: lock_rec lock_csr%rowtype;
721: --