DBA Data[Home] [Help]

APPS.PO_CHANGE_API1_S dependencies on PO_HEADERS_ALL

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 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),