APPS.CSM_NOTES_TYPE_MAP_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 64: l_user_List asg_download.user_list;

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

Line 65: l_access_list asg_download.access_list;

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

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

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

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

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

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

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