eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSM_MTL_SYSTEM_ITEMS_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 47: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

43: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
44:
45: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
46: l_organization_id_tbl organization_id_tbl_typ;
47: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
48: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
49:
50: -- Both category and cat set are null
51: CURSOR c_items (b_user_id NUMBER, b_organization_id NUMBER,

Line 48: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

44:
45: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
46: l_organization_id_tbl organization_id_tbl_typ;
47: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
48: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
49:
50: -- Both category and cat set are null
51: CURSOR c_items (b_user_id NUMBER, b_organization_id NUMBER,
52: b_changed VARCHAR2, b_last_run_date DATE)

Line 236: l_markdirty := asg_download.mark_dirty(

232: WHERE acc.counter = 0;
233:
234: IF l_tab_access_id.COUNT > 0 THEN
235: -- do bulk makedirty
236: l_markdirty := asg_download.mark_dirty(
237: P_PUB_ITEM => g_pub_item
238: , p_accessList => l_tab_access_id
239: , p_userid_list => l_tab_user_id
240: , p_dml_type => 'D'

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

274: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
275: VALUES (l_tab_access_id(i), p_user_id, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
276: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
277:
278: /*** push to oLite using asg_download ***/
279: -- do bulk makedirty
280: l_markdirty := asg_download.mark_dirty(
281: P_PUB_ITEM => g_pub_item
282: , p_accessList => l_tab_access_id

Line 280: l_markdirty := asg_download.mark_dirty(

276: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
277:
278: /*** push to oLite using asg_download ***/
279: -- do bulk makedirty
280: l_markdirty := asg_download.mark_dirty(
281: P_PUB_ITEM => g_pub_item
282: , p_accessList => l_tab_access_id
283: , p_userid_list => l_tab_user_id
284: , p_dml_type => 'I'

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

315: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
316: VALUES (l_tab_access_id(i), p_user_id, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
317: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
318:
319: /*** push to oLite using asg_download ***/
320: -- do bulk makedirty
321: l_markdirty := asg_download.mark_dirty(
322: P_PUB_ITEM => g_pub_item
323: , p_accessList => l_tab_access_id

Line 321: l_markdirty := asg_download.mark_dirty(

317: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
318:
319: /*** push to oLite using asg_download ***/
320: -- do bulk makedirty
321: l_markdirty := asg_download.mark_dirty(
322: P_PUB_ITEM => g_pub_item
323: , p_accessList => l_tab_access_id
324: , p_userid_list => l_tab_user_id
325: , p_dml_type => 'I'

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

356: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
357: VALUES (l_tab_access_id(i), p_user_id, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
358: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
359:
360: /*** push to oLite using asg_download ***/
361: -- do bulk makedirty
362: l_markdirty := asg_download.mark_dirty(
363: P_PUB_ITEM => g_pub_item
364: , p_accessList => l_tab_access_id

Line 362: l_markdirty := asg_download.mark_dirty(

358: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
359:
360: /*** push to oLite using asg_download ***/
361: -- do bulk makedirty
362: l_markdirty := asg_download.mark_dirty(
363: P_PUB_ITEM => g_pub_item
364: , p_accessList => l_tab_access_id
365: , p_userid_list => l_tab_user_id
366: , p_dml_type => 'I'

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

397: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
398: VALUES (l_tab_access_id(i), p_user_id, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
399: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
400:
401: /*** push to oLite using asg_download ***/
402: -- do bulk makedirty
403: l_markdirty := asg_download.mark_dirty(
404: P_PUB_ITEM => g_pub_item
405: , p_accessList => l_tab_access_id

Line 403: l_markdirty := asg_download.mark_dirty(

399: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
400:
401: /*** push to oLite using asg_download ***/
402: -- do bulk makedirty
403: l_markdirty := asg_download.mark_dirty(
404: P_PUB_ITEM => g_pub_item
405: , p_accessList => l_tab_access_id
406: , p_userid_list => l_tab_user_id
407: , p_dml_type => 'I'

Line 437: l_tab_access_id asg_download.access_list;

433: l_sqlerrmsg VARCHAR2(4000);
434: l_error_msg VARCHAR2(4000);
435: l_return_status VARCHAR2(2000);
436: l_run_date DATE;
437: l_tab_access_id asg_download.access_list;
438: l_tab_user_id asg_download.user_list;
439: l_markdirty BOOLEAN;
440: l_max_last_update_date_b DATE;
441: l_max_last_update_date_tl DATE;

Line 438: l_tab_user_id asg_download.user_list;

434: l_error_msg VARCHAR2(4000);
435: l_return_status VARCHAR2(2000);
436: l_run_date DATE;
437: l_tab_access_id asg_download.access_list;
438: l_tab_user_id asg_download.user_list;
439: l_markdirty BOOLEAN;
440: l_max_last_update_date_b DATE;
441: l_max_last_update_date_tl DATE;
442:

Line 486: l_markdirty := asg_download.mark_dirty(

482: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for updating csm_mtl_system_items',
483: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
484:
485: -- do bulk makedirty
486: l_markdirty := asg_download.mark_dirty(
487: P_PUB_ITEM => g_pub_item
488: , p_accessList => l_tab_access_id
489: , p_userid_list => l_tab_user_id
490: , p_dml_type => 'U'

Line 521: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

517: l_stmt VARCHAR2(4000);
518: l_stmt1 VARCHAR2(4000);
519: l_markdirty BOOLEAN;
520: l_run_date DATE;
521: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
522: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
523:
524: BEGIN
525: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS ',

Line 522: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

518: l_stmt1 VARCHAR2(4000);
519: l_markdirty BOOLEAN;
520: l_run_date DATE;
521: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
522: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
523:
524: BEGIN
525: CSM_UTIL_PKG.LOG('Entering CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS ',
526: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.DELETE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

Line 578: l_markdirty := asg_download.mark_dirty(

574: WHERE acc.counter = 0;
575:
576: IF l_tab_access_id.COUNT > 0 THEN
577: -- do bulk makedirty
578: l_markdirty := asg_download.mark_dirty(
579: P_PUB_ITEM => g_pub_item
580: , p_accessList => l_tab_access_id
581: , p_userid_list => l_tab_user_id
582: , p_dml_type => 'D'

Line 747: l_all_omfs_user_list asg_download.user_list;

743: p_message OUT NOCOPY VARCHAR2)
744: IS
745: PRAGMA AUTONOMOUS_TRANSACTION;
746: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
747: l_all_omfs_user_list asg_download.user_list;
748: l_null_omfs_user_list asg_download.user_list;
749: l_user_id fnd_user.user_id%TYPE;
750: l_user_organization_id mtl_system_items.organization_id%TYPE;
751: l_user_category_set_id mtl_category_sets.category_set_id%TYPE;

Line 748: l_null_omfs_user_list asg_download.user_list;

744: IS
745: PRAGMA AUTONOMOUS_TRANSACTION;
746: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
747: l_all_omfs_user_list asg_download.user_list;
748: l_null_omfs_user_list asg_download.user_list;
749: l_user_id fnd_user.user_id%TYPE;
750: l_user_organization_id mtl_system_items.organization_id%TYPE;
751: l_user_category_set_id mtl_category_sets.category_set_id%TYPE;
752: l_user_category_id mtl_categories.category_id%TYPE;