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;
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;
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;
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;
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;
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;
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;
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;
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;
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:
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;
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:
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;
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;
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;
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;