APPS.AHL_PARTY_MERGE_PKG dependencies on AHL_SUPPLIER_DOCUMENTS

Line 10: -- AHL_SUPPLIER_DOCUMENTS

6: -- Online tables. The
7: -- Tables that need to be considered for
8: -- Party Merge are:
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

Line 138: -- Merge AHL_SUPPLIER_DOCUMENTS.SUPPLIER_ID

134: end if;
135: END AHL_DI_SOURCE_PARTY;
136:
137:
138: -- Merge AHL_SUPPLIER_DOCUMENTS.SUPPLIER_ID
139:
140: PROCEDURE AHL_DI_SUPPLIER (
141: p_entity_name IN VARCHAR2,
142: p_from_id IN NUMBER,

Line 153: from ahl_supplier_documents

149: x_return_status OUT NOCOPY VARCHAR2)
150: IS
151: cursor c1 is
152: select 1
153: from ahl_supplier_documents
154: where supplier_id = p_from_fk_id
155: for update nowait;
156:
157:

Line 201: -- In the case of AHL_SUPPLIER_DOCUMENTS table, if supplier id 1000 got merged to supplier id 2000

197: -- dependent record exists on the new parent. If a duplicate exists then do
198: -- not transfer and return the id of the duplicate record as the Merged To Id
199:
200:
201: -- In the case of AHL_SUPPLIER_DOCUMENTS table, if supplier id 1000 got merged to supplier id 2000
202: -- then, we have to update all records with supplier_id = 1000 to 2000
203:
204: if p_from_fk_id <> p_to_fk_id then
205: begin

Line 208: arp_message.set_token('TABLE_NAME', 'AHL_SUPPLIER_DOCUMENTS', FALSE);

204: if p_from_fk_id <> p_to_fk_id then
205: begin
206: -- obtain lock on records to be updated.
207: arp_message.set_name('AR', 'AR_LOCKING_TABLE');
208: arp_message.set_token('TABLE_NAME', 'AHL_SUPPLIER_DOCUMENTS', FALSE);
209:
210: open c1;
211: close c1;
212:

Line 213: update ahl_supplier_documents

209:
210: open c1;
211: close c1;
212:
213: update ahl_supplier_documents
214: set supplier_id = p_to_fk_id,
215: last_update_date = SYSDATE,
216: last_updated_by = G_USER_ID,
217: last_update_login = G_LOGIN_ID

Line 229: 'AHL_SUPPLIER_DOCUMENTS for supplier_id = ' || p_from_fk_id );

225: exception
226: when resource_busy then
227: arp_message.set_line(g_proc_name || '.' || l_api_name ||
228: '; Could not obtain lock for records in table ' ||
229: 'AHL_SUPPLIER_DOCUMENTS for supplier_id = ' || p_from_fk_id );
230: x_return_status := FND_API.G_RET_STS_ERROR;
231: raise;
232:
233: when others then