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 50: po_headers poh,

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
54: and nvl(por.authorization_status,'INCOMPLETE') in ('APPROVED','REQUIRES REAPPROVAL','INCOMPLETE','REJECTED')

Line 65: x_po_num po_headers.segment1%TYPE;

61:
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;

Line 93: l_document_id po_headers.po_header_id%TYPE;

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

Line 94: l_document_type po_headers.type_lookup_code%TYPE;

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

Line 95: l_document_version po_headers.revision_num%TYPE;

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

Line 96: l_conterms_exist_flag po_headers.conterms_exist_flag%TYPE;

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

Line 228: update po_headers_all

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