APPS.PO_DOCUMENT_CONTROL_PUB dependencies on PO_HEADERS

Line 39: p_doc_num IN PO_HEADERS.segment1%TYPE,

35: x_return_status OUT NOCOPY VARCHAR2,
36: p_doc_type IN PO_DOCUMENT_TYPES.document_type_code%TYPE,
37: p_doc_subtype IN PO_DOCUMENT_TYPES.document_subtype%TYPE,
38: p_doc_id IN NUMBER,
39: p_doc_num IN PO_HEADERS.segment1%TYPE,
40: p_release_id IN NUMBER,
41: p_release_num IN NUMBER,
42: p_doc_line_id IN NUMBER,
43: p_doc_line_num IN NUMBER,

Line 51: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,

47: p_action_date IN DATE,
48: p_cancel_reason IN PO_LINES.cancel_reason%TYPE,
49: p_cancel_reqs_flag IN VARCHAR2,
50: p_print_flag IN VARCHAR2,
51: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,
52: p_use_gldate IN VARCHAR2, --
53: p_org_id IN NUMBER, --
54: p_launch_approvals_flag IN VARCHAR2 --
55: )

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

56: IS
57:
58: l_api_name CONSTANT VARCHAR2(30) := 'control_document';
59: l_api_version CONSTANT NUMBER := 1.0;
60: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;
61: BEGIN
62: -- Start standard API initialization
63: SAVEPOINT control_document_PUB;
64: IF FND_API.to_boolean(p_init_msg_list) THEN

Line 184: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,

180: p_cancel_reqs_flag IN VARCHAR2,
181: p_print_flag IN VARCHAR2,
182: p_revert_chg_flag IN VARCHAR2,
183: p_launch_approvals_flag IN VARCHAR2,
184: p_note_to_vendor IN PO_HEADERS.note_to_vendor%TYPE,
185: p_use_gldate IN VARCHAR2 DEFAULT NULL,
186: p_org_id IN NUMBER DEFAULT NULL
187: )
188: IS

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

188: IS
189:
190: l_api_name CONSTANT VARCHAR2(30) := 'control_document';
191: l_api_version CONSTANT NUMBER := 1.0;
192: l_org_id PO_HEADERS_ALL.org_id%type := p_org_id;
193:
194:
195: l_entity_dtl_rec_tbl po_document_action_pvt.entity_dtl_rec_type_tbl;
196: l_online_report_id NUMBER;

Line 332: FROM po_headers_all

328: ELSE
329:
330: SELECT authorization_status
331: INTO l_old_auth_status_tbl(i)
332: FROM po_headers_all
333: WHERE po_header_id= l_doc_id;
334:
335: END IF;
336: