[Home] [Help]
231: FROM MSC_ITEM_ID_LID miil,
232: MSC_TP_ID_LID mtil,
233: MSC_TP_SITE_ID_LID mtsil,
234: MSC_CATEGORY_SET_ID_LID mcsil,
235: MSC_Assignment_SETS mas,
236: MSC_Sourcing_Rules msr,
237: MSC_ST_SR_ASSIGNMENTS mssa
238: WHERE mas.SR_ASSIGNMENT_SET_ID= mssa.ASSIGNMENT_SET_ID -- Assignment Set
239: AND mas.SR_INSTANCE_ID= mssa.SR_ASSIGNMENT_INSTANCE_ID
481: --/* it's removed due to bug 1219661
482: IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)
483: AND MSC_CL_COLLECTION.v_sourcing_flag=MSC_UTIL.SYS_YES ) THEN
484:
485: UPDATE MSC_ASSIGNMENT_SETS
486: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
487: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
488: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
489: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
499: FOR c_rec IN c1 LOOP
500:
501: BEGIN
502:
503: UPDATE MSC_ASSIGNMENT_SETS mas
504: SET mas.ASSIGNMENT_SET_NAME=c_rec.ASSIGNMENT_SET_NAME,
505: mas.Description= c_rec.Description,
506: mas.Deleted_Flag= MSC_UTIL.SYS_NO,
507: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
512: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
513:
514: IF SQL%NOTFOUND THEN
515:
516: INSERT INTO MSC_ASSIGNMENT_SETS
517: ( ASSIGNMENT_SET_ID,
518: SR_ASSIGNMENT_SET_ID,
519: DESCRIPTION,
520: ASSIGNMENT_SET_NAME,
526: LAST_UPDATED_BY,
527: CREATION_DATE,
528: CREATED_BY)
529: VALUES
530: ( MSC_ASSIGNMENT_SETS_S.NEXTVAL,
531: c_rec.SR_ASSIGNMENT_SET_ID,
532: c_rec.DESCRIPTION,
533: c_rec.ASSIGNMENT_SET_NAME,
534: MSC_UTIL.SYS_YES,
556:
557: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
558: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
559: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
560: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
562:
563: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
564: RAISE;
569:
570: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
571: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
572: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
573: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_ASSIGNMENT_SETS');
574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
575:
576: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
577: FND_MESSAGE.SET_TOKEN('COLUMN', 'ASSIGNMENT_SET_NAME');
592:
593: COMMIT;
594:
595: --/* it's removed due to bug 1219661
596: DELETE MSC_ASSIGNMENT_SETS
597: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
598: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
599: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
600:
602: --*/
603:
604: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
605:
606: msc_analyse_tables_pk.analyse_table( 'MSC_ASSIGNMENT_SETS');
607:
608: END IF;
609:
610: --/* it's removed due to bug 1219661
910: FROM MSC_ITEM_ID_LID miil,
911: MSC_TP_ID_LID mtil,
912: MSC_TP_SITE_ID_LID mtsil,
913: MSC_CATEGORY_SET_ID_LID mcsil,
914: MSC_Assignment_SETS mas,
915: MSC_Sourcing_Rules msr,
916: MSC_ST_SR_ASSIGNMENTS mssa
917: WHERE mas.SR_ASSIGNMENT_SET_ID= mssa.ASSIGNMENT_SET_ID -- Assignment Set
918: AND mas.SR_INSTANCE_ID= mssa.SR_ASSIGNMENT_INSTANCE_ID
5542: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Instance ID---' || lv_instance_id ||
5543: ' Assignment Set Id ----' || lv_assign_set_id || ' Refresh Type ----' ||lv_refresh_type) ;
5544:
5545: /*SELECT ASSIGNMENT_SET_ID INTO lv_assign_set_id
5546: FROM MSC_ASSIGNMENT_SETS
5547: WHERE ASSIGNMENT_SET_NAME = lv_assign_set_name
5548: AND SR_INSTANCE_ID = lv_instance_id;*/
5549:
5550: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, 'Aset id ---' || lv_assign_set_id) ;