APPS.PO_CHANGE_API1_S dependencies on PO_HEADERS

Line 43: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;

39: l_rowid ROWID;
40: l_Last_Update_Login PO_ACCEPTANCES.last_update_login%TYPE;
41: l_Last_Update_Date PO_ACCEPTANCES.last_update_date%TYPE;
42: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
43: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
44: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
45: -- End of Bug 2850566
46: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;
47: CURSOR c_po_header IS

Line 46: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;

42: l_Last_Updated_By PO_ACCEPTANCES.last_updated_by%TYPE;
43: l_acc_po_header_id PO_HEADERS_ALL.po_header_id%TYPE;
44: l_acceptance_id PO_ACCEPTANCES.acceptance_id%TYPE;
45: -- End of Bug 2850566
46: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;
47: CURSOR c_po_header IS
48: select PO_HEADER_ID
49: from PO_HEADERS
50: where segment1 = X_PO_NUMBER

Line 49: from PO_HEADERS

45: -- End of Bug 2850566
46: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;
47: CURSOR c_po_header IS
48: select PO_HEADER_ID
49: from PO_HEADERS
50: where segment1 = X_PO_NUMBER
51: and type_lookup_code in ('STANDARD', 'BLANKET', 'CONTRACT', 'PLANNED');
52:
53: CURSOR c_po_release IS

Line 132: 'PO_HEADERS',

128: if (c_po_header%NOTFOUND or l_po_header_id is null) then
129: PO_CHANGE_API1_S.insert_error(l_interface_type,
130: l_transaction_id,
131: 'PO_HEADER_ID',
132: 'PO_HEADERS',
133: 'PO_NOPOFOUND',
134: NULL,
135: NULL);
136: return 0;

Line 219: update PO_HEADERS

215:
216: IF (X_REVISION_NUMBER = l_current_revision) then
217: IF x_accepted_flag = 'Y' THEN
218: IF (l_po_release_id is null) then
219: update PO_HEADERS
220: /* Changed ACCEPTANCE_REQUIRED_FLAG value from null to N*/
221: set ACCEPTANCE_REQUIRED_FLAG = 'N', -- bug 4721255
222: ACCEPTANCE_DUE_DATE = null,
223: last_update_date = g_sysdate,

Line 289: from po_headers

285: l_status,
286: l_cancel_flag,
287: X_current_revision,
288: X_employee_id
289: from po_headers
290: where po_header_id = X_po_header_id;
291: END IF;
292:
293: if (l_closed_code = 'FINALLY CLOSED') then

Line 298: 'PO_HEADERS',

294: l_result := 0;
295: PO_CHANGE_API1_S.insert_error(X_interface_type,
296: X_transaction_id,
297: 'CLOSED_CODE',
298: 'PO_HEADERS',
299: 'PO_ALL_DOC_CANNOT_BE_OPENED',
300: NULL,
301: NULL);
302: end if;

Line 310: 'PO_HEADERS',

306: l_result := 0;
307: PO_CHANGE_API1_S.insert_error(X_interface_type,
308: X_transaction_id,
309: 'AUTHORIZATION_STATUS',
310: 'PO_HEADERS',
311: 'PO_ALL_DOC_CANNOT_BE_OPENED',
312: NULL,
313: NULL);
314: end if;

Line 321: 'PO_HEADERS',

317: l_result := 0;
318: PO_CHANGE_API1_S.insert_error(X_interface_type,
319: X_transaction_id,
320: 'CANCEL_FLAG',
321: 'PO_HEADERS',
322: 'PO_ALL_DOC_CANNOT_BE_OPENED',
323: NULL,
324: NULL);
325: end if;

Line 525: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;

521: l_error_message PO_INTERFACE_ERRORS.ERROR_MESSAGE%TYPE;
522:
523: l_result NUMBER := 1;
524: l_return_status VARCHAR2(1);
525: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;
526: BEGIN
527:
528: IF NOT FND_API.Compatible_API_CALL ( l_api_version,
529: TO_NUMBER(VERSION,99.999),