eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WF_NOTIFICATION dependencies on WF_ITEM_ACTIVITY_STATUSES

Line 526: from WF_ITEM_ACTIVITY_STATUSES IAS,

522: is
523: -- current notification
524: cursor hist0c(x_item_type varchar2, x_item_key varchar2, x_actid number) is
525: 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
526: from WF_ITEM_ACTIVITY_STATUSES IAS,
527: WF_ACTIVITIES A,
528: WF_PROCESS_ACTIVITIES PA,
529: WF_ITEM_TYPES IT,
530: WF_ITEMS I

Line 545: from WF_ITEM_ACTIVITY_STATUSES_H IAS,

541:
542: -- past notifications
543: cursor histc(x_item_type varchar2, x_item_key varchar2, x_actid number) is
544: 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
545: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
546: WF_ACTIVITIES A,
547: WF_PROCESS_ACTIVITIES PA,
548: WF_ITEM_TYPES IT,
549: WF_ITEMS I

Line 587: from WF_ITEM_ACTIVITY_STATUSES

583:
584: begin
585: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
586: into l_itype, l_ikey, l_actid
587: from WF_ITEM_ACTIVITY_STATUSES
588: where notification_id = nid;
589: exception
590: when NO_DATA_FOUND then
591: begin

Line 594: from WF_ITEM_ACTIVITY_STATUSES_H

590: when NO_DATA_FOUND then
591: begin
592: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
593: into l_itype, l_ikey, l_actid
594: from WF_ITEM_ACTIVITY_STATUSES_H
595: where notification_id = nid;
596: exception
597: when NO_DATA_FOUND then
598: null; -- raise a notification not exist message

Line 3329: FROM wf_item_activity_statuses_h

3325: -- If a record exists in history table for this item activity, it has already
3326: -- been executed
3327: SELECT count(1)
3328: INTO l_count
3329: FROM wf_item_activity_statuses_h
3330: WHERE item_type = l_item_type
3331: AND item_key = l_item_key
3332: AND process_activity = l_actid
3333: AND rownum = 1;

Line 3511: wf_item_activity_statuses wias,

3507: is
3508: cursor c_notifications is
3509: select wi.item_key, wi.user_key, wn.notification_id
3510: from wf_items wi,
3511: wf_item_activity_statuses wias,
3512: wf_notifications wn
3513: where wi.item_key = wias.item_key
3514: and wi.item_type = wias.item_type
3515: and wias.notification_id = wn.group_id

Line 3991: FROM wf_item_activity_statuses_h wiash

