APPS.CSM_AD_SIMPLE_SRCH_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 12: g_access_list asg_download.access_list;

8:
9: g_ad_simple_sch_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SIMPLE_SRCH_EVENT_PKG';
10: g_ad_simple_sch_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';
11:
12: g_access_list asg_download.access_list;
13:
14: PROCEDURE GET_ACCESS_LIST(p_access_id IN CSM_AD_SIMPLE_SEARCH_ACC.ACCESS_ID%TYPE ,
15: p_count IN NUMBER)
16: IS

Line 96: l_user_list asg_download.user_list;

92: l_tab l_tab_type;
93: l_lastrundate c_LastRundate%ROWTYPE;
94: l_dummy BOOLEAN;
95: l_access_id NUMBER;
96: l_user_list asg_download.user_list;
97: l_sqlerrno VARCHAR2(20);
98: l_sqlerrmsg VARCHAR2(4000);
99:
100: BEGIN

Line 131: l_dummy := asg_download.mark_dirty(g_ad_simple_sch_pubi_name,g_access_list,l_user_list, 'D', sysdate );

127: FOR I IN 1..l_tab.COUNT
128: LOOP
129: IF l_user_list.COUNT > 0 THEN
130: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);
131: l_dummy := asg_download.mark_dirty(g_ad_simple_sch_pubi_name,g_access_list,l_user_list, 'D', sysdate );
132: END IF;
133: DELETE FROM CSM_AD_SIMPLE_SEARCH_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;
134: END LOOP;
135:

Line 158: l_dummy := asg_download.mark_dirty(g_ad_simple_sch_pubi_name,g_access_list,l_user_list, 'U', sysdate );

154: FOR I IN 1..l_tab.COUNT
155: LOOP
156: IF l_user_list.COUNT > 0 THEN
157: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);
158: l_dummy := asg_download.mark_dirty(g_ad_simple_sch_pubi_name,g_access_list,l_user_list, 'U', sysdate );
159: END IF;
160: UPDATE CSM_AD_SIMPLE_SEARCH_ACC
161: SET
162: LAST_UPDATE_DATE=SYSDATE,

Line 215: l_dummy:= ASG_DOWNLOAD.mark_dirty(g_ad_simple_sch_pubi_name,g_access_list,l_user_list,'I',SYSDATE);

211: );
212:
213: IF l_user_list.COUNT > 0 THEN
214: GET_ACCESS_LIST(l_access_id,l_user_list.COUNT);
215: l_dummy:= ASG_DOWNLOAD.mark_dirty(g_ad_simple_sch_pubi_name,g_access_list,l_user_list,'I',SYSDATE);
216: END IF;
217:
218: END LOOP;
219: