APPS.MSC_CL_OTHER_ODS_LOAD dependencies on MSC_TRIPS

Line 4155: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRIPS', MSC_CL_COLLECTION.v_instance_id, -1);

4151: IF MSC_CL_COLLECTION.v_apps_ver >= MSC_UTIL.G_APPS115 THEN
4152:
4153: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
4154:
4155: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRIPS', MSC_CL_COLLECTION.v_instance_id, -1);
4156:
4157: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_TRIP_STOPS', MSC_CL_COLLECTION.v_instance_id, -1);
4158:
4159: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh

Line 4165: DELETE MSC_TRIPS

4161: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
4162:
4163: FOR c_rec IN c1_d LOOP
4164:
4165: DELETE MSC_TRIPS
4166: WHERE PLAN_ID= -1
4167: AND TRIP_ID= c_rec.TRIP_ID
4168: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
4169:

Line 4191: UPDATE MSC_TRIPS

4187: BEGIN
4188:
4189: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
4190:
4191: UPDATE MSC_TRIPS
4192: SET
4193: NAME = c_rec.NAME,
4194: SHIP_METHOD_CODE = c_rec.SHIP_METHOD_CODE,
4195: PLANNED_FLAG = c_rec.PLANNED_FLAG,

Line 4213: INSERT INTO MSC_TRIPS

4209: END IF;
4210:
4211: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
4212:
4213: INSERT INTO MSC_TRIPS
4214: ( PLAN_ID,
4215: TRIP_ID,
4216: NAME,
4217: SHIP_METHOD_CODE,

Line 4264: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');

4260:
4261: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4262: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4263: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4264: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4265: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4266:
4267: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
4268: RAISE;

Line 4276: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');

4272:
4273: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
4274: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
4275: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_TRIP');
4276: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_TRIPS');
4277: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
4278:
4279:
4280: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');