DBA Data[Home] [Help]

APPS.PO_WF_REQ_NOTIFICATION dependencies on WF_ITEMS

Line 201: l_item_type wf_items.item_type%TYPE;

197: display_type in varchar2,
198: document in out NOCOPY varchar2,
199: document_type in out NOCOPY varchar2) IS
200: max_seqno number;
201: l_item_type wf_items.item_type%TYPE;
202: l_item_key wf_items.item_key%TYPE;
203:
204: l_document_id po_requisition_headers.requisition_header_id%TYPE;
205: l_org_id po_requisition_headers.org_id%TYPE;

Line 202: l_item_key wf_items.item_key%TYPE;

198: document in out NOCOPY varchar2,
199: document_type in out NOCOPY varchar2) IS
200: max_seqno number;
201: l_item_type wf_items.item_type%TYPE;
202: l_item_key wf_items.item_key%TYPE;
203:
204: l_document_id po_requisition_headers.requisition_header_id%TYPE;
205: l_org_id po_requisition_headers.org_id%TYPE;
206: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;

Line 446: l_item_type wf_items.item_type%TYPE;

442: display_type in varchar2,
443: document in out NOCOPY varchar2,
444: document_type in out NOCOPY varchar2) IS
445: max_seqno number;
446: l_item_type wf_items.item_type%TYPE;
447: l_item_key wf_items.item_key%TYPE;
448:
449: l_document_id po_requisition_headers.requisition_header_id%TYPE;
450: l_org_id po_requisition_headers.org_id%TYPE;

Line 447: l_item_key wf_items.item_key%TYPE;

443: document in out NOCOPY varchar2,
444: document_type in out NOCOPY varchar2) IS
445: max_seqno number;
446: l_item_type wf_items.item_type%TYPE;
447: l_item_key wf_items.item_key%TYPE;
448:
449: l_document_id po_requisition_headers.requisition_header_id%TYPE;
450: l_org_id po_requisition_headers.org_id%TYPE;
451: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;

Line 716: l_item_type wf_items.item_type%TYPE;

712: display_type in varchar2,
713: document in out NOCOPY varchar2,
714: document_type in out NOCOPY varchar2) IS
715: max_seqno number;
716: l_item_type wf_items.item_type%TYPE;
717: l_item_key wf_items.item_key%TYPE;
718:
719: l_document_id po_requisition_headers.requisition_header_id%TYPE;
720: l_org_id po_requisition_headers.org_id%TYPE;

Line 717: l_item_key wf_items.item_key%TYPE;

713: document in out NOCOPY varchar2,
714: document_type in out NOCOPY varchar2) IS
715: max_seqno number;
716: l_item_type wf_items.item_type%TYPE;
717: l_item_key wf_items.item_key%TYPE;
718:
719: l_document_id po_requisition_headers.requisition_header_id%TYPE;
720: l_org_id po_requisition_headers.org_id%TYPE;
721: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;

Line 941: l_item_type wf_items.item_type%TYPE;

937: display_type in varchar2,
938: document in out NOCOPY varchar2,
939: document_type in out NOCOPY varchar2) IS
940: max_seqno number;
941: l_item_type wf_items.item_type%TYPE;
942: l_item_key wf_items.item_key%TYPE;
943:
944: l_document_id po_requisition_headers.requisition_header_id%TYPE;
945: l_org_id po_requisition_headers.org_id%TYPE;

Line 942: l_item_key wf_items.item_key%TYPE;

938: document in out NOCOPY varchar2,
939: document_type in out NOCOPY varchar2) IS
940: max_seqno number;
941: l_item_type wf_items.item_type%TYPE;
942: l_item_key wf_items.item_key%TYPE;
943:
944: l_document_id po_requisition_headers.requisition_header_id%TYPE;
945: l_org_id po_requisition_headers.org_id%TYPE;
946: -- l_document_subtype po_lookup_codes.displayed_field%TYPE;

Line 1168: l_item_type wf_items.item_type%TYPE;

1164: display_type in varchar2,
1165: document in out NOCOPY varchar2,
1166: document_type in out NOCOPY varchar2) IS
1167:
1168: l_item_type wf_items.item_type%TYPE;
1169: l_item_key wf_items.item_key%TYPE;
1170:
1171: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1172: l_org_id po_requisition_lines.org_id%TYPE;

Line 1169: l_item_key wf_items.item_key%TYPE;

1165: document in out NOCOPY varchar2,
1166: document_type in out NOCOPY varchar2) IS
1167:
1168: l_item_type wf_items.item_type%TYPE;
1169: l_item_key wf_items.item_key%TYPE;
1170:
1171: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1172: l_org_id po_requisition_lines.org_id%TYPE;
1173:

Line 1397: l_item_type wf_items.item_type%TYPE;

1393: dist_num number;
1394: multiple_cost_center VARCHAR2(100):= '';
1395:
1396:
1397: l_item_type wf_items.item_type%TYPE;
1398: l_item_key wf_items.item_key%TYPE;
1399:
1400: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1401: l_org_id po_requisition_lines.org_id%TYPE;

Line 1398: l_item_key wf_items.item_key%TYPE;

1394: multiple_cost_center VARCHAR2(100):= '';
1395:
1396:
1397: l_item_type wf_items.item_type%TYPE;
1398: l_item_key wf_items.item_key%TYPE;
1399:
1400: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1401: l_org_id po_requisition_lines.org_id%TYPE;
1402:

Line 1884: l_item_type wf_items.item_type%TYPE;

1880: document in out NOCOPY varchar2,
1881: document_type in out NOCOPY varchar2) IS
1882:
1883:
1884: l_item_type wf_items.item_type%TYPE;
1885: l_item_key wf_items.item_key%TYPE;
1886:
1887: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1888: l_object_type po_action_history.object_type_code%TYPE;

Line 1885: l_item_key wf_items.item_key%TYPE;

1881: document_type in out NOCOPY varchar2) IS
1882:
1883:
1884: l_item_type wf_items.item_type%TYPE;
1885: l_item_key wf_items.item_key%TYPE;
1886:
1887: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1888: l_object_type po_action_history.object_type_code%TYPE;
1889: l_org_id po_requisition_lines.org_id%TYPE;

Line 2262: l_item_type wf_items.item_type%TYPE;

2258: display_type in varchar2,
2259: document in out NOCOPY varchar2,
2260: document_type in out NOCOPY varchar2) IS
2261:
2262: l_item_type wf_items.item_type%TYPE;
2263: l_item_key wf_items.item_key%TYPE;
2264:
2265: l_document_id po_requisition_lines.requisition_header_id%TYPE;
2266: l_object_type po_action_history.object_type_code%TYPE;

Line 2263: l_item_key wf_items.item_key%TYPE;

2259: document in out NOCOPY varchar2,
2260: document_type in out NOCOPY varchar2) IS
2261:
2262: l_item_type wf_items.item_type%TYPE;
2263: l_item_key wf_items.item_key%TYPE;
2264:
2265: l_document_id po_requisition_lines.requisition_header_id%TYPE;
2266: l_object_type po_action_history.object_type_code%TYPE;
2267: l_org_id po_requisition_lines.org_id%TYPE;