APPS.AHL_DI_DOC_INDEX_PVT dependencies on AHL_SUPPLIER_DOCUMENTS

Line 1183: FROM AHL_SUPPLIER_DOCUMENTS

1179: IS
1180: SELECT supplier_id,
1181: document_id,
1182: preference_code
1183: FROM AHL_SUPPLIER_DOCUMENTS
1184: WHERE supplier_document_id = c_supplier_document_id;
1185: -- Used to check Duplicate Record
1186: CURSOR dup_rec(c_supplier_id NUMBER,
1187: c_document_id NUMBER)

Line 1190: FROM AHL_SUPPLIER_DOCUMENTS

1186: CURSOR dup_rec(c_supplier_id NUMBER,
1187: c_document_id NUMBER)
1188: IS
1189: SELECT 'X'
1190: FROM AHL_SUPPLIER_DOCUMENTS
1191: WHERE supplier_id = c_supplier_id
1192: AND document_id = c_document_id;
1193:
1194: -- Perf Bug Fix 4919011.

Line 1365: FROM AHL_SUPPLIER_DOCUMENTS

1361: CURSOR dup_rec(c_supplier_id NUMBER,
1362: c_document_id NUMBER)
1363: IS
1364: SELECT 'X'
1365: FROM AHL_SUPPLIER_DOCUMENTS
1366: WHERE supplier_id = c_supplier_id
1367: AND document_id = c_document_id;
1368:
1369: -- Perf Bug Fix 4919011.

Line 1512: SELECT AHL_SUPPLIER_DOCUMENTS_S.Nextval INTO

1508: --ad CLOSE dup_rec;
1509:
1510: ELSE
1511: --Retrieve the sequence number
1512: SELECT AHL_SUPPLIER_DOCUMENTS_S.Nextval INTO
1513: l_supplier_document_id from DUAL;
1514: --Insert the record into supplier documents table
1515: INSERT INTO AHL_SUPPLIER_DOCUMENTS
1516: (

Line 1515: INSERT INTO AHL_SUPPLIER_DOCUMENTS

1511: --Retrieve the sequence number
1512: SELECT AHL_SUPPLIER_DOCUMENTS_S.Nextval INTO
1513: l_supplier_document_id from DUAL;
1514: --Insert the record into supplier documents table
1515: INSERT INTO AHL_SUPPLIER_DOCUMENTS
1516: (
1517: SUPPLIER_DOCUMENT_ID,
1518: SUPPLIER_ID,
1519: DOCUMENT_ID,

Line 1720: FROM AHL_SUPPLIER_DOCUMENTS

1716: attribute13,
1717: attribute14,
1718: attribute15,
1719: object_version_number
1720: FROM AHL_SUPPLIER_DOCUMENTS
1721: WHERE supplier_document_id = c_supplier_document_id
1722: FOR UPDATE OF object_version_number NOWAIT;
1723:
1724: -- Perf Bug Fix 4919011.

Line 1893: UPDATE AHL_SUPPLIER_DOCUMENTS

1889:
1890:
1891:
1892: --Updates the supplier table
1893: UPDATE AHL_SUPPLIER_DOCUMENTS
1894: SET supplier_id = l_supplier_info.supplier_id,
1895: document_id = l_supplier_info.document_id,
1896: preference_code = l_supplier_info.preference_code,
1897: object_version_number = l_supplier_info.object_version_number+1,

Line 2077: FROM AHL_SUPPLIER_DOCUMENTS

2073: SELECT ROWID ,
2074: supplier_id,
2075: document_id,
2076: object_version_number
2077: FROM AHL_SUPPLIER_DOCUMENTS
2078: WHERE supplier_document_id = c_supplier_document_id
2079: FOR UPDATE OF object_version_number NOWAIT;
2080: --Cursor to check the record exists in Subscriptions table
2081: --Cursor modified to check only active subscriptions: pjha: 16-Jul-2002

Line 2214: DELETE FROM AHL_SUPPLIER_DOCUMENTS

2210: END IF;
2211: CLOSE get_subc_rec;
2212: END IF;
2213: -- Delete the record from suppliers table
2214: DELETE FROM AHL_SUPPLIER_DOCUMENTS
2215: WHERE ROWID = l_rowid;
2216: --END IF;
2217: -- Standard call to get message count
2218: l_msg_count := FND_MSG_PUB.count_msg;