APPS.CSM_AD_SRCH_RESULT_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 12: g_access_list asg_download.access_list;

8:
9: g_ad_sch_result_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SRCH_RESULT_EVENT_PKG';
10: g_ad_sch_result_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_SEARCH_RESULT_ACC.ACCESS_ID%TYPE ,
15: p_count IN NUMBER)
16: IS

Line 95: l_user_list asg_download.user_list;

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

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

126: FOR I IN 1..l_tab.COUNT
127: LOOP
128: IF l_user_list.COUNT > 0 THEN --Mark dirty only if there are valid users
129: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);
130: l_dummy := asg_download.mark_dirty(g_ad_sch_result_pubi_name,g_access_list,l_user_list, 'D', sysdate );
131: END IF;
132: DELETE FROM CSM_AD_SEARCH_RESULT_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;
133: END LOOP;
134:

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

152: FOR I IN 1..l_tab.COUNT
153: LOOP
154: IF l_user_list.COUNT > 0 THEN --Mark dirty only if there are valid users
155: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);
156: l_dummy := asg_download.mark_dirty(g_ad_sch_result_pubi_name,g_access_list,l_user_list, 'U', sysdate );
157: END IF;
158: UPDATE CSM_AD_SEARCH_RESULT_ACC
159: SET
160: LAST_UPDATE_DATE=SYSDATE,

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

209: );
210:
211: IF l_user_list.COUNT > 0 THEN --Mark dirty only if there are valid users
212: GET_ACCESS_LIST(l_access_id,l_user_list.COUNT);
213: l_dummy:= ASG_DOWNLOAD.mark_dirty(g_ad_sch_result_pubi_name,g_access_list,l_user_list,'I',SYSDATE);
214: END IF;
215: END LOOP;
216:
217: IF l_tab.COUNT > 0 THEN