[Home] [Help]
235: ,p_itemKey OUT NOCOPY VARCHAR2 ) IS
236:
237: CURSOR cur_ias IS
238: SELECT item_type, item_key
239: FROM wf_item_activity_statuses
240: WHERE notification_id = p_ntfId;
241:
242: CURSOR cur_not IS
243: SELECT SUBSTR(context,1,INSTR(context,':',1)-1)
308: l_ntfId NUMBER;
309: --
310: CURSOR cur_ntf IS
311: SELECT ias.notification_id
312: FROM WF_ITEM_ACTIVITY_STATUSES IAS
313: WHERE ias.item_type = p_itemType
314: and ias.item_key = p_itemKey
315: and IAS.ACTIVITY_STATUS = 'NOTIFIED'
316: and notification_id is not null
365: l_activityId NUMBER;
366: --
367: CURSOR cur_wf IS
368: SELECT process_activity
369: FROM WF_ITEM_ACTIVITY_STATUSES IAS
370: WHERE ias.item_type = p_itemType
371: and ias.item_key = p_itemKey
372: AND ias.notification_id IS NULL
373: and IAS.ACTIVITY_STATUS = 'NOTIFIED'
374: and rownum < 2;
375: --
376: CURSOR cur_wf_ntfId(p_ntfId VARCHAR2) IS
377: SELECT process_activity
378: FROM WF_ITEM_ACTIVITY_STATUSES IAS
379: WHERE ias.item_type = p_itemType
380: and ias.item_key = p_itemKey
381: and ias.notification_id = p_ntfId
382: and IAS.ACTIVITY_STATUS = 'NOTIFIED'
422: --
423: CURSOR cur_wf IS
424: -- Fix for bug 3719338
425: /*SELECT ias.process_activity
426: FROM wf_item_activity_statuses ias
427: WHERE ias.item_type = p_itemType
428: and ias.item_key = p_itemKey
429: and ias.activity_status = 'NOTIFIED'
430: and ias.process_activity in (
449: */
450: SELECT process_activity
451: from
452: (select process_activity
453: FROM WF_ITEM_ACTIVITY_STATUSES IAS
454: WHERE ias.item_type = p_itemType
455: and ias.item_key = p_itemKey
456: and ias.activity_status = 'NOTIFIED'
457: and ias.process_activity in (
514:
515:
516: CURSOR c_wf IS
517: SELECT instance_label,ias.process_activity actvityId, ias.notification_id ntfId
518: FROM WF_ITEM_ACTIVITY_STATUSES IAS,
519: WF_PROCESS_ACTIVITIES PA
520: WHERE IAS.PROCESS_ACTIVITY = PA.INSTANCE_ID
521: AND ias.item_type = pa.process_item_type
522: and ias.item_type = p_itemType
1274: -- so that only SFL activity is left notified
1275: -- NO DML Operations directly on FND schema.
1276: -- Fix for bug#3578646
1277: /*
1278: UPDATE wf_item_activity_statuses
1279: SET activity_status = 'COMPLETE',
1280: activity_result_code ='#NULL'
1281: WHERE item_type = p_itemType
1282: AND item_key = p_itemKey
3508: AND name = 'WF_NOTE'
3509: ) h_comment
3510: ,nvl (ias.end_date
3511: ,ias.begin_date) h_action_date
3512: FROM wf_item_activity_statuses ias
3513: ,wf_activities a
3514: ,wf_process_activities pa
3515: ,wf_items i
3516: ,WF_ITEM_TYPES IT
3541: AND name = 'WF_NOTE'
3542: ) h_comment
3543: ,nvl (ias.end_date
3544: ,ias.begin_date) h_action_date
3545: FROM wf_item_activity_statuses_h ias
3546: ,wf_activities a
3547: ,wf_process_activities pa
3548: ,wf_items i
3549: ,WF_ITEM_TYPES IT
3566: ,c.from_role h_from_role
3567: ,wf_core.translate (c.action) h_action
3568: ,c.user_comment h_comment
3569: ,c.comment_date h_action_date
3570: FROM wf_item_activity_statuses ias
3571: ,wf_comments c
3572: WHERE ias.item_type = x_item_type
3573: AND ias.item_key = x_item_key
3574: -- AND ias.process_activity = x_actid
3581: ,c.from_role h_from_role
3582: ,wf_core.translate (c.action) h_action
3583: ,c.user_comment h_comment
3584: ,c.comment_date h_action_date
3585: FROM wf_item_activity_statuses_h ias
3586: ,wf_comments c
3587: WHERE ias.item_type = x_item_type
3588: AND ias.item_key = x_item_key
3589: -- AND ias.process_activity = x_actid
3970:
3971:
3972: CURSOR cur_wf IS
3973: SELECT process_activity
3974: FROM WF_ITEM_ACTIVITY_STATUSES IAS
3975: WHERE ias.item_type = p_itemType
3976: AND ias.item_key = p_itemKey
3977: AND ias.activity_status = 'NOTIFIED'
3978: ORDER BY begin_date DESC, execution_time DESC;