APPS.PO_VENDORMERGE_GRP dependencies on PO_GA_ORG_ASSIGNMENTS

Line 276: UPDATE po_ga_org_assignments PGOA

272: -- Starting from 11i FPJ we no longer update ga org assignments based on
273: -- vendor site code. Instead we just need to update org assignment with
274: -- vendor site id that matches p_from_vendor_id
275:
276: UPDATE po_ga_org_assignments PGOA
277: SET PGOA.vendor_site_id = p_vendor_site_id,
278: PGOA.last_update_date = SYSDATE,
279: PGOA.last_updated_by = l_last_updated_by,
280: PGOA.last_update_login = FND_GLOBAL.login_id

Line 283: UPDATE po_ga_org_assignments_archive PGOA

279: PGOA.last_updated_by = l_last_updated_by,
280: PGOA.last_update_login = FND_GLOBAL.login_id
281: WHERE PGOA.vendor_site_id = p_dup_vendor_site_id;
282:
283: UPDATE po_ga_org_assignments_archive PGOA
284: SET PGOA.vendor_site_id = p_vendor_site_id,
285: PGOA.last_update_date = SYSDATE,
286: PGOA.last_updated_by = l_last_updated_by,
287: PGOA.last_update_login = FND_GLOBAL.login_id

Line 291: PO_LOG.stmt(d_module, d_progress, 'updated PO_GA_ORG_ASSIGNMENTS');

287: PGOA.last_update_login = FND_GLOBAL.login_id
288: WHERE PGOA.vendor_site_id = p_dup_vendor_site_id;
289:
290: IF (PO_LOG.d_stmt) THEN
291: PO_LOG.stmt(d_module, d_progress, 'updated PO_GA_ORG_ASSIGNMENTS');
292: END IF;
293:
294: -- modify PO_REQUISITION_LINES
295: UPDATE PO_REQUISITION_LINES