APPS.AHL_DI_DOC_INDEX_PVT dependencies on AHL_DOCUMENTS_B

Line 168: FROM AHL_DOCUMENTS_B

164: operator_code,
165: product_type_code,
166: subscribe_avail_flag,
167: subscribe_to_flag
168: FROM AHL_DOCUMENTS_B
169: WHERE document_id = c_document_id;
170:
171: CURSOR get_sub_type_exists(c_doc_type_code VARCHAR2,
172: c_doc_sub_type_code VARCHAR2)

Line 184: FROM AHL_DOCUMENTS_B

180: CURSOR dup_rec(c_source_party_id NUMBER,
181: c_document_no VARCHAR2)
182: IS
183: SELECT 'X'
184: FROM AHL_DOCUMENTS_B
185: WHERE document_no = c_document_no
186: AND source_party_id = c_source_party_id;
187:
188:

Line 461: FROM AHL_DOCUMENTS_B

457: -- Cursor to check for uniqueness
458: CURSOR unique_rec(c_document_no VARCHAR2)
459: IS
460: SELECT 'X'
461: FROM AHL_DOCUMENTS_B
462: WHERE document_no = c_document_no;
463: --
464: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_DOCUMENT';
465: l_api_version CONSTANT NUMBER := 1.0;

Line 568: SELECT AHL_DOCUMENTS_B_S.Nextval INTO

564: END IF;
565: CLOSE unique_rec;
566: -- Get the sequence number
567:
568: SELECT AHL_DOCUMENTS_B_S.Nextval INTO
569: l_document_id from DUAL;
570: /*-------------------------------------------------------- */
571: /* procedure name: AHL_DI_DOCUMENTS_PKG.INSERT_ROW */
572: /* description : Added by Senthil to call Table Handler */

Line 797: FROM AHL_DOCUMENTS_B

793: attribute12,
794: attribute13,
795: attribute14,
796: attribute15
797: FROM AHL_DOCUMENTS_B
798: WHERE document_id = c_document_id;
799: --FOR UPDATE OF object_version_number NOWAIT;
800:
801: --

Line 1089: FROM AHL_DOCUMENTS_B

1085: -- Used to validate document id
1086: CURSOR check_doc_info(c_document_id NUMBER)
1087: IS
1088: SELECT 'X'
1089: FROM AHL_DOCUMENTS_B
1090: WHERE document_id = c_document_id;
1091: --Cursor to get supplier info
1092: CURSOR get_supplier_rec_info (c_supplier_document_id NUMBER)
1093: IS

Line 2241: FROM AHL_DOCUMENTS_B

2237: -- Used to validate the document id
2238: CURSOR check_doc_info(c_document_id NUMBER)
2239: IS
2240: SELECT 'X'
2241: FROM AHL_DOCUMENTS_B
2242: WHERE document_id = c_document_id;
2243:
2244: --Cursor to check duplicate record
2245: CURSOR dup_rec(c_recipient_party_id NUMBER,