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.CS_MESSAGES_PKG dependencies on WF_NOTIFICATION

Line 43: FROM wf_notifications ntf

39: FROM dual;
40:
41: CURSOR l_ntf_csr IS
42: SELECT ntf.notification_id
43: FROM wf_notifications ntf
44: WHERE ntf.group_id = l_ntf_group_id;
45:
46: CURSOR l_priority_csr IS
47: SELECT meaning

Line 62: WF_NOTIFICATION.SetAttrText(

58: PROCEDURE SetAttributes( p_nid IN NUMBER,
59: p_priority IN VARCHAR2,
60: p_ext_id IN VARCHAR2 DEFAULT NULL ) IS
61: BEGIN
62: WF_NOTIFICATION.SetAttrText(
63: nid => p_nid,
64: aname => 'OBJECT_ID',
65: avalue => p_ext_id );
66:

Line 67: WF_NOTIFICATION.SetAttrText(

63: nid => p_nid,
64: aname => 'OBJECT_ID',
65: avalue => p_ext_id );
66:
67: WF_NOTIFICATION.SetAttrText(
68: nid => p_nid,
69: aname => 'OBJECT_TYPE',
70: avalue => p_source_object_type );
71:

Line 72: WF_NOTIFICATION.SetAttrText(

68: nid => p_nid,
69: aname => 'OBJECT_TYPE',
70: avalue => p_source_object_type );
71:
72: WF_NOTIFICATION.SetAttrText(
73: nid => p_nid,
74: aname => 'SENDER',
75: avalue => p_sender );
76:

Line 77: WF_NOTIFICATION.SetAttrText(

73: nid => p_nid,
74: aname => 'SENDER',
75: avalue => p_sender );
76:
77: WF_NOTIFICATION.SetAttrText(
78: nid => p_nid,
79: aname => 'MESSAGE_TEXT',
80: avalue => p_message );
81:

Line 82: WF_NOTIFICATION.SetAttrText(

78: nid => p_nid,
79: aname => 'MESSAGE_TEXT',
80: avalue => p_message );
81:
82: WF_NOTIFICATION.SetAttrText(
83: nid => p_nid,
84: aname => 'PRIORITY',
85: avalue => p_priority );
86:

Line 87: WF_NOTIFICATION.SetAttrText(

83: nid => p_nid,
84: aname => 'PRIORITY',
85: avalue => p_priority );
86:
87: WF_NOTIFICATION.SetAttrText(
88: nid => p_nid,
89: aname => 'OBJECT_FORM',
90: avalue => p_function_name||':'||p_function_params );
91:

Line 92: WF_NOTIFICATION.SetAttrText(

88: nid => p_nid,
89: aname => 'OBJECT_FORM',
90: avalue => p_function_name||':'||p_function_params );
91:
92: WF_NOTIFICATION.SetAttrText(
93: nid => p_nid,
94: aname => '#FROM_ROLE',
95: avalue => p_sender_role);
96:

Line 99: Wf_Notification.Denormalize_Notification(p_nid);

95: avalue => p_sender_role);
96:
97:
98: -- Fix for bug 2122488--
99: Wf_Notification.Denormalize_Notification(p_nid);
100:
101: END SetAttributes;
102:
103:

