DBA Data[Home] [Help]

APPS.CSM_CSP_REQ_LINES_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 153: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

149: AND crld.source_id = ol.line_id
150: AND ol.LAST_UPDATE_DATE >= b_last_run_date ;
151:
152:
153: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
154: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
155: g_debug_level NUMBER;
156: l_dummy BOOLEAN;
157: l_current_run_date DATE;

Line 154: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

150: AND ol.LAST_UPDATE_DATE >= b_last_run_date ;
151:
152:
153: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
154: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
155: g_debug_level NUMBER;
156: l_dummy BOOLEAN;
157: l_current_run_date DATE;
158:

Line 196: l_dummy := asg_download.mark_dirty(

192:
193: FOR i IN l_tab_access_id.FIRST..l_tab_access_id.LAST
194: LOOP
195: -- mark dirty the record
196: l_dummy := asg_download.mark_dirty(
197: p_pub_item => g_publication_item_name1(1)
198: , p_accessid => l_tab_access_id(i)
199: , p_userid => l_tab_user_id(i)
200: , p_dml => 'U'