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_COMMENTS

Line 451: -- Construct Action History table for a given notification from the WF_COMMENTS table

447: end wf_msg_attr;
448:
449:
450: -- Wf_Ntf_History
451: -- Construct Action History table for a given notification from the WF_COMMENTS table
452: -- The table consists of actions like Reassign, More Info Request and Respond and related
453: -- comments. The user can restrict the rows in the table using the following format.
454: -- WF_NOTIFICATION(HISTORY, hide_reassign, hide_requestinfo)
455: -- Example:

Line 502: ** WF_COMMENTS table and on the Notification Activities' history. Hence, WF_NTF_HISTORY

498: end wf_ntf_history;
499:
500: /*
501: ** This Procedure is obsolete. From 11.5.10 onwards, Action History table is based on
502: ** WF_COMMENTS table and on the Notification Activities' history. Hence, WF_NTF_HISTORY
503: ** procedure is reimplemented.
504: **
505: --
506: -- Wf_Ntf_History

Line 2771: FROM wf_comments

2767:
2768: -- To check if Reassign or Request Info is performed on a FYI Notification
2769: CURSOR c_comm IS
2770: SELECT count(1)
2771: FROM wf_comments
2772: WHERE action_type in ('REASSIGN', 'QA')
2773: AND notification_id = nid
2774: AND rownum = 1;
2775:

Line 4120: wf_comments wc

4116: -- bug 8729116. Need to select only one row
4117: SELECT max(wn.notification_id)
4118: INTO prev_nid
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

Line 4134: UPDATE wf_comments

4130: AND wn.notification_id = wc.notification_id
4131: AND wc.to_role = 'WF_SYSTEM'
4132: AND wc.action_type = 'RESPOND';
4133:
4134: UPDATE wf_comments
4135: SET to_role = role,
4136: to_user = nvl(Wf_Directory.GetRoleDisplayname(role), role)
4137: WHERE notification_id = prev_nid
4138: AND to_role = 'WF_SYSTEM'

Line 6704: -- insert into WF_COMMENTS (

6700:
6701: Wf_Notification.SetComments(nid, myusername, username, 'QUESTION', action_source, substrb(comment,1,4000));
6702:
6703: -- LANGUAGE here is for FROM_USER which came from WF_NOTIFICATIONS above
6704: -- insert into WF_COMMENTS (
6705: -- NOTIFICATION_ID,
6706: -- FROM_ROLE,
6707: -- FROM_USER,
6708: -- COMMENT_DATE,

Line 6832: -- insert into WF_COMMENTS (

6828: Wf_Notification.SetComments(nid, l_from_role, recipient_role, 'ANSWER', action_source, substrb(comment,1,4000));
6829:
6830: -- LANGUAGE here is for FROM_USER which came from GetRoleDisplayName above,
6831: -- so the LANGUAGE should be current userenv('LANG').
6832: -- insert into WF_COMMENTS (
6833: -- NOTIFICATION_ID,
6834: -- FROM_ROLE,
6835: -- FROM_USER,
6836: -- COMMENT_DATE,

Line 7643: -- insert into WF_COMMENTS (

7639: Wf_Notification.SetComments(nid, myusername, l_username, 'QUESTION', null, substrb(comment,1,4000));
7640: Wf_Notification.Route(nid, 0);
7641:
7642: -- LANGUAGE here is for FROM_USER which came from WF_NOTIFICATIONS above
7643: -- insert into WF_COMMENTS (
7644: -- NOTIFICATION_ID,
7645: -- FROM_ROLE,
7646: -- FROM_USER,
7647: -- COMMENT_DATE,

Line 7738: -- insert into WF_COMMENTS (

7734: Wf_Notification.SetComments(nid, myusername, l_recip_role, 'ANSWER', null, substrb(comment,1,4000));
7735:
7736: -- LANGUAGE here is for FROM_USER which came from GetRoleDisplayName above,
7737: -- so the LANGUAGE should be current userenv('LANG').
7738: -- insert into WF_COMMENTS (
7739: -- NOTIFICATION_ID,
7740: -- FROM_ROLE,
7741: -- FROM_USER,
7742: -- COMMENT_DATE,

Line 8030: FROM wf_comments

8026: last_ques out nocopy varchar2)
8027: is
8028: CURSOR c_ques IS
8029: SELECT user_comment
8030: FROM wf_comments
8031: WHERE notification_id = nid
8032: AND action in ('QUESTION', 'QUESTION_WA', 'QUESTION_RULE')
8033: ORDER BY comment_date desc;
8034: begin

Line 8171: '#WF_COMMENTS#' H_ACTION_TYPE,

8167: C.FROM_ROLE H_FROM_ROLE,
8168: C.FROM_USER H_FROM_USER,
8169: C.TO_ROLE H_TO_ROLE,
8170: C.TO_USER H_TO_USER,
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,

Line 8176: WF_COMMENTS C

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
8180: and IAS.NOTIFICATION_ID = C.NOTIFICATION_ID

Line 8189: '#WF_COMMENTS#' H_ACTION_TYPE,

8185: C.FROM_ROLE H_FROM_ROLE,
8186: C.FROM_USER H_FROM_USER,
8187: C.TO_ROLE H_TO_ROLE,
8188: C.TO_USER H_TO_USER,
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,

Line 8194: WF_COMMENTS C

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
8198: and IAS.NOTIFICATION_ID = C.NOTIFICATION_ID

Line 8220: WF_COMMENTS C

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
8224: and IAS.NOTIFICATION_ID = C.NOTIFICATION_ID

Line 8238: WF_COMMENTS C

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
8242: and IAS.NOTIFICATION_ID = C.NOTIFICATION_ID

Line 8361: -- If the record is not from WF_COMMENTS, need to resolve the action

8357: end if;
8358:
8359: j := j+1;
8360:
8361: -- If the record is not from WF_COMMENTS, need to resolve the action
8362: if (l_comm_rec.h_action_type <> '#WF_COMMENTS#') then
8363: l_action_str := Wf_Core.Activity_Result(l_comm_rec.h_action_type, l_comm_rec.h_action);
8364: else
8365: l_action := l_comm_rec.h_action;

Line 8362: if (l_comm_rec.h_action_type <> '#WF_COMMENTS#') then

8358:
8359: j := j+1;
8360:
8361: -- If the record is not from WF_COMMENTS, need to resolve the action
8362: if (l_comm_rec.h_action_type <> '#WF_COMMENTS#') then
8363: l_action_str := Wf_Core.Activity_Result(l_comm_rec.h_action_type, l_comm_rec.h_action);
8364: else
8365: l_action := l_comm_rec.h_action;
8366: --l_pos := instr(l_action, '_', 1);

Line 9343: -- Private procedure that is used to store a comment record into WF_COMMENTS

9339: end SetUIErrorMessage;
9340:
9341: --
9342: -- SetComments
9343: -- Private procedure that is used to store a comment record into WF_COMMENTS
9344: -- table with the denormalized information. A record is inserted for every
9345: -- action performed on a notification.
9346: -- IN
9347: -- p_nid - Notification Id

Line 9419: INSERT INTO wf_comments (

9415: -- Calculate sequence for comments in the same session
9416: l_seq_num := g_comments_seq + 1;
9417: g_comments_seq := g_comments_seq + 1;
9418:
9419: INSERT INTO wf_comments (
9420: sequence,
9421: notification_id,
9422: from_role,
9423: from_user,

Line 9618: -- to WF_COMMENTS table.

9614:
9615: --
9616: -- PropagateHistory (PUBLIC)
9617: -- This API allows Product Teams to publish custom action
9618: -- to WF_COMMENTS table.
9619: --
9620: procedure PropagateHistory(p_item_type in varchar2,
9621: p_item_key in varchar2,
9622: p_document_id in varchar2,