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.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_ROUTINGS

Line 523: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);

519:
520: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
521: -- We want to delete all ROUTING related data and get new stuff.
522:
523: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
524:
525: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
526: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
527: ELSE

Line 526: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);

522:
523: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
524:
525: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
526: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
527: ELSE
528: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
529: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
530: END IF;

Line 529: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

525: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
526: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1);
527: ELSE
528: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
529: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_ROUTINGS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
530: END IF;
531:
532: BEGIN
533: lv_sql_ins:=

Line 534: 'INSERT INTO MSC_ROUTINGS'

530: END IF;
531:
532: BEGIN
533: lv_sql_ins:=
534: 'INSERT INTO MSC_ROUTINGS'
535: ||' (PLAN_ID,'
536: ||' ROUTING_SEQUENCE_ID,'
537: ||' ROUTING_TYPE,'
538: ||' ROUTING_COMMENT,'

Line 604: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');

600:
601: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
602: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
603: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
604: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
605: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
606:
607: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
608: RAISE;

Line 614: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');

610: ELSE
611: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
612: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
613: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
614: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
615: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
616:
617: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
618:

Line 637: DELETE MSC_ROUTINGS

633: FOR c_rec IN c4_d LOOP
634:
635: -- set SR_INSTANCE_ID to negative to indicate a SOFT delete
636:
637: DELETE MSC_ROUTINGS
638: WHERE PLAN_ID= -1
639: AND ROUTING_SEQUENCE_ID= c_rec.ROUTING_SEQUENCE_ID
640: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
641:

Line 655: UPDATE MSC_ROUTINGS

651: BEGIN
652:
653: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
654:
655: UPDATE MSC_ROUTINGS
656: SET
657: ROUTING_TYPE= c_rec.ROUTING_TYPE,
658: ROUTING_COMMENT= c_rec.ROUTING_COMMENT,
659: ALTERNATE_ROUTING_DESIGNATOR= c_rec.ALTERNATE_ROUTING_DESIGNATOR,

Line 683: INSERT INTO MSC_ROUTINGS

679: END IF;
680:
681: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
682:
683: INSERT INTO MSC_ROUTINGS
684: ( PLAN_ID,
685: ROUTING_SEQUENCE_ID,
686: ROUTING_TYPE,
687: ROUTING_COMMENT,

Line 752: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');

748:
749: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
750: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
751: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
752: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
753: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
754:
755: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
756: RAISE;

Line 764: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');

760:
761: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
762: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
763: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_ROUTING');
764: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ROUTINGS');
765: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
766:
767: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
768: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSEMBLY_ITEM_NAME');

Line 2453: from MSC_ROUTINGS mr,MSC_ROUTING_OPERATIONS mn

2449: IS
2450:
2451: cursor c1 IS
2452: select distinct mr.ROUTING_SEQUENCE_ID,trunc(mn.effectivity_date) effectivity_date
2453: from MSC_ROUTINGS mr,MSC_ROUTING_OPERATIONS mn
2454: where
2455: mr.sr_instance_id=mn.sr_instance_id
2456: and mr.routing_sequence_id= mn.routing_sequence_id
2457: and mr.CFM_ROUTING_FLAG=3

Line 2476: UPDATE MSC_ROUTINGS mr

2472: FND_MESSAGE.SET_TOKEN('COLUMN', 'effectivity_date');
2473: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.effectivity_date);
2474: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2475:
2476: UPDATE MSC_ROUTINGS mr
2477: set mr.first_op_seq_num =get_start_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date),
2478: mr.last_op_seq_num =get_last_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date)
2479: where mr.sr_instance_id=MSC_CL_COLLECTION.v_instance_id
2480: and mr.ROUTING_SEQUENCE_ID = c_rec.ROUTING_SEQUENCE_ID

Line 2529: UPDATE MSC_ROUTINGS mr

2525: FND_MESSAGE.SET_TOKEN('COLUMN', 'effectivity_date');
2526: FND_MESSAGE.SET_TOKEN('VALUE',c_rec.effectivity_date);
2527: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
2528:
2529: UPDATE MSC_ROUTINGS mr
2530: set mr.first_op_seq_num =get_start_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date),
2531: mr.last_op_seq_num =get_last_op(MSC_CL_COLLECTION.v_instance_id,c_rec.ROUTING_SEQUENCE_ID,c_rec.effectivity_date)
2532: where mr.sr_instance_id=MSC_CL_COLLECTION.v_instance_id
2533: and mr.ROUTING_SEQUENCE_ID = c_rec.ROUTING_SEQUENCE_ID