APPS.PO_MASS_UPDATE dependencies on PO_RELEASES

Line 49: from po_releases por,

45: select por.rowid,
46: poh.segment1,
47: por.release_num,
48: pdt.type_name
49: from po_releases por,
50: po_headers poh,
51: po_document_types_vl pdt
52: where por.po_header_id = poh.po_header_id
53: and por.agent_id = x_old_buyer_id

Line 66: x_rel_num po_releases.release_num%TYPE;

62: x_po_rowid ROWID;
63: x_rel_rowid ROWID;
64: x_doc_type po_document_types_all.type_name%TYPE;
65: x_po_num po_headers.segment1%TYPE;
66: x_rel_num po_releases.release_num%TYPE;
67: x_old_buyer_name varchar2(240);
68: x_new_buyer_name varchar2(240);
69: x_org_id number;
70:

Line 355: update po_releases_all

351: /* Bug#3082301 Added the WHO columns to the below update statement so that
352: ** Mass Update Buyer Name Program will update the WHO columns also on all
353: ** Purchasing Documents(Releases) which are effected by the program.
354: */
355: update po_releases_all
356: set agent_id = x_new_buyer_id,
357: last_update_date = sysdate,
358: last_updated_by = fnd_global.user_id,
359: last_update_login = fnd_global.login_id