APPS.CSM_NEW_MESSAGES_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 162: l_dummy := asg_download.mark_dirty(g_new_msg_pubi_name,l_ACCESS_ID , l_tab(I).USER_ID, 'D', sysdate );

158: OPEN c_get_access(l_tab(I).MESSAGE_ID,l_tab(I).USER_ID);
159: FETCH c_get_access INTO l_access_id;
160: CLOSE c_get_access;
161:
162: l_dummy := asg_download.mark_dirty(g_new_msg_pubi_name,l_ACCESS_ID , l_tab(I).USER_ID, 'D', sysdate );
163:
164: DELETE FROM CSM_NEW_MESSAGES_ACC WHERE ACCESS_ID=l_ACCESS_ID;
165: END LOOP;
166:

Line 185: l_dummy := asg_download.mark_dirty(g_new_msg_pubi_name,l_ACCESS_ID , l_tab(I).USER_ID, 'D', sysdate );

181: OPEN c_get_access(l_tab(I).MESSAGE_ID,l_tab(I).USER_ID);
182: FETCH c_get_access INTO l_access_id;
183: CLOSE c_get_access;
184:
185: l_dummy := asg_download.mark_dirty(g_new_msg_pubi_name,l_ACCESS_ID , l_tab(I).USER_ID, 'D', sysdate );
186:
187: DELETE FROM CSM_NEW_MESSAGES_ACC WHERE ACCESS_ID=l_ACCESS_ID;
188: END LOOP;
189:

Line 406: l_dummy := asg_download.mark_dirty(g_new_msg_pubi_name,l_tab(I).ACCESS_ID ,

402: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_tab.count||' records',
403: 'CSM_NEW_MESSAGES_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
404:
405: FOR I IN 1..l_tab.COUNT LOOP
406: l_dummy := asg_download.mark_dirty(g_new_msg_pubi_name,l_tab(I).ACCESS_ID ,
407: l_tab(I).USER_ID, 'U', sysdate );
408:
409: UPDATE CSM_NEW_MESSAGES_ACC
410: SET

Line 473: l_dummy := asg_download.mark_dirty(g_new_msg_pubi_name,l_access_id , l_tab(I).USER_ID, 'I', sysdate );

469: SYSDATE,
470: 1
471: );
472:
473: l_dummy := asg_download.mark_dirty(g_new_msg_pubi_name,l_access_id , l_tab(I).USER_ID, 'I', sysdate );
474:
475: END LOOP;
476:
477: COMMIT;

Line 655: l_dummy := asg_download.mark_dirty(g_new_msg_pubi_name,l_access_id , l_tab(I).USER_ID, 'I', sysdate );

651: SYSDATE,
652: 1
653: );
654:
655: l_dummy := asg_download.mark_dirty(g_new_msg_pubi_name,l_access_id , l_tab(I).USER_ID, 'I', sysdate );
656:
657: END LOOP;
658:
659: CSM_UTIL_PKG.LOG('INSERTION Successful ',