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.

[Home] [Help]

APPS.MSC_CL_ROUTING_ODS_LOAD dependencies on MSC_OPERATION_COMPONENTS

Line 822: FROM MSC_OPERATION_COMPONENTS moc,

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

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

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

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

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

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

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

Line 855: INTO MSC_OPERATION_COMPONENTS

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

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

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

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

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

Line 922: lv_sql_stmt1 := ' DELETE MSC_OPERATION_COMPONENTS '

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

Line 957: DELETE MSC_OPERATION_COMPONENTS

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

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

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

Line 1010: UPDATE MSC_OPERATION_COMPONENTS

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

Line 1026: INSERT INTO MSC_OPERATION_COMPONENTS

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

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

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

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

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