APPS.CSL_NOTIFICATIONS_PKG dependencies on WF_NOTIFICATION

Line 7: g_pub_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';

3: error EXCEPTION;
4:
5: /*** Globals ***/
6: g_object_name CONSTANT VARCHAR2(30) := 'CSL_NOTIFICATIONS_PKG';
7: g_pub_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
8: g_debug_level NUMBER; -- debug level
9:
10: CURSOR c_notification( b_user_name VARCHAR2, b_tranid NUMBER) is
11: SELECT *

Line 12: FROM CSL_WF_NOTIFICATIONS_inq

8: g_debug_level NUMBER; -- debug level
9:
10: CURSOR c_notification( b_user_name VARCHAR2, b_tranid NUMBER) is
11: SELECT *
12: FROM CSL_WF_NOTIFICATIONS_inq
13: WHERE tranid$$ = b_tranid
14: AND clid$$cs = b_user_name;
15:
16: CURSOR c_notification_attr( b_user_name VARCHAR2, b_tranid NUMBER, b_notification_id NUMBER) is

Line 18: FROM CSL_WF_NOTIFICATION_ATTR_INQ

14: AND clid$$cs = b_user_name;
15:
16: CURSOR c_notification_attr( b_user_name VARCHAR2, b_tranid NUMBER, b_notification_id NUMBER) is
17: SELECT *
18: FROM CSL_WF_NOTIFICATION_ATTR_INQ
19: WHERE tranid$$ = b_tranid
20: AND clid$$cs = b_user_name
21: AND notification_id = b_notification_id;
22:

Line 47: FROM WF_NOTIFICATION_ATTRIBUTES

43: r_fnd_user c_fnd_user%ROWTYPE;
44:
45: CURSOR c_attr( b_notification_id NUMBER, b_name VARCHAR2 ) IS
46: SELECT *
47: FROM WF_NOTIFICATION_ATTRIBUTES
48: WHERE NOTIFICATION_ID = b_notification_id
49: AND NAME = b_name;
50:
51: r_attr c_attr%ROWTYPE;

Line 120: l_notification_id := WF_NOTIFICATION.Send

116: END IF;
117:
118: IF l_valid_receiver THEN
119: -- Create a notification
120: l_notification_id := WF_NOTIFICATION.Send
121: ( role => p_record.recipient_role
122: , msg_type => 'CS_MSGS' -- Service Message
123: , msg_name => 'FYI_MESSAGE' -- ...
124: );

Line 126: -- The WF_NOTIFICATION.Send API has also created the following attributes:

122: , msg_type => 'CS_MSGS' -- Service Message
123: , msg_name => 'FYI_MESSAGE' -- ...
124: );
125:
126: -- The WF_NOTIFICATION.Send API has also created the following attributes:
127: -- COMMENT, MESSAGE_TEXT, OBJECT_FORM, OBJECT_ID, OBJECT_TYPE, PRIORITY,
128: -- RESULT, SENDER.
129:
130: -- Set the 'PRIORITY' attribute for the priority of the notification

Line 131: WF_NOTIFICATION.SetAttrText

127: -- COMMENT, MESSAGE_TEXT, OBJECT_FORM, OBJECT_ID, OBJECT_TYPE, PRIORITY,
128: -- RESULT, SENDER.
129:
130: -- Set the 'PRIORITY' attribute for the priority of the notification
131: WF_NOTIFICATION.SetAttrText
132: ( l_notification_id
133: , 'PRIORITY'
134: , p_record.priority
135: );

Line 138: WF_NOTIFICATION.AddAttr

134: , p_record.priority
135: );
136:
137: -- Create a 'SUBJECT' attribute for the subject of the notification
138: WF_NOTIFICATION.AddAttr
139: ( nid => l_notification_id
140: , aname => 'SUBJECT'
141: );
142:

Line 144: WF_NOTIFICATION.SetAttrText

140: , aname => 'SUBJECT'
141: );
142:
143: -- Set the 'SUBJECT' attribute
144: WF_NOTIFICATION.SetAttrText
145: ( l_notification_id
146: , 'SUBJECT'
147: , p_record.subject
148: );

Line 161: WF_NOTIFICATION.AddAttr

157: , b_name => r_notification_attr.name );
158: FETCH c_attr INTO r_attr;
159: IF c_attr%NOTFOUND THEN
160: -- Create the attribute
161: WF_NOTIFICATION.AddAttr
162: ( nid => l_notification_id
163: , aname => r_notification_attr.name );
164: END IF;
165: CLOSE c_attr;

Line 166: WF_NOTIFICATION.SetAttrText

162: ( nid => l_notification_id
163: , aname => r_notification_attr.name );
164: END IF;
165: CLOSE c_attr;
166: WF_NOTIFICATION.SetAttrText
167: ( l_notification_id
168: , r_notification_attr.name
169: , r_notification_attr.text_value
170: );

Line 399: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item WF_NOTIFICATIONS

395: x_return_status := FND_API.G_RET_STS_ERROR;
396: END APPLY_RECORD;
397:
398: /***
399: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item WF_NOTIFICATIONS
400: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
401: a fast sync. This procedure will insert the data that came from mobile into the backend tables using
402: public APIs.
403: ***/

Line 426: /*** loop through WF_NOTIFICATION records in inqueue ***/

422: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
423: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
424: END IF;
425:
426: /*** loop through WF_NOTIFICATION records in inqueue ***/
427: FOR r_notification IN c_notification( p_user_name, p_tranid) LOOP
428:
429: SAVEPOINT save_rec;
430:

Line 482: 'WF_NOTIFICATION_ATTR',

478: p_tranid,
479: r_notification_attr.seqno$$,
480: r_notification_attr.notification_id,
481: g_object_name,
482: 'WF_NOTIFICATION_ATTR',
483: l_error_msg,
484: l_process_status
485: );
486: END LOOP;

Line 540: 'WF_NOTIFICATION_ATTR',

536: p_tranid,
537: r_notification_attr.seqno$$,
538: r_notification_attr.notification_id,
539: g_object_name,
540: 'WF_NOTIFICATION_ATTR',
541: l_error_msg,
542: l_process_status
543: );
544:

Line 602: 'WF_NOTIFICATION_ATTR',

598: p_tranid,
599: r_notification_attr.seqno$$,
600: r_notification_attr.notification_id,
601: g_object_name,
602: 'WF_NOTIFICATION_ATTR',
603: l_error_msg,
604: l_process_status
605: );
606: END LOOP;