DBA Data[Home] [Help]

APPS.IRC_NOTIFICATION_HELPER_PKG dependencies on WF_NOTIFICATION

Line 60: wf_notification.setAttrText ( p_nid

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

Line 75: wf_notification.setAttrText ( p_nid

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

Line 87: wf_notification.setAttrText ( p_nid

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

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

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

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

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

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

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

Line 130: wf_notification.denormalize_notification(l_nid);

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

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

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

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

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

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

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

Line 179: wf_notification.denormalize_notification(l_nid);

175: (p_wf_attribute_value => p_text_body
176: ,p_wf_attribute_name => 'TEXT_BODY'
177: ,p_nid => l_nid);
178: end if;
179: wf_notification.denormalize_notification(l_nid);
180: commit;
181: RETURN l_nid;
182: END send_html_text_notification;
183: -- --------------------------------------------------------------------- *

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

350: else
351: l_message_name := 'IRC_TEXT_HTML_MSG';
352: end if;
353: --
354: l_nid:=wf_notification.send(upper(p_user_name)
355: ,l_message_type
356: ,l_message_name);
357: --
358: -- p_from_role contains the name of the person who is sending this

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

359: -- Notification
360: --
361: if(p_from_role is not null) then
362: --
363: wf_notification.setAttrText(l_nid, '#FROM_ROLE', p_from_role);
364: --
365: end if;
366: --
367: wf_notification.setAttrText(l_nid, 'SUBJECT', p_subject);

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

363: wf_notification.setAttrText(l_nid, '#FROM_ROLE', p_from_role);
364: --
365: end if;
366: --
367: wf_notification.setAttrText(l_nid, 'SUBJECT', p_subject);
368: set_v2_attributes(p_wf_attribute_value => p_html_body
369: ,p_wf_attribute_name => 'HTML_BODY'
370: ,p_nid => l_nid);
371: --

Line 377: wf_notification.setAttrText(l_nid,

373: --
374: for i in p_doc_ids.first..p_doc_ids.count loop
375: --
376: l_doc_text := 'plsqlblob:irc_notification_helper_pkg.show_resume/'||p_doc_ids(i);
377: wf_notification.setAttrText(l_nid,
378: 'IRC_RESUME_'||to_char(i),
379: l_doc_text);
380: --
381: end loop;

Line 385: wf_notification.denormalize_notification(l_nid);

381: end loop;
382: --
383: end if;
384: --
385: wf_notification.denormalize_notification(l_nid);
386: commit;
387: return l_nid;
388: --
389: end send_attach_resume_notify;