APPS.MSC_CL_ITEM_ODS_LOAD dependencies on MSC_SUPPLIER_FLEX_FENCES

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

3051: COMMIT;
3052:
3053: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) THEN
3054:
3055: --MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1);
3056:
3057: IF MSC_CL_COLLECTION.v_coll_prec.org_group_flag = MSC_UTIL.G_ALL_ORGANIZATIONS THEN
3058: MSC_CL_COLLECTION.DELETE_MSC_TABLE( 'MSC_SUPPLIER_FLEX_FENCES', MSC_CL_COLLECTION.v_instance_id, -1);
3059: ELSE

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

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

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

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

Line 3074: UPDATE MSC_SUPPLIER_FLEX_FENCES

3070: BEGIN
3071:
3072: IF MSC_CL_COLLECTION.v_is_incremental_refresh THEN
3073:
3074: UPDATE MSC_SUPPLIER_FLEX_FENCES
3075: SET
3076: USING_ORGANIZATION_ID= c_rec.USING_ORGANIZATION_ID,
3077: TOLERANCE_PERCENTAGE= c_rec.TOLERANCE_PERCENTAGE,
3078: REFRESH_NUMBER= MSC_CL_COLLECTION.v_last_collection_id,

Line 3094: INSERT INTO MSC_SUPPLIER_FLEX_FENCES

3090: END IF;
3091:
3092: IF (MSC_CL_COLLECTION.v_is_complete_refresh OR MSC_CL_COLLECTION.v_is_partial_refresh) OR SQL%NOTFOUND THEN
3093:
3094: INSERT INTO MSC_SUPPLIER_FLEX_FENCES
3095: ( TRANSACTION_ID,
3096: PLAN_ID,
3097: SUPPLIER_ID,
3098: SUPPLIER_SITE_ID,

Line 3111: ( MSC_SUPPLIER_FLEX_FENCES_S.NEXTVAL,

3107: LAST_UPDATED_BY,
3108: CREATION_DATE,
3109: CREATED_BY)
3110: VALUES
3111: ( MSC_SUPPLIER_FLEX_FENCES_S.NEXTVAL,
3112: -1,
3113: c_rec.SUPPLIER_ID,
3114: c_rec.SUPPLIER_SITE_ID,
3115: c_rec.ORGANIZATION_ID,

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

3141:
3142: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3143: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3144: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3145: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3146: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3147:
3148: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3149: RAISE;

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

3153:
3154: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3155: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3156: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_SUPPLIER_CAPACITY');
3157: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_SUPPLIER_FLEX_FENCES');
3158: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3159:
3160: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3161: FND_MESSAGE.SET_TOKEN('COLUMN', 'ITEM_NAME');