APPS.CSM_NOTIFICATION_EVENT_PKG dependencies on CSM_CLIENT_NFN_LOG

Line 460: FOR nfn_rec IN (SELECT NOTIFICATION_ID,USER_ID FROM csm_client_nfn_log_acc acc

456: END LOOP;
457:
458: DELETE FROM csm_auto_sync_nfn WHERE CREATION_DATE < SYSDATE-l_days;
459:
460: FOR nfn_rec IN (SELECT NOTIFICATION_ID,USER_ID FROM csm_client_nfn_log_acc acc
461: WHERE NOT EXISTS (SELECT 1 FROM csm_auto_sync_nfn b
462: WHERE b.NOTIFICATION_ID=acc.NOTIFICATION_ID))
463: LOOP
464: CSM_ACC_PKG.Delete_Acc

Line 465: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_CLIENT_NFN_LOG')

461: WHERE NOT EXISTS (SELECT 1 FROM csm_auto_sync_nfn b
462: WHERE b.NOTIFICATION_ID=acc.NOTIFICATION_ID))
463: LOOP
464: CSM_ACC_PKG.Delete_Acc
465: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_CLIENT_NFN_LOG')
466: ,P_ACC_TABLE_NAME => 'CSM_CLIENT_NFN_LOG_ACC'
467: ,P_PK1_NAME => 'NOTIFICATION_ID'
468: ,P_PK1_NUM_VALUE => nfn_rec.NOTIFICATION_ID
469: ,P_USER_ID => nfn_rec.USER_ID

Line 466: ,P_ACC_TABLE_NAME => 'CSM_CLIENT_NFN_LOG_ACC'

462: WHERE b.NOTIFICATION_ID=acc.NOTIFICATION_ID))
463: LOOP
464: CSM_ACC_PKG.Delete_Acc
465: ( P_PUBLICATION_ITEM_NAMES => CSM_ACC_PKG.t_publication_item_list('CSM_CLIENT_NFN_LOG')
466: ,P_ACC_TABLE_NAME => 'CSM_CLIENT_NFN_LOG_ACC'
467: ,P_PK1_NAME => 'NOTIFICATION_ID'
468: ,P_PK1_NUM_VALUE => nfn_rec.NOTIFICATION_ID
469: ,P_USER_ID => nfn_rec.USER_ID
470: );

Line 473: DELETE FROM csm_client_nfn_log cl

469: ,P_USER_ID => nfn_rec.USER_ID
470: );
471: END LOOP;
472:
473: DELETE FROM csm_client_nfn_log cl
474: WHERE NOT EXISTS (SELECT 1 FROM csm_auto_sync_nfn b WHERE b.NOTIFICATION_ID=cl.NOTIFICATION_ID);
475:
476: COMMIT;
477:

Line 2171: DELETE FROM csm_client_nfn_log cl

2167: loop
2168: wf_notification.respond(rec.notification_id);
2169: end loop;
2170:
2171: DELETE FROM csm_client_nfn_log cl
2172: WHERE EXISTS (SELECT 1 FROM csm_auto_sync_nfn b WHERE b.NOTIFICATION_ID=cl.NOTIFICATION_ID and user_id=p_user_id);
2173:
2174: delete from csm_auto_sync_nfn where user_id=p_user_id;
2175: