APPS.CSM_DBOARD_SRCH_COLS_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 13: g_access_list asg_download.access_list;

9:
10: g_dboard_sch_cols_pkg_name CONSTANT VARCHAR2(30) := 'CSM_DBOARD_SRCH_COLS_EVENT_PKG';
11: g_dboard_sch_cols_api_name CONSTANT VARCHAR2(30) := 'REFRESH_ACC';
12:
13: g_access_list asg_download.access_list;
14:
15: PROCEDURE GET_ACCESS_LIST(p_access_id IN CSM_DASHBOARD_SEARCH_COLS_ACC.ACCESS_ID%TYPE ,
16: p_count IN NUMBER)
17: IS

Line 87: l_user_list asg_download.user_list;

83: l_tab l_tab_type;
84: l_lastrundate c_LastRundate%ROWTYPE;
85: l_dummy BOOLEAN;
86: l_access_id NUMBER;
87: l_user_list asg_download.user_list;
88: l_sqlerrno VARCHAR2(20);
89: l_sqlerrmsg VARCHAR2(4000);
90:
91: BEGIN

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

117:
118: FOR I IN 1..l_tab.COUNT
119: LOOP
120: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);
121: l_dummy := asg_download.mark_dirty(g_dboard_sch_cols_pubi_name,g_access_list,l_user_list, 'D', sysdate );
122:
123: DELETE FROM CSM_DASHBOARD_SEARCH_COLS_ACC WHERE ACCESS_ID=l_tab(I).ACCESS_ID;
124: END LOOP;
125:

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

141:
142: FOR I IN 1..l_tab.COUNT
143: LOOP
144: GET_ACCESS_LIST(l_tab(I).ACCESS_ID,l_user_list.COUNT);
145: l_dummy := asg_download.mark_dirty(g_dboard_sch_cols_pubi_name,g_access_list,l_user_list, 'U', sysdate );
146:
147: UPDATE CSM_DASHBOARD_SEARCH_COLS_ACC
148: SET
149: LAST_UPDATE_DATE=SYSDATE,

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

192: );
193:
194: GET_ACCESS_LIST(l_access_id,l_user_list.COUNT);
195:
196: l_dummy:= ASG_DOWNLOAD.mark_dirty(g_dboard_sch_cols_pubi_name,g_access_list,l_user_list,'I',SYSDATE);
197:
198: END LOOP;
199:
200: COMMIT;