APPS.CSL_WF_NOTIFICATION_AT_ACC_PKG dependencies on CSL_WF_NOTIFICATIONS_ACC_PKG

Line 204: CSL_WF_NOTIFICATIONS_ACC_PKG.INSERT_NOTIFICATION( p_notification_id );

200: OPEN c_notification_exists( p_notification_id );
201: FETCH c_notification_exists INTO r_notification_exists;
202: IF c_notification_exists%NOTFOUND THEN
203: /*** Notification id is not in ACC table yet: Insert ***/
204: CSL_WF_NOTIFICATIONS_ACC_PKG.INSERT_NOTIFICATION( p_notification_id );
205: END IF;
206: CLOSE c_notification_exists;
207: END IF;
208:

Line 449: CSL_WF_NOTIFICATIONS_ACC_PKG.Insert_Notification(r_notification_sender.notification_id);

445: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
446: END IF;
447: ELSE
448: WHILE c_notification_sender%FOUND LOOP
449: CSL_WF_NOTIFICATIONS_ACC_PKG.Insert_Notification(r_notification_sender.notification_id);
450: OPEN c_get_attribute_name ( r_notification_sender.notification_id );
451: FETCH c_get_attribute_name INTO r_get_attribute_name;
452: IF c_get_attribute_name%NOTFOUND THEN
453: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN

Line 486: CSL_WF_NOTIFICATIONS_ACC_PKG.Insert_Notification(r_notification_receive.notification_id);

482: , v_level_id => JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM);
483: END IF;
484: ELSE
485: WHILE c_notification_receive%FOUND LOOP
486: CSL_WF_NOTIFICATIONS_ACC_PKG.Insert_Notification(r_notification_receive.notification_id);
487: OPEN c_get_attribute_name ( r_notification_receive.notification_id );
488: FETCH c_get_attribute_name INTO r_get_attribute_name;
489: IF c_get_attribute_name%NOTFOUND THEN
490: IF g_debug_level >= JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_MEDIUM THEN