12: r_LastRundate c_LastRundate%ROWTYPE;
13:
14: CURSOR c_notification( b_last_date DATE ) IS
15: SELECT NOTIFICATION_ID
16: FROM WF_NOTIFICATIONS
17: WHERE BEGIN_DATE >=NVL( b_last_date, BEGIN_DATE )
18: AND NOTIFICATION_ID NOT IN
19: ( SELECT NOTIFICATION_ID
20: FROM JTM_WF_NOTIFICATIONS_ACC );
16: FROM WF_NOTIFICATIONS
17: WHERE BEGIN_DATE >=NVL( b_last_date, BEGIN_DATE )
18: AND NOTIFICATION_ID NOT IN
19: ( SELECT NOTIFICATION_ID
20: FROM JTM_WF_NOTIFICATIONS_ACC );
21:
22: CURSOR c_attributes( b_notification_id NUMBER ) IS
23: SELECT NAME
24: FROM WF_NOTIFICATION_ATTRIBUTES
63: )
64: AND NOTIFICATION_ID IN
65: (
66: SELECT NOTIFICATION_ID
67: FROM JTM_WF_NOTIFICATIONS_ACC
68: WHERE RESOURCE_ID = b_resource_id
69: );
70:
71: r_get_attr_per_notification c_get_attr_per_notification%ROWTYPE;
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*/
98: CSL_WF_NOTIFICATIONS_ACC_PKG.INSERT_NOTIFICATION( r_notification.NOTIFICATION_ID );
99:
100: /*Now fetch the attributes*/
101: FOR r_attribute IN c_attributes( r_notification.NOTIFICATION_ID ) LOOP
102: CSL_WF_NOTIFICATION_AT_ACC_PKG.INSERT_NOTIFICATION_ATTRIBUTE ( r_notification.NOTIFICATION_ID