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_OPERATION_COMPONENTS

Line 823: FROM MSC_OPERATION_COMPONENTS moc,

819: moc.BILL_SEQUENCE_ID,
820: moc.ROUTING_SEQUENCE_ID,
821: moc.SR_INSTANCE_ID,
822: moc.ORGANIZATION_ID
823: FROM MSC_OPERATION_COMPONENTS moc,
824: MSC_ST_OPERATION_COMPONENTS msoc
825: WHERE msoc.Bill_Sequence_ID= moc.Bill_Sequence_ID
826: AND msoc.Routing_Sequence_ID <> moc.Routing_Sequence_ID
827: AND msoc.Organization_ID= moc.Organization_ID

Line 846: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);

842:
843: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
844: -- We want to delete all BOM related data and get new stuff.
845:
846: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
847:
848: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
849: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
850: ELSE

Line 849: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);

845:
846: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
847:
848: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
849: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
850: ELSE
851: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
852: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
853: END IF;

Line 852: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

848: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
849: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1);
850: ELSE
851: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
852: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
853: END IF;
854: BEGIN
855: INSERT /*+ append */
856: INTO MSC_OPERATION_COMPONENTS

Line 856: INTO MSC_OPERATION_COMPONENTS

852: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_OPERATION_COMPONENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
853: END IF;
854: BEGIN
855: INSERT /*+ append */
856: INTO MSC_OPERATION_COMPONENTS
857: (PLAN_ID,
858: ORGANIZATION_ID,
859: OPERATION_SEQUENCE_ID,
860: COMPONENT_SEQUENCE_ID,

Line 895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');

891:
892: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
893: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
894: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
895: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
896: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
897:
898: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
899: RAISE;

Line 905: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');

901: MSC_CL_COLLECTION.v_warning_flag := MSC_UTIL.SYS_YES;
902: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
903: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
904: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
905: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
906: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
907:
908: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
909: lb_refresh_failed := TRUE;

Line 923: lv_sql_stmt1 := ' DELETE MSC_OPERATION_COMPONENTS '

919:
920: BEGIN
921:
922: ---5470477
923: lv_sql_stmt1 := ' DELETE MSC_OPERATION_COMPONENTS '
924: ||' WHERE PLAN_ID= -1 '
925: ||' AND SR_INSTANCE_ID= :SR_INSTANCE_ID ';
926:
927: lv_delete_flag := FALSE;

Line 958: DELETE MSC_OPERATION_COMPONENTS

954: EXECUTE IMMEDIATE lv_sql_stmt1 USING c_rec.SR_INSTANCE_ID;
955: end if;
956: /* bug 988700 fix : change UPDATE to DELETE */
957: /*
958: DELETE MSC_OPERATION_COMPONENTS
959: WHERE PLAN_ID= -1
960: AND BILL_SEQUENCE_ID= NVL( c_rec.BILL_SEQUENCE_ID, BILL_SEQUENCE_ID)
961: AND ROUTING_SEQUENCE_ID= NVL( c_rec.ROUTING_SEQUENCE_ID, ROUTING_SEQUENCE_ID)
962: AND COMPONENT_SEQUENCE_ID= NVL( c_rec.COMPONENT_SEQUENCE_ID, COMPONENT_SEQUENCE_ID)

Line 971: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');

967: WHEN OTHERS THEN
968: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
969: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
970: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
971: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
972: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
973:
974: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
975: FND_MESSAGE.SET_TOKEN('COLUMN', 'OPERATION_SEQUENCE_ID');

Line 1011: UPDATE MSC_OPERATION_COMPONENTS

1007: BEGIN
1008:
1009: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1010:
1011: UPDATE MSC_OPERATION_COMPONENTS
1012: SET PLAN_ID= -1,
1013: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
1014: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
1015: WHERE PLAN_ID= -1

Line 1027: INSERT INTO MSC_OPERATION_COMPONENTS

1023: END IF;
1024:
1025: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1026:
1027: INSERT INTO MSC_OPERATION_COMPONENTS
1028: ( PLAN_ID,
1029: ORGANIZATION_ID,
1030: OPERATION_SEQUENCE_ID,
1031: COMPONENT_SEQUENCE_ID,

Line 1071: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');

1067:
1068: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1069: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1070: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
1071: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
1072: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1073:
1074: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1075: RAISE;

Line 1083: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');

1079:
1080: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1081: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1082: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_OPERATION_COMPONENTS');
1083: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_OPERATION_COMPONENTS');
1084: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1085:
1086: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1087: FND_MESSAGE.SET_TOKEN('COLUMN', 'ORGANIZATION_CODE');