APPS.CSL_CONC_NOTIFICATION_PKG dependencies on CSL_CONC_NOTIFICATION_PKG

Line 1: PACKAGE BODY CSL_CONC_NOTIFICATION_PKG AS

1: PACKAGE BODY CSL_CONC_NOTIFICATION_PKG AS
2: /* $Header: cslcnwfb.pls 115.5 2002/08/21 08:24:57 rrademak noship $ */
3:
4: PROCEDURE RUN_CONCURRENT_NOTIFICATIONS
5: IS

Line 10: WHERE package_name = 'CSL_CONC_NOTIFICATION_PKG'

6:
7: CURSOR c_LastRundate IS
8: SELECT LAST_RUN_DATE
9: FROM JTM_CON_REQUEST_DATA
10: WHERE package_name = 'CSL_CONC_NOTIFICATION_PKG'
11: AND procedure_name = 'RUN_CONCURRENT_NOTIFICATIONS';
12: r_LastRundate c_LastRundate%ROWTYPE;
13:
14: CURSOR c_notification( b_last_date DATE ) IS

Line 81: , 'CSL_CONC_NOTIFICATION_PKG'

77: IF c_LastRundate%NOTFOUND THEN
78: /*Never seeded = ERROR */
79: jtm_message_log_pkg.Log_Msg
80: ( 0
81: , 'CSL_CONC_NOTIFICATION_PKG'
82: , 'CSL_CONC_NOTIFICATION_PKG called but not seeded'
83: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
84: );
85: CLOSE c_LastRundate;

Line 82: , 'CSL_CONC_NOTIFICATION_PKG called but not seeded'

78: /*Never seeded = ERROR */
79: jtm_message_log_pkg.Log_Msg
80: ( 0
81: , 'CSL_CONC_NOTIFICATION_PKG'
82: , 'CSL_CONC_NOTIFICATION_PKG called but not seeded'
83: , JTM_HOOK_UTIL_PKG.G_DEBUG_LEVEL_ERROR
84: );
85: CLOSE c_LastRundate;
86: RETURN;

Line 93: WHERE package_name = 'CSL_CONC_NOTIFICATION_PKG'

89:
90: /*Update the last run date*/
91: UPDATE JTM_CON_REQUEST_DATA
92: SET LAST_RUN_DATE = SYSDATE
93: WHERE package_name = 'CSL_CONC_NOTIFICATION_PKG'
94: AND procedure_name = 'RUN_CONCURRENT_NOTIFICATIONS';
95:
96: FOR r_notification IN c_notification( r_LastRundate.LAST_RUN_DATE ) LOOP
97: /*We have all new notifications now call notification package*/

Line 125: END CSL_CONC_NOTIFICATION_PKG;

121: EXCEPTION WHEN OTHERS THEN
122: ROLLBACK;
123: END RUN_CONCURRENT_NOTIFICATIONS;
124:
125: END CSL_CONC_NOTIFICATION_PKG;