DBA Data[Home] [Help]

APPS.MSC_X_USER_EXCEP_GEN dependencies on WF_NOTIFICATIONS

Line 3278: wf_notifications nt

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
3282: union

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 3294: update wf_notifications set

3290:
3291: BEGIN
3292:
3293: FOR aRec IN c1 LOOP
3294: update wf_notifications set
3295: end_date = sysdate
3296: where notification_id = aRec.notification_id;
3297: IF aRec.status = 'OPEN' THEN
3298: wf_notification.close(aRec.notification_id);