[Home] [Help]
536:
537: -- past notifications
538: cursor histc(x_item_type varchar2, x_item_key varchar2, x_actid number) is
539: select IAS.NOTIFICATION_ID, IAS.ASSIGNED_USER, A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE, nvl(IAS.END_DATE, IAS.BEGIN_DATE) ACT_DATE, IAS.EXECUTION_TIME
540: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
541: WF_ACTIVITIES A,
542: WF_PROCESS_ACTIVITIES PA,
543: WF_ITEM_TYPES IT,
544: WF_ITEMS I
585: when NO_DATA_FOUND then
586: begin
587: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
588: into l_itype, l_ikey, l_actid
589: from WF_ITEM_ACTIVITY_STATUSES_H
590: where notification_id = nid;
591: exception
592: when NO_DATA_FOUND then
593: null; -- raise a notification not exist message
3439: -- If a record exists in history table for this item activity, it has already
3440: -- been executed
3441: SELECT count(1)
3442: INTO l_count
3443: FROM wf_item_activity_statuses_h
3444: WHERE item_type = l_item_type
3445: AND item_key = l_item_key
3446: AND process_activity = l_actid
3447: AND rownum = 1;
4119: FROM wf_notifications wn,
4120: wf_comments wc
4121: WHERE
4122: EXISTS ( SELECT 'x' -- 8554209
4123: FROM wf_item_activity_statuses_h wiash
4124: WHERE wiash.notification_id= wn.notification_id
4125: AND wiash.item_type = wn.message_type
4126: AND wiash.item_type = itemtype
4127: AND wiash.item_key = itemkey
7290: begin
7291: -- rarely the nid is from WIASH, but just in case
7292: select ITEM_TYPE, ITEM_KEY
7293: into itype, ikey
7294: from WF_ITEM_ACTIVITY_STATUSES_H
7295: where NOTIFICATION_ID = nid;
7296: exception
7297: when NO_DATA_FOUND then
7298: -- Notification only
7356: where item_type = itype
7357: and item_key = ikey
7358: union all
7359: select notification_id group_id
7360: from WF_ITEM_ACTIVITY_STATUSES_H
7361: where item_type = itype
7362: and item_key = ikey
7363: ) grp_id_view
7364: where grp_id_view.group_id = a.group_id
8144: A.RESULT_TYPE H_ACTION_TYPE,
8145: IAS.ACTIVITY_RESULT_CODE H_ACTION,
8146: '#WF_NOTE#' H_COMMENT,
8147: nvl(IAS.END_DATE, IAS.BEGIN_DATE) H_ACTION_DATE
8148: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
8149: WF_ACTIVITIES A,
8150: WF_PROCESS_ACTIVITIES PA,
8151: WF_ITEMS I
8152: where IAS.ITEM_TYPE = l_item_type
8189: '#WF_COMMENTS#' H_ACTION_TYPE,
8190: C.ACTION H_ACTION,
8191: C.USER_COMMENT H_COMMENT,
8192: C.COMMENT_DATE H_ACTION_DATE
8193: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
8194: WF_COMMENTS C
8195: where IAS.ITEM_TYPE = l_item_type
8196: and IAS.ITEM_KEY = l_item_key
8197: and IAS.PROCESS_ACTIVITY = l_actid
8233: C.ACTION_TYPE H_ACTION_TYPE,
8234: C.ACTION H_ACTION,
8235: C.USER_COMMENT H_COMMENT,
8236: C.COMMENT_DATE H_ACTION_DATE
8237: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
8238: WF_COMMENTS C
8239: where IAS.ITEM_TYPE = l_item_type
8240: and IAS.ITEM_KEY = l_item_key
8241: and IAS.PROCESS_ACTIVITY = l_actid
8259: when NO_DATA_FOUND then
8260: begin
8261: SELECT item_type, item_key, process_activity
8262: INTO l_item_type, l_item_key, l_actid
8263: FROM wf_item_activity_statuses_h
8264: WHERE notification_id = p_nid;
8265: exception
8266: when NO_DATA_FOUND then
8267: -- It is possible that notification is sent outside of a flow,
9006: --
9007: -- getNtfActInfo
9008: -- Fetch Notification Activity info of a given notification. It is possible
9009: -- that there will not be an entry in WF_ITEM_ACTIVITY_STATUSES and/or
9010: -- WF_ITEM_ACTIVITY_STATUSES_H in case when the notification is sent using
9011: -- Send API instead of part of a process.
9012: -- IN
9013: -- nid - Notification ID
9014: -- OUT
9028: where notification_id = group_nid;
9029:
9030: cursor act_info_statuses_h_cursor( group_nid number ) is
9031: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
9032: from WF_ITEM_ACTIVITY_STATUSES_H
9033: where notification_id = group_nid;
9034:
9035: l_group_nid number;
9036:
9570:
9571: begin
9572: select A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE
9573: into l_result_type, p_result_code
9574: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
9575: WF_ACTIVITIES A,
9576: WF_PROCESS_ACTIVITIES PA,
9577: WF_ITEMS I
9578: where IAS.NOTIFICATION_ID = p_nid