APPS.PO_MASS_UPDATE dependencies on PO_HEADERS

Line 28: from po_headers poh,

24: poh.po_header_id, --
25: poh.type_lookup_code, --
26: poh.revision_num, --
27: NVL(poh.conterms_exist_flag, 'N') --
28: from po_headers poh,
29: po_document_types_vl pdt
30: where poh.agent_id = x_old_buyer_id
31: and nvl(poh.authorization_status,'INCOMPLETE') in ('APPROVED','REQUIRES REAPPROVAL','INCOMPLETE','REJECTED')
32: and nvl(poh.closed_code,'OPEN') not in ('CLOSED','FINALLY CLOSED')

Line 51: po_headers poh,

47: por.release_num,
48: pdt.type_name,
49: por.po_release_id--8551445
50: from po_releases por,
51: po_headers poh,
52: po_document_types_vl pdt
53: where por.po_header_id = poh.po_header_id
54: and por.agent_id = x_old_buyer_id
55: and nvl(por.authorization_status,'INCOMPLETE') in ('APPROVED','REQUIRES REAPPROVAL','INCOMPLETE','REJECTED')

Line 66: x_po_num po_headers.segment1%TYPE;

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

Line 94: l_document_id po_headers.po_header_id%TYPE;

90:
91: /* CONTERMS FPJ */
92: l_api_name VARCHAR2(30) := 'po_update_buyer';
93:
94: l_document_id po_headers.po_header_id%TYPE;
95: l_document_type po_headers.type_lookup_code%TYPE;
96: l_document_version po_headers.revision_num%TYPE;
97: l_conterms_exist_flag po_headers.conterms_exist_flag%TYPE;
98:

Line 95: l_document_type po_headers.type_lookup_code%TYPE;

91: /* CONTERMS FPJ */
92: l_api_name VARCHAR2(30) := 'po_update_buyer';
93:
94: l_document_id po_headers.po_header_id%TYPE;
95: l_document_type po_headers.type_lookup_code%TYPE;
96: l_document_version po_headers.revision_num%TYPE;
97: l_conterms_exist_flag po_headers.conterms_exist_flag%TYPE;
98:
99: -- contracts dependency

Line 96: l_document_version po_headers.revision_num%TYPE;

92: l_api_name VARCHAR2(30) := 'po_update_buyer';
93:
94: l_document_id po_headers.po_header_id%TYPE;
95: l_document_type po_headers.type_lookup_code%TYPE;
96: l_document_version po_headers.revision_num%TYPE;
97: l_conterms_exist_flag po_headers.conterms_exist_flag%TYPE;
98:
99: -- contracts dependency
100: l_contracts_document_type VARCHAR2(150);

Line 97: l_conterms_exist_flag po_headers.conterms_exist_flag%TYPE;

93:
94: l_document_id po_headers.po_header_id%TYPE;
95: l_document_type po_headers.type_lookup_code%TYPE;
96: l_document_version po_headers.revision_num%TYPE;
97: l_conterms_exist_flag po_headers.conterms_exist_flag%TYPE;
98:
99: -- contracts dependency
100: l_contracts_document_type VARCHAR2(150);
101: SUBTYPE busdocs_tbl_type IS okc_manage_deliverables_grp.busdocs_tbl_type;

Line 229: update po_headers_all

225: /* Bug#3082301 Added the WHO columns to the below update statement so that
226: ** Mass Update Buyer Name Program will update the WHO columns also on all
227: ** Purchasing Documents(POs) which are effected by the program.
228: */
229: update po_headers_all
230: set agent_id = x_new_buyer_id,
231: last_update_date = sysdate,
232: last_updated_by = fnd_global.user_id,
233: last_update_login = fnd_global.login_id

Line 239: UPDATE po_headers_archive_all

235:
236: --Bug 8551445, update archive also.
237:
238: BEGIN
239: UPDATE po_headers_archive_all
240: SET agent_id = x_new_buyer_id,
241: last_update_date = sysdate,
242: last_updated_by = fnd_global.user_id,
243: last_update_login = fnd_global.login_id