eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AP_PARTYMERGE_GRP dependencies on FND_LOG

Line 4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1: PACKAGE BODY AP_PartyMerge_GRP AS
2: /* $Header: apgsmrgb.pls 120.5 2011/05/04 09:40:52 kpasikan ship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_PartyMerge_PKG';
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_PartyMerge_GRP';
8:

Line 5: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;

1: PACKAGE BODY AP_PartyMerge_GRP AS
2: /* $Header: apgsmrgb.pls 120.5 2011/05/04 09:40:52 kpasikan ship $ */
3:
4: G_CURRENT_RUNTIME_LEVEL CONSTANT NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
5: G_LEVEL_STATEMENT CONSTANT NUMBER := FND_LOG.LEVEL_STATEMENT;
6: G_MODULE_NAME CONSTANT VARCHAR2(100) := 'AP.PLSQL.AP_PartyMerge_PKG';
7: G_PKG_NAME CONSTANT VARCHAR2(30) := 'AP_PartyMerge_GRP';
8:
9: --

Line 37: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

33:
34: x_return_status := FND_API.G_RET_STS_SUCCESS;
35:
36: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
37: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
38: 'p_Entity_name: '|| p_Entity_name);
39: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
40: 'p_from_id: '|| p_from_id);
41: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 39: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

35:
36: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
37: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
38: 'p_Entity_name: '|| p_Entity_name);
39: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
40: 'p_from_id: '|| p_from_id);
41: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
42: 'p_to_id: '|| p_to_id);
43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 41: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

37: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
38: 'p_Entity_name: '|| p_Entity_name);
39: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
40: 'p_from_id: '|| p_from_id);
41: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
42: 'p_to_id: '|| p_to_id);
43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
44: 'p_From_FK_id: '|| p_From_FK_id);
45: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

39: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
40: 'p_from_id: '|| p_from_id);
41: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
42: 'p_to_id: '|| p_to_id);
43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
44: 'p_From_FK_id: '|| p_From_FK_id);
45: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
46: 'p_To_FK_id: '|| p_To_FK_id);
47: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 45: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

41: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
42: 'p_to_id: '|| p_to_id);
43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
44: 'p_From_FK_id: '|| p_From_FK_id);
45: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
46: 'p_To_FK_id: '|| p_To_FK_id);
47: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
48: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
49: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 47: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

43: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
44: 'p_From_FK_id: '|| p_From_FK_id);
45: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
46: 'p_To_FK_id: '|| p_To_FK_id);
47: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
48: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
49: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
50: 'p_batch_id: '|| p_batch_id);
51: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 49: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

45: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
46: 'p_To_FK_id: '|| p_To_FK_id);
47: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
48: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
49: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
50: 'p_batch_id: '|| p_batch_id);
51: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
52: 'p_Batch_Party_id: '|| p_Batch_Party_id);
53: END IF;

Line 51: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

47: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
48: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
49: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
50: 'p_batch_id: '|| p_batch_id);
51: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
52: 'p_Batch_Party_id: '|| p_Batch_Party_id);
53: END IF;
54:
55: ------------------------------------------------------------------------

Line 59: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

55: ------------------------------------------------------------------------
56: l_debug_info := 'Validating Veto Rule One';
57: ------------------------------------------------------------------------
58: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
59: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
60: END IF;
61:
62: -- Veto Rule 1
63: -- there could be three cases

Line 92: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

88: ------------------------------------------------------------------------
89: l_debug_info := 'Validating Veto Rule Two';
90: ------------------------------------------------------------------------
91: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
92: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
93: END IF;
94:
95: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
96:

Line 125: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

121: ------------------------------------------------------------------------
122: l_debug_info := 'Validating Veto Rule Three';
123: ------------------------------------------------------------------------
124: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
125: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
126: END IF;
127:
128: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
129:

Line 172: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

168: ------------------------------------------------------------------------
169: l_debug_info := 'Validating Veto Rule Four';
170: ------------------------------------------------------------------------
171: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
172: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
173: END IF;
174:
175: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
176:

Line 205: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

201: ------------------------------------------------------------------------
202: l_debug_info := 'Validating Veto Rule Five';
203: ------------------------------------------------------------------------
204: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
205: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
206: END IF;
207:
208: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
209:

Line 297: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

293:
294: x_return_status := FND_API.G_RET_STS_SUCCESS;
295:
296: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
297: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
298: 'p_Entity_name: '|| p_Entity_name);
299: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
300: 'p_from_id: '|| p_from_id);
301: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 299: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

295:
296: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
297: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
298: 'p_Entity_name: '|| p_Entity_name);
299: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
300: 'p_from_id: '|| p_from_id);
301: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
302: 'p_to_id: '|| p_to_id);
303: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 301: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

