[Home] [Help]
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;
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:
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;
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,
315: END IF;
316:
317: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
318:
319: insert into MSC_OPERATION_NETWORKS
320: ( FROM_OP_SEQ_ID,
321: TO_OP_SEQ_ID,
322: ROUTING_SEQUENCE_ID,
323: TRANSITION_TYPE,
423:
424: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
425: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
426: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_NETWORKS');
427: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_NETWORKS');
428: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
429:
430: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
431: RAISE;
435:
436: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
437: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
438: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_NETWORKS');
439: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_NETWORKS');
440: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
441:
442: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
443: FND_MESSAGE.SET_TOKEN('COLUMN', 'FROM_OP_SEQ_ID');
2559: BEGIN
2560:
2561: SELECT unique mon.FROM_OP_SEQ_ID, trunc(mro.EFFECTIVITY_DATE), trunc(nvl(mro.DISABLE_DATE,sysdate + 2))
2562: INTO l_from_op_seqid, l_effdate, l_disabdate
2563: FROM MSC_OPERATION_NETWORKS mon,
2564: MSC_ROUTING_OPERATIONS mro
2565: WHERE mon.PLAN_ID= -1
2566: AND mon.SR_INSTANCE_ID = v_instance_id
2567: AND mon.ROUTING_SEQUENCE_ID = v_routing_sequence_id
2564: MSC_ROUTING_OPERATIONS mro
2565: WHERE mon.PLAN_ID= -1
2566: AND mon.SR_INSTANCE_ID = v_instance_id
2567: AND mon.ROUTING_SEQUENCE_ID = v_routing_sequence_id
2568: AND NOT EXISTS (SELECT 1 FROM MSC_OPERATION_NETWORKS mon2
2569: WHERE mon2.PLAN_ID= -1
2570: AND mon2.SR_INSTANCE_ID = v_instance_id
2571: AND mon2.ROUTING_SEQUENCE_ID = v_routing_sequence_id
2572: AND mon2.TO_OP_SEQ_ID = mon.FROM_OP_SEQ_ID)
2578: /* IF v_routing_effdate BETWEEN l_effdate AND l_disabdate THEN */ --6792068
2579:
2580: select distinct FROM_OP_SEQ_NUM
2581: into l_from_op_seqnum
2582: from MSC_OPERATION_NETWORKS
2583: where from_op_seq_id = l_from_op_seqid
2584: and routing_sequence_id= v_routing_sequence_id
2585: and sr_instance_id = v_instance_id
2586: and plan_id= -1;
2608: BEGIN
2609:
2610: SELECT unique mon.TO_OP_SEQ_ID, trunc(mro.EFFECTIVITY_DATE), trunc(nvl(mro.DISABLE_DATE,sysdate + 2))
2611: INTO l_to_op_seqid, l_effdate, l_disabdate
2612: FROM MSC_OPERATION_NETWORKS mon,
2613: MSC_ROUTING_OPERATIONS mro
2614: WHERE mon.PLAN_ID= -1
2615: AND mon.SR_INSTANCE_ID = v_instance_id
2616: AND mon.ROUTING_SEQUENCE_ID = v_routing_sequence_id
2613: MSC_ROUTING_OPERATIONS mro
2614: WHERE mon.PLAN_ID= -1
2615: AND mon.SR_INSTANCE_ID = v_instance_id
2616: AND mon.ROUTING_SEQUENCE_ID = v_routing_sequence_id
2617: AND NOT EXISTS (SELECT 1 FROM MSC_OPERATION_NETWORKS mon2
2618: WHERE mon2.PLAN_ID= -1
2619: AND mon2.SR_INSTANCE_ID = MSC_CL_COLLECTION.v_instance_id
2620: AND mon2.ROUTING_SEQUENCE_ID = v_routing_sequence_id
2621: AND mon.TO_OP_SEQ_ID = mon2.FROM_OP_SEQ_ID)
2627: /* IF v_routing_effdate BETWEEN l_effdate AND l_disabdate THEN */ --6793068
2628:
2629: select distinct TO_OP_SEQ_NUM
2630: into l_to_op_seqnum
2631: from MSC_OPERATION_NETWORKS
2632: where to_op_seq_id = l_to_op_seqid
2633: and routing_sequence_id= v_routing_sequence_id
2634: and sr_instance_id = v_instance_id
2635: and plan_id= -1;