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

Line 806: from wf_item_activity_statuses wias, wf_notifications wfn

802:
803: -- bug 3896181
804: select wfn.MESSAGE_NAME
805: into l_message_name
806: from wf_item_activity_statuses wias, wf_notifications wfn
807: where wias.notification_id = wfn.group_id
808: and wias.item_type = 'APVRMDER'
809: and wias.item_key = l_ItemKey ;
810: IF l_message_name = 'PO_ACCEPTANCE_PAST_DUE' then

Line 887: from wf_item_activity_statuses wias, wf_notifications wfn

883: END IF;
884: -- bug 3896181
885: select wfn.MESSAGE_NAME
886: into l_message_name
887: from wf_item_activity_statuses wias, wf_notifications wfn
888: where wias.notification_id = wfn.group_id
889: and wias.item_type = 'APVRMDER'
890: and wias.item_key = l_ItemKey ;
891: IF l_message_name = 'PO_ACCEPTANCE_REQUIRED' then

Line 1147: from wf_item_activity_statuses wias, wf_notifications wfn

1143: --bug 3896181
1144: begin
1145: select wfn.MESSAGE_NAME
1146: into l_message_name
1147: from wf_item_activity_statuses wias, wf_notifications wfn
1148: where wias.notification_id = wfn.group_id
1149: and wias.item_type = 'APVRMDER'
1150: and wias.item_key = l_ItemKey ;
1151: exception

Line 1234: from wf_item_activity_statuses wias, wf_notifications wfn

1230: --bug 3896181
1231: begin
1232: select wfn.MESSAGE_NAME
1233: into l_message_name
1234: from wf_item_activity_statuses wias, wf_notifications wfn
1235: where wias.notification_id = wfn.group_id
1236: and wias.item_type = 'APVRMDER'
1237: and wias.item_key = l_ItemKey ;
1238: exception

Line 2805: from wf_item_activity_statuses_v wias, wf_items_v wi

2801: --we want to make sure that the reminder notification with new item key
2802: --is aborted correctly.
2803: Cursor cand_active_wf(l_itemkey VARCHAR2) IS
2804: select wias.activity_status_code, wias.item_key
2805: from wf_item_activity_statuses_v wias, wf_items_v wi
2806: where wias.item_type = 'APVRMDER'
2807: and wias.item_key like l_itemkey||'%'
2808: and wias.item_type = wi.item_type
2809: and wias.item_key = wi.item_key

Line 3066: x_act_status WF_ITEM_ACTIVITY_STATUSES.ACTIVITY_STATUS%TYPE;

3062: FUNCTION is_active (x_item_type in varchar2,
3063: x_item_key in varchar2) RETURN BOOLEAN is
3064:
3065: -- Bug 3693990
3066: x_act_status WF_ITEM_ACTIVITY_STATUSES.ACTIVITY_STATUS%TYPE;
3067: x_result varchar2(30);
3068: -- Bug 3693990
3069:
3070: x_progress varchar2(100) := '001';

Line 3076: --wf_item_activity_statuses_v is a view which is based on

3072: BEGIN
3073: x_progress := 'PO_APPROVAL_REMINDER_SV.is_active-001';
3074:
3075: --bug#3693990 commented out the above sql because the view
3076: --wf_item_activity_statuses_v is a view which is based on
3077: --a union all between wf_item_activity_statuses and
3078: --wf_item_activity_statuses_h(history). A new record
3079: --gets inserted into history table when the wf process
3080: --raises an error.

Line 3077: --a union all between wf_item_activity_statuses and

3073: x_progress := 'PO_APPROVAL_REMINDER_SV.is_active-001';
3074:
3075: --bug#3693990 commented out the above sql because the view
3076: --wf_item_activity_statuses_v is a view which is based on
3077: --a union all between wf_item_activity_statuses and
3078: --wf_item_activity_statuses_h(history). A new record
3079: --gets inserted into history table when the wf process
3080: --raises an error.
3081: --WF Team has provided an api wf_engine.itemstatus to check the

Line 3078: --wf_item_activity_statuses_h(history). A new record

3074:
3075: --bug#3693990 commented out the above sql because the view
3076: --wf_item_activity_statuses_v is a view which is based on
3077: --a union all between wf_item_activity_statuses and
3078: --wf_item_activity_statuses_h(history). A new record
3079: --gets inserted into history table when the wf process
3080: --raises an error.
3081: --WF Team has provided an api wf_engine.itemstatus to check the
3082: --active status of any given activity. We need to call this

Line 3083: --instead of query the wf_item_activity_statuses_v view directly.

3079: --gets inserted into history table when the wf process
3080: --raises an error.
3081: --WF Team has provided an api wf_engine.itemstatus to check the
3082: --active status of any given activity. We need to call this
3083: --instead of query the wf_item_activity_statuses_v view directly.
3084: BEGIN
3085: wf_engine.itemstatus (itemtype => x_item_type,
3086: itemkey => x_item_key,
3087: status => x_act_status,