APPS.CSM_AD_SRCH_TITLE_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 12: g_access_list asg_download.access_list;

8:
9: g_ad_sch_title_pkg_name CONSTANT VARCHAR2(30) := 'CSM_AD_SRCH_TITLE_EVENT_PKG';
10: g_ad_sch_title_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_TITLE_ACC.ACCESS_ID%TYPE ,
15: p_count IN NUMBER)
16: IS

Line 91: l_user_list asg_download.user_list;

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

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

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

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

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

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

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