DBA Data[Home] [Help]

APPS.CSL_WF_NOTIFICATION_AT_ACC_PKG dependencies on JTM_WF_NOTIFICATIONS_ACC

Line 12: g_acc_table_name2 CONSTANT VARCHAR2(30) := 'JTM_WF_NOTIFICATIONS_ACC';

8: g_publication_item_name2 CONSTANT JTM_HOOK_UTIL_PKG.t_publication_item_list :=
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';

Line 89: FROM JTM_WF_NOTIFICATIONS_ACC

85:
86: CURSOR c_notification_exists( b_notification_id NUMBER ) IS
87: SELECT access_id
88: , resource_id
89: FROM JTM_WF_NOTIFICATIONS_ACC
90: WHERE NOTIFICATION_ID = b_notification_id;
91:
92: r_notification_exists c_notification_exists%ROWTYPE;
93: