APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_OPERATION_NETWORKS

Line 243: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1);

239:
240: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
241:
242: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
243: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1);
244: ELSE
245: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
246: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
247: END IF;

Line 246: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

242: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
243: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1);
244: ELSE
245: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
246: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_NETWORKS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
247: END IF;
248:
249: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
250:

Line 257: DELETE MSC_OPERATION_NETWORKS

253: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete
254:
255: FOR c_rec IN c10_d LOOP
256:
257: DELETE MSC_OPERATION_NETWORKS
258: WHERE PLAN_ID= -1
259: AND FROM_OP_SEQ_ID = c_rec.from_op_seq_id
260: AND TO_OP_SEQ_ID = c_rec.to_op_seq_id
261: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;

Line 276: UPDATE MSC_OPERATION_NETWORKS

272: BEGIN
273:
274: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
275:
276: UPDATE MSC_OPERATION_NETWORKS
277: SET
278: FROM_OP_SEQ_ID = c_rec.from_op_seq_id,
279: TO_OP_SEQ_ID = c_rec.to_op_seq_id,
280: routing_sequence_id = c_rec.routing_sequence_id,

Line 318: insert into MSC_OPERATION_NETWORKS

314: END IF;
315:
316: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
317:
318: insert into MSC_OPERATION_NETWORKS
319: ( FROM_OP_SEQ_ID,
320: TO_OP_SEQ_ID,
321: ROUTING_SEQUENCE_ID,
322: TRANSITION_TYPE,

Line 426: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_NETWORKS');

422:
423: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
424: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
425: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_NETWORKS');
426: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_NETWORKS');
427: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
428:
429: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
430: RAISE;

Line 438: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_NETWORKS');

434:
435: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
436: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
437: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_NETWORKS');
438: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_NETWORKS');
439: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
440:
441: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
442: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_OP_SEQ_ID');