APPS.AHL_DI_DOC_REVISION_PVT dependencies on AHL_DOC_TITLE_ASSOS_B

Line 498: FROM AHL_DOC_TITLE_ASSOS_B

494: CURSOR get_association_records(c_document_id NUMBER)
495: IS
496: SELECT doc_title_asso_id,object_version_number,last_update_date,last_updated_by,last_update_login,
497: aso_object_type_code,aso_object_id
498: FROM AHL_DOC_TITLE_ASSOS_B
499: WHERE document_id = c_document_id
500: AND use_latest_rev_flag = 'Y';
501:
502: l_asso_record get_association_records%rowtype;

Line 619: UPDATE AHL_DOC_TITLE_ASSOS_B

615: OR l_object_status_code = 'DRAFT' THEN
616: IF G_DEBUG='Y' THEN
617: AHL_DEBUG_PUB.debug( 'Before Update in New Procedure' );
618: END IF;
619: UPDATE AHL_DOC_TITLE_ASSOS_B
620: SET doc_revision_id = l_latest_doc_revision_id,
621: object_version_number = l_asso_record.object_version_number + 1,
622: last_update_date = l_asso_record.last_update_date,
623: last_updated_by =l_asso_record.last_updated_by,

Line 1615: from ahl_doc_title_assos_b asso,ahl_documents_b doc

1611: --Cursor to get ids of all the documents which are associated with use latest flag ='Yes'.
1612: CURSOR get_all_document_ids
1613: IS
1614: select distinct(asso.document_id),doc.document_no
1615: from ahl_doc_title_assos_b asso,ahl_documents_b doc
1616: where asso.use_latest_rev_flag='Y'
1617: and asso.document_id=doc.document_id;
1618:
1619: l_api_version NUMBER :=1.0;