APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_INTERORG_SHIP_METHODS

Line 1293: msc_interorg_ship_methods mism

1289:
1290: UPDATE msc_st_interorg_ship_methods msism
1291: SET (shipment_weight, shipment_volume, shipment_weight_uom, shipment_volume_uom, leadtime_variability) =
1292: (SELECT shipment_weight, shipment_volume, shipment_weight_uom, shipment_volume_uom, leadtime_variability FROM
1293: msc_interorg_ship_methods mism
1294: WHERE mism.from_organization_id = msism.from_organization_id
1295: AND mism.sr_instance_id = msism.sr_instance_id
1296: AND mism.to_organization_id = msism.to_organization_id
1297: AND mism.sr_instance_id2 = msism.sr_instance_id2

Line 1305: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_INTERORG_SHIP_METHODS', MSC_CL_COLLECTION.v_instance_id,-1, 'AND nvl(COLLECTED_FLAG,1) <> 2');

1301: AND mism.ship_method = msism.ship_method);
1302:
1303: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1304:
1305: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_INTERORG_SHIP_METHODS', MSC_CL_COLLECTION.v_instance_id,-1, 'AND nvl(COLLECTED_FLAG,1) <> 2');
1306:
1307: END IF;
1308:
1309: c_count:= 0;

Line 1315: INSERT INTO MSC_INTERORG_SHIP_METHODS

1311: FOR c_rec IN c6 LOOP
1312:
1313: BEGIN
1314:
1315: INSERT INTO MSC_INTERORG_SHIP_METHODS
1316: ( PLAN_ID,
1317: TRANSACTION_ID,
1318: FROM_ORGANIZATION_ID,
1319: TO_ORGANIZATION_ID,

Line 1351: MSC_INTERORG_SHIP_METHODS_S.NEXTVAL,

1347: SHIPMENT_VOLUME_UOM,
1348: LEADTIME_VARIABILITY)
1349: VALUES
1350: ( -1,
1351: MSC_INTERORG_SHIP_METHODS_S.NEXTVAL,
1352: c_rec.FROM_ORGANIZATION_ID,
1353: c_rec.TO_ORGANIZATION_ID,
1354: c_rec.SHIP_METHOD,
1355: c_rec.SHIP_METHOD_TEXT,

Line 1400: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');

1396:
1397: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1398: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1399: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1400: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1401: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1402:
1403: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1404: RAISE;

Line 1412: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');

1408:
1409: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1410: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1411: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1412: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_INTERORG_SHIP_METHODS');
1413: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1414:
1415: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1416: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_ORGANIZATION_CODE');