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_BOM_ODS_LOAD dependencies on MSC_BOR_REQUIREMENTS

Line 930: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1);

926:
927: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
928:
929: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
930: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1);
931:
932: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
933: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
934: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1);

Line 934: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1);

930: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1);
931:
932: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
933: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1);
934: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1);
935: ELSE
936: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
937: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
938: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

Line 938: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

934: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1);
935: ELSE
936: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
937: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BILL_OF_RESOURCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
938: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_BOR_REQUIREMENTS', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
939: END IF;
940:
941: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
942:

Line 1060: UPDATE MSC_BOR_REQUIREMENTS

1056: BEGIN
1057:
1058: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
1059:
1060: UPDATE MSC_BOR_REQUIREMENTS
1061: SET
1062: BILL_OF_RESOURCES= c_rec.BILL_OF_RESOURCES,
1063: RESOURCE_DEPARTMENT_HOURS= c_rec.RESOURCE_DEPARTMENT_HOURS,
1064: OPERATION_SEQUENCE_ID= c_rec.OPERATION_SEQUENCE_ID,

Line 1089: INSERT INTO MSC_BOR_REQUIREMENTS

1085:
1086:
1087: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
1088:
1089: INSERT INTO MSC_BOR_REQUIREMENTS
1090: ( PLAN_ID,
1091: TRANSACTION_ID,
1092: SR_TRANSACTION_ID,
1093: BILL_OF_RESOURCES,

Line 1116: MSC_BOR_REQUIREMENTS_S.NEXTVAL,

1112: CREATION_DATE,
1113: CREATED_BY)
1114: VALUES
1115: ( -1,
1116: MSC_BOR_REQUIREMENTS_S.NEXTVAL,
1117: c_rec.SR_TRANSACTION_ID,
1118: c_rec.BILL_OF_RESOURCES,
1119: c_rec.RESOURCE_DEPARTMENT_HOURS,
1120: c_rec.OPERATION_SEQUENCE_ID,

Line 1158: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');

1154:
1155: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1156: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1157: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1158: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1159: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1160:
1161: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
1162: RAISE;

Line 1170: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');

1166:
1167: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
1168: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
1169: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_BOR');
1170: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_BOR_REQUIREMENTS');
1171: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
1172:
1173: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
1174: FND_MESSAGE.SET_TOKEN('COLUMN', 'SR_TRANSACTION_ID');