3987: FROM wf_notifications wn,
3988: wf_comments wc
3989: WHERE
3990: EXISTS ( SELECT /*+ NO_UNNEST */ 'x'
3991: FROM wf_item_activity_statuses_h wiash
3992: WHERE wiash.notification_id= wn.notification_id
3993: AND wiash.item_type = wn.message_type
3994: AND wiash.item_type = itemtype
3995: AND wiash.item_key = itemkey

Line 7124: from WF_ITEM_ACTIVITY_STATUSES

7120: begin
7121: -- 99% of the case, it should be found in WIAS
7122: select ITEM_TYPE, ITEM_KEY
7123: into itype, ikey
7124: from WF_ITEM_ACTIVITY_STATUSES
7125: where NOTIFICATION_ID = nid;
7126: exception
7127: when NO_DATA_FOUND then
7128: begin

Line 7132: from WF_ITEM_ACTIVITY_STATUSES_H

7128: begin
7129: -- rarely the nid is from WIASH, but just in case
7130: select ITEM_TYPE, ITEM_KEY
7131: into itype, ikey
7132: from WF_ITEM_ACTIVITY_STATUSES_H
7133: where NOTIFICATION_ID = nid;
7134: exception
7135: when NO_DATA_FOUND then
7136: -- Notification only

Line 7193: from WF_ITEM_ACTIVITY_STATUSES

7189: select /*+ leading(grp_id_view) */
7190: RECIPIENT_ROLE , ORIGINAL_RECIPIENT
7191: from WF_NOTIFICATIONS a ,
7192: ( select notification_id group_id
7193: from WF_ITEM_ACTIVITY_STATUSES
7194: where item_type = itype
7195: and item_key = ikey
7196: union all
7197: select notification_id group_id

Line 7198: from WF_ITEM_ACTIVITY_STATUSES_H

7194: where item_type = itype
7195: and item_key = ikey
7196: union all
7197: select notification_id group_id
7198: from WF_ITEM_ACTIVITY_STATUSES_H
7199: where item_type = itype
7200: and item_key = ikey
7201: ) grp_id_view
7202: where grp_id_view.group_id = a.group_id

Line 7894: from WF_ITEM_ACTIVITY_STATUSES IAS,

7890: A.RESULT_TYPE H_ACTION_TYPE,
7891: IAS.ACTIVITY_RESULT_CODE H_ACTION,
7892: '#WF_NOTE#' H_COMMENT,
7893: nvl(IAS.END_DATE, IAS.BEGIN_DATE) H_ACTION_DATE
7894: from WF_ITEM_ACTIVITY_STATUSES IAS,
7895: WF_ACTIVITIES A,
7896: WF_PROCESS_ACTIVITIES PA,
7897: WF_ITEMS I
7898: where IAS.ITEM_TYPE = l_item_type

Line 7922: from WF_ITEM_ACTIVITY_STATUSES_H IAS,

7918: A.RESULT_TYPE H_ACTION_TYPE,
7919: IAS.ACTIVITY_RESULT_CODE H_ACTION,
7920: '#WF_NOTE#' H_COMMENT,
7921: nvl(IAS.END_DATE, IAS.BEGIN_DATE) H_ACTION_DATE
7922: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
7923: WF_ACTIVITIES A,
7924: WF_PROCESS_ACTIVITIES PA,
7925: WF_ITEMS I
7926: where IAS.ITEM_TYPE = l_item_type

Line 7949: from WF_ITEM_ACTIVITY_STATUSES IAS,

7945: '#WF_COMMENTS#' H_ACTION_TYPE,
7946: C.ACTION H_ACTION,
7947: C.USER_COMMENT H_COMMENT,
7948: C.COMMENT_DATE H_ACTION_DATE
7949: from WF_ITEM_ACTIVITY_STATUSES IAS,
7950: WF_COMMENTS C
7951: where IAS.ITEM_TYPE = l_item_type
7952: and IAS.ITEM_KEY = l_item_key
7953: and IAS.PROCESS_ACTIVITY = l_actid

Line 7967: from WF_ITEM_ACTIVITY_STATUSES_H IAS,

7963: '#WF_COMMENTS#' H_ACTION_TYPE,
7964: C.ACTION H_ACTION,
7965: C.USER_COMMENT H_COMMENT,
7966: C.COMMENT_DATE H_ACTION_DATE
7967: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
7968: WF_COMMENTS C
7969: where IAS.ITEM_TYPE = l_item_type
7970: and IAS.ITEM_KEY = l_item_key
7971: and IAS.PROCESS_ACTIVITY = l_actid

Line 7993: from WF_ITEM_ACTIVITY_STATUSES IAS,

7989: C.ACTION_TYPE H_ACTION_TYPE,
7990: C.ACTION H_ACTION,
7991: C.USER_COMMENT H_COMMENT,
7992: C.COMMENT_DATE H_ACTION_DATE
7993: from WF_ITEM_ACTIVITY_STATUSES IAS,
7994: WF_COMMENTS C
7995: where IAS.ITEM_TYPE = l_item_type
7996: and IAS.ITEM_KEY = l_item_key
7997: and IAS.PROCESS_ACTIVITY = l_actid

Line 8011: from WF_ITEM_ACTIVITY_STATUSES_H IAS,

8007: C.ACTION_TYPE H_ACTION_TYPE,
8008: C.ACTION H_ACTION,
8009: C.USER_COMMENT H_COMMENT,
8010: C.COMMENT_DATE H_ACTION_DATE
8011: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
8012: WF_COMMENTS C
8013: where IAS.ITEM_TYPE = l_item_type
8014: and IAS.ITEM_KEY = l_item_key
8015: and IAS.PROCESS_ACTIVITY = l_actid

Line 8030: FROM wf_item_activity_statuses

8026:
8027: begin
8028: SELECT item_type, item_key, process_activity
8029: INTO l_item_type, l_item_key, l_actid
8030: FROM wf_item_activity_statuses
8031: WHERE notification_id = p_nid;
8032: exception
8033: when NO_DATA_FOUND then
8034: begin

Line 8037: FROM wf_item_activity_statuses_h

8033: when NO_DATA_FOUND then
8034: begin
8035: SELECT item_type, item_key, process_activity
8036: INTO l_item_type, l_item_key, l_actid
8037: FROM wf_item_activity_statuses_h
8038: WHERE notification_id = p_nid;
8039: exception
8040: when NO_DATA_FOUND then
8041: -- It is possible that notification is sent outside of a flow,

Line 8759: -- that there will not be an entry in WF_ITEM_ACTIVITY_STATUSES and/or

8755:
8756: --
8757: -- getNtfActInfo
8758: -- Fetch Notification Activity info of a given notification. It is possible
8759: -- that there will not be an entry in WF_ITEM_ACTIVITY_STATUSES and/or
8760: -- WF_ITEM_ACTIVITY_STATUSES_H in case when the notification is sent using
8761: -- Send API instead of part of a process.
8762: -- IN
8763: -- nid - Notification ID

Line 8760: -- WF_ITEM_ACTIVITY_STATUSES_H in case when the notification is sent using

8756: --
8757: -- getNtfActInfo
8758: -- Fetch Notification Activity info of a given notification. It is possible
8759: -- that there will not be an entry in WF_ITEM_ACTIVITY_STATUSES and/or
8760: -- WF_ITEM_ACTIVITY_STATUSES_H in case when the notification is sent using
8761: -- Send API instead of part of a process.
8762: -- IN
8763: -- nid - Notification ID
8764: -- OUT

Line 8777: from WF_ITEM_ACTIVITY_STATUSES

8773: is
8774: --bug 2276260 skilaru 15-July-03
8775: cursor act_info_statuses_cursor( group_nid number ) is
8776: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
8777: from WF_ITEM_ACTIVITY_STATUSES
8778: where notification_id = group_nid;
8779:
8780: cursor act_info_statuses_h_cursor( group_nid number ) is
8781: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY

Line 8782: from WF_ITEM_ACTIVITY_STATUSES_H

8778: where notification_id = group_nid;
8779:
8780: cursor act_info_statuses_h_cursor( group_nid number ) is
8781: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
8782: from WF_ITEM_ACTIVITY_STATUSES_H
8783: where notification_id = group_nid;
8784:
8785: l_group_nid number;
8786:

Line 8789: --WF_ITEM_ACTIVITY_STATUSES.NOTIFICATION_ID is the foreing key

8785: l_group_nid number;
8786:
8787: begin
8788: --skilaru 16-July-03
8789: --WF_ITEM_ACTIVITY_STATUSES.NOTIFICATION_ID is the foreing key
8790: --mapped to WF_NOTIFICATIONS.GROUP_ID
8791: SELECT group_id
8792: INTO l_group_nid
8793: FROM wf_notifications

Line 9326: from WF_ITEM_ACTIVITY_STATUSES_H IAS,

9322:
9323: begin
9324: select A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE
9325: into l_result_type, p_result_code
9326: from WF_ITEM_ACTIVITY_STATUSES_H IAS,
9327: WF_ACTIVITIES A,
9328: WF_PROCESS_ACTIVITIES PA,
9329: WF_ITEMS I
9330: where IAS.NOTIFICATION_ID = p_nid

Line 9342: from WF_ITEM_ACTIVITY_STATUSES IAS,

9338: exception
9339: when NO_DATA_FOUND then
9340: select A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE
9341: into l_result_type, p_result_code
9342: from WF_ITEM_ACTIVITY_STATUSES IAS,
9343: WF_ACTIVITIES A,
9344: WF_PROCESS_ACTIVITIES PA,
9345: WF_ITEMS I
9346: where IAS.NOTIFICATION_ID = p_nid

Line 9384: from wf_item_activity_statuses wfas, wf_notifications wfn , wf_notification_attributes wfna

9380: is
9381: --Get the nids in curs_nid which have the attribute document_id
9382: cursor curs_nid(l_doc_id varchar2,l_item_type varchar2,l_item_key varchar2) is
9383: select wfn.notification_id
9384: from wf_item_activity_statuses wfas, wf_notifications wfn , wf_notification_attributes wfna
9385: where wfna.name = '#DOCUMENT_ID'
9386: and wfna.text_value = l_doc_id
9387: and wfas.item_type = l_item_type
9388: and wfas.item_key = l_item_key