APPS.CSM_NOTES_TYPE_MAP_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 62: l_user_List asg_download.user_list;

58: AND AUPR.PUB_NAME ='SERVICEP';
59:
60: TYPE tab_type IS TABLE OF NUMBER;
61:
62: l_user_List asg_download.user_list;
63: l_access_list asg_download.access_list;
64: l_id_tab TAB_TYPE;
65: l_lastrundate c_LastRundate%ROWTYPE;
66: l_sqlerrno VARCHAR2(20);

Line 63: l_access_list asg_download.access_list;

59:
60: TYPE tab_type IS TABLE OF NUMBER;
61:
62: l_user_List asg_download.user_list;
63: l_access_list asg_download.access_list;
64: l_id_tab TAB_TYPE;
65: l_lastrundate c_LastRundate%ROWTYPE;
66: l_sqlerrno VARCHAR2(20);
67: l_sqlerrmsg VARCHAR2(4000);

Line 97: l_dummy := asg_download.mark_dirty(g_notes_type_map_pubi_name,l_access_list, l_user_list, 'D', sysdate,TRUE );

93: CSM_UTIL_PKG.LOG('Entering DELETE to remove ' || l_access_list.count||' records',
94: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
95:
96: IF l_access_list.COUNT > 0 THEN
97: l_dummy := asg_download.mark_dirty(g_notes_type_map_pubi_name,l_access_list, l_user_list, 'D', sysdate,TRUE );
98: END IF;
99:
100: FORALL I IN 1..l_access_list.COUNT
101: DELETE FROM CSM_NOTES_TYPE_MAPPING_ACC WHERE ACCESS_ID=l_access_list(I);

Line 119: l_dummy := asg_download.mark_dirty(g_notes_type_map_pubi_name,l_access_list, l_user_list, 'U', sysdate,TRUE );

115: CSM_UTIL_PKG.LOG('Entering UPDATE to update ' || l_access_list.count||' records',
116: 'CSM_NOTES_TYPE_MAP_EVENT_PKG.REFRESH_ACC',FND_LOG.LEVEL_PROCEDURE);
117:
118: IF l_access_list.COUNT >0 THEN
119: l_dummy := asg_download.mark_dirty(g_notes_type_map_pubi_name,l_access_list, l_user_list, 'U', sysdate,TRUE );
120: END IF;
121:
122:
123: CSM_UTIL_PKG.LOG('UPDATE Successful ',

Line 161: l_dummy := asg_download.mark_dirty(g_notes_type_map_pubi_name,l_access_list, l_user_list, 'I', sysdate,TRUE );

157: ) RETURNING ACCESS_ID BULK COLLECT INTO l_access_list;
158:
159:
160: IF l_access_list.COUNT >0 THEN
161: l_dummy := asg_download.mark_dirty(g_notes_type_map_pubi_name,l_access_list, l_user_list, 'I', sysdate,TRUE );
162: END IF;
163:
164:
165: CSM_UTIL_PKG.LOG('INSERTION Successful ',