APPS.AHL_DI_ASSO_DOC_GEN_PVT dependencies on AHL_DOC_TITLE_ASSOS_TL

Line 545: DELETE FROM AHL_DOC_TITLE_ASSOS_TL

541: DELETE FROM AHL_DOC_TITLE_ASSOS_B
542: WHERE doc_title_asso_id = p_association_rec.doc_title_asso_id;
543: --
544: -- Delete the record from document associations Trans table
545: DELETE FROM AHL_DOC_TITLE_ASSOS_TL
546: WHERE doc_title_asso_id = p_association_rec.doc_title_asso_id;
547: --
548: */
549: --Standard check for commit;

Line 764: FROM AHL_DOC_TITLE_ASSOS_TL

760: subject,
761: page,
762: figure,
763: note
764: FROM AHL_DOC_TITLE_ASSOS_TL
765: WHERE doc_title_asso_id = c_doc_title_asso_id
766: FOR UPDATE OF doc_title_asso_id NOWAIT;
767: ---------- for update only
768: l_api_name CONSTANT VARCHAR2(30) := 'PROCESS_ASSOCIATION';

Line 2110: FROM AHL_DOC_TITLE_ASSOS_TL

2106: END IF;
2107:
2108: -- Knocking off all doc associations from the particular ASO object...
2109: DELETE
2110: FROM AHL_DOC_TITLE_ASSOS_TL
2111: WHERE DOC_TITLE_ASSO_ID IN (
2112: SELECT DOC_TITLE_ASSO_ID
2113: FROM AHL_DOC_TITLE_ASSOS_B
2114: WHERE aso_object_type_code = p_aso_object_type_code and