DBA Data[Home] [Help]

APPS.PO_VENDORMERGE_GRP dependencies on PO_HEADERS_ARCHIVE

Line 192: -- modify PO_HEADERS_ARCHIVE

188:
189:
190: --Bug 5435716 END
191:
192: -- modify PO_HEADERS_ARCHIVE
193: UPDATE po_headers_archive pha
194: SET pha.vendor_id = p_vendor_id,
195: pha.vendor_site_id = p_vendor_site_id
196: WHERE pha.vendor_id = p_dup_vendor_id

Line 193: UPDATE po_headers_archive pha

189:
190: --Bug 5435716 END
191:
192: -- modify PO_HEADERS_ARCHIVE
193: UPDATE po_headers_archive pha
194: SET pha.vendor_id = p_vendor_id,
195: pha.vendor_site_id = p_vendor_site_id
196: WHERE pha.vendor_id = p_dup_vendor_id
197: AND pha.vendor_site_id = p_dup_vendor_site_id

Line 204: PO_LOG.stmt(d_module, d_progress, 'updated PO_HEADERS_ARCHIVE');

200: WHERE pods.style_id = pha.style_id
201: AND NVL(pods.CLM_FLAG,'N') = 'Y');
202:
203: IF (PO_LOG.d_stmt) THEN
204: PO_LOG.stmt(d_module, d_progress, 'updated PO_HEADERS_ARCHIVE');
205: END IF;
206:
207:
208: -- modify PO_VENDOR_LIST_ENTRIES