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 48: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

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

Line 49: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

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

Line 176: l_markdirty := asg_download.mark_dirty(

172: l_tab_user_id.DELETE;
173: FETCH c_get_all_items_acc BULK COLLECT INTO l_tab_access_id, l_tab_user_id LIMIT 1000;
174: EXIT WHEN l_tab_access_id.COUNT =0;
175:
176: l_markdirty := asg_download.mark_dirty(
177: P_PUB_ITEM => g_pub_item
178: , p_accessList => l_tab_access_id
179: , p_userid_list => l_tab_user_id
180: , p_dml_type => 'I'

Line 205: l_markdirty := asg_download.mark_dirty(

201: l_tab_access_id.DELETE;
202: l_tab_user_id.DELETE;
203: FETCH c_get_all_items_acc BULK COLLECT INTO l_tab_access_id, l_tab_user_id LIMIT 1000;
204: EXIT WHEN l_tab_access_id.COUNT =0;
205: l_markdirty := asg_download.mark_dirty(
206: P_PUB_ITEM => g_pub_item
207: , p_accessList => l_tab_access_id
208: , p_userid_list => l_tab_user_id
209: , p_dml_type => 'I'

Line 325: l_markdirty := asg_download.mark_dirty(

321: WHERE acc.counter = 0;
322:
323: IF l_tab_access_id.COUNT > 0 THEN
324: -- do bulk makedirty
325: l_markdirty := asg_download.mark_dirty(
326: P_PUB_ITEM => g_pub_item
327: , p_accessList => l_tab_access_id
328: , p_userid_list => l_tab_user_id
329: , p_dml_type => 'D'

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

369: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
370: VALUES (l_tab_access_id(i), l_number, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
371: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
372:
373: /*** push to oLite using asg_download ***/
374: -- do bulk makedirty
375: l_markdirty := asg_download.mark_dirty(
376: P_PUB_ITEM => g_pub_item
377: , p_accessList => l_tab_access_id

Line 375: l_markdirty := asg_download.mark_dirty(

371: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
372:
373: /*** push to oLite using asg_download ***/
374: -- do bulk makedirty
375: l_markdirty := asg_download.mark_dirty(
376: P_PUB_ITEM => g_pub_item
377: , p_accessList => l_tab_access_id
378: , p_userid_list => l_tab_user_id
379: , p_dml_type => 'I'

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

410: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
411: VALUES (l_tab_access_id(i), l_number, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
412: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
413:
414: /*** push to oLite using asg_download ***/
415: -- do bulk makedirty
416: l_markdirty := asg_download.mark_dirty(
417: P_PUB_ITEM => g_pub_item
418: , p_accessList => l_tab_access_id

Line 416: l_markdirty := asg_download.mark_dirty(

412: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
413:
414: /*** push to oLite using asg_download ***/
415: -- do bulk makedirty
416: l_markdirty := asg_download.mark_dirty(
417: P_PUB_ITEM => g_pub_item
418: , p_accessList => l_tab_access_id
419: , p_userid_list => l_tab_user_id
420: , p_dml_type => 'I'

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

451: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
452: VALUES (l_tab_access_id(i), l_number, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
453: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
454:
455: /*** push to oLite using asg_download ***/
456: -- do bulk makedirty
457: l_markdirty := asg_download.mark_dirty(
458: P_PUB_ITEM => g_pub_item
459: , p_accessList => l_tab_access_id

Line 457: l_markdirty := asg_download.mark_dirty(

453: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
454:
455: /*** push to oLite using asg_download ***/
456: -- do bulk makedirty
457: l_markdirty := asg_download.mark_dirty(
458: P_PUB_ITEM => g_pub_item
459: , p_accessList => l_tab_access_id
460: , p_userid_list => l_tab_user_id
461: , p_dml_type => 'I'

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

492: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
493: VALUES (l_tab_access_id(i), l_number, l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
494: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
495:
496: /*** push to oLite using asg_download ***/
497: -- do bulk makedirty
498: l_markdirty := asg_download.mark_dirty(
499: P_PUB_ITEM => g_pub_item
500: , p_accessList => l_tab_access_id

Line 498: l_markdirty := asg_download.mark_dirty(

494: fnd_global.user_id, l_run_date, fnd_global.user_id, l_run_date, fnd_global.login_id);
495:
496: /*** push to oLite using asg_download ***/
497: -- do bulk makedirty
498: l_markdirty := asg_download.mark_dirty(
499: P_PUB_ITEM => g_pub_item
500: , p_accessList => l_tab_access_id
501: , p_userid_list => l_tab_user_id
502: , p_dml_type => 'I'

Line 536: l_tab_access_id asg_download.access_list;

532: l_sqlerrmsg VARCHAR2(4000);
533: l_error_msg VARCHAR2(4000);
534: l_return_status VARCHAR2(2000);
535: l_run_date DATE;
536: l_tab_access_id asg_download.access_list;
537: l_tab_user_id asg_download.user_list;
538: l_markdirty BOOLEAN;
539: l_max_last_update_date_b DATE;
540: l_max_last_update_date_tl DATE;

Line 537: l_tab_user_id asg_download.user_list;

533: l_error_msg VARCHAR2(4000);
534: l_return_status VARCHAR2(2000);
535: l_run_date DATE;
536: l_tab_access_id asg_download.access_list;
537: l_tab_user_id asg_download.user_list;
538: l_markdirty BOOLEAN;
539: l_max_last_update_date_b DATE;
540: l_max_last_update_date_tl DATE;
541: l_profile_value VARCHAR2(10);

Line 650: l_markdirty := asg_download.mark_dirty(

646: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for updating csm_mtl_system_items',
647: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
648: l_transaction_flag :='Y'; --this flag is to save db access
649: -- do bulk makedirty
650: l_markdirty := asg_download.mark_dirty(
651: P_PUB_ITEM => g_pub_item
652: , p_accessList => l_tab_access_id
653: , p_userid_list => l_tab_user_id
654: , p_dml_type => 'D'

Line 688: l_markdirty := asg_download.mark_dirty(

684: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for updating csm_mtl_system_items',
685: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
686:
687: -- do bulk makedirty
688: l_markdirty := asg_download.mark_dirty(
689: P_PUB_ITEM => g_pub_item
690: , p_accessList => l_tab_access_id
691: , p_userid_list => l_tab_user_id
692: , p_dml_type => 'U'

Line 736: l_markdirty := asg_download.mark_dirty(

732: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for Inerting csm_mtl_system_items',
733: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
734: l_transaction_flag := 'Y';
735: -- do bulk makedirty
736: l_markdirty := asg_download.mark_dirty(
737: P_PUB_ITEM => g_pub_item
738: , p_accessList => l_tab_access_id
739: , p_userid_list => l_tab_user_id
740: , p_dml_type => 'I'

Line 770: l_markdirty := asg_download.mark_dirty(

766: CSM_UTIL_PKG.LOG(l_tab_access_id.COUNT || ' records sent to olite for updating csm_mtl_system_items',
767: 'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.UPDATE_MTL_SYSTEM_ITEMS',FND_LOG.LEVEL_EVENT);
768:
769: -- do bulk makedirty
770: l_markdirty := asg_download.mark_dirty(
771: P_PUB_ITEM => g_pub_item
772: , p_accessList => l_tab_access_id
773: , p_userid_list => l_tab_user_id
774: , p_dml_type => 'U'

Line 809: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

805: l_stmt VARCHAR2(4000);
806: l_stmt1 VARCHAR2(4000);
807: l_markdirty BOOLEAN;
808: l_run_date DATE;
809: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
810: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
811:
812: CURSOR c_Delete_items(b_org_id NUMBER, b_user_id NUMBER)
813: IS

Line 810: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

806: l_stmt1 VARCHAR2(4000);
807: l_markdirty BOOLEAN;
808: l_run_date DATE;
809: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
810: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
811:
812: CURSOR c_Delete_items(b_org_id NUMBER, b_user_id NUMBER)
813: IS
814: SELECT b_user_id, ACCESS_ID

Line 845: l_markdirty := asg_download.mark_dirty(

841: LOOP
842: FETCH c_Delete_items BULK COLLECT INTO l_tab_user_id, l_tab_access_id LIMIT 1000;
843: EXIT WHEN l_tab_access_id.COUNT =0;
844:
845: l_markdirty := asg_download.mark_dirty(
846: P_PUB_ITEM => g_pub_item
847: , p_accessList => l_tab_access_id
848: , p_userid_list => l_tab_user_id
849: , p_dml_type => 'D'

Line 914: l_markdirty := asg_download.mark_dirty(

910: WHERE acc.counter = 0;
911:
912: IF l_tab_access_id.COUNT > 0 THEN
913: -- do bulk makedirty
914: l_markdirty := asg_download.mark_dirty(
915: P_PUB_ITEM => g_pub_item
916: , p_accessList => l_tab_access_id
917: , p_userid_list => l_tab_user_id
918: , p_dml_type => 'D'

Line 1116: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

1112: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1113: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
1114: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
1115: l_organization_id_tbl organization_id_tbl_typ;
1116: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1117: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
1118: l_markdirty BOOLEAN;
1119:
1120: BEGIN

Line 1117: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

1113: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
1114: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
1115: l_organization_id_tbl organization_id_tbl_typ;
1116: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1117: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
1118: l_markdirty BOOLEAN;
1119:
1120: BEGIN
1121:

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

1138: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
1139: VALUES (l_tab_access_id(i), l_tab_user_id(i), l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
1140: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);
1141:
1142: /*** push to oLite using asg_download ***/
1143: -- do bulk makedirty
1144: l_markdirty := asg_download.mark_dirty(
1145: P_PUB_ITEM => g_pub_item
1146: , p_accessList => l_tab_access_id

Line 1144: l_markdirty := asg_download.mark_dirty(

1140: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);
1141:
1142: /*** push to oLite using asg_download ***/
1143: -- do bulk makedirty
1144: l_markdirty := asg_download.mark_dirty(
1145: P_PUB_ITEM => g_pub_item
1146: , p_accessList => l_tab_access_id
1147: , p_userid_list => l_tab_user_id
1148: , p_dml_type => 'I'

Line 1226: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

1222: TYPE inventory_item_id_tbl_typ IS TABLE OF mtl_system_items_b.inventory_item_id%TYPE INDEX BY BINARY_INTEGER;
1223: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
1224: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
1225: l_organization_id_tbl organization_id_tbl_typ;
1226: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1227: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
1228: l_markdirty BOOLEAN;
1229: l_respId NUMBER;
1230: l_ret_acty_date DATE;

Line 1227: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

1223: TYPE organization_id_tbl_typ IS TABLE OF mtl_system_items_b.organization_id%TYPE INDEX BY BINARY_INTEGER;
1224: l_inventory_item_id_tbl inventory_item_id_tbl_typ;
1225: l_organization_id_tbl organization_id_tbl_typ;
1226: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
1227: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
1228: l_markdirty BOOLEAN;
1229: l_respId NUMBER;
1230: l_ret_acty_date DATE;
1231: l_max_mtl_items NUMBER;

Line 1252: l_markdirty := asg_download.mark_dirty(

1248: EXIT WHEN l_tab_access_id.COUNT =0;
1249:
1250: CSM_UTIL_PKG.LOG('Bulk deleted ' || l_tab_access_id.count || ' records from csm_mtl_system_items_acc','CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.process_htm5_user_items',FND_LOG.LEVEL_EVENT);
1251:
1252: l_markdirty := asg_download.mark_dirty(
1253: P_PUB_ITEM => g_pub_item
1254: , p_accessList => l_tab_access_id
1255: , p_userid_list => l_tab_user_id
1256: , p_dml_type => 'D'

Line 1276: l_markdirty := asg_download.mark_dirty(

1272: l_tab_user_id.DELETE;
1273: FETCH c_get_upd_items BULK COLLECT INTO l_tab_access_id,l_tab_user_id LIMIT 1000;
1274: EXIT WHEN l_tab_access_id.COUNT =0;
1275: CSM_UTIL_PKG.LOG('Bulk updated ' || l_tab_access_id.count || ' records from csm_mtl_system_items_acc' ,'CSM_MTL_SYSTEM_ITEMS_EVENT_PKG.process_htm5_user_items',FND_LOG.LEVEL_EVENT);
1276: l_markdirty := asg_download.mark_dirty(
1277: P_PUB_ITEM => g_pub_item
1278: , p_accessList => l_tab_access_id
1279: , p_userid_list => l_tab_user_id
1280: , p_dml_type => 'U'

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

1307: created_by, creation_date, last_updated_by, last_update_date, last_update_login)
1308: VALUES (l_tab_access_id(i), l_tab_user_id(i), l_inventory_item_id_tbl(i), l_organization_id_tbl(i), 1,
1309: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);
1310:
1311: /*** push to oLite using asg_download ***/
1312: -- do bulk makedirty
1313: l_markdirty := asg_download.mark_dirty(
1314: P_PUB_ITEM => g_pub_item
1315: , p_accessList => l_tab_access_id

Line 1313: l_markdirty := asg_download.mark_dirty(

1309: fnd_global.user_id, sysdate, fnd_global.user_id, sysdate, fnd_global.login_id);
1310:
1311: /*** push to oLite using asg_download ***/
1312: -- do bulk makedirty
1313: l_markdirty := asg_download.mark_dirty(
1314: P_PUB_ITEM => g_pub_item
1315: , p_accessList => l_tab_access_id
1316: , p_userid_list => l_tab_user_id
1317: , p_dml_type => 'I'

Line 1334: l_all_omfs_user_list asg_download.user_list;

1330: p_message OUT NOCOPY VARCHAR2)
1331: IS
1332: PRAGMA AUTONOMOUS_TRANSACTION;
1333: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
1334: l_all_omfs_user_list asg_download.user_list;
1335: l_null_omfs_user_list asg_download.user_list;
1336: l_user_id fnd_user.user_id%TYPE;
1337: l_user_organization_id mtl_system_items.organization_id%TYPE;
1338: l_user_category_set_id mtl_category_sets.category_set_id%TYPE;

Line 1335: l_null_omfs_user_list asg_download.user_list;

1331: IS
1332: PRAGMA AUTONOMOUS_TRANSACTION;
1333: l_prog_update_date jtm_con_request_data.last_run_date%TYPE;
1334: l_all_omfs_user_list asg_download.user_list;
1335: l_null_omfs_user_list asg_download.user_list;
1336: l_user_id fnd_user.user_id%TYPE;
1337: l_user_organization_id mtl_system_items.organization_id%TYPE;
1338: l_user_category_set_id mtl_category_sets.category_set_id%TYPE;
1339: l_user_category_id mtl_categories.category_id%TYPE;