DBA Data[Home] [Help]

APPS.IRC_NOTIFICATION_HELPER_PKG dependencies on WF_NOTIFICATION

Line 59: wf_notification.setAttrText ( p_nid

55: (trunc
56: (l_attribute_length/1950), l_max_no_of_attribs)
57: LOOP
58: l_counter := l_counter + 1;
59: wf_notification.setAttrText ( p_nid
60: , p_wf_attribute_name|| '_' ||x
61: , substr( p_wf_attribute_value
62: , ((x * 1950) - 1949)
63: , 1950

Line 74: wf_notification.setAttrText ( p_nid

70: -- hold the remainder to the value.
71: IF ((l_counter < l_max_no_of_attribs)
72: AND mod(l_attribute_length,1950)<> 0) THEN
73: l_next_attrib := l_counter + 1;
74: wf_notification.setAttrText ( p_nid
75: , p_wf_attribute_name|| '_' ||l_next_attrib
76: , substr( p_wf_attribute_value
77: , l_attribute_length
78: - (mod (l_attribute_length,1950)- 1)

Line 86: wf_notification.setAttrText ( p_nid

82: END IF;
83: ELSE
84: -- There are less than 1950 chars in the value, so it can be stored
85: -- whole in the first workflow attribute.
86: wf_notification.setAttrText ( p_nid
87: , p_wf_attribute_name|| '_' ||'1'
88: , p_wf_attribute_value
89: );
90: END IF;

Line 111: l_nid:=wf_notification.send( upper(p_user_name)

107: l_nid number;
108: BEGIN
109: --
110: l_message_type :=fnd_profile.value('IRC_WORKFLOW_ITEM_TYPE');
111: l_nid:=wf_notification.send( upper(p_user_name)
112: , l_message_type
113: , l_message_name
114: );
115: --

Line 121: wf_notification.setAttrText ( l_nid , '#FROM_ROLE' , p_from_role);

117: -- Notification
118: --
119: if(p_from_role is not null)
120: then
121: wf_notification.setAttrText ( l_nid , '#FROM_ROLE' , p_from_role);
122: end if;
123: --
124: wf_notification.setAttrText ( l_nid , 'SUBJECT' , p_subject);
125: set_v2_attributes

Line 124: wf_notification.setAttrText ( l_nid , 'SUBJECT' , p_subject);

120: then
121: wf_notification.setAttrText ( l_nid , '#FROM_ROLE' , p_from_role);
122: end if;
123: --
124: wf_notification.setAttrText ( l_nid , 'SUBJECT' , p_subject);
125: set_v2_attributes
126: (p_wf_attribute_value => p_text_body
127: ,p_wf_attribute_name => 'TEXT_BODY'
128: ,p_nid => l_nid);

Line 129: wf_notification.denormalize_notification(l_nid);

125: set_v2_attributes
126: (p_wf_attribute_value => p_text_body
127: ,p_wf_attribute_name => 'TEXT_BODY'
128: ,p_nid => l_nid);
129: wf_notification.denormalize_notification(l_nid);
130: commit;
131: RETURN l_nid;
132: END send_text_notification;
133: --

Line 154: l_nid:=wf_notification.send( upper(p_user_name)

150: l_nid number;
151: BEGIN
152: --
153: l_message_type :=fnd_profile.value('IRC_WORKFLOW_ITEM_TYPE');
154: l_nid:=wf_notification.send( upper(p_user_name)
155: , l_message_type
156: , l_message_name
157: );
158: --

Line 164: wf_notification.setAttrText ( l_nid , '#FROM_ROLE' , p_from_role);

160: -- Notification
161: --
162: if(p_from_role is not null)
163: then
164: wf_notification.setAttrText ( l_nid , '#FROM_ROLE' , p_from_role);
165: end if;
166: --
167: wf_notification.setAttrText ( l_nid , 'SUBJECT' , p_subject);
168: set_v2_attributes

Line 167: wf_notification.setAttrText ( l_nid , 'SUBJECT' , p_subject);

163: then
164: wf_notification.setAttrText ( l_nid , '#FROM_ROLE' , p_from_role);
165: end if;
166: --
167: wf_notification.setAttrText ( l_nid , 'SUBJECT' , p_subject);
168: set_v2_attributes
169: (p_wf_attribute_value => p_html_body
170: ,p_wf_attribute_name => 'HTML_BODY'
171: ,p_nid => l_nid);

Line 176: wf_notification.denormalize_notification(l_nid);

172: set_v2_attributes
173: (p_wf_attribute_value => p_text_body
174: ,p_wf_attribute_name => 'TEXT_BODY'
175: ,p_nid => l_nid);
176: wf_notification.denormalize_notification(l_nid);
177: commit;
178: RETURN l_nid;
179: END send_html_text_notification;
180: -- --------------------------------------------------------------------- *

Line 350: l_nid:=wf_notification.send(upper(p_user_name)

346: else
347: l_message_name := 'IRC_TEXT_MSG';
348: end if;
349: --
350: l_nid:=wf_notification.send(upper(p_user_name)
351: ,l_message_type
352: ,l_message_name);
353: --
354: -- p_from_role contains the name of the person who is sending this

Line 359: wf_notification.setAttrText(l_nid, '#FROM_ROLE', p_from_role);

355: -- Notification
356: --
357: if(p_from_role is not null) then
358: --
359: wf_notification.setAttrText(l_nid, '#FROM_ROLE', p_from_role);
360: --
361: end if;
362: --
363: wf_notification.setAttrText(l_nid, 'SUBJECT', p_subject);

Line 363: wf_notification.setAttrText(l_nid, 'SUBJECT', p_subject);

359: wf_notification.setAttrText(l_nid, '#FROM_ROLE', p_from_role);
360: --
361: end if;
362: --
363: wf_notification.setAttrText(l_nid, 'SUBJECT', p_subject);
364: set_v2_attributes(p_wf_attribute_value => p_text_body
365: ,p_wf_attribute_name => 'TEXT_BODY'
366: ,p_nid => l_nid);
367: --

Line 372: l_doc_text := wf_notification.getAttrText(l_nid,'IRC_RESUME_'||to_char(i));

368: if p_doc_ids.count > 0 then
369: --
370: for i in p_doc_ids.first..p_doc_ids.count loop
371: --
372: l_doc_text := wf_notification.getAttrText(l_nid,'IRC_RESUME_'||to_char(i));
373: l_doc_text := l_doc_text||'/'||p_doc_ids(i);
374: wf_notification.setAttrText(l_nid,
375: 'IRC_RESUME_'||to_char(i),
376: l_doc_text);

Line 374: wf_notification.setAttrText(l_nid,

370: for i in p_doc_ids.first..p_doc_ids.count loop
371: --
372: l_doc_text := wf_notification.getAttrText(l_nid,'IRC_RESUME_'||to_char(i));
373: l_doc_text := l_doc_text||'/'||p_doc_ids(i);
374: wf_notification.setAttrText(l_nid,
375: 'IRC_RESUME_'||to_char(i),
376: l_doc_text);
377: --
378: end loop;

Line 382: wf_notification.denormalize_notification(l_nid);

378: end loop;
379: --
380: end if;
381: --
382: wf_notification.denormalize_notification(l_nid);
383: commit;
384: return l_nid;
385: --
386: end send_attach_resume_notify;