APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_SR_SOURCE_ORG

Line 1148: UPDATE MSC_SR_SOURCE_ORG

1144: --/* it's removed due to bug 1219661
1145: IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)
1146: AND MSC_CL_COLLECTION.v_sourcing_flag=MSC_UTIL.SYS_YES ) THEN
1147:
1148: UPDATE MSC_SR_SOURCE_ORG
1149: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
1150: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1151: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1152: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id

Line 1166: UPDATE MSC_SR_SOURCE_ORG msso

1162: FOR c_rec IN c5 LOOP
1163:
1164: BEGIN
1165:
1166: UPDATE MSC_SR_SOURCE_ORG msso
1167: SET msso.SR_RECEIPT_ID= c_rec.SR_Receipt_ID,
1168: msso.SOURCE_ORGANIZATION_ID= c_rec.Source_Organization_ID,
1169: msso.SOURCE_ORG_INSTANCE_ID= c_rec.SOURCE_ORG_INSTANCE_ID,
1170: msso.SOURCE_PARTNER_ID= c_rec.TP_ID,

Line 1186: INSERT INTO MSC_SR_SOURCE_ORG

1182: AND msso.COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1183:
1184: IF SQL%NOTFOUND THEN
1185:
1186: INSERT INTO MSC_SR_SOURCE_ORG
1187: ( SR_SOURCE_ID,
1188: SR_SR_SOURCE_ID,
1189: SR_RECEIPT_ID,
1190: SOURCE_ORGANIZATION_ID,

Line 1207: ( MSC_SR_SOURCE_ORG_S.NEXTVAL,

1203: LAST_UPDATED_BY,
1204: CREATION_DATE,
1205: CREATED_BY)
1206: VALUES
1207: ( MSC_SR_SOURCE_ORG_S.NEXTVAL,
1208: c_rec.SR_SR_SOURCE_ID,
1209: c_rec.SR_RECEIPT_ID,
1210: c_rec.Source_Organization_ID,
1211: c_rec.SOURCE_ORG_INSTANCE_ID,

Line 1245: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');

1241:
1242: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1243: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1244: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1245: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1246: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1247:
1248: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1249: RAISE;

Line 1257: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');

1253:
1254: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1255: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1256: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
1257: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SR_SOURCE_ORG');
1258: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1259:
1260: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1261: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_SR_SOURCE_ID');

Line 1275: DELETE MSC_SR_SOURCE_ORG

1271:
1272: COMMIT;
1273:
1274: --/* it's removed due to bug 1219661
1275: DELETE MSC_SR_SOURCE_ORG
1276: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
1277: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
1278: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
1279:

Line 1285: msc_analyse_tables_pk.analyse_table( 'MSC_SR_SOURCE_ORG');

1281: --*/
1282:
1283: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
1284:
1285: msc_analyse_tables_pk.analyse_table( 'MSC_SR_SOURCE_ORG');
1286:
1287: END IF;
1288:
1289:

Line 5562: ||' MSC_SR_SOURCE_ORG MSSO'

5558: ||' select MSSO.SOURCE_ORGANIZATION_ID'
5559: ||' from MSC_SR_ASSIGNMENTS MSA,'
5560: ||' MSC_SOURCING_RULES MSR,'
5561: ||' MSC_SR_RECEIPT_ORG MSRO,'
5562: ||' MSC_SR_SOURCE_ORG MSSO'
5563: ||' WHERE MSA.ASSIGNMENT_SET_ID = :lv_assign_set_id'
5564: ||' AND ( (msa.assignment_type=9 AND MSA.REGION_ID = MOAI.REGION_ID AND'
5565: ||' MSA.SR_INSTANCE_ID = MOAI.SR_INSTANCE_ID AND MOAI.INVENTORY_ITEM_ID = msa.INVENTORY_ITEM_ID)'
5566: ||' OR'