APPS.AHL_PARTY_MERGE_PKG dependencies on AHL_DOC_REVISIONS_B

Line 13: -- AHL_DOC_REVISIONS_B

9: -- AHL_DOCUMENTS_B
10: -- AHL_SUPPLIER_DOCUMENTS
11: -- AHL_RECIPIENT_DOCUEMTNS
12: -- AHL_SUBSCRIPTIONS_B
13: -- AHL_DOC_REVISIONS_B
14: -- AHL_DOC_REVISION_COPIES
15: --
16: -- AHL_OPERATIONS_B
17: -- AHL_OPERATIONS_H_B

Line 547: -- Merge AHL_DOC_REVISIONS_B.APPROVED_BY_PARTY_ID

543: end;
544: end if;
545: END AHL_DI_SUBSCRIBED_FRM_PARTY;
546:
547: -- Merge AHL_DOC_REVISIONS_B.APPROVED_BY_PARTY_ID
548:
549: PROCEDURE AHL_DI_APPROVED_BY_PARTY (
550: p_entity_name IN VARCHAR2,
551: p_from_id IN NUMBER,

Line 562: from ahl_doc_revisions_b

558: x_return_status OUT NOCOPY VARCHAR2)
559: IS
560: cursor c1 is
561: select 1
562: from ahl_doc_revisions_b
563: where approved_by_party_id = p_from_fk_id
564: for update nowait;
565:
566:

Line 611: -- In the case of AHL_DOC_REVISIONS_B table, if approved by party id 1000 got merged to approved by party id 2000

607: -- dependent record exists on the new parent. If a duplicate exists then do
608: -- not transfer and return the id of the duplicate record as the Merged To Id
609:
610:
611: -- In the case of AHL_DOC_REVISIONS_B table, if approved by party id 1000 got merged to approved by party id 2000
612: -- then, we have to update all records with approved by party id = 1000 to 2000
613:
614: if p_from_fk_id <> p_to_fk_id then
615: begin

Line 618: arp_message.set_token('TABLE_NAME', 'AHL_DOC_REVISIONS_B', FALSE);

614: if p_from_fk_id <> p_to_fk_id then
615: begin
616: -- obtain lock on records to be updated.
617: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
618: arp_message.set_token('TABLE_NAME', 'AHL_DOC_REVISIONS_B', FALSE);
619:
620: open c1;
621: close c1;
622:

Line 623: update ahl_doc_revisions_b

619:
620: open c1;
621: close c1;
622:
623: update ahl_doc_revisions_b
624: set approved_by_party_id = p_to_fk_id,
625: last_update_date = SYSDATE,
626: last_updated_by = G_USER_ID,
627: last_update_login = G_LOGIN_ID