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 221: update PO_HEADERS

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

Line 291: from po_headers

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

Line 300: 'PO_HEADERS',

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

Line 312: 'PO_HEADERS',

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

Line 323: 'PO_HEADERS',

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

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

527: l_error_message PO_INTERFACE_ERRORS.ERROR_MESSAGE%TYPE;
528:
529: l_result NUMBER := 1;
530: l_return_status VARCHAR2(1);
531: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;
532: BEGIN
533:
534: IF NOT FND_API.Compatible_API_CALL ( l_api_version,
535: TO_NUMBER(VERSION,99.999),