APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_RES_INSTANCE_CHANGES

Line 499: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RES_INSTANCE_CHANGES', MSC_CL_COLLECTION.v_instance_id, NULL);

495: MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_incremental_refresh) then
496:
497: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
498:
499: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RES_INSTANCE_CHANGES', MSC_CL_COLLECTION.v_instance_id, NULL);
500:
501:
502: END IF;
503:

Line 513: DELETE MSC_RES_INSTANCE_CHANGES

509: BEGIN
510:
511: IF MSC_CL_COLLECTION.v_is_incremental_refresh AND c_rec.DELETED_FLAG= MSC_UTIL.SYS_YES THEN
512:
513: DELETE MSC_RES_INSTANCE_CHANGES
514: WHERE DEPARTMENT_ID = c_rec.DEPARTMENT_ID
515: AND RESOURCE_ID = c_rec.RESOURCE_ID
516: AND RES_INSTANCE_ID = c_rec.RES_INSTANCE_ID
517: AND SERIAL_NUMBER = c_rec.SERIAL_NUMBER

Line 529: INSERT INTO MSC_RES_INSTANCE_CHANGES

525: AND ACTION_TYPE= c_rec.ACTION_TYPE
526: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
527:
528: ELSE
529: INSERT INTO MSC_RES_INSTANCE_CHANGES
530: ( DEPARTMENT_ID,
531: RESOURCE_ID,
532: RES_INSTANCE_ID,
533: SERIAL_NUMBER,

Line 587: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');

583: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
585: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
586: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
587: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
589:
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
591: RAISE;

Line 599: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');

595:
596: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
597: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
598: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
599: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
600: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
601:
602: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
603: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');