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

Line 1509: l_parent_item_type wf_items.parent_item_type%TYPE;

1505: funcmode in varchar2,
1506: resultout out NOCOPY varchar2) AS
1507:
1508:
1509: l_parent_item_type wf_items.parent_item_type%TYPE;
1510: l_parent_item_key wf_items.parent_item_key%TYPE;
1511: l_child_approver_empid NUMBER;
1512: l_child_approver_groupid NUMBER;
1513: l_header_id NUMBER;

Line 1510: l_parent_item_key wf_items.parent_item_key%TYPE;

1506: resultout out NOCOPY varchar2) AS
1507:
1508:
1509: l_parent_item_type wf_items.parent_item_type%TYPE;
1510: l_parent_item_key wf_items.parent_item_key%TYPE;
1511: l_child_approver_empid NUMBER;
1512: l_child_approver_groupid NUMBER;
1513: l_header_id NUMBER;
1514: l_process_out VARCHAR2 (10);

Line 1525: p_itemtype IN wf_items.parent_item_type%TYPE,

1521: l_orig_system_id NUMBER;
1522: l_approver_response VARCHAR2 (20);
1523:
1524: CURSOR l_child_wf (
1525: p_itemtype IN wf_items.parent_item_type%TYPE,
1526: p_itemkey IN wf_items.parent_item_key%TYPE
1527: )
1528: IS
1529: SELECT wfi.item_type, wfi.item_key

Line 1526: p_itemkey IN wf_items.parent_item_key%TYPE

1522: l_approver_response VARCHAR2 (20);
1523:
1524: CURSOR l_child_wf (
1525: p_itemtype IN wf_items.parent_item_type%TYPE,
1526: p_itemkey IN wf_items.parent_item_key%TYPE
1527: )
1528: IS
1529: SELECT wfi.item_type, wfi.item_key
1530: FROM wf_items wfi, wf_item_activity_statuses wfias

Line 1530: FROM wf_items wfi, wf_item_activity_statuses wfias

1526: p_itemkey IN wf_items.parent_item_key%TYPE
1527: )
1528: IS
1529: SELECT wfi.item_type, wfi.item_key
1530: FROM wf_items wfi, wf_item_activity_statuses wfias
1531: WHERE wfi.parent_item_key = p_itemkey
1532: AND wfi.item_type = p_itemtype
1533: AND wfi.parent_item_type = p_itemtype
1534: AND wfias.item_type = wfi.item_type

Line 1562: FROM wf_items

1558: IF funcmode = 'RUN' THEN
1559: --pp_debug('Entered Beat by First Responder');
1560: SELECT parent_item_type, parent_item_key
1561: INTO l_parent_item_type, l_parent_item_key
1562: FROM wf_items
1563: WHERE item_type = itemtype AND item_key = itemkey;
1564:
1565: --pp_debug('In Beat by First Responder parent_item_type'||l_parent_item_type);
1566: --pp_debug('In Beat by First Responder l_parent_item_key'||l_parent_item_key);

Line 1801: l_parent_item_type wf_items.parent_item_type%TYPE;

1797: funcmode IN VARCHAR2,
1798: resultout OUT NOCOPY VARCHAR2)
1799: IS
1800:
1801: l_parent_item_type wf_items.parent_item_type%TYPE;
1802: l_parent_item_key wf_items.parent_item_key%TYPE;
1803: l_child_approver_empid NUMBER;
1804: l_child_approver_user_name wf_users.name%TYPE;
1805: l_child_approver_display_name wf_users.display_name%TYPE;

Line 1802: l_parent_item_key wf_items.parent_item_key%TYPE;

1798: resultout OUT NOCOPY VARCHAR2)
1799: IS
1800:
1801: l_parent_item_type wf_items.parent_item_type%TYPE;
1802: l_parent_item_key wf_items.parent_item_key%TYPE;
1803: l_child_approver_empid NUMBER;
1804: l_child_approver_user_name wf_users.name%TYPE;
1805: l_child_approver_display_name wf_users.display_name%TYPE;
1806: l_api_name VARCHAR2(500) := 'process_response_approve';

Line 1827: FROM wf_items

1823: -- APPROVER_EMPID, APPROVER_USER_NAME, APPROVER_DISPLAY_NAME with child approver attributes.
1824:
1825: SELECT parent_item_type, parent_item_key
1826: INTO l_parent_item_type, l_parent_item_key
1827: FROM wf_items
1828: WHERE item_type = itemtype
1829: AND item_key = itemkey;
1830:
1831: --pp_debug('Process response approve AME itemkey'||l_parent_item_key);

Line 1921: l_parent_item_type wf_items.parent_item_type%TYPE;

1917: funcmode IN VARCHAR2,
1918: resultout OUT NOCOPY VARCHAR2)
1919: IS
1920:
1921: l_parent_item_type wf_items.parent_item_type%TYPE;
1922: l_parent_item_key wf_items.parent_item_key%TYPE;
1923: l_child_approver_empid NUMBER;
1924: l_child_approver_user_name wf_users.name%TYPE;
1925: l_child_approver_display_name wf_users.display_name%TYPE;

Line 1922: l_parent_item_key wf_items.parent_item_key%TYPE;

1918: resultout OUT NOCOPY VARCHAR2)
1919: IS
1920:
1921: l_parent_item_type wf_items.parent_item_type%TYPE;
1922: l_parent_item_key wf_items.parent_item_key%TYPE;
1923: l_child_approver_empid NUMBER;
1924: l_child_approver_user_name wf_users.name%TYPE;
1925: l_child_approver_display_name wf_users.display_name%TYPE;
1926: l_api_name VARCHAR2(500) := 'process_response_reject';

Line 1947: FROM wf_items

1943: -- APPROVER_EMPID, APPROVER_USER_NAME, APPROVER_DISPLAY_NAME with child approver attributes.
1944:
1945: SELECT parent_item_type, parent_item_key
1946: INTO l_parent_item_type, l_parent_item_key
1947: FROM wf_items
1948: WHERE item_type = itemtype
1949: AND item_key = itemkey;
1950:
1951: process_response_ame(itemtype, itemkey, 'REJECT');

Line 2039: l_parent_item_type wf_items.parent_item_type%TYPE;

2035: funcmode IN VARCHAR2,
2036: resultout OUT NOCOPY VARCHAR2)
2037: IS
2038:
2039: l_parent_item_type wf_items.parent_item_type%TYPE;
2040: l_parent_item_key wf_items.parent_item_key%TYPE;
2041: l_child_approver_empid NUMBER;
2042: l_child_approver_user_name wf_users.name%TYPE;
2043: l_child_approver_display_name wf_users.display_name%TYPE;

Line 2040: l_parent_item_key wf_items.parent_item_key%TYPE;

2036: resultout OUT NOCOPY VARCHAR2)
2037: IS
2038:
2039: l_parent_item_type wf_items.parent_item_type%TYPE;
2040: l_parent_item_key wf_items.parent_item_key%TYPE;
2041: l_child_approver_empid NUMBER;
2042: l_child_approver_user_name wf_users.name%TYPE;
2043: l_child_approver_display_name wf_users.display_name%TYPE;
2044: l_api_name VARCHAR2(500) := 'Process_Response_timedout';

Line 2064: FROM wf_items

2060: -- + Populate parent workflow attributes APPROVER_EMPID, APPROVER_USER_NAME, APPROVER_DISPLAY_NAME with child approver attributes.
2061:
2062: SELECT parent_item_type, parent_item_key
2063: INTO l_parent_item_type, l_parent_item_key
2064: FROM wf_items
2065: WHERE item_type = itemtype
2066: AND item_key = itemkey;
2067:
2068: process_response_ame(itemtype, itemkey, 'TIMEOUT');

Line 2750: l_parent_item_type wf_items.parent_item_type%TYPE;

2746: l_approval_object VARCHAR2 (4000);
2747: l_cancellor_displayname VARCHAR2 (240);
2748: l_cancellor_username VARCHAR2 (240);
2749: l_approval_det_id number;
2750: l_parent_item_type wf_items.parent_item_type%TYPE;
2751: l_parent_item_key wf_items.parent_item_key%TYPE;
2752:
2753:
2754: CURSOR l_child_wf (

Line 2751: l_parent_item_key wf_items.parent_item_key%TYPE;

2747: l_cancellor_displayname VARCHAR2 (240);
2748: l_cancellor_username VARCHAR2 (240);
2749: l_approval_det_id number;
2750: l_parent_item_type wf_items.parent_item_type%TYPE;
2751: l_parent_item_key wf_items.parent_item_key%TYPE;
2752:
2753:
2754: CURSOR l_child_wf (
2755: p_itemtype IN wf_items.parent_item_type%TYPE,

Line 2755: p_itemtype IN wf_items.parent_item_type%TYPE,

2751: l_parent_item_key wf_items.parent_item_key%TYPE;
2752:
2753:
2754: CURSOR l_child_wf (
2755: p_itemtype IN wf_items.parent_item_type%TYPE,
2756: p_itemkey IN wf_items.parent_item_key%TYPE
2757: )
2758: IS
2759: SELECT wfi.item_type, wfi.item_key

Line 2756: p_itemkey IN wf_items.parent_item_key%TYPE

2752:
2753:
2754: CURSOR l_child_wf (
2755: p_itemtype IN wf_items.parent_item_type%TYPE,
2756: p_itemkey IN wf_items.parent_item_key%TYPE
2757: )
2758: IS
2759: SELECT wfi.item_type, wfi.item_key
2760: FROM wf_items wfi, wf_item_activity_statuses wfias

Line 2760: FROM wf_items wfi, wf_item_activity_statuses wfias

2756: p_itemkey IN wf_items.parent_item_key%TYPE
2757: )
2758: IS
2759: SELECT wfi.item_type, wfi.item_key
2760: FROM wf_items wfi, wf_item_activity_statuses wfias
2761: WHERE wfi.parent_item_key = p_itemkey
2762: AND wfi.item_type = p_itemtype
2763: AND wfi.parent_item_type = p_itemtype
2764: AND wfias.item_type = wfi.item_type