APPS.MSC_CL_BOM_ODS_LOAD dependencies on MSC_COMPONENT_SUBSTITUTES

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

705:
706: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
707: -- We want to delete all BOM related data and get new stuff.
708:
709: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);
710:
711: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
712: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);
713: ELSE

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

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

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

711: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
712: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1);
713: ELSE
714: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
715: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_COMPONENT_SUBSTITUTES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
716: END IF;
717:
718: END IF; -- MSC_CL_COLLECTION.v_is_complete_refresh
719:

Line 728: UPDATE MSC_COMPONENT_SUBSTITUTES

724: FOR c_rec IN c1_d LOOP
725:
726: 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
727:
728: UPDATE MSC_COMPONENT_SUBSTITUTES
729: SET USAGE_QUANTITY= 0,
730: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
731: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
732: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 739: UPDATE MSC_COMPONENT_SUBSTITUTES

735: AND SR_INSTANCE_ID= c_rec.SR_INSTANCE_ID;
736:
737: 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
738:
739: UPDATE MSC_COMPONENT_SUBSTITUTES
740: SET USAGE_QUANTITY= 0,
741: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
742: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
743: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 751: UPDATE MSC_COMPONENT_SUBSTITUTES

747:
748: ELSIF c_rec.COMPONENT_SEQUENCE_ID IS NOT NULL AND c_rec.SUBSTITUTE_ITEM_ID IS NOT NULL
749: AND c_rec.BILL_SEQUENCE_ID IS NULL THEN
750:
751: UPDATE MSC_COMPONENT_SUBSTITUTES
752: SET USAGE_QUANTITY= 0,
753: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,
754: LAST_UPDATE_DATE= MSC_CL_COLLECTION.v_current_date,
755: LAST_UPDATED_BY= MSC_CL_COLLECTION.v_current_user

Line 777: UPDATE MSC_COMPONENT_SUBSTITUTES

773: BEGIN
774:
775: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
776:
777: UPDATE MSC_COMPONENT_SUBSTITUTES
778: SET
779: USAGE_QUANTITY= c_rec.USAGE_QUANTITY,
780: PRIORITY= c_rec.PRIORITY,
781: ROUNDING_DIRECTION= c_rec.ROUNDING_DIRECTION,

Line 797: INSERT INTO MSC_COMPONENT_SUBSTITUTES

793:
794:
795: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
796:
797: INSERT INTO MSC_COMPONENT_SUBSTITUTES
798: ( PLAN_ID,
799: BILL_SEQUENCE_ID,
800: USAGE_QUANTITY,
801: PRIORITY,

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

842:
843: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
844: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
845: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_COMPONENT_SUBSTITUTE');
846: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_COMPONENT_SUBSTITUTES');
847: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
848:
849: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
850: FND_MESSAGE.SET_TOKEN('COLUMN', 'BILL_SEQUENCE_ID');