APPS.CSL_NOTIFICATION_ATTR_PKG dependencies on WF_NOTIFICATION

Line 8: g_pub_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATION_ATTR';

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

Line 13: FROM CSL_WF_NOTIFICATION_ATTR_inq

9: g_debug_level NUMBER; -- debug level
10:
11: CURSOR c_not_attr( b_user_name VARCHAR2, b_tranid NUMBER) is
12: SELECT *
13: FROM CSL_WF_NOTIFICATION_ATTR_inq
14: WHERE tranid$$ = b_tranid
15: AND clid$$cs = b_user_name;
16:
17: /***

Line 28: FROM WF_NOTIFICATION_ATTRIBUTES

24: x_return_status IN OUT NOCOPY VARCHAR2
25: ) IS
26: CURSOR c_attr( b_notification_id NUMBER, b_name VARCHAR2 ) IS
27: SELECT *
28: FROM WF_NOTIFICATION_ATTRIBUTES
29: WHERE NOTIFICATION_ID = b_notification_id
30: AND NAME = b_name;
31: r_attr c_attr%ROWTYPE;
32: BEGIN

Line 48: WF_NOTIFICATION.AddAttr

44: , b_name => p_record.name );
45: FETCH c_attr INTO r_attr;
46: IF c_attr%NOTFOUND THEN
47: -- Create the attribute
48: WF_NOTIFICATION.AddAttr
49: ( nid => p_record.notification_id
50: , aname => p_record.name );
51: END IF;
52: CLOSE c_attr;

Line 55: WF_NOTIFICATION.SetAttrText

51: END IF;
52: CLOSE c_attr;
53:
54: -- Set the attribute
55: WF_NOTIFICATION.SetAttrText
56: ( nid => p_record.notification_id
57: , aname => p_record.name
58: , avalue => p_record.text_value );
59:

Line 280: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item WF_NOTIFICATION_ATTR

276: x_return_status := FND_API.G_RET_STS_ERROR;
277: END APPLY_RECORD;
278:
279: /***
280: This procedure is called by CSL_SERVICEL_WRAPPER_PKG when publication item WF_NOTIFICATION_ATTR
281: is dirty. This happens when a mobile field service device executed DML on an updatable table and did
282: a fast sync. This procedure will insert the data that came from mobile into the backend tables using
283: public APIs.
284: ***/

Line 307: /*** loop through WF_NOTIFICATION_ATTR records in inqueue ***/

303: , v_message => 'Entering ' || g_object_name || '.Apply_Client_Changes'
304: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_FULL);
305: END IF;
306:
307: /*** loop through WF_NOTIFICATION_ATTR records in inqueue ***/
308: FOR r_not_attr IN c_not_attr( p_user_name, p_tranid) LOOP
309:
310: SAVEPOINT save_rec;
311: