DBA Data[Home] [Help]

APPS.CSM_MAIL_MESSAGES_PKG dependencies on WF_NOTIFICATION

Line 138: l_notification_id := wf_notification.Send

134: OPEN l_sender_full_name_csr(p_record.sender);
135: FETCH l_sender_full_name_csr INTO l_sender_full_name;
136: CLOSE l_sender_full_name_csr;
137:
138: l_notification_id := wf_notification.Send
139: ( role => p_record.receiver
140: , msg_type => 'CS_MSGS'
141: , msg_name => 'FYI_MESSAGE'
142: );

Line 145: wf_notification.SetAttrText

141: , msg_name => 'FYI_MESSAGE'
142: );
143:
144: --Bug 5337816
145: wf_notification.SetAttrText
146: ( l_notification_id
147: , '#FROM_ROLE'
148: , p_record.sender
149: );

Line 151: wf_notification.SetAttrText

147: , '#FROM_ROLE'
148: , p_record.sender
149: );
150:
151: wf_notification.SetAttrText
152: ( l_notification_id
153: , 'SENDER'
154: , l_sender_full_name
155: );

Line 157: wf_notification.SetAttrText

153: , 'SENDER'
154: , l_sender_full_name
155: );
156:
157: wf_notification.SetAttrText
158: ( l_notification_id
159: , 'MESSAGE_TEXT'
160: , p_record.message
161: );

Line 164: wf_notification.AddAttr

160: , p_record.message
161: );
162:
163: --Bug 5337816
164: wf_notification.AddAttr
165: ( l_notification_id
166: , 'MSG_SUBJECT'
167: );
168: wf_notification.SetAttrText

Line 168: wf_notification.SetAttrText

164: wf_notification.AddAttr
165: ( l_notification_id
166: , 'MSG_SUBJECT'
167: );
168: wf_notification.SetAttrText
169: ( l_notification_id
170: , 'MSG_SUBJECT'
171: , p_record.subject
172: );

Line 176: wf_notification.AddAttr

172: );
173:
174:
175: --12.1
176: wf_notification.AddAttr
177: ( l_notification_id
178: , 'MESSAGE_TYPE'
179: );
180: wf_notification.SetAttrText

Line 180: wf_notification.SetAttrText

176: wf_notification.AddAttr
177: ( l_notification_id
178: , 'MESSAGE_TYPE'
179: );
180: wf_notification.SetAttrText
181: ( l_notification_id
182: , 'MESSAGE_TYPE'
183: , NVL(p_record.message_type,'i')
184: );