DBA Data[Home] [Help]

APPS.PO_SECURITY_CHECK_SV dependencies on PO_HEADERS_ALL

Line 32: x_wf_item_type po_headers_all.wf_item_type%type := NULL;

28: x_count number := 0;
29:
30: l_authorization_status varchar2(25);
31:
32: x_wf_item_type po_headers_all.wf_item_type%type := NULL;
33: x_wf_item_key po_headers_all.wf_item_key%type := NULL; -- Modified for Bug 2783162
34:
35: BEGIN
36:

Line 33: x_wf_item_key po_headers_all.wf_item_key%type := NULL; -- Modified for Bug 2783162

29:
30: l_authorization_status varchar2(25);
31:
32: x_wf_item_type po_headers_all.wf_item_type%type := NULL;
33: x_wf_item_key po_headers_all.wf_item_key%type := NULL; -- Modified for Bug 2783162
34:
35: BEGIN
36:
37: IF x_type_lookup_code = 'RELEASE' THEN

Line 89: from po_headers_all

85:
86: select NVL(AUTHORIZATION_STATUS, 'INCOMPLETE'),
87: wf_item_type, wf_item_key
88: into l_authorization_status, x_wf_item_type, x_wf_item_key
89: from po_headers_all
90: where PO_HEADER_ID = x_object_id;
91:
92: ELSIF x_document_type_code = 'RELEASE' THEN
93: x_progress := '008'; -- Added for bug 2783162