[Home] [Help]
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
240: AND msr.SR_SOURCING_RULE_ID= mssa.SOURCING_RULE_ID -- Sourcing Rule
281: mssro.RECEIPT_PARTNER_SITE_ID,
282: mssro.EFFECTIVE_DATE,
283: mssro.DISABLE_DATE,
284: mssro.SR_INSTANCE_ID
285: FROM MSC_Sourcing_Rules msr,
286: MSC_ST_SR_RECEIPT_ORG mssro
287: WHERE msr.SR_SOURCING_RULE_ID= mssro.SOURCING_RULE_ID
288: AND msr.SR_INSTANCE_ID= mssro.SR_INSTANCE_ID
289: AND mssro.SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id;
610: --/* it's removed due to bug 1219661
611: IF ((MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh)
612: AND MSC_CL_COLLECTION.v_sourcing_flag =MSC_UTIL.SYS_YES) THEN
613:
614: UPDATE MSC_SOURCING_RULES
615: SET DELETED_FLAG= MSC_UTIL.SYS_YES,
616: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
617: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user
618: WHERE SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
628: FOR c_rec IN c2 LOOP
629:
630: BEGIN
631:
632: UPDATE MSC_SOURCING_RULES msr
633: SET msr.Description= c_rec.Description,
634: msr.Status= c_rec.Status,
635: msr.Sourcing_Rule_Type= c_rec.Sourcing_Rule_Type,
636: msr.sourcing_rule_name= c_rec.sourcing_rule_name,
646: AND msr.COLLECTED_FLAG= MSC_UTIL.SYS_YES;
647:
648: IF SQL%NOTFOUND THEN
649:
650: INSERT INTO MSC_SOURCING_RULES
651: ( ORGANIZATION_ID,
652: SOURCING_RULE_ID,
653: SR_SOURCING_RULE_ID,
654: SOURCING_RULE_NAME,
665: CREATION_DATE,
666: CREATED_BY)
667: VALUES
668: ( c_rec.ORGANIZATION_ID,
669: MSC_SOURCING_RULES_S.NEXTVAL,
670: c_rec.SR_SOURCING_RULE_ID,
671: c_rec.SOURCING_RULE_NAME,
672: c_rec.DESCRIPTION,
673: c_rec.STATUS,
697:
698: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
699: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
700: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
701: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
702: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
703:
704: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
705: RAISE;
709:
710: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
711: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
712: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SOURCING');
713: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SOURCING_RULES');
714: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
715:
716: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
717: FND_MESSAGE.SET_TOKEN('COLUMN', 'SOURCING_RULE_NAME');
727:
728: COMMIT;
729:
730: --/* it's removed due to bug 1219661
731: DELETE MSC_SOURCING_RULES
732: WHERE DELETED_FLAG= MSC_UTIL.SYS_YES
733: AND SR_INSTANCE_ID= MSC_CL_COLLECTION.v_instance_id
734: AND COLLECTED_FLAG= MSC_UTIL.SYS_YES;
735:
737: --*/
738:
739: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
740:
741: msc_analyse_tables_pk.analyse_table( 'MSC_SOURCING_RULES');
742:
743: END IF;
744:
745: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
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
919: AND msr.SR_SOURCING_RULE_ID= mssa.SOURCING_RULE_ID -- Sourcing Rule