Line 151: l_ntf_group_id := WF_NOTIFICATION.Send(

147: --
148: IF (p_expand_roles = 'N') THEN
149:
150: -- Do not expand roles, just call the Send API
151: l_ntf_group_id := WF_NOTIFICATION.Send(
152: role => p_receiver_role,
153: msg_type => 'CS_MSGS',
154: msg_name => 'FYI_MESSAGE',
155: due_date => NULL,

Line 164: l_ntf_group_id := WF_NOTIFICATION.SendGroup(

160:
161: ELSE
162:
163: -- Expand Roles requested, call the SendGroup API instead
164: l_ntf_group_id := WF_NOTIFICATION.SendGroup(
165: role => p_receiver_role,
166: msg_type => 'CS_MSGS',
167: msg_name => 'EXPANDED_FYI_MSG',
168: due_date => NULL,

Line 197: l_notification_id := WF_NOTIFICATION.Send(

193:
194: ELSE
195:
196: -- Action requested, send the ACTION_REQUEST_MSG message
197: l_notification_id := WF_NOTIFICATION.Send(
198: role => p_receiver_role,
199: msg_type => 'CS_MSGS',
200: msg_name => 'ACTION_REQUEST_MSG',
201: due_date => NULL,

Line 210: WF_NOTIFICATION.SetAttrText(

206:
207: -- Set the notification attributes
208: SetAttributes(l_notification_id, l_priority, l_source_obj_ext_id);
209:
210: WF_NOTIFICATION.SetAttrText(
211: nid => l_notification_id,
212: aname => 'ACTION',
213: avalue => p_action_type );
214:

Line 287: -- WF_NOTIFICATION.Respond API for more detail.

283: -- responded.
284: -- Note that the context parameter will contain the char representation
285: -- of the MESSAGE_ID. Parameter text_value and number_value will contain
286: -- the values of RESPONSE and NOTIFICATION_ID respectively. See the
287: -- WF_NOTIFICATION.Respond API for more detail.
288: -- ------------------------------------------------------------------------
289:
290: PROCEDURE Notification_Callback (
291: command IN VARCHAR2,

Line 315: FROM wf_notifications ntf, wf_roles wf, cs_messages msg

311: wf.display_name responder,
312: msg.confirmation,
313: msg.notification_id,
314: msg.sender_role sender
315: FROM wf_notifications ntf, wf_roles wf, cs_messages msg
316: WHERE msg.message_id = l_message_id
317: AND msg.notification_id = ntf.notification_id
318: AND ntf.responder = wf.name(+)
319: FOR UPDATE OF msg.message_id;

Line 369: l_comment := WF_NOTIFICATION.GetAttrText(l_ntf_rec.notification_id, 'COMMENT');

365: OPEN l_ntf_csr;
366: FETCH l_ntf_csr INTO l_ntf_rec;
367:
368: -- Get the comment of the responder
369: l_comment := WF_NOTIFICATION.GetAttrText(l_ntf_rec.notification_id, 'COMMENT');
370:
371: -- Update the row in the CS_MESSAGES table
372: UPDATE cs_messages
373: SET last_update_date = sysdate,

Line 390: l_source_type := WF_NOTIFICATION.GetAttrText(l_ntf_rec.notification_id, 'OBJECT_TYPE');

386: OPEN l_response_csr;
387: FETCH l_response_csr INTO l_response;
388: CLOSE l_response_csr;
389:
390: l_source_type := WF_NOTIFICATION.GetAttrText(l_ntf_rec.notification_id, 'OBJECT_TYPE');
391: l_source_id := WF_NOTIFICATION.GetAttrText(l_ntf_rec.notification_id, 'OBJECT_ID');
392: l_message := WF_NOTIFICATION.GetATTRTEXT(l_ntf_rec.notification_id, 'MESSAGE_TEXT');
393:
394: l_confirmation_nid := WF_NOTIFICATION.Send(

Line 391: l_source_id := WF_NOTIFICATION.GetAttrText(l_ntf_rec.notification_id, 'OBJECT_ID');

387: FETCH l_response_csr INTO l_response;
388: CLOSE l_response_csr;
389:
390: l_source_type := WF_NOTIFICATION.GetAttrText(l_ntf_rec.notification_id, 'OBJECT_TYPE');
391: l_source_id := WF_NOTIFICATION.GetAttrText(l_ntf_rec.notification_id, 'OBJECT_ID');
392: l_message := WF_NOTIFICATION.GetATTRTEXT(l_ntf_rec.notification_id, 'MESSAGE_TEXT');
393:
394: l_confirmation_nid := WF_NOTIFICATION.Send(
395: role => l_ntf_rec.sender,

Line 392: l_message := WF_NOTIFICATION.GetATTRTEXT(l_ntf_rec.notification_id, 'MESSAGE_TEXT');

388: CLOSE l_response_csr;
389:
390: l_source_type := WF_NOTIFICATION.GetAttrText(l_ntf_rec.notification_id, 'OBJECT_TYPE');
391: l_source_id := WF_NOTIFICATION.GetAttrText(l_ntf_rec.notification_id, 'OBJECT_ID');
392: l_message := WF_NOTIFICATION.GetATTRTEXT(l_ntf_rec.notification_id, 'MESSAGE_TEXT');
393:
394: l_confirmation_nid := WF_NOTIFICATION.Send(
395: role => l_ntf_rec.sender,
396: msg_type => 'CS_MSGS',

Line 394: l_confirmation_nid := WF_NOTIFICATION.Send(

390: l_source_type := WF_NOTIFICATION.GetAttrText(l_ntf_rec.notification_id, 'OBJECT_TYPE');
391: l_source_id := WF_NOTIFICATION.GetAttrText(l_ntf_rec.notification_id, 'OBJECT_ID');
392: l_message := WF_NOTIFICATION.GetATTRTEXT(l_ntf_rec.notification_id, 'MESSAGE_TEXT');
393:
394: l_confirmation_nid := WF_NOTIFICATION.Send(
395: role => l_ntf_rec.sender,
396: msg_type => 'CS_MSGS',
397: msg_name => 'CONFIRMATION_MESSAGE',
398: due_date => NULL,

Line 404: WF_NOTIFICATION.SetAttrText(

400: context => to_char(l_message_id),
401: send_comment => NULL );
402:
403: -- Set up the message attributes
404: WF_NOTIFICATION.SetAttrText(
405: nid => l_confirmation_nid,
406: aname => 'OBJECT_TYPE',
407: avalue => l_source_type );
408:

Line 409: WF_NOTIFICATION.SetAttrText(

405: nid => l_confirmation_nid,
406: aname => 'OBJECT_TYPE',
407: avalue => l_source_type );
408:
409: WF_NOTIFICATION.SetAttrText(
410: nid => l_confirmation_nid,
411: aname => 'OBJECT_ID',
412: avalue => l_source_id );
413:

Line 414: WF_NOTIFICATION.SetAttrText(

410: nid => l_confirmation_nid,
411: aname => 'OBJECT_ID',
412: avalue => l_source_id );
413:
414: WF_NOTIFICATION.SetAttrText(
415: nid => l_confirmation_nid,
416: aname => 'RESPONDER',
417: avalue => l_ntf_rec.responder );
418:

Line 419: WF_NOTIFICATION.SetAttrText(

415: nid => l_confirmation_nid,
416: aname => 'RESPONDER',
417: avalue => l_ntf_rec.responder );
418:
419: WF_NOTIFICATION.SetAttrText(
420: nid => l_confirmation_nid,
421: aname => 'RESPONSE',
422: avalue => l_response );
423:

Line 424: WF_NOTIFICATION.SetAttrText(

420: nid => l_confirmation_nid,
421: aname => 'RESPONSE',
422: avalue => l_response );
423:
424: WF_NOTIFICATION.SetAttrText(
425: nid => l_confirmation_nid,
426: aname => 'COMMENT',
427: avalue => l_comment );
428:

Line 429: WF_NOTIFICATION.SetAttrText(

425: nid => l_confirmation_nid,
426: aname => 'COMMENT',
427: avalue => l_comment );
428:
429: WF_NOTIFICATION.SetAttrText(
430: nid => l_confirmation_nid,
431: aname => 'MESSAGE',
432: avalue => l_message );
433: -- Fix for bug 2122488

Line 434: Wf_Notification.Denormalize_Notification(l_confirmation_nid);

430: nid => l_confirmation_nid,
431: aname => 'MESSAGE',
432: avalue => l_message );
433: -- Fix for bug 2122488
434: Wf_Notification.Denormalize_Notification(l_confirmation_nid);
435:
436: END IF;
437:
438: CLOSE l_ntf_csr;