eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

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 2321: l_item_type wf_items.item_type%TYPE;

2317: display_type in varchar2,
2318: document in out NOCOPY varchar2,
2319: document_type in out NOCOPY varchar2) IS
2320:
2321: l_item_type wf_items.item_type%TYPE;
2322: l_item_key wf_items.item_key%TYPE;
2323:
2324: l_document_id po_requisition_lines.requisition_header_id%TYPE;
2325: l_object_type po_action_history.object_type_code%TYPE;

Line 2322: l_item_key wf_items.item_key%TYPE;

2318: document in out NOCOPY varchar2,
2319: document_type in out NOCOPY varchar2) IS
2320:
2321: l_item_type wf_items.item_type%TYPE;
2322: l_item_key wf_items.item_key%TYPE;
2323:
2324: l_document_id po_requisition_lines.requisition_header_id%TYPE;
2325: l_object_type po_action_history.object_type_code%TYPE;
2326: l_org_id po_requisition_lines.org_id%TYPE;

Line 2883: from wf_items

2879: l_session_appl_id := fnd_global.resp_appl_id;
2880:
2881: select PARENT_ITEM_TYPE, PARENT_ITEM_KEY
2882: into p_itemtype,p_itemkey
2883: from wf_items
2884: where item_type = itemtype and item_key =itemkey;
2885:
2886: if ( l_is_ame_approval = 'Y' ) then
2887: l_progress := 'notif callback watch for l_is_ame_approval p_itemtype,'||p_itemtype ||' p_itemkey ' || p_itemkey ;