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: l_curr_user_id asg_download.user_list;
339:
340: l_dummy BOOLEAN;

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: l_curr_user_id asg_download.user_list;
339:
340: l_dummy BOOLEAN;
341:

Line 338: l_curr_user_id asg_download.user_list;

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: l_curr_user_id asg_download.user_list;
339:
340: l_dummy BOOLEAN;
341:
342: l_org_count NUMBER;

Line 485: l_dummy := asg_download.mark_dirty(

481: EXIT WHEN l_acc_id.COUNT = 0;
482: -- post deletes to olite
483: IF l_acc_id.COUNT > 0 THEN
484: -- do bulk makedirty
485: l_dummy := asg_download.mark_dirty(
486: P_PUB_ITEM => g_pub_item_name1
487: , p_accessList => l_acc_id
488: , p_userid_list => l_user_id
489: , p_dml_type => 'D'

Line 564: l_dummy := asg_download.mark_dirty(

560:
561: -- post updates to olite
562: IF l_acc_id.COUNT > 0 THEN
563: -- do bulk makedirty
564: l_dummy := asg_download.mark_dirty(
565: P_PUB_ITEM => g_pub_item_name1
566: , p_accessList => l_acc_id
567: , p_userid_list => l_user_id
568: , p_dml_type => 'U'

Line 629: l_dummy := asg_download.mark_dirty(

625: l_current_run_date, 1)
626: RETURNING access_id, user_id BULK COLLECT INTO l_acc_id, l_curr_user_id;
627:
628: -- do bulk makedirty
629: l_dummy := asg_download.mark_dirty(
630: P_PUB_ITEM => g_pub_item_name1
631: , p_accessList => l_acc_id
632: , p_userid_list => l_curr_user_id
633: , p_dml_type => 'I'

Line 671: l_dummy := asg_download.mark_dirty(

667: COUNTER,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
668: 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);
669:
670: -- do bulk makedirty
671: l_dummy := asg_download.mark_dirty(
672: P_PUB_ITEM => g_pub_item_name1
673: , p_accessList => l_acc_id
674: , p_userid_list => l_user_id
675: , p_dml_type => 'I'

Line 848: user_id_lst asg_download.user_list;

844: loc_id loc_idTab;
845: lot_num lot_numTab;
846: qty tran_qtyTab;
847: dummy_qty tran_qtyTab;
848: user_id_lst asg_download.user_list;
849: acc_id_lst asg_download.access_list;
850:
851: l_dummy BOOLEAN;
852:

Line 849: acc_id_lst asg_download.access_list;

845: lot_num lot_numTab;
846: qty tran_qtyTab;
847: dummy_qty tran_qtyTab;
848: user_id_lst asg_download.user_list;
849: acc_id_lst asg_download.access_list;
850:
851: l_dummy BOOLEAN;
852:
853: l_current_run_date DATE;

Line 908: l_dummy := asg_download.mark_dirty(

904: CSM_UTIL_PKG.LOG('Pushing ' || acc_id_lst.COUNT || 'deleted records',
905: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
906:
907: -- do bulk makedirty
908: l_dummy := asg_download.mark_dirty(
909: P_PUB_ITEM => g_pub_item
910: , p_accessList => acc_id_lst
911: , p_userid_list => user_id_lst
912: , p_dml_type => 'D'

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

964: 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;
965: EXIT WHEN user_id_lst.COUNT = 0;
966:
967: IF user_id_lst.COUNT > 0 THEN
968: --*** push to oLite using asg_download ***
969: CSM_UTIL_PKG.LOG('Pushing ' || user_id_lst.COUNT || 'updated records',
970: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
971:
972: FORALL i IN user_id_lst.FIRST..user_id_lst.LAST

Line 986: l_dummy := asg_download.mark_dirty(

982: AND (LOT_NUMBER IS NULL OR LOT_NUMBER = lot_num(i))
983: RETURNING access_id BULK COLLECT INTO acc_id_lst;
984:
985: -- do bulk makedirty
986: l_dummy := asg_download.mark_dirty(
987: P_PUB_ITEM => g_pub_item
988: , p_accessList => acc_id_lst
989: , p_userid_list => user_id_lst
990: , p_dml_type => 'U'

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

1042: EXIT WHEN inv_id.COUNT = 0;
1043:
1044: -- check if there are any items to be downloaded
1045: IF inv_id.COUNT > 0 THEN
1046: --*** push to oLite using asg_download ***
1047: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || 'inserted records',
1048: 'CSM_SYSTEM_ITEM_EVENT_PKG.REFRESH_MTL_ONHAND_QUANTITY',FND_LOG.LEVEL_STATEMENT);
1049:
1050: FOR i IN inv_id.FIRST..inv_id.LAST LOOP

Line 1061: l_dummy := asg_download.mark_dirty(

1057: 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),
1058: 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));
1059:
1060: -- do bulk makedirty
1061: l_dummy := asg_download.mark_dirty(
1062: P_PUB_ITEM => g_pub_item
1063: , p_accessList => acc_id_lst
1064: , p_userid_list => user_id_lst
1065: , p_dml_type => 'I'

Line 1184: l_user_id_lst asg_download.user_list;

1180: TYPE org_idTab IS TABLE OF csm_system_items_acc.organization_id%TYPE INDEX BY BINARY_INTEGER;
1181:
1182: l_inv_id inv_idTab;
1183: l_org_id org_idTab;
1184: l_user_id_lst asg_download.user_list;
1185: l_acc_id_lst asg_download.access_list;
1186: l_user_id NUMBER;
1187:
1188: l_dummy BOOLEAN;

Line 1185: l_acc_id_lst asg_download.access_list;

1181:
1182: l_inv_id inv_idTab;
1183: l_org_id org_idTab;
1184: l_user_id_lst asg_download.user_list;
1185: l_acc_id_lst asg_download.access_list;
1186: l_user_id NUMBER;
1187:
1188: l_dummy BOOLEAN;
1189: l_organization_id mtl_system_items.organization_id%TYPE;

Line 1238: -- l_dummy := asg_download.mark_dirty(

1234: VALUES (CSM_SYSTEM_ITEMS_ACC_S.NEXTVAL, p_user_id , l_inv_id(i), l_organization_id, 1, 1, l_current_run_date,1,l_current_run_date,1);
1235: -- RETURNING access_id, user_id BULK COLLECT INTO l_acc_id_lst, l_user_id_lst;
1236:
1237: -- -- do bulk makedirty
1238: -- l_dummy := asg_download.mark_dirty(
1239: -- P_PUB_ITEM => g_pub_item
1240: -- , p_accessList => l_acc_id_lst
1241: -- , p_userid_list => l_user_id_lst
1242: -- , p_dml_type => 'I'

Line 1279: -- l_dummy := asg_download.mark_dirty(

1275: COUNTER,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN)
1276: 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);
1277:
1278: -- -- do bulk makedirty
1279: -- l_dummy := asg_download.mark_dirty(
1280: -- P_PUB_ITEM => g_pub_item
1281: -- , p_accessList => l_acc_id_lst
1282: -- , p_userid_list => l_user_id_lst
1283: -- , p_dml_type => 'I'

Line 1498: user_id_lst asg_download.user_list;

1494: loc_id loc_idTab;
1495: lot_num lot_numTab;
1496: qty tran_qtyTab;
1497: dummy_qty tran_qtyTab;
1498: user_id_lst asg_download.user_list;
1499: acc_id_lst asg_download.access_list;
1500:
1501: l_dummy BOOLEAN;
1502: l_return_status VARCHAR2(100);

Line 1499: acc_id_lst asg_download.access_list;

1495: lot_num lot_numTab;
1496: qty tran_qtyTab;
1497: dummy_qty tran_qtyTab;
1498: user_id_lst asg_download.user_list;
1499: acc_id_lst asg_download.access_list;
1500:
1501: l_dummy BOOLEAN;
1502: l_return_status VARCHAR2(100);
1503: l_err_msg VARCHAR2(4000);

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

1509: 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;
1510: CLOSE l_onhand_update_csr;
1511:
1512: IF user_id_lst.COUNT > 0 THEN
1513: --*** push to oLite using asg_download ***
1514: CSM_UTIL_PKG.LOG('Pushing ' || user_id_lst.COUNT || ' updates',
1515: 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);
1516:
1517: FORALL i IN 1..user_id_lst.COUNT

Line 1530: l_dummy := asg_download.mark_dirty(

1526: AND (LOT_NUMBER IS NULL OR LOT_NUMBER = lot_num(i))
1527: RETURNING access_id BULK COLLECT INTO acc_id_lst;
1528:
1529: -- do bulk makedirty
1530: l_dummy := asg_download.mark_dirty(
1531: P_PUB_ITEM => 'CSF_M_INVENTORY'
1532: , p_accessList => acc_id_lst
1533: , p_userid_list => user_id_lst
1534: , p_dml_type => 'U'

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

1557: CLOSE l_onhand_insert_csr;
1558:
1559: -- check if there are any items to be downloaded
1560: IF inv_id.COUNT > 0 THEN
1561: --*** push to oLite using asg_download ***
1562: CSM_UTIL_PKG.LOG('Pushing ' || inv_id.COUNT || ' inserts',
1563: 'CSM_SYSTEM_ITEM_EVENT_PKG.RECEIVED_MTL_ONHAND',FND_LOG.LEVEL_STATEMENT);
1564:
1565: FOR i IN 1..inv_id.COUNT LOOP

Line 1576: l_dummy := asg_download.mark_dirty(

1572: 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),
1573: loc_id(i), rvsion(i), lot_num(i), sysdate,1,sysdate,1, 1, qty(i), acc_id_lst(i));
1574:
1575: -- do bulk makedirty
1576: l_dummy := asg_download.mark_dirty(
1577: P_PUB_ITEM => 'CSF_M_INVENTORY'
1578: , p_accessList => acc_id_lst
1579: , p_userid_list => user_id_lst
1580: , p_dml_type => 'I'