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 456: -- Construct Action History table for a given notification from the WF_COMMENTS table

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

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

503: end wf_ntf_history;
504:
505: /*
506: ** This Procedure is obsolete. From 11.5.10 onwards, Action History table is based on
507: ** WF_COMMENTS table and on the Notification Activities' history. Hence, WF_NTF_HISTORY
508: ** procedure is reimplemented.
509: **
510: --
511: -- Wf_Ntf_History

Line 2685: FROM wf_comments

2681:
2682: -- To check if Reassign or Request Info is performed on a FYI Notification
2683: CURSOR c_comm IS
2684: SELECT count(1)
2685: FROM wf_comments
2686: WHERE action_type in ('REASSIGN', 'QA')
2687: AND notification_id = nid
2688: AND rownum = 1;
2689:

Line 3988: wf_comments wc

3984: if (itemtype is not null AND itemkey is not null AND actid is not null) then
3985: SELECT wn.notification_id
3986: INTO prev_nid
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

Line 4002: UPDATE wf_comments

3998: AND wn.notification_id = wc.notification_id
3999: AND wc.to_role = 'WF_SYSTEM'
4000: AND wc.action_type = 'RESPOND';
4001:
4002: UPDATE wf_comments
4003: SET to_role = role,
4004: to_user = nvl(Wf_Directory.GetRoleDisplayname(role), role)
4005: WHERE notification_id = prev_nid
4006: AND to_role = 'WF_SYSTEM'

Line 6923: -- insert into WF_COMMENTS (

6919:
6920: Wf_Notification.SetComments(nid, myusername, username, 'QUESTION', action_source, substrb(comment,1,4000));
6921:
6922: -- LANGUAGE here is for FROM_USER which came from WF_NOTIFICATIONS above
6923: -- insert into WF_COMMENTS (
6924: -- NOTIFICATION_ID,
6925: -- FROM_ROLE,
6926: -- FROM_USER,
6927: -- COMMENT_DATE,

Line 7036: -- insert into WF_COMMENTS (

7032: Wf_Notification.Route(nid, 0);
7033:
7034: -- LANGUAGE here is for FROM_USER which came from GetRoleDisplayName above,
7035: -- so the LANGUAGE should be current userenv('LANG').
7036: -- insert into WF_COMMENTS (
7037: -- NOTIFICATION_ID,
7038: -- FROM_ROLE,
7039: -- FROM_USER,
7040: -- COMMENT_DATE,

Line 7418: -- insert into WF_COMMENTS (

7414:
7415: Wf_Notification.SetComments(nid, myusername, l_username, 'QUESTION', null, substrb(comment,1,4000));
7416:
7417: -- LANGUAGE here is for FROM_USER which came from WF_NOTIFICATIONS above
7418: -- insert into WF_COMMENTS (
7419: -- NOTIFICATION_ID,
7420: -- FROM_ROLE,
7421: -- FROM_USER,
7422: -- COMMENT_DATE,

Line 7512: -- insert into WF_COMMENTS (

7508: Wf_Notification.SetComments(nid, myusername, l_recip_role, 'ANSWER', null, substrb(comment,1,4000));
7509:
7510: -- LANGUAGE here is for FROM_USER which came from GetRoleDisplayName above,
7511: -- so the LANGUAGE should be current userenv('LANG').
7512: -- insert into WF_COMMENTS (
7513: -- NOTIFICATION_ID,
7514: -- FROM_ROLE,
7515: -- FROM_USER,
7516: -- COMMENT_DATE,

Line 7804: FROM wf_comments

7800: last_ques out nocopy varchar2)
7801: is
7802: CURSOR c_ques IS
7803: SELECT user_comment
7804: FROM wf_comments
7805: WHERE notification_id = nid
7806: AND action = 'QUESTION'
7807: ORDER BY comment_date desc;
7808: begin

Line 7945: '#WF_COMMENTS#' H_ACTION_TYPE,

7941: C.FROM_ROLE H_FROM_ROLE,
7942: C.FROM_USER H_FROM_USER,
7943: C.TO_ROLE H_TO_ROLE,
7944: C.TO_USER H_TO_USER,
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,

Line 7950: WF_COMMENTS C

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

Line 7963: '#WF_COMMENTS#' H_ACTION_TYPE,

7959: C.FROM_ROLE H_FROM_ROLE,
7960: C.FROM_USER H_FROM_USER,
7961: C.TO_ROLE H_TO_ROLE,
7962: C.TO_USER H_TO_USER,
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,

Line 7968: WF_COMMENTS C

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

Line 7994: WF_COMMENTS C

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

Line 8012: WF_COMMENTS C

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

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

8126: end if;
8127:
8128: j := j+1;
8129:
8130: -- If the record is not from WF_COMMENTS, need to resolve the action
8131: if (l_comm_rec.h_action_type <> '#WF_COMMENTS#') then
8132: l_action_str := Wf_Core.Activity_Result(l_comm_rec.h_action_type, l_comm_rec.h_action);
8133: else
8134: l_action := l_comm_rec.h_action;

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

8127:
8128: j := j+1;
8129:
8130: -- If the record is not from WF_COMMENTS, need to resolve the action
8131: if (l_comm_rec.h_action_type <> '#WF_COMMENTS#') then
8132: l_action_str := Wf_Core.Activity_Result(l_comm_rec.h_action_type, l_comm_rec.h_action);
8133: else
8134: l_action := l_comm_rec.h_action;
8135: l_pos := instr(l_action, '_', 1);

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

9091: end SetUIErrorMessage;
9092:
9093: --
9094: -- SetComments
9095: -- Private procedure that is used to store a comment record into WF_COMMENTS
9096: -- table with the denormalized information. A record is inserted for every
9097: -- action performed on a notification.
9098: -- IN
9099: -- p_nid - Notification Id

Line 9171: INSERT INTO wf_comments (

9167: -- Calculate sequence for comments in the same session
9168: l_seq_num := g_comments_seq + 1;
9169: g_comments_seq := g_comments_seq + 1;
9170:
9171: INSERT INTO wf_comments (
9172: sequence,
9173: notification_id,
9174: from_role,
9175: from_user,

Line 9370: -- to WF_COMMENTS table.

9366:
9367: --
9368: -- PropagateHistory (PUBLIC)
9369: -- This API allows Product Teams to publish custom action
9370: -- to WF_COMMENTS table.
9371: --
9372: procedure PropagateHistory(p_item_type in varchar2,
9373: p_item_key in varchar2,
9374: p_document_id in varchar2,