[Home] [Help]
431: select pa.instance_id
432: FROM wf_process_activities PA,
433: wf_activity_attributes AA,
434: wf_activities WA,
435: wf_items WI
436: WHERE pa.process_item_type = ias.item_type
437: and wa.item_type = pa.process_item_type
438: and wa.name = pa.activity_name
439: and wi.item_type = ias.item_type
458: select wpa.instance_id
459: FROM WF_PROCESS_ACTIVITIES WPA,
460: WF_ACTIVITY_ATTRIBUTES WAA,
461: WF_ACTIVITIES WA,
462: WF_ITEMS WI
463: WHERE wpa.process_item_type = ias.item_type
464: and wa.item_type = wpa.process_item_type
465: and wa.name = wpa.activity_name
466: and wi.item_type = ias.item_type
523: and ias.item_key = p_itemKey
524: and ias.activity_status = 'NOTIFIED'
525: and ias.process_activity <> p_activity
526: and not exists (select 'e'
527: from WF_ACTIVITIES wa, WF_ACTIVITY_ATTRIBUTES waa, WF_ITEMS wi
528: where wa.item_type = pa.process_item_type
529: and wa.name = pa.activity_name
530: and wi.item_type = ias.item_type
531: and wi.item_key = ias.item_key
3456: from WF_ITEM_ACTIVITY_STATUSES IAS,
3457: WF_ACTIVITIES A,
3458: WF_PROCESS_ACTIVITIES PA,
3459: WF_ITEM_TYPES IT,
3460: WF_ITEMS I
3461: where IAS.ITEM_TYPE = x_item_type
3462: and IAS.ITEM_KEY = x_item_key
3463: and IAS.NOTIFICATION_ID is not null
3464: and nvl(RESULT_TYPE,'*') NOT IN ( '*','HR_DONE')
3477: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
3478: WF_ACTIVITIES A,
3479: WF_PROCESS_ACTIVITIES PA,
3480: WF_ITEM_TYPES IT,
3481: WF_ITEMS I
3482: where IAS.ITEM_TYPE = x_item_type
3483: and IAS.ITEM_KEY = x_item_key
3484: and IAS.NOTIFICATION_ID is not null
3485: and (IAS.ACTIVITY_RESULT_CODE is null or IAS.ACTIVITY_RESULT_CODE not in ('SFL','#NULL'))
3559:
3560: begin
3561: select OWNER_ROLE, BEGIN_DATE
3562: into l_owner_role, l_begin_date
3563: from WF_ITEMS
3564: where ITEM_TYPE = l_itype
3565: and ITEM_KEY = l_ikey;
3566: exception
3567: when OTHERS then