297: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
298: 'p_Entity_name: '|| p_Entity_name);
299: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
300: 'p_from_id: '|| p_from_id);
301: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
302: 'p_to_id: '|| p_to_id);
303: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
304: 'p_From_FK_id: '|| p_From_FK_id);
305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 303: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

299: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
300: 'p_from_id: '|| p_from_id);
301: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
302: 'p_to_id: '|| p_to_id);
303: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
304: 'p_From_FK_id: '|| p_From_FK_id);
305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
306: 'p_To_FK_id: '|| p_To_FK_id);
307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

301: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
302: 'p_to_id: '|| p_to_id);
303: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
304: 'p_From_FK_id: '|| p_From_FK_id);
305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
306: 'p_To_FK_id: '|| p_To_FK_id);
307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
308: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
309: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

303: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
304: 'p_From_FK_id: '|| p_From_FK_id);
305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
306: 'p_To_FK_id: '|| p_To_FK_id);
307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
308: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
309: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
310: 'p_batch_id: '|| p_batch_id);
311: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

Line 309: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

305: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
306: 'p_To_FK_id: '|| p_To_FK_id);
307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
308: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
309: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
310: 'p_batch_id: '|| p_batch_id);
311: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
312: 'p_Batch_Party_id: '|| p_Batch_Party_id);
313: END IF;

Line 311: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,

307: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
308: 'p_Parent_Entity_name: '|| p_Parent_Entity_name);
309: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
310: 'p_batch_id: '|| p_batch_id);
311: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,
312: 'p_Batch_Party_id: '|| p_Batch_Party_id);
313: END IF;
314:
315: ------------------------------------------------------------------------

Line 319: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

315: ------------------------------------------------------------------------
316: l_debug_info := 'Validating Veto Rule One';
317: ------------------------------------------------------------------------
318: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
319: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
320: END IF;
321:
322: -- Veto Rule 1
323: -- there could be four cases

Line 366: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

362: ------------------------------------------------------------------------
363: l_debug_info := 'Validating Veto Rule Two';
364: ------------------------------------------------------------------------
365: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
366: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
367: END IF;
368:
369: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
370:

Line 403: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

399: ------------------------------------------------------------------------
400: l_debug_info := 'Validating Veto Rule Three';
401: ------------------------------------------------------------------------
402: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
403: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
404: END IF;
405:
406: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
407:

Line 452: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

448: ------------------------------------------------------------------------
449: l_debug_info := 'Validating Veto Rule Four';
450: ------------------------------------------------------------------------
451: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
452: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
453: END IF;
454:
455: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
456:

Line 492: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

488: ------------------------------------------------------------------------
489: l_debug_info := 'Validating Veto Rule Five';
490: ------------------------------------------------------------------------
491: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
492: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
493: END IF;
494:
495: IF x_return_status <> FND_API.G_RET_STS_ERROR THEN
496:

Line 589: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

585: ------------------------------------------------------------------------
586: l_debug_info := 'Updating po_vendor_contacts';
587: ------------------------------------------------------------------------
588: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
589: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
590: END IF;
591:
592: UPDATE ap_supplier_contacts
593: --po_vendor_contacts

Line 647: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

643: ------------------------------------------------------------------------
644: l_debug_info := 'Updating po_vendor_contacts';
645: ------------------------------------------------------------------------
646: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
647: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
648: END IF;
649:
650: UPDATE ap_supplier_contacts
651: --po_vendor_contacts

Line 705: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

701: ------------------------------------------------------------------------
702: l_debug_info := 'Updating po_vendor_contacts';
703: ------------------------------------------------------------------------
704: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
705: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
706: END IF;
707:
708: UPDATE ap_supplier_contacts
709: -- po_vendor_contacts

Line 760: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

756: ------------------------------------------------------------------------
757: l_debug_info := 'Updating po_vendor_contacts';
758: ------------------------------------------------------------------------
759: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
760: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
761: END IF;
762:
763: UPDATE ap_supplier_contacts
764: SET relationship_id = new_relship_id

Line 814: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);

810: ------------------------------------------------------------------------
811: l_debug_info := 'Updating po_vendor_contacts';
812: ------------------------------------------------------------------------
813: IF (G_LEVEL_STATEMENT >= G_CURRENT_RUNTIME_LEVEL) THEN
814: FND_LOG.STRING(G_LEVEL_STATEMENT,G_MODULE_NAME||l_api_name,l_debug_info);
815: END IF;
816:
817: UPDATE ap_supplier_contacts
818: SET org_contact_id = new_orgcontact_id