APPS.AHL_PARTY_MERGE_PKG dependencies on AHL_DOC_REVISION_COPIES

Line 14: -- AHL_DOC_REVISION_COPIES

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
18: -- AHL_ROUTES_B

Line 651: -- Merge AHL_DOC_REVISION_COPIES.RECEIVED_BY_PARTY_ID

647: end;
648: end if;
649: END AHL_DI_APPROVED_BY_PARTY ;
650:
651: -- Merge AHL_DOC_REVISION_COPIES.RECEIVED_BY_PARTY_ID
652:
653: PROCEDURE AHL_DI_RECEIVED_BY_PARTY (
654: p_entity_name IN VARCHAR2,
655: p_from_id IN NUMBER,

Line 666: from ahl_doc_revision_copies

662: x_return_status OUT NOCOPY VARCHAR2)
663: IS
664: cursor c1 is
665: select 1
666: from ahl_doc_revision_copies
667: where received_by_party_id = p_from_fk_id
668: for update nowait;
669:
670:

Line 711: -- In the case of AHL_DOC_REVISION_COPIES table, if received by party id 1000 got merged to received by party id 2000

707: -- dependent record exists on the new parent. If a duplicate exists then do
708: -- not transfer and return the id of the duplicate record as the Merged To Id
709:
710:
711: -- In the case of AHL_DOC_REVISION_COPIES table, if received by party id 1000 got merged to received by party id 2000
712: -- then, we have to update all records with received by party id = 1000 to 2000
713:
714: if p_from_fk_id <> p_to_fk_id then
715: begin

Line 718: arp_message.set_token('TABLE_NAME', 'AHL_DOC_REVISION_COPIES', FALSE);

714: if p_from_fk_id <> p_to_fk_id then
715: begin
716: -- obtain lock on records to be updated.
717: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
718: arp_message.set_token('TABLE_NAME', 'AHL_DOC_REVISION_COPIES', FALSE);
719:
720: open c1;
721: close c1;
722:

Line 723: update ahl_doc_revision_copies

719:
720: open c1;
721: close c1;
722:
723: update ahl_doc_revision_copies
724: set received_by_party_id = p_to_fk_id,
725: last_update_date = SYSDATE,
726: last_updated_by = G_USER_ID,
727: last_update_login = G_LOGIN_ID

Line 739: 'AHL_DOC_REVISION_COPIES for received_by_party_id = ' || p_from_fk_id );

735: exception
736: when resource_busy then
737: arp_message.set_line(g_proc_name || '.' || l_api_name ||
738: '; Could not obtain lock for records in table ' ||
739: 'AHL_DOC_REVISION_COPIES for received_by_party_id = ' || p_from_fk_id );
740: x_return_status := FND_API.G_RET_STS_ERROR;
741: raise;
742:
743: when others then