DBA Data[Home] [Help]

APPS.MSC_X_USER_EXCEP_GEN dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 3277: from wf_item_activity_statuses st,

3273: PROCEDURE Delete_Item(l_type in varchar2, l_key in varchar2)
3274: IS
3275: CURSOR c1 IS
3276: select nt.notification_id,nt.status
3277: from wf_item_activity_statuses st,
3278: wf_notifications nt
3279: where st.item_type = l_type
3280: and st.item_key like l_key
3281: and nt.notification_id = st.notification_id

Line 3284: from wf_item_activity_statuses_h st1,wf_notifications nt

3280: and st.item_key like l_key
3281: and nt.notification_id = st.notification_id
3282: union
3283: select nt.notification_id,nt.status
3284: from wf_item_activity_statuses_h st1,wf_notifications nt
3285: where st1.item_type = l_type
3286: and st1.item_key like l_key
3287: and
3288: nt.notification_id = st1.notification_id;

Line 3307: update wf_item_activity_statuses set

3303: end_date = sysdate
3304: where item_type = l_type
3305: and item_key like l_key;
3306:
3307: update wf_item_activity_statuses set
3308: end_date = sysdate
3309: where item_type = l_type
3310: and item_key like l_key;
3311:

Line 3312: update wf_item_activity_statuses_h set

3308: end_date = sysdate
3309: where item_type = l_type
3310: and item_key like l_key;
3311:
3312: update wf_item_activity_statuses_h set
3313: end_date = sysdate
3314: where item_type = l_type
3315: and item_key like l_key;
3316: