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_SYSTEM_ITEM_EVENT_PKG dependencies on ASG_DOWNLOAD

Line 42: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;

38: l_return_status VARCHAR2(2000);
39: l_stmt VARCHAR2(4000);
40: l_markdirty BOOLEAN;
41: l_run_date DATE;
42: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
43: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
44:
45: BEGIN
46: CSM_UTIL_PKG.LOG('Entering DELETE_SYSTEM_ITEMS ',

Line 43: l_tab_user_id ASG_DOWNLOAD.USER_LIST;

39: l_stmt VARCHAR2(4000);
40: l_markdirty BOOLEAN;
41: l_run_date DATE;
42: l_tab_access_id ASG_DOWNLOAD.ACCESS_LIST;
43: l_tab_user_id ASG_DOWNLOAD.USER_LIST;
44:
45: BEGIN
46: CSM_UTIL_PKG.LOG('Entering DELETE_SYSTEM_ITEMS ',
47: 'CSM_SYSTEM_ITEM_EVENT_PKG.DELETE_SYSTEM_ITEMS',FND_LOG.LEVEL_PROCEDURE);

Line 73: l_markdirty := asg_download.mark_dirty(

69: WHERE acc.counter = 0;
70:
71: IF l_tab_access_id.COUNT > 0 THEN
72: -- do bulk makedirty
73: l_markdirty := asg_download.mark_dirty(
74: P_PUB_ITEM => g_pub_item
75: , p_accessList => l_tab_access_id
76: , p_userid_list => l_tab_user_id
77: , p_dml_type => 'D'

Line 117: l_user_id_lst asg_download.user_list;

113: WHERE acc.user_id = p_user_id
114: AND acc.organization_id = p_old_organization_id;
115:
116: l_dummy BOOLEAN;
117: l_user_id_lst asg_download.user_list;
118: l_acc_id_lst asg_download.access_list;
119: l_old_organization_id mtl_system_items.organization_id%TYPE;
120: l_organization_id mtl_system_items.organization_id%TYPE;
121: l_userid NUMBER;

Line 118: l_acc_id_lst asg_download.access_list;

114: AND acc.organization_id = p_old_organization_id;
115:
116: l_dummy BOOLEAN;
117: l_user_id_lst asg_download.user_list;
118: l_acc_id_lst asg_download.access_list;
119: l_old_organization_id mtl_system_items.organization_id%TYPE;
120: l_organization_id mtl_system_items.organization_id%TYPE;
121: l_userid NUMBER;
122:

Line 158: l_dummy := asg_download.mark_dirty(

154:
155: -- post deletes to olite
156: IF l_acc_id_lst.COUNT > 0 THEN
157: -- do bulk makedirty
158: l_dummy := asg_download.mark_dirty(
159: P_PUB_ITEM => g_pub_item
160: , p_accessList => l_acc_id_lst
161: , p_userid_list => l_user_id_lst
162: , p_dml_type => 'D'

Line 233: l_user_id_lst asg_download.user_list;

229: TYPE org_idTab IS TABLE OF csm_system_items_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
230:
231: l_inv_id inv_idTab;
232: l_org_id org_idTab;
233: l_user_id_lst asg_download.user_list;
234: l_acc_id_lst asg_download.access_list;
235:
236: l_dummy BOOLEAN;
237: l_old_organization_id mtl_system_items.organization_id%TYPE;

Line 234: l_acc_id_lst asg_download.access_list;

230:
231: l_inv_id inv_idTab;
232: l_org_id org_idTab;
233: l_user_id_lst asg_download.user_list;
234: l_acc_id_lst asg_download.access_list;
235:
236: l_dummy BOOLEAN;
237: l_old_organization_id mtl_system_items.organization_id%TYPE;
238: l_organization_id mtl_system_items.organization_id%TYPE;

Line 293: l_dummy := asg_download.mark_dirty(

289: COUNTER,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
290: VALUES (l_acc_id_lst(i), l_user_id_lst(i), l_inv_id(i), l_org_id(i), 1, 1, l_current_run_date,1,l_current_run_date,1);
291:
292: -- do bulk makedirty
293: l_dummy := asg_download.mark_dirty(
294: P_PUB_ITEM => g_pub_item
295: , p_accessList => l_acc_id_lst
296: , p_userid_list => l_user_id_lst
297: , p_dml_type => 'I'

Line 336: l_user_id asg_download.user_list;

332: TYPE org_idTab IS TABLE OF csm_system_items_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
333:
334: l_inv_id inv_idTab;
335: l_org_id org_idTab;
336: l_user_id asg_download.user_list;
337: l_acc_id asg_download.access_list;
338:
339: l_dummy BOOLEAN;
340:

Line 337: l_acc_id asg_download.access_list;

333:
334: l_inv_id inv_idTab;
335: l_org_id org_idTab;
336: l_user_id asg_download.user_list;
337: l_acc_id asg_download.access_list;
338:
339: l_dummy BOOLEAN;
340:
341: CURSOR l_last_run_date_csr

Line 467: l_dummy := asg_download.mark_dirty(

463: EXIT WHEN l_acc_id.COUNT = 0;
464: -- post deletes to olite
465: IF l_acc_id.COUNT > 0 THEN
466: -- do bulk makedirty
467: l_dummy := asg_download.mark_dirty(
468: P_PUB_ITEM => g_pub_item_name1
469: , p_accessList => l_acc_id
470: , p_userid_list => l_user_id
471: , p_dml_type => 'D'

Line 546: l_dummy := asg_download.mark_dirty(

542:
543: -- post updates to olite
544: IF l_acc_id.COUNT > 0 THEN
545: -- do bulk makedirty
546: l_dummy := asg_download.mark_dirty(
547: P_PUB_ITEM => g_pub_item_name1
548: , p_accessList => l_acc_id
549: , p_userid_list => l_user_id
550: , p_dml_type => 'U'

Line 582: l_dummy := asg_download.mark_dirty(

578: COUNTER,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
579: VALUES (l_acc_id(i), l_user_id(i), l_inv_id(i), l_org_id(i), 1, 1, l_current_run_date,1,l_current_run_date,1);
580:
581: -- do bulk makedirty
582: l_dummy := asg_download.mark_dirty(
583: P_PUB_ITEM => g_pub_item_name1
584: , p_accessList => l_acc_id
585: , p_userid_list => l_user_id
586: , p_dml_type => 'I'

Line 759: user_id_lst asg_download.user_list;

755: loc_id loc_idTab;
756: lot_num lot_numTab;
757: qty tran_qtyTab;
758: dummy_qty tran_qtyTab;
759: user_id_lst asg_download.user_list;
760: acc_id_lst asg_download.access_list;
761:
762: l_dummy BOOLEAN;
763:

Line 760: acc_id_lst asg_download.access_list;

756: lot_num lot_numTab;
757: qty tran_qtyTab;
758: dummy_qty tran_qtyTab;
759: user_id_lst asg_download.user_list;
760: acc_id_lst asg_download.access_list;
761:
762: l_dummy BOOLEAN;
763:
764: l_current_run_date DATE;

Line 815: l_dummy := asg_download.mark_dirty(

811: CSM_UTIL_PKG.LOG('Pushing ' || acc_id_lst.COUNT || 'deleted records',
812: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
813:
814: -- do bulk makedirty
815: l_dummy := asg_download.mark_dirty(
816: P_PUB_ITEM => g_pub_item
817: , p_accessList => acc_id_lst
818: , p_userid_list => user_id_lst
819: , p_dml_type => 'D'

Line 875: --* push to oLite using asg_download *

871: FETCH l_onhand_update_csr BULK COLLECT INTO user_id_lst, inv_id, org_id, sub_code, loc_id, rvsion, lot_num, dummy_qty, qty LIMIT 100;
872: EXIT WHEN user_id_lst.COUNT = 0;
873:
874: IF user_id_lst.COUNT > 0 THEN
875: --*** push to oLite using asg_download ***
876: CSM_UTIL_PKG.LOG('Pushing ' || user_id_lst.COUNT || 'updated records',
877: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
878:
879: FORALL i IN user_id_lst.FIRST..user_id_lst.LAST

Line 893: l_dummy := asg_download.mark_dirty(

889: AND (LOT_NUMBER IS NULL OR LOT_NUMBER = lot_num(i))
890: RETURNING access_id BULK COLLECT INTO acc_id_lst;
891:
892: -- do bulk makedirty
893: l_dummy := asg_download.mark_dirty(
894: P_PUB_ITEM => g_pub_item
895: , p_accessList => acc_id_lst
896: , p_userid_list => user_id_lst
897: , p_dml_type => 'U'

Line 945: --* push to oLite using asg_download *

941: EXIT WHEN inv_id.COUNT = 0;
942:
943: -- check if there are any items to be downloaded
944: IF inv_id.COUNT > 0 THEN
945: --*** push to oLite using asg_download ***
946: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || 'inserted records',
947: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
948:
949: FOR i IN inv_id.FIRST..inv_id.LAST LOOP

Line 960: l_dummy := asg_download.mark_dirty(

956: CREATION_DATE,CREATED_BY, LAST_UPDATE_LOGIN, QUANTITY, GEN_PK) VALUES (acc_id_lst(i), user_id_lst(i), inv_id(i), org_id(i), sub_code(i),
957: loc_id(i), rvsion(i), lot_num(i), l_current_run_date,1,l_current_run_date,1, 1, qty(i), acc_id_lst(i));
958:
959: -- do bulk makedirty
960: l_dummy := asg_download.mark_dirty(
961: P_PUB_ITEM => g_pub_item
962: , p_accessList => acc_id_lst
963: , p_userid_list => user_id_lst
964: , p_dml_type => 'I'

Line 1037: l_user_id_lst asg_download.user_list;

1033: TYPE org_idTab IS TABLE OF csm_system_items_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
1034:
1035: l_inv_id inv_idTab;
1036: l_org_id org_idTab;
1037: l_user_id_lst asg_download.user_list;
1038: l_acc_id_lst asg_download.access_list;
1039:
1040: l_dummy BOOLEAN;
1041: l_organization_id mtl_system_items.organization_id%TYPE;

Line 1038: l_acc_id_lst asg_download.access_list;

1034:
1035: l_inv_id inv_idTab;
1036: l_org_id org_idTab;
1037: l_user_id_lst asg_download.user_list;
1038: l_acc_id_lst asg_download.access_list;
1039:
1040: l_dummy BOOLEAN;
1041: l_organization_id mtl_system_items.organization_id%TYPE;
1042:

Line 1069: l_dummy := asg_download.mark_dirty(

1065: COUNTER,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
1066: VALUES (l_acc_id_lst(i), l_user_id_lst(i), l_inv_id(i), l_org_id(i), 1, 1, l_current_run_date,1,l_current_run_date,1);
1067:
1068: -- do bulk makedirty
1069: l_dummy := asg_download.mark_dirty(
1070: P_PUB_ITEM => g_pub_item
1071: , p_accessList => l_acc_id_lst
1072: , p_userid_list => l_user_id_lst
1073: , p_dml_type => 'I'