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 521: from WF_ITEM_ACTIVITY_STATUSES IAS,

517: is
518: -- current notification
519: cursor hist0c(x_item_type varchar2, x_item_key varchar2, x_actid number) is
520: 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
521: from WF_ITEM_ACTIVITY_STATUSES IAS,
522: WF_ACTIVITIES A,
523: WF_PROCESS_ACTIVITIES PA,
524: WF_ITEM_TYPES IT,
525: WF_ITEMS I

Line 540: from WF_ITEM_ACTIVITY_STATUSES_H IAS,

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

Line 582: from WF_ITEM_ACTIVITY_STATUSES

578:
579: begin
580: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
581: into l_itype, l_ikey, l_actid
582: from WF_ITEM_ACTIVITY_STATUSES
583: where notification_id = nid;
584: exception
585: when NO_DATA_FOUND then
586: begin

Line 589: from WF_ITEM_ACTIVITY_STATUSES_H

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

Line 3443: FROM wf_item_activity_statuses_h

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;

Line 3625: wf_item_activity_statuses wias,

3621: is
3622: cursor c_notifications is
3623: select wi.item_key, wi.user_key, wn.notification_id
3624: from wf_items wi,
3625: wf_item_activity_statuses wias,
3626: wf_notifications wn
3627: where wi.item_key = wias.item_key
3628: and wi.item_type = wias.item_type
3629: and wias.notification_id = wn.group_id

Line 4123: FROM wf_item_activity_statuses_h wiash

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

Line 7286: from WF_ITEM_ACTIVITY_STATUSES

7282: begin
7283: -- 99% of the case, it should be found in WIAS
7284: select ITEM_TYPE, ITEM_KEY
7285: into itype, ikey
7286: from WF_ITEM_ACTIVITY_STATUSES
7287: where NOTIFICATION_ID = nid;
7288: exception
7289: when NO_DATA_FOUND then
7290: begin

Line 7294: from WF_ITEM_ACTIVITY_STATUSES_H

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

Line 7355: from WF_ITEM_ACTIVITY_STATUSES

7351: select /*+ leading(grp_id_view) */
7352: RECIPIENT_ROLE , ORIGINAL_RECIPIENT
7353: from WF_NOTIFICATIONS a ,
7354: ( select notification_id group_id
7355: from WF_ITEM_ACTIVITY_STATUSES
7356: where item_type = itype
7357: and item_key = ikey
7358: union all
7359: select notification_id group_id

Line 7360: from WF_ITEM_ACTIVITY_STATUSES_H

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

Line 8120: from WF_ITEM_ACTIVITY_STATUSES IAS,

8116: A.RESULT_TYPE H_ACTION_TYPE,
8117: IAS.ACTIVITY_RESULT_CODE H_ACTION,
8118: '#WF_NOTE#' H_COMMENT,
8119: nvl(IAS.END_DATE, IAS.BEGIN_DATE) H_ACTION_DATE
8120: from WF_ITEM_ACTIVITY_STATUSES IAS,
8121: WF_ACTIVITIES A,
8122: WF_PROCESS_ACTIVITIES PA,
8123: WF_ITEMS I
8124: where IAS.ITEM_TYPE = l_item_type

Line 8148: from WF_ITEM_ACTIVITY_STATUSES_H IAS,

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

Line 8175: from WF_ITEM_ACTIVITY_STATUSES IAS,

8171: '#WF_COMMENTS#' H_ACTION_TYPE,
8172: C.ACTION H_ACTION,
8173: C.USER_COMMENT H_COMMENT,
8174: C.COMMENT_DATE H_ACTION_DATE
8175: from WF_ITEM_ACTIVITY_STATUSES IAS,
8176: WF_COMMENTS C
8177: where IAS.ITEM_TYPE = l_item_type
8178: and IAS.ITEM_KEY = l_item_key
8179: and IAS.PROCESS_ACTIVITY = l_actid

Line 8193: from WF_ITEM_ACTIVITY_STATUSES_H IAS,

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

Line 8219: from WF_ITEM_ACTIVITY_STATUSES IAS,

8215: C.ACTION_TYPE H_ACTION_TYPE,
8216: C.ACTION H_ACTION,
8217: C.USER_COMMENT H_COMMENT,
8218: C.COMMENT_DATE H_ACTION_DATE
8219: from WF_ITEM_ACTIVITY_STATUSES IAS,
8220: WF_COMMENTS C
8221: where IAS.ITEM_TYPE = l_item_type
8222: and IAS.ITEM_KEY = l_item_key
8223: and IAS.PROCESS_ACTIVITY = l_actid

Line 8237: from WF_ITEM_ACTIVITY_STATUSES_H IAS,

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

Line 8256: FROM wf_item_activity_statuses

8252:
8253: begin
8254: SELECT item_type, item_key, process_activity
8255: INTO l_item_type, l_item_key, l_actid
8256: FROM wf_item_activity_statuses
8257: WHERE notification_id = p_nid;
8258: exception
8259: when NO_DATA_FOUND then
8260: begin

Line 8263: FROM wf_item_activity_statuses_h

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,

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

9005:
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

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

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

Line 9027: from WF_ITEM_ACTIVITY_STATUSES

9023: is
9024: --bug 2276260 skilaru 15-July-03
9025: cursor act_info_statuses_cursor( group_nid number ) is
9026: select ITEM_TYPE, ITEM_KEY, PROCESS_ACTIVITY
9027: from WF_ITEM_ACTIVITY_STATUSES
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

Line 9032: from WF_ITEM_ACTIVITY_STATUSES_H

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:

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

9035: l_group_nid number;
9036:
9037: begin
9038: --skilaru 16-July-03
9039: --WF_ITEM_ACTIVITY_STATUSES.NOTIFICATION_ID is the foreing key
9040: --mapped to WF_NOTIFICATIONS.GROUP_ID
9041: SELECT group_id
9042: INTO l_group_nid
9043: FROM wf_notifications

Line 9574: from WF_ITEM_ACTIVITY_STATUSES_H IAS,

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

Line 9590: from WF_ITEM_ACTIVITY_STATUSES IAS,

9586: exception
9587: when NO_DATA_FOUND then
9588: select A.RESULT_TYPE, IAS.ACTIVITY_RESULT_CODE
9589: into l_result_type, p_result_code
9590: from WF_ITEM_ACTIVITY_STATUSES IAS,
9591: WF_ACTIVITIES A,
9592: WF_PROCESS_ACTIVITIES PA,
9593: WF_ITEMS I
9594: where IAS.NOTIFICATION_ID = p_nid

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

9628: is
9629: --Get the nids in curs_nid which have the attribute document_id
9630: cursor curs_nid(l_doc_id varchar2,l_item_type varchar2,l_item_key varchar2) is
9631: select wfn.notification_id
9632: from wf_item_activity_statuses wfas, wf_notifications wfn , wf_notification_attributes wfna
9633: where wfna.name = '#DOCUMENT_ID'
9634: and wfna.text_value = l_doc_id
9635: and wfas.item_type = l_item_type
9636: and wfas.item_key = l_item_key