APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_COMPONENT_SUBSTITUTES

Line 703: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);

699:
700: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
701: -- We want to delete all BOM related data and get new stuff.
702:
703: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);
704:
705: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
706: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);
707: ELSE

Line 706: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);

702:
703: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);
704:
705: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
706: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);
707: ELSE
708: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
709: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
710: END IF;

Line 709: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

705: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
706: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);
707: ELSE
708: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
709: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
710: END IF;
711:
712: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
713:

Line 722: UPDATE MSC_COMPONENT_SUBSTITUTES

718: FOR c_rec IN c1_d LOOP
719:
720: IF c_rec.BILL_SEQUENCE_ID IS NOT NULL AND c_rec.COMPONENT_SEQUENCE_ID IS NULL AND c_rec.SUBSTITUTE_ITEM_ID IS NULL THEN
721:
722: UPDATE MSC_COMPONENT_SUBSTITUTES
723: SET USAGE_QUANTITY= 0,
724: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
725: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
726: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 733: UPDATE MSC_COMPONENT_SUBSTITUTES

729: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
730:
731: ELSIF c_rec.COMPONENT_SEQUENCE_ID IS NOT NULL AND c_rec.BILL_SEQUENCE_ID IS NULL AND c_rec.SUBSTITUTE_ITEM_ID IS NULL THEN
732:
733: UPDATE MSC_COMPONENT_SUBSTITUTES
734: SET USAGE_QUANTITY= 0,
735: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
736: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
737: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 745: UPDATE MSC_COMPONENT_SUBSTITUTES

741:
742: ELSIF c_rec.COMPONENT_SEQUENCE_ID IS NOT NULL AND c_rec.SUBSTITUTE_ITEM_ID IS NOT NULL
743: AND c_rec.BILL_SEQUENCE_ID IS NULL THEN
744:
745: UPDATE MSC_COMPONENT_SUBSTITUTES
746: SET USAGE_QUANTITY= 0,
747: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
748: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
749: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 771: UPDATE MSC_COMPONENT_SUBSTITUTES

767: BEGIN
768:
769: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
770:
771: UPDATE MSC_COMPONENT_SUBSTITUTES
772: SET
773: USAGE_QUANTITY= c_rec.USAGE_QUANTITY,
774: PRIORITY= c_rec.PRIORITY,
775: ROUNDING_DIRECTION= c_rec.ROUNDING_DIRECTION,

Line 791: INSERT INTO MSC_COMPONENT_SUBSTITUTES

787:
788:
789: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
790:
791: INSERT INTO MSC_COMPONENT_SUBSTITUTES
792: ( PLAN_ID,
793: BILL_SEQUENCE_ID,
794: USAGE_QUANTITY,
795: PRIORITY,

Line 840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');

836:
837: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
838: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
839: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
840: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
841: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
842:
843: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
844: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');