APPS.CSM_AD_SRCH_REGION_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 12: g_access_list asg_download.access_list;

8:
9: g_ad_sch_region_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SRCH_REGION_EVENT_PKG';
10: g_ad_sch_region_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_REGION_ACC.ACCESS_ID%TYPE ,
15: p_count IN NUMBER)
16: IS

Line 93: l_user_list asg_download.user_list;

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

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

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

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

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

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

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