DBA Data[Home] [Help]

APPS.PO_WF_PO_NOTIFICATION dependencies on WF_ITEMS

Line 24: l_item_type wf_items.item_type%TYPE;

20: display_type in varchar2,
21: document in out NOCOPY varchar2,
22: document_type in out NOCOPY varchar2) IS
23:
24: l_item_type wf_items.item_type%TYPE;
25: l_item_key wf_items.item_key%TYPE;
26:
27: l_document_id po_headers.po_header_id%TYPE;
28: l_org_id po_headers.org_id%TYPE;

Line 25: l_item_key wf_items.item_key%TYPE;

21: document in out NOCOPY varchar2,
22: document_type in out NOCOPY varchar2) IS
23:
24: l_item_type wf_items.item_type%TYPE;
25: l_item_key wf_items.item_key%TYPE;
26:
27: l_document_id po_headers.po_header_id%TYPE;
28: l_org_id po_headers.org_id%TYPE;
29: l_currency_code fnd_currencies.CURRENCY_CODE%TYPE;

Line 305: l_item_type wf_items.item_type%TYPE;

301: display_type in varchar2,
302: document in out NOCOPY CLOB, --
303: document_type in out NOCOPY varchar2) IS
304:
305: l_item_type wf_items.item_type%TYPE;
306: l_item_key wf_items.item_key%TYPE;
307:
308: l_document_id po_lines.po_header_id%TYPE;
309: l_org_id po_lines.org_id%TYPE;

Line 306: l_item_key wf_items.item_key%TYPE;

302: document in out NOCOPY CLOB, --
303: document_type in out NOCOPY varchar2) IS
304:
305: l_item_type wf_items.item_type%TYPE;
306: l_item_key wf_items.item_key%TYPE;
307:
308: l_document_id po_lines.po_header_id%TYPE;
309: l_org_id po_lines.org_id%TYPE;
310: l_document_type VARCHAR2(25);

Line 1221: l_item_type wf_items.item_type%TYPE;

1217: display_type in varchar2,
1218: document in out NOCOPY varchar2,
1219: document_type in out NOCOPY varchar2) IS
1220:
1221: l_item_type wf_items.item_type%TYPE;
1222: l_item_key wf_items.item_key%TYPE;
1223:
1224: l_document_id po_lines.po_header_id%TYPE;
1225: l_org_id po_lines.org_id%TYPE;

Line 1222: l_item_key wf_items.item_key%TYPE;

1218: document in out NOCOPY varchar2,
1219: document_type in out NOCOPY varchar2) IS
1220:
1221: l_item_type wf_items.item_type%TYPE;
1222: l_item_key wf_items.item_key%TYPE;
1223:
1224: l_document_id po_lines.po_header_id%TYPE;
1225: l_org_id po_lines.org_id%TYPE;
1226: l_doc_type_code VARCHAR2(80);