APPS.PO_VENDORMERGE_GRP dependencies on PO_HEADERS

Line 107: UPDATE po_headers

103:
104: d_progress := 10;
105:
106: --Bug 5435716 START
107: UPDATE po_headers
108: SET vendor_id = p_vendor_id,
109: vendor_site_id = p_vendor_site_id,
110: last_updated_by = l_last_updated_by,
111: last_update_date = sysdate

Line 130: -- modify PO_HEADERS_ARCHIVE

126:
127:
128: --Bug 5435716 END
129:
130: -- modify PO_HEADERS_ARCHIVE
131: UPDATE po_headers_archive
132: SET vendor_id = p_vendor_id,
133: vendor_site_id = p_vendor_site_id
134: WHERE vendor_id = p_dup_vendor_id

Line 131: UPDATE po_headers_archive

127:
128: --Bug 5435716 END
129:
130: -- modify PO_HEADERS_ARCHIVE
131: UPDATE po_headers_archive
132: SET vendor_id = p_vendor_id,
133: vendor_site_id = p_vendor_site_id
134: WHERE vendor_id = p_dup_vendor_id
135: AND vendor_site_id = p_dup_vendor_site_id ;

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

134: WHERE vendor_id = p_dup_vendor_id
135: AND vendor_site_id = p_dup_vendor_site_id ;
136:
137: IF (PO_LOG.d_stmt) THEN
138: PO_LOG.stmt(d_module, d_progress, 'updated PO_HEADERS_ARCHIVE');
139: END IF;
140:
141:
142: -- modify PO_VENDOR_LIST_ENTRIES