DBA Data[Home] [Help]

APPS.CSL_WF_NOTIFICATIONS_ACC_PKG dependencies on WF_NOTIFICATIONS

Line 1: PACKAGE BODY CSL_WF_NOTIFICATIONS_ACC_PKG AS

1: PACKAGE BODY CSL_WF_NOTIFICATIONS_ACC_PKG AS
2: /* $Header: cslwnacb.pls 115.5 2002/08/21 07:50:03 rrademak ship $ */
3:
4:
5: /*** Globals for notifications ***/

Line 6: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATIONS_ACC';

2: /* $Header: cslwnacb.pls 115.5 2002/08/21 07:50:03 rrademak ship $ */
3:
4:
5: /*** Globals for notifications ***/
6: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATIONS_ACC';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');
9: g_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';

Line 8: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');

4:
5: /*** Globals for notifications ***/
6: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATIONS_ACC';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');
9: g_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
11: g_debug_level NUMBER;
12:

Line 9: g_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';

5: /*** Globals for notifications ***/
6: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATIONS_ACC';
7: g_publication_item_name CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
8: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');
9: g_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
10: g_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
11: g_debug_level NUMBER;
12:
13: FUNCTION REPLICATE_RECORD( p_notification_id IN NUMBER )

Line 19: FROM WF_NOTIFICATIONS wn

15: IS
16: CURSOR c_notification( b_notification_id NUMBER ) IS
17: SELECT wn.RECIPIENT_ROLE
18: , wna.TEXT_VALUE
19: FROM WF_NOTIFICATIONS wn
20: , WF_NOTIFICATION_ATTRIBUTES wna
21: WHERE wn.NOTIFICATION_ID = b_notification_id
22: AND wn.MESSAGE_TYPE = 'CS_MSGS'
23: AND wn.MESSAGE_NAME = 'FYI_MESSAGE'

Line 117: , wf_notifications wfn

113: SELECT jre.resource_id
114: , usr.user_id
115: FROM jtf_rs_resource_extns jre
116: , fnd_user usr
117: , wf_notifications wfn
118: WHERE wfn.recipient_role = usr.user_name
119: AND usr.user_id = jre.user_id
120: AND jre.category = 'EMPLOYEE'
121: AND wfn.notification_id = b_notification_id;

Line 197: END CSL_WF_NOTIFICATIONS_ACC_PKG;

193: END IF;
194:
195: END INSERT_NOTIFICATION;
196:
197: END CSL_WF_NOTIFICATIONS_ACC_PKG;