APPS.OE_APPROVALS_WF dependencies on WF_ITEMS

Line 1407: FROM wf_items wi

1403: l_transaction_id := TO_NUMBER (itemkey);
1404:
1405: SELECT parent_item_key
1406: INTO l_parent_item_key
1407: FROM wf_items wi
1408: WHERE wi.item_type = itemtype AND wi.item_key = itemkey;
1409:
1410: oe_standard_wf.set_msg_context (actid);
1411: oe_msg_pub.set_msg_context (p_entity_code => 'HEADER',

Line 2129: FROM wf_items wi

2125: END IF ;
2126:
2127: SELECT COUNT (1)
2128: INTO l_open_children
2129: FROM wf_items wi
2130: WHERE wi.item_type = 'OEAME'
2131: AND wi.parent_item_type = itemtype
2132: AND wi.parent_item_key = itemkey
2133: AND wi.item_key <> NVL (g_current_item_key, 'XXXX')

Line 2178: FROM wf_items

2174: IS
2175: CURSOR get_all_children
2176: IS
2177: SELECT item_type, item_key
2178: FROM wf_items
2179: WHERE parent_item_type = itemtype AND parent_item_key = itemkey;
2180: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2181: BEGIN
2182: IF l_debug_level >0 THEN

Line 2347: FROM wf_items

2343: THEN
2344: BEGIN
2345: SELECT parent_item_key, parent_item_type
2346: INTO l_parent_itemkey, l_parent_itemtype
2347: FROM wf_items
2348: WHERE item_type = itemtype AND item_key = itemkey;
2349: EXCEPTION
2350: WHEN OTHERS
2351: THEN

Line 2673: FROM wf_items

2669: THEN
2670: BEGIN
2671: SELECT parent_item_key, parent_item_type
2672: INTO l_parent_itemkey, l_parent_item_type
2673: FROM wf_items
2674: WHERE item_type = itemtype AND item_key = itemkey;
2675: EXCEPTION
2676: WHEN OTHERS
2677: THEN

Line 2938: l_parent_item_type wf_items.parent_item_type%TYPE;

2934: resultout OUT NOCOPY VARCHAR2
2935: )
2936: IS
2937: l_progress VARCHAR2 (500) := '000';
2938: l_parent_item_type wf_items.parent_item_type%TYPE;
2939: l_parent_item_key wf_items.parent_item_key%TYPE;
2940: l_child_approver_empid NUMBER;
2941: l_child_approver_groupid NUMBER;
2942: --l_approver_group_id NUMBER;

Line 2939: l_parent_item_key wf_items.parent_item_key%TYPE;

2935: )
2936: IS
2937: l_progress VARCHAR2 (500) := '000';
2938: l_parent_item_type wf_items.parent_item_type%TYPE;
2939: l_parent_item_key wf_items.parent_item_key%TYPE;
2940: l_child_approver_empid NUMBER;
2941: l_child_approver_groupid NUMBER;
2942: --l_approver_group_id NUMBER;
2943: l_header_id NUMBER;

Line 2962: p_itemtype IN wf_items.parent_item_type%TYPE,

2958: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2959: xx_ame EXCEPTION;
2960:
2961: CURSOR l_child_wf (
2962: p_itemtype IN wf_items.parent_item_type%TYPE,
2963: p_itemkey IN wf_items.parent_item_key%TYPE
2964: )
2965: IS
2966: SELECT wfi.item_type, wfi.item_key

Line 2963: p_itemkey IN wf_items.parent_item_key%TYPE

2959: xx_ame EXCEPTION;
2960:
2961: CURSOR l_child_wf (
2962: p_itemtype IN wf_items.parent_item_type%TYPE,
2963: p_itemkey IN wf_items.parent_item_key%TYPE
2964: )
2965: IS
2966: SELECT wfi.item_type, wfi.item_key
2967: FROM wf_items wfi, wf_item_activity_statuses wfias

Line 2967: FROM wf_items wfi, wf_item_activity_statuses wfias

2963: p_itemkey IN wf_items.parent_item_key%TYPE
2964: )
2965: IS
2966: SELECT wfi.item_type, wfi.item_key
2967: FROM wf_items wfi, wf_item_activity_statuses wfias
2968: WHERE wfi.parent_item_key = p_itemkey
2969: AND wfi.item_type = 'OEAME'
2970: AND wfi.parent_item_type = p_itemtype
2971: AND wfias.item_type = wfi.item_type

Line 2990: FROM wf_items

2986: END IF;
2987:
2988: SELECT parent_item_type, parent_item_key
2989: INTO l_parent_item_type, l_parent_item_key
2990: FROM wf_items
2991: WHERE item_type = itemtype AND item_key = itemkey;
2992: IF l_debug_level > 0 THEN
2993: oe_debug_pub.ADD ('After getting parent details');
2994: END IF ;

Line 3460: FROM wf_items

3456: g_current_item_key := NULL;
3457:
3458: SELECT parent_item_key, parent_item_type
3459: INTO l_parent_item_key, l_parent_item_type
3460: FROM wf_items
3461: WHERE item_type = itemtype AND item_key = itemkey;
3462:
3463: g_current_item_key := itemkey;
3464: