DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on WF_ITEMS

Line 12: l_item_type wf_items.item_type%TYPE;

8: display_type in varchar2,
9: document in out NOCOPY varchar2,
10: document_type in out NOCOPY varchar2) IS
11:
12: l_item_type wf_items.item_type%TYPE;
13: l_item_key wf_items.item_key%TYPE;
14:
15: l_document_id po_headers.po_header_id%TYPE;
16: l_org_id po_headers.org_id%TYPE;

Line 13: l_item_key wf_items.item_key%TYPE;

9: document in out NOCOPY varchar2,
10: document_type in out NOCOPY varchar2) IS
11:
12: l_item_type wf_items.item_type%TYPE;
13: l_item_key wf_items.item_key%TYPE;
14:
15: l_document_id po_headers.po_header_id%TYPE;
16: l_org_id po_headers.org_id%TYPE;
17: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

Line 224: l_item_type wf_items.item_type%TYPE;

220: display_type in varchar2,
221: document in out NOCOPY CLOB, --
222: document_type in out NOCOPY varchar2) IS
223:
224: l_item_type wf_items.item_type%TYPE;
225: l_item_key wf_items.item_key%TYPE;
226:
227: l_document_id po_lines.po_header_id%TYPE;
228: l_org_id po_lines.org_id%TYPE;

Line 225: l_item_key wf_items.item_key%TYPE;

221: document in out NOCOPY CLOB, --
222: document_type in out NOCOPY varchar2) IS
223:
224: l_item_type wf_items.item_type%TYPE;
225: l_item_key wf_items.item_key%TYPE;
226:
227: l_document_id po_lines.po_header_id%TYPE;
228: l_org_id po_lines.org_id%TYPE;
229: l_document_type VARCHAR2(25);

Line 958: l_item_type wf_items.item_type%TYPE;

954: display_type in varchar2,
955: document in out NOCOPY varchar2,
956: document_type in out NOCOPY varchar2) IS
957:
958: l_item_type wf_items.item_type%TYPE;
959: l_item_key wf_items.item_key%TYPE;
960:
961: l_document_id po_lines.po_header_id%TYPE;
962: l_org_id po_lines.org_id%TYPE;

Line 959: l_item_key wf_items.item_key%TYPE;

955: document in out NOCOPY varchar2,
956: document_type in out NOCOPY varchar2) IS
957:
958: l_item_type wf_items.item_type%TYPE;
959: l_item_key wf_items.item_key%TYPE;
960:
961: l_document_id po_lines.po_header_id%TYPE;
962: l_org_id po_lines.org_id%TYPE;
963: l_doc_type_code VARCHAR2(80);