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.MSC_X_NETTING_PKG dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 1515: from wf_item_activity_statuses

1511: PROCEDURE Delete_Item(l_type in varchar2, l_key in varchar2) IS
1512:
1513: cursor get_notification_c (l_type in varchar2, l_key in varchar2) IS
1514: select notification_id
1515: from wf_item_activity_statuses
1516: where item_type = l_type
1517: and item_key like l_key
1518: union
1519: select notification_id

Line 1520: from wf_item_activity_statuses_h

1516: where item_type = l_type
1517: and item_key like l_key
1518: union
1519: select notification_id
1520: from wf_item_activity_statuses_h
1521: where item_type = l_type
1522: and item_key like l_key;
1523:
1524: l_item_key Varchar2(100);

Line 1547: update wf_item_activity_statuses set

1543: end_date = sysdate
1544: where item_type = l_type
1545: and item_key like l_key;
1546:
1547: update wf_item_activity_statuses set
1548: end_date = sysdate
1549: where item_type = l_type
1550: and item_key like l_key;
1551:

Line 1552: update wf_item_activity_statuses_h set

1548: end_date = sysdate
1549: where item_type = l_type
1550: and item_key like l_key;
1551:
1552: update wf_item_activity_statuses_h set
1553: end_date = sysdate
1554: where item_type = l_type
1555: and item_key like l_key;
1556:

Line 1573: from wf_item_activity_statuses

1569: cursor get_notification_c (p_type In Varchar2,
1570: p_key in varchar2) IS
1571:
1572: select (max(notification_id))
1573: from wf_item_activity_statuses
1574: where item_type = p_type
1575: and item_key like p_key || '%'
1576: and notification_id is not null;
1577: