APPS.CSL_WF_NOTIFICATION_AT_ACC_PKG dependencies on WF_NOTIFICATION_ATTRIBUTES

Line 13: g_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATION_ATTRIBUTES';

9: JTM_HOOK_UTIL_PKG.t_publication_item_list('WF_NOTIFICATIONS');
10:
11: g_acc_table_name CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATION_AT_ACC';
12: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATIONS_ACC';
13: g_table_name CONSTANT VARCHAR2(30) := 'WF_NOTIFICATION_ATTRIBUTES';
14: g_table_name2 CONSTANT VARCHAR2(30) := 'WF_NOTIFICATIONS';
15: g_pk1_name CONSTANT VARCHAR2(30) := 'NOTIFICATION_ID';
16: g_pk2_name CONSTANT VARCHAR2(30) := 'NAME';
17: g_debug_level NUMBER;

Line 35: , wf_notification_attributes wna

31: IS
32: SELECT user_id
33: FROM fnd_user usr
34: , wf_notifications wno
35: , wf_notification_attributes wna
36: WHERE usr.user_name = wna.text_value
37: AND wna.notification_id = wno.notification_id
38: AND wna.notification_id = b_notification_id
39: AND wno.MESSAGE_TYPE = 'CS_MSGS'

Line 360: WF_NOTIFICATION_ATTRIBUTES WNA,

356:
357: CURSOR c_notification_sender (b_resource_id NUMBER) IS
358: SELECT DISTINCT WNO.NOTIFICATION_ID
359: FROM WF_NOTIFICATIONS WNO,
360: WF_NOTIFICATION_ATTRIBUTES WNA,
361: FND_USER USR,
362: ASG_USER ADU
363: WHERE WNO.NOTIFICATION_ID = WNA.NOTIFICATION_ID
364: AND WNA.NAME = 'SENDER'

Line 386: FROM WF_NOTIFICATION_ATTRIBUTES WNA_DEL

382: AND WNO.MESSAGE_TYPE = 'CS_MSGS'
383: AND WNO.MESSAGE_NAME = 'FYI_MESSAGE'
384: AND NOT EXISTS
385: ( SELECT NULL
386: FROM WF_NOTIFICATION_ATTRIBUTES WNA_DEL
387: WHERE WNA_DEL.NOTIFICATION_ID = WNO.NOTIFICATION_ID
388: AND WNA_DEL.NAME = 'DELETE_FLAG')
389: AND EXISTS
390: ( SELECT NULL

Line 391: FROM WF_NOTIFICATION_ATTRIBUTES WNA_DEL

387: WHERE WNA_DEL.NOTIFICATION_ID = WNO.NOTIFICATION_ID
388: AND WNA_DEL.NAME = 'DELETE_FLAG')
389: AND EXISTS
390: ( SELECT NULL
391: FROM WF_NOTIFICATION_ATTRIBUTES WNA_DEL
392: WHERE WNA_DEL.NOTIFICATION_ID = WNO.NOTIFICATION_ID
393: AND WNA_DEL.NAME = 'MESSAGE_TEXT')
394: AND EXISTS
395: ( SELECT NULL

Line 396: FROM WF_NOTIFICATION_ATTRIBUTES WNA_DEL

392: WHERE WNA_DEL.NOTIFICATION_ID = WNO.NOTIFICATION_ID
393: AND WNA_DEL.NAME = 'MESSAGE_TEXT')
394: AND EXISTS
395: ( SELECT NULL
396: FROM WF_NOTIFICATION_ATTRIBUTES WNA_DEL
397: WHERE WNA_DEL.NOTIFICATION_ID = WNO.NOTIFICATION_ID
398: AND WNA_DEL.NAME = 'SENDER'
399: AND WNA_DEL.TEXT_VALUE IN (
400: SELECT USER_NAME

Line 408: FROM WF_NOTIFICATION_ATTRIBUTES

404: r_notification_receive c_notification_receive%ROWTYPE;
405:
406: CURSOR c_get_attribute_name (p_notification_id NUMBER) IS
407: SELECT NAME
408: FROM WF_NOTIFICATION_ATTRIBUTES
409: WHERE NOTIFICATION_ID = p_notification_id;
410: r_get_attribute_name c_get_attribute_name%ROWTYPE;
411:
412: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;

Line 539: WF_NOTIFICATION_ATTRIBUTES WNA,

535: CURSOR c_notification_sender (b_resource_id NUMBER) IS
536: SELECT DISTINCT WNO.NOTIFICATION_ID,
537: USR.USER_ID
538: FROM WF_NOTIFICATIONS WNO,
539: WF_NOTIFICATION_ATTRIBUTES WNA,
540: FND_USER USR,
541: ASG_USER ADU
542: WHERE WNO.NOTIFICATION_ID = WNA.NOTIFICATION_ID
543: AND WNA.NAME = 'SENDER'

Line 561: FROM WF_NOTIFICATION_ATTRIBUTES WNA_DEL

557: AND ADU.RESOURCE_ID = b_resource_id
558: AND WNO.STATUS = 'OPEN'
559: AND NOT EXISTS
560: ( SELECT NULL
561: FROM WF_NOTIFICATION_ATTRIBUTES WNA_DEL
562: WHERE WNA_DEL.NOTIFICATION_ID = WNO.NOTIFICATION_ID
563: AND WNA_DEL.NAME = 'DELETE_FLAG');
564: r_notification_receive c_notification_receive%ROWTYPE;
565:

Line 568: FROM WF_NOTIFICATION_ATTRIBUTES

564: r_notification_receive c_notification_receive%ROWTYPE;
565:
566: CURSOR c_get_attribute_name (p_notification_id NUMBER) IS
567: SELECT NAME
568: FROM WF_NOTIFICATION_ATTRIBUTES
569: WHERE NOTIFICATION_ID = p_notification_id;
570: r_get_attribute_name c_get_attribute_name%ROWTYPE;
571:
572: l_return_value VARCHAR2(2000) := FND_API.G_RET_STS_SUCCESS;