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.POR_AME_REQ_WF_PVT dependencies on WF_ITEMS

Line 296: l_item_key wf_items.item_key%TYPE;

292: resultout out NOCOPY varchar2) IS
293:
294: l_progress VARCHAR2(500) := '000';
295: l_document_id number;
296: l_item_key wf_items.item_key%TYPE;
297: l_next_approver_id number;
298: l_next_approver_name per_employees_current_x.full_name%TYPE;
299: l_next_approver_user_name VARCHAR2(100);
300: l_next_approver_disp_name VARCHAR2(240);

Line 1001: l_parent_item_type wf_items.parent_item_type%TYPE;

997: l_approver_posoition_id number;
998: l_approver_type varchar2(10);
999: l_error_code NUMBER;
1000: l_error_message ame_util.longestStringType;
1001: l_parent_item_type wf_items.parent_item_type%TYPE;
1002: l_parent_item_key wf_items.parent_item_key%TYPE;
1003: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE; --
1004: l_ame_transaction_id PO_HEADERS_ALL.ame_approval_id%TYPE; --
1005: begin

Line 1002: l_parent_item_key wf_items.parent_item_key%TYPE;

998: l_approver_type varchar2(10);
999: l_error_code NUMBER;
1000: l_error_message ame_util.longestStringType;
1001: l_parent_item_type wf_items.parent_item_type%TYPE;
1002: l_parent_item_key wf_items.parent_item_key%TYPE;
1003: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE; --
1004: l_ame_transaction_id PO_HEADERS_ALL.ame_approval_id%TYPE; --
1005: begin
1006:

Line 1158: FROM wf_items

1154: l_error_message := SQLERRM;
1155:
1156: SELECT parent_item_type, parent_item_key
1157: into l_parent_item_type, l_parent_item_key
1158: FROM wf_items
1159: WHERE item_type = itemtype and item_key = itemkey;
1160:
1161: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1162: itemkey => l_parent_item_key,

Line 1201: l_parent_item_type wf_items.parent_item_type%TYPE;

1197: funcmode in varchar2,
1198: resultout out NOCOPY varchar2) IS
1199:
1200: l_progress VARCHAR2(500) := '000';
1201: l_parent_item_type wf_items.parent_item_type%TYPE;
1202: l_parent_item_key wf_items.parent_item_key%TYPE;
1203:
1204: l_child_approver_empid NUMBER;
1205: l_child_approver_groupid NUMBER;

Line 1202: l_parent_item_key wf_items.parent_item_key%TYPE;

1198: resultout out NOCOPY varchar2) IS
1199:
1200: l_progress VARCHAR2(500) := '000';
1201: l_parent_item_type wf_items.parent_item_type%TYPE;
1202: l_parent_item_key wf_items.parent_item_key%TYPE;
1203:
1204: l_child_approver_empid NUMBER;
1205: l_child_approver_groupid NUMBER;
1206:

Line 1228: CURSOR l_child_wf (itemtype IN wf_items.parent_item_type%TYPE,itemkey IN wf_items.parent_item_key%TYPE) IS

1224: l_transaction_type po_document_types.ame_transaction_type%TYPE; --
1225: l_ame_transaction_id NUMBER; --
1226: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE; --
1227:
1228: CURSOR l_child_wf (itemtype IN wf_items.parent_item_type%TYPE,itemkey IN wf_items.parent_item_key%TYPE) IS
1229: SELECT wfi.item_type, wfi.item_key,wfn.recipient_role, wfn.original_recipient
1230: FROM wf_items wfi,wf_item_activity_statuses wfias,wf_notifications wfn
1231: WHERE wfi.parent_item_key =itemkey
1232: and wfi.item_type=itemtype

Line 1230: FROM wf_items wfi,wf_item_activity_statuses wfias,wf_notifications wfn

1226: l_document_type PO_DOCUMENT_TYPES.document_type_code%TYPE; --
1227:
1228: CURSOR l_child_wf (itemtype IN wf_items.parent_item_type%TYPE,itemkey IN wf_items.parent_item_key%TYPE) IS
1229: SELECT wfi.item_type, wfi.item_key,wfn.recipient_role, wfn.original_recipient
1230: FROM wf_items wfi,wf_item_activity_statuses wfias,wf_notifications wfn
1231: WHERE wfi.parent_item_key =itemkey
1232: and wfi.item_type=itemtype
1233: AND wfias.item_type=wfi.item_type
1234: AND wfias.item_key=wfi.item_key

Line 1252: FROM wf_items

1248: END IF;
1249:
1250: SELECT parent_item_type, parent_item_key
1251: into l_parent_item_type, l_parent_item_key
1252: FROM wf_items
1253: WHERE item_type = itemtype and item_key = itemkey;
1254:
1255: /* Check if there we have encountered any ame exception.
1256: If the value of ame_exception is not null, then we have faced some exception.

Line 1622: l_parent_item_type wf_items.parent_item_type%TYPE;

1618: funcmode in varchar2,
1619: resultout out NOCOPY varchar2) IS
1620:
1621: l_progress VARCHAR2(500) := '000';
1622: l_parent_item_type wf_items.parent_item_type%TYPE;
1623: l_parent_item_key wf_items.parent_item_key%TYPE;
1624:
1625: l_child_approver_empid number;
1626: l_child_approver_user_name wf_users.name%TYPE;

Line 1623: l_parent_item_key wf_items.parent_item_key%TYPE;

1619: resultout out NOCOPY varchar2) IS
1620:
1621: l_progress VARCHAR2(500) := '000';
1622: l_parent_item_type wf_items.parent_item_type%TYPE;
1623: l_parent_item_key wf_items.parent_item_key%TYPE;
1624:
1625: l_child_approver_empid number;
1626: l_child_approver_user_name wf_users.name%TYPE;
1627: l_child_approver_display_name wf_users.display_name%TYPE;

Line 1638: FROM wf_items

1634: END IF;
1635:
1636: SELECT parent_item_type, parent_item_key
1637: into l_parent_item_type, l_parent_item_key
1638: FROM wf_items
1639: WHERE item_type = itemtype and item_key = itemkey;
1640:
1641: Process_Response_Internal(itemtype, itemkey, 'APPROVE');
1642: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

Line 1729: l_parent_item_type wf_items.parent_item_type%TYPE;

1725: funcmode in varchar2,
1726: resultout out NOCOPY varchar2) IS
1727:
1728: l_progress VARCHAR2(500) := '000';
1729: l_parent_item_type wf_items.parent_item_type%TYPE;
1730: l_parent_item_key wf_items.parent_item_key%TYPE;
1731:
1732: l_child_approver_empid number;
1733: l_child_approver_user_name wf_users.name%TYPE;

Line 1730: l_parent_item_key wf_items.parent_item_key%TYPE;

1726: resultout out NOCOPY varchar2) IS
1727:
1728: l_progress VARCHAR2(500) := '000';
1729: l_parent_item_type wf_items.parent_item_type%TYPE;
1730: l_parent_item_key wf_items.parent_item_key%TYPE;
1731:
1732: l_child_approver_empid number;
1733: l_child_approver_user_name wf_users.name%TYPE;
1734: l_child_approver_display_name wf_users.display_name%TYPE;

Line 1747: FROM wf_items

1743: Process_Response_Internal(itemtype, itemkey, 'REJECT');
1744:
1745: SELECT parent_item_type, parent_item_key
1746: into l_parent_item_type, l_parent_item_key
1747: FROM wf_items
1748: WHERE item_type = itemtype and item_key = itemkey;
1749:
1750: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1751: itemkey => l_parent_item_key,

Line 1843: l_parent_item_type wf_items.parent_item_type%TYPE;

1839: funcmode in varchar2,
1840: resultout out NOCOPY varchar2) IS
1841:
1842: l_progress VARCHAR2(500) := '000';
1843: l_parent_item_type wf_items.parent_item_type%TYPE;
1844: l_parent_item_key wf_items.parent_item_key%TYPE;
1845:
1846: l_child_approver_empid number;
1847: l_child_approver_user_name wf_users.name%TYPE;

Line 1844: l_parent_item_key wf_items.parent_item_key%TYPE;

1840: resultout out NOCOPY varchar2) IS
1841:
1842: l_progress VARCHAR2(500) := '000';
1843: l_parent_item_type wf_items.parent_item_type%TYPE;
1844: l_parent_item_key wf_items.parent_item_key%TYPE;
1845:
1846: l_child_approver_empid number;
1847: l_child_approver_user_name wf_users.name%TYPE;
1848: l_child_approver_display_name wf_users.display_name%TYPE;

Line 1862: FROM wf_items

1858: Process_Response_Internal(itemtype, itemkey, 'TIMEOUT');
1859:
1860: SELECT parent_item_type, parent_item_key
1861: into l_parent_item_type, l_parent_item_key
1862: FROM wf_items
1863: WHERE item_type = itemtype and item_key = itemkey;
1864:
1865: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,
1866: itemkey => l_parent_item_key,

Line 1963: l_parent_item_type wf_items.parent_item_type%TYPE;

1959: funcmode in varchar2,
1960: resultout out NOCOPY varchar2) IS
1961:
1962: l_progress VARCHAR2(500) := '000';
1963: l_parent_item_type wf_items.parent_item_type%TYPE;
1964: l_parent_item_key wf_items.parent_item_key%TYPE;
1965:
1966: l_child_approver_empid number;
1967: l_child_approver_user_name wf_users.name%TYPE;

Line 1964: l_parent_item_key wf_items.parent_item_key%TYPE;

1960: resultout out NOCOPY varchar2) IS
1961:
1962: l_progress VARCHAR2(500) := '000';
1963: l_parent_item_type wf_items.parent_item_type%TYPE;
1964: l_parent_item_key wf_items.parent_item_key%TYPE;
1965:
1966: l_child_approver_empid number;
1967: l_child_approver_user_name wf_users.name%TYPE;
1968: l_child_approver_display_name wf_users.display_name%TYPE;

Line 1979: FROM wf_items

1975: END IF;
1976:
1977: SELECT parent_item_type, parent_item_key
1978: into l_parent_item_type, l_parent_item_key
1979: FROM wf_items
1980: WHERE item_type = itemtype and item_key = itemkey;
1981:
1982: Process_Response_Internal(itemtype, itemkey, 'FORWARD');
1983: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

Line 2071: l_parent_item_type wf_items.parent_item_type%TYPE;

2067: funcmode in varchar2,
2068: resultout out NOCOPY varchar2) IS
2069:
2070: l_progress VARCHAR2(500) := '000';
2071: l_parent_item_type wf_items.parent_item_type%TYPE;
2072: l_parent_item_key wf_items.parent_item_key%TYPE;
2073:
2074: l_child_approver_empid number;
2075: l_child_approver_user_name wf_users.name%TYPE;

Line 2072: l_parent_item_key wf_items.parent_item_key%TYPE;

2068: resultout out NOCOPY varchar2) IS
2069:
2070: l_progress VARCHAR2(500) := '000';
2071: l_parent_item_type wf_items.parent_item_type%TYPE;
2072: l_parent_item_key wf_items.parent_item_key%TYPE;
2073:
2074: l_child_approver_empid number;
2075: l_child_approver_user_name wf_users.name%TYPE;
2076: l_child_approver_display_name wf_users.display_name%TYPE;

Line 2087: FROM wf_items

2083: END IF;
2084:
2085: SELECT parent_item_type, parent_item_key
2086: into l_parent_item_type, l_parent_item_key
2087: FROM wf_items
2088: WHERE item_type = itemtype and item_key = itemkey;
2089:
2090: Process_Response_Internal(itemtype, itemkey, 'APPROVE AND FORWARD');
2091: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,

Line 3721: l_parent_item_type wf_items.parent_item_type%TYPE;

3717: funcmode in varchar2,
3718: resultout out NOCOPY varchar2) IS
3719:
3720: l_progress VARCHAR2(500) := '000';
3721: l_parent_item_type wf_items.parent_item_type%TYPE;
3722: l_parent_item_key wf_items.parent_item_key%TYPE;
3723:
3724: l_child_approver_empid number;
3725: l_child_approver_user_name wf_users.name%TYPE;

Line 3722: l_parent_item_key wf_items.parent_item_key%TYPE;

3718: resultout out NOCOPY varchar2) IS
3719:
3720: l_progress VARCHAR2(500) := '000';
3721: l_parent_item_type wf_items.parent_item_type%TYPE;
3722: l_parent_item_key wf_items.parent_item_key%TYPE;
3723:
3724: l_child_approver_empid number;
3725: l_child_approver_user_name wf_users.name%TYPE;
3726: l_child_approver_display_name wf_users.display_name%TYPE;

Line 3737: FROM wf_items

3733: END IF;
3734:
3735: SELECT parent_item_type, parent_item_key
3736: into l_parent_item_type, l_parent_item_key
3737: FROM wf_items
3738: WHERE item_type = itemtype and item_key = itemkey;
3739:
3740: Process_Response_Internal(itemtype, itemkey, 'EXCEPTION');
3741: po_wf_util_pkg.SetItemAttrText( itemtype => l_parent_item_type,