DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTNOTIF_PVT dependencies on WF_ITEMS

Line 267: l_item_type wf_items.item_type%TYPE;

263: display_type in varchar2,
264: document in out nocopy clob,
265: document_type in out nocopy varchar2) IS
266: max_seqno number;
267: l_item_type wf_items.item_type%TYPE;
268: l_item_key wf_items.item_key%TYPE;
269:
270: l_document_id po_requisition_headers.requisition_header_id%TYPE;
271: l_org_id po_requisition_headers.org_id%TYPE;

Line 268: l_item_key wf_items.item_key%TYPE;

264: document in out nocopy clob,
265: document_type in out nocopy varchar2) IS
266: max_seqno number;
267: l_item_type wf_items.item_type%TYPE;
268: l_item_key wf_items.item_key%TYPE;
269:
270: l_document_id po_requisition_headers.requisition_header_id%TYPE;
271: l_org_id po_requisition_headers.org_id%TYPE;
272: l_document_subtype po_lookup_codes.displayed_field%TYPE;

Line 443: l_item_type wf_items.item_type%TYPE;

439: display_type in varchar2,
440: document in out nocopy clob,
441: document_type in out nocopy varchar2) IS
442: max_seqno number;
443: l_item_type wf_items.item_type%TYPE;
444: l_item_key wf_items.item_key%TYPE;
445:
446: l_change_request_group_id number;
447:

Line 444: l_item_key wf_items.item_key%TYPE;

440: document in out nocopy clob,
441: document_type in out nocopy varchar2) IS
442: max_seqno number;
443: l_item_type wf_items.item_type%TYPE;
444: l_item_key wf_items.item_key%TYPE;
445:
446: l_change_request_group_id number;
447:
448: l_document_id po_requisition_headers.requisition_header_id%TYPE;

Line 605: l_item_type wf_items.item_type%TYPE;

601: dist_num number;
602: multiple_cost_center VARCHAR2(100):= '';
603:
604:
605: l_item_type wf_items.item_type%TYPE;
606: l_item_key wf_items.item_key%TYPE;
607:
608: l_document_id po_requisition_lines.requisition_header_id%TYPE;
609: l_org_id po_requisition_lines.org_id%TYPE;

Line 606: l_item_key wf_items.item_key%TYPE;

602: multiple_cost_center VARCHAR2(100):= '';
603:
604:
605: l_item_type wf_items.item_type%TYPE;
606: l_item_key wf_items.item_key%TYPE;
607:
608: l_document_id po_requisition_lines.requisition_header_id%TYPE;
609: l_org_id po_requisition_lines.org_id%TYPE;
610:

Line 1117: l_item_type wf_items.item_type%TYPE;

1113: dist_num number;
1114: multiple_cost_center VARCHAR2(100):= '';
1115:
1116:
1117: l_item_type wf_items.item_type%TYPE;
1118: l_item_key wf_items.item_key%TYPE;
1119:
1120: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1121: l_org_id po_requisition_lines.org_id%TYPE;

Line 1118: l_item_key wf_items.item_key%TYPE;

1114: multiple_cost_center VARCHAR2(100):= '';
1115:
1116:
1117: l_item_type wf_items.item_type%TYPE;
1118: l_item_key wf_items.item_key%TYPE;
1119:
1120: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1121: l_org_id po_requisition_lines.org_id%TYPE;
1122:

Line 1628: l_item_type wf_items.item_type%TYPE;

1624: document in out NOCOPY varchar2,
1625: document_type in out NOCOPY varchar2) IS
1626:
1627:
1628: l_item_type wf_items.item_type%TYPE;
1629: l_item_key wf_items.item_key%TYPE;
1630:
1631: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1632: l_object_type po_action_history.object_type_code%TYPE;

Line 1629: l_item_key wf_items.item_key%TYPE;

1625: document_type in out NOCOPY varchar2) IS
1626:
1627:
1628: l_item_type wf_items.item_type%TYPE;
1629: l_item_key wf_items.item_key%TYPE;
1630:
1631: l_document_id po_requisition_lines.requisition_header_id%TYPE;
1632: l_object_type po_action_history.object_type_code%TYPE;
1633: l_org_id po_requisition_lines.org_id%TYPE;

Line 3849: l_item_type wf_items.item_type%type;

3845: display_type in Varchar2,
3846: document in out nocopy varchar2,
3847: document_type in out nocopy varchar2)
3848: is
3849: l_item_type wf_items.item_type%type;
3850: l_item_key wf_items.item_key%type;
3851: begin
3852: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
3853: l_item_key := substr(document_id, instr(document_id, ':') + 1,

Line 3850: l_item_key wf_items.item_key%type;

3846: document in out nocopy varchar2,
3847: document_type in out nocopy varchar2)
3848: is
3849: l_item_type wf_items.item_type%type;
3850: l_item_key wf_items.item_key%type;
3851: begin
3852: l_item_type := substr(document_id, 1, instr(document_id, ':') - 1);
3853: l_item_key := substr(document_id, instr(document_id, ':') + 1,
3854: length(document_id) - 2);