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.

[Home] [Help]

APPS.MSC_EXP_WF dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 2209: from wf_item_activity_statuses

2205: wf_notifications
2206: set end_date = sysdate
2207: where group_id in
2208: (select notification_id
2209: from wf_item_activity_statuses
2210: where item_type = l_item_type
2211: and item_key = l_item_key
2212: union
2213: select notification_id

Line 2214: from wf_item_activity_statuses_h

2210: where item_type = l_item_type
2211: and item_key = l_item_key
2212: union
2213: select notification_id
2214: from wf_item_activity_statuses_h
2215: where item_type = l_item_type
2216: and item_key = l_item_key);
2217:
2218: update wf_items

Line 2223: update wf_item_activity_statuses

2219: set end_date = sysdate
2220: where item_type = l_item_type
2221: and item_key = l_item_key;
2222:
2223: update wf_item_activity_statuses
2224: set end_date = sysdate
2225: where item_type = l_item_type
2226: and item_key = l_item_key;
2227:

Line 2228: update wf_item_activity_statuses_h

2224: set end_date = sysdate
2225: where item_type = l_item_type
2226: and item_key = l_item_key;
2227:
2228: update wf_item_activity_statuses_h
2229: set end_date = sysdate
2230: where item_type = l_item_type
2231: and item_key = l_item_key;
2232:

Line 3620: from wf_item_activity_statuses

3616: p_item_type varchar2,
3617: p_item_key varchar2) IS
3618: CURSOR status_cur IS
3619: select 1
3620: from wf_item_activity_statuses
3621: where item_type = p_item_type
3622: and item_key = p_item_key
3623: and activity_status = 'DEFERRED';
3624: v_dummy number;