APPS.MSC_CL_ITEM_ODS_LOAD dependencies on MSC_SUPPLIER_FLEX_FENCES

Line 3051: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1);

3047: COMMIT;
3048:
3049: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
3050:
3051: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1);
3052:
3053: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3054: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1);
3055: ELSE

Line 3054: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1);

3050:
3051: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1);
3052:
3053: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3054: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1);
3055: ELSE
3056: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3057: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
3058: END IF;

Line 3057: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);

3053: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3054: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1);
3055: ELSE
3056: v_sub_str :=' AND ORGANIZATION_ID '||MSC_UTIL.v_in_org_str;
3057: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1,v_sub_str);
3058: END IF;
3059:
3060: END IF;
3061:

Line 3070: UPDATE MSC_SUPPLIER_FLEX_FENCES

3066: BEGIN
3067:
3068: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
3069:
3070: UPDATE MSC_SUPPLIER_FLEX_FENCES
3071: SET
3072: USING_ORGANIZATION_ID= c_rec.USING_ORGANIZATION_ID,
3073: TOLERANCE_PERCENTAGE= c_rec.TOLERANCE_PERCENTAGE,
3074: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

Line 3090: INSERT INTO MSC_SUPPLIER_FLEX_FENCES

3086: END IF;
3087:
3088: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
3089:
3090: INSERT INTO MSC_SUPPLIER_FLEX_FENCES
3091: ( TRANSACTION_ID,
3092: PLAN_ID,
3093: SUPPLIER_ID,
3094: SUPPLIER_SITE_ID,

Line 3107: ( MSC_SUPPLIER_FLEX_FENCES_S.NEXTVAL,

3103: LAST_UPDATED_BY,
3104: CREATION_DATE,
3105: CREATED_BY)
3106: VALUES
3107: ( MSC_SUPPLIER_FLEX_FENCES_S.NEXTVAL,
3108: -1,
3109: c_rec.SUPPLIER_ID,
3110: c_rec.SUPPLIER_SITE_ID,
3111: c_rec.ORGANIZATION_ID,

Line 3141: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');

3137:
3138: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3139: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3140: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3141: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3142: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3143:
3144: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3145: RAISE;

Line 3153: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');

3149:
3150: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3151: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3152: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3153: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3155:
3156: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3157: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');