APPS.CSM_PROFILE_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 202: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

198:
199: TYPE num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
200: TYPE char_tab_type IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
201:
202: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
203: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
204: l_tab_app_id num_tab_type;
205: l_tab_prf_id num_tab_type;
206: l_tab_l_id num_tab_type;

Line 203: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

199: TYPE num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
200: TYPE char_tab_type IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
201:
202: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
203: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
204: l_tab_app_id num_tab_type;
205: l_tab_prf_id num_tab_type;
206: l_tab_l_id num_tab_type;
207: l_tab_l_val num_tab_type;

Line 230: l_markdirty := asg_download.mark_dirty(

226:
227: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from csm_profile_option_values_acc' ,
228: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
229:
230: l_markdirty := asg_download.mark_dirty(
231: P_PUB_ITEM => g_pub_item
232: , p_accessList => l_tab_access_id
233: , p_userid_list => l_tab_user_id
234: , p_dml_type => 'D'

Line 265: l_markdirty := asg_download.mark_dirty(

261:
262: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records in csm_profile_option_values_acc' ,
263: 'CSM_PROFILE_EVENT_PKG.refresh_acc',FND_LOG.LEVEL_EVENT);
264:
265: l_markdirty := asg_download.mark_dirty(
266: P_PUB_ITEM => g_pub_item
267: , p_accessList => l_tab_access_id
268: , p_userid_list => l_tab_user_id
269: , p_dml_type => 'U'

Line 319: l_markdirty := asg_download.mark_dirty(

315: VALUES (l_tab_access_id(I),l_tab_user_id(I),l_tab_app_id(I),l_tab_prf_id(I),
316: l_tab_l_id(I),l_tab_l_val(I),l_tab_lva_id(I),l_tab_pf_val(I),l_tab_prf_name(I),
317: fnd_global.user_id, sysdate, fnd_global.user_id,sysdate, fnd_global.login_id);
318:
319: l_markdirty := asg_download.mark_dirty(
320: P_PUB_ITEM => g_pub_item
321: , p_accessList => l_tab_access_id
322: , p_userid_list => l_tab_user_id
323: , p_dml_type => 'I'

Line 425: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

421:
422: TYPE num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
423: TYPE char_tab_type IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
424:
425: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
426: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
427: l_tab_app_id num_tab_type;
428: l_tab_prf_id num_tab_type;
429: l_tab_l_id num_tab_type;

Line 426: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

422: TYPE num_tab_type IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
423: TYPE char_tab_type IS TABLE OF VARCHAR2(4000) INDEX BY BINARY_INTEGER;
424:
425: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
426: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
427: l_tab_app_id num_tab_type;
428: l_tab_prf_id num_tab_type;
429: l_tab_l_id num_tab_type;
430: l_tab_l_val num_tab_type;

Line 468: l_markdirty := asg_download.mark_dirty(

464: VALUES (l_tab_access_id(I),l_tab_user_id(I),l_tab_app_id(I),l_tab_prf_id(I),
465: l_tab_l_id(I),l_tab_l_val(I),l_tab_lva_id(I),l_tab_pf_val(I),l_tab_prf_name(I),
466: fnd_global.user_id, sysdate, fnd_global.user_id,sysdate, fnd_global.login_id);
467:
468: l_markdirty := asg_download.mark_dirty(
469: P_PUB_ITEM => g_pub_item
470: , p_accessList => l_tab_access_id
471: , p_userid_list => l_tab_user_id
472: , p_dml_type => 'I'