APPS.AHL_DI_DOC_INDEX_PVT dependencies on AHL_RECIPIENT_DOCUMENTS

Line 2320: FROM AHL_RECIPIENT_DOCUMENTS

2316: CURSOR get_recipient_rec_info (c_recipient_document_id NUMBER)
2317: IS
2318: SELECT recipient_party_id,
2319: document_id
2320: FROM AHL_RECIPIENT_DOCUMENTS
2321: WHERE recipient_document_id = c_recipient_document_id;
2322:
2323: -- Used to validate the document id
2324: CURSOR check_doc_info(c_document_id NUMBER)

Line 2335: FROM AHL_RECIPIENT_DOCUMENTS

2331: CURSOR dup_rec(c_recipient_party_id NUMBER,
2332: c_document_id NUMBER)
2333: IS
2334: SELECT 'X'
2335: FROM AHL_RECIPIENT_DOCUMENTS
2336: WHERE recipient_party_id = c_recipient_party_id
2337: AND document_id = c_document_id;
2338:
2339: CURSOR DUP_REC_NAME(c_recipient_party_id NUMBER)

Line 2452: FROM AHL_RECIPIENT_DOCUMENTS

2448: CURSOR dup_rec(c_recipient_party_id NUMBER,
2449: c_document_id NUMBER)
2450: IS
2451: SELECT 'X'
2452: FROM AHL_RECIPIENT_DOCUMENTS
2453: WHERE recipient_party_id = c_recipient_party_id
2454: AND document_id = c_document_id;
2455:
2456: CURSOR DUP_REC_NAME(c_recipient_party_id NUMBER)

Line 2559: SELECT AHL_RECIPIENT_DOCUMENTS_S.Nextval INTO

2555: --ad END IF;
2556: --ad CLOSE dup_rec;
2557: else --ad
2558: --Retrieves the sequence number
2559: SELECT AHL_RECIPIENT_DOCUMENTS_S.Nextval INTO
2560: l_recipient_document_id from DUAL;
2561: --Insert the record into recipient documents
2562: INSERT INTO AHL_RECIPIENT_DOCUMENTS
2563: (

Line 2562: INSERT INTO AHL_RECIPIENT_DOCUMENTS

2558: --Retrieves the sequence number
2559: SELECT AHL_RECIPIENT_DOCUMENTS_S.Nextval INTO
2560: l_recipient_document_id from DUAL;
2561: --Insert the record into recipient documents
2562: INSERT INTO AHL_RECIPIENT_DOCUMENTS
2563: (
2564: RECIPIENT_DOCUMENT_ID,
2565: RECIPIENT_PARTY_ID,
2566: DOCUMENT_ID,

Line 2761: FROM AHL_RECIPIENT_DOCUMENTS

2757: attribute12,
2758: attribute13,
2759: attribute14,
2760: attribute15
2761: FROM AHL_RECIPIENT_DOCUMENTS
2762: WHERE recipient_document_id = c_recipient_document_id
2763: FOR UPDATE OF object_version_number NOWAIT;
2764: --
2765: l_api_name CONSTANT VARCHAR2(30) := 'MODIFY_RECIPIENT';

Line 2870: UPDATE AHL_RECIPIENT_DOCUMENTS

2866: l_recipient_info.attribute13 := p_recipient_tbl(i).attribute13;
2867: l_recipient_info.attribute14 := p_recipient_tbl(i).attribute14;
2868: l_recipient_info.attribute15 := p_recipient_tbl(i).attribute15;
2869: -- update the table
2870: UPDATE AHL_RECIPIENT_DOCUMENTS
2871: SET recipient_party_id = l_recipient_info.recipient_party_id,
2872: document_id = l_recipient_info.document_id,
2873: object_version_number = l_recipient_info.object_version_number+1,
2874: attribute_category = l_recipient_info.attribute_category,

Line 3022: FROM AHL_RECIPIENT_DOCUMENTS

3018: CURSOR get_recipient_rec_info(c_recipient_document_id NUMBER)
3019: IS
3020: SELECT ROWID ,
3021: object_version_number
3022: FROM AHL_RECIPIENT_DOCUMENTS
3023: WHERE recipient_document_id = c_recipient_document_id
3024: FOR UPDATE OF object_version_number NOWAIT;
3025:
3026: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_RECIPIENT';

Line 3090: DELETE FROM AHL_RECIPIENT_DOCUMENTS

3086: END IF;
3087: */
3088:
3089: -- Delete the record from suppliers table
3090: DELETE FROM AHL_RECIPIENT_DOCUMENTS
3091: WHERE ROWID = l_rowid;
3092: -- END LOOP;
3093: -- END IF;
3094: --Standarad check for commit