APPS.PO_VENDORMERGE_GRP dependencies on PO_GA_ORG_ASSIGNMENTS

Line 342: UPDATE po_ga_org_assignments PGOA

338: -- Starting from 11i FPJ we no longer update ga org assignments based on
339: -- vendor site code. Instead we just need to update org assignment with
340: -- vendor site id that matches p_from_vendor_id
341:
342: UPDATE po_ga_org_assignments PGOA
343: SET PGOA.vendor_site_id = p_vendor_site_id,
344: PGOA.last_update_date = SYSDATE,
345: PGOA.last_updated_by = l_last_updated_by,
346: PGOA.last_update_login = FND_GLOBAL.login_id

Line 355: UPDATE po_ga_org_assignments_archive PGOA

351: WHERE pods.style_id = ph.style_id
352: AND ph.PO_HEADER_ID= pgoa.PO_HEADER_ID
353: AND NVL(pods.CLM_FLAG,'N') = 'Y');
354:
355: UPDATE po_ga_org_assignments_archive PGOA
356: SET PGOA.vendor_site_id = p_vendor_site_id,
357: PGOA.last_update_date = SYSDATE,
358: PGOA.last_updated_by = l_last_updated_by,
359: PGOA.last_update_login = FND_GLOBAL.login_id

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

364: WHERE pods.style_id = ph.style_id
365: AND ph.PO_HEADER_ID= pgoa.PO_HEADER_ID
366: AND NVL(pods.CLM_FLAG,'N') = 'Y');
367: IF (PO_LOG.d_stmt) THEN
368: PO_LOG.stmt(d_module, d_progress, 'updated PO_GA_ORG_ASSIGNMENTS');
369: END IF;
370:
371: -- modify PO_REQUISITION_LINES
372: UPDATE PO_REQUISITION_LINES prl