DBA Data[Home] [Help]

APPS.CSM_MTL_SEC_INV_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 146: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

142:
143: TYPE l_num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
144: TYPE l_char_tab_type IS TABLE OF VARCHAR2(400) INDEX BY BINARY_INTEGER;
145:
146: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
147: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
148: l_tab_org_id l_num_tab_type;
149: l_tab_sub_code l_char_tab_type;
150:

Line 147: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

143: TYPE l_num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
144: TYPE l_char_tab_type IS TABLE OF VARCHAR2(400) INDEX BY BINARY_INTEGER;
145:
146: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
147: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
148: l_tab_org_id l_num_tab_type;
149: l_tab_sub_code l_char_tab_type;
150:
151: CURSOR l_last_run_date_csr

Line 212: l_markdirty := asg_download.mark_dirty(

208:
209: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from csm_mtl_sec_inv_acc' ,
210: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
211:
212: l_markdirty := asg_download.mark_dirty(
213: P_PUB_ITEM => g_pub_item
214: , p_accessList => l_tab_access_id
215: , p_userid_list => l_tab_user_id
216: , p_dml_type => 'D'

Line 241: l_markdirty := asg_download.mark_dirty(

237:
238: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records from csm_mtl_sec_inv_acc' ,
239: 'CSM_MTL_SEC_INV_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
240:
241: l_markdirty := asg_download.mark_dirty(
242: P_PUB_ITEM => g_pub_item
243: , p_accessList => l_tab_access_id
244: , p_userid_list => l_tab_user_id
245: , p_dml_type => 'U'

Line 274: /*** push to oLite using asg_download ***/

270: counter, created_by, creation_date, last_updated_by, last_update_date ,lasT_update_login)
271: VALUES (l_tab_access_id(i), l_tab_user_id(i),l_tab_org_id(i),l_tab_sub_code(i),
272: 1,fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date,1);
273:
274: /*** push to oLite using asg_download ***/
275: -- do bulk makedirty
276: l_markdirty := asg_download.mark_dirty(
277: P_PUB_ITEM => g_pub_item
278: , p_accessList => l_tab_access_id

Line 276: l_markdirty := asg_download.mark_dirty(

272: 1,fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date,1);
273:
274: /*** push to oLite using asg_download ***/
275: -- do bulk makedirty
276: l_markdirty := asg_download.mark_dirty(
277: P_PUB_ITEM => g_pub_item
278: , p_accessList => l_tab_access_id
279: , p_userid_list => l_tab_user_id
280: , p_dml_type => 'I'