APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_RES_INSTANCE_CHANGES

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

489: MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_incremental_refresh) then
490:
491: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
492:
493: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_RES_INSTANCE_CHANGES', MSC_CL_COLLECTION.v_instance_id, NULL);
494:
495:
496: END IF;
497:

Line 507: DELETE MSC_RES_INSTANCE_CHANGES

503: BEGIN
504:
505: IF MSC_CL_COLLECTION.v_is_incremental_refresh AND c_rec.DELETED_FLAG= MSC_UTIL.SYS_YES THEN
506:
507: DELETE MSC_RES_INSTANCE_CHANGES
508: WHERE DEPARTMENT_ID = c_rec.DEPARTMENT_ID
509: AND RESOURCE_ID = c_rec.RESOURCE_ID
510: AND RES_INSTANCE_ID = c_rec.RES_INSTANCE_ID
511: AND SERIAL_NUMBER = c_rec.SERIAL_NUMBER

Line 523: INSERT INTO MSC_RES_INSTANCE_CHANGES

519: AND ACTION_TYPE= c_rec.ACTION_TYPE
520: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
521:
522: ELSE
523: INSERT INTO MSC_RES_INSTANCE_CHANGES
524: ( DEPARTMENT_ID,
525: RESOURCE_ID,
526: RES_INSTANCE_ID,
527: SERIAL_NUMBER,

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

577: IF SQLCODE IN (-01683,-01653,-01650,-01562) THEN
578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
579: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
580: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
581: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
582: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
583:
584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
585: RAISE;

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

589:
590: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
591: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
592: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_RES_INST_CHANGE');
593: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_RES_INSTANCE_CHANGES');
594: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
595:
596: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
597: FND_MESSAGE.SET_TOKEN('COLUMN', 'DEPARTMENT_ID');