The following lines contain the word 'select', 'insert', 'update' or 'delete':
PROCEDURE Insert_Row(
px_PLANNING_PARAMETERS_ID NUMBER
,p_CREATED_BY NUMBER
,p_CREATION_DATE DATE
,p_LAST_UPDATED_BY NUMBER
,p_LAST_UPDATE_DATE DATE
,p_LAST_UPDATE_LOGIN NUMBER
,p_FORECAST_RULE_ID NUMBER
,p_ORGANIZATION_TYPE VARCHAR2
,p_ORGANIZATION_ID NUMBER
,p_SECONDARY_INVENTORY VARCHAR2
,p_SERVICE_LEVEL NUMBER
,p_EDQ_FACTOR NUMBER
,p_PLANNER_CODE VARCHAR2
,p_CONDITION_TYPE VARCHAR2
,p_ASL_FLAG VARCHAR2
,p_SAFETY_STOCK_FLAG VARCHAR2
,p_EXCESS_RULE_ID NUMBER
,p_NOTIFICATION_RULE_ID NUMBER
,p_RECOMMENDATION_RULE_ID NUMBER
,p_ATTRIBUTE_CATEGORY VARCHAR2
,p_ATTRIBUTE1 VARCHAR2
,p_ATTRIBUTE2 VARCHAR2
,p_ATTRIBUTE3 VARCHAR2
,p_ATTRIBUTE4 VARCHAR2
,p_ATTRIBUTE5 VARCHAR2
,p_ATTRIBUTE6 VARCHAR2
,p_ATTRIBUTE7 VARCHAR2
,p_ATTRIBUTE8 VARCHAR2
,p_ATTRIBUTE9 VARCHAR2
,p_ATTRIBUTE10 VARCHAR2
,p_ATTRIBUTE11 VARCHAR2
,p_ATTRIBUTE12 VARCHAR2
,p_ATTRIBUTE13 VARCHAR2
,p_ATTRIBUTE14 VARCHAR2
,p_ATTRIBUTE15 VARCHAR2
,p_CATEGORY_SET_ID NUMBER
,p_CATEGORY_ID NUMBER
,p_RECOMMEND_METHOD VARCHAR2
,p_EDQ_MULTIPLE NUMBER
,p_MINIMUM_VALUE NUMBER
,p_USABLE_ASSIGNMENT_SET_ID NUMBER
,p_DEFECTIVE_ASSIGNMENT_SET_ID NUMBER
,p_REPAIR_ASSIGNMENT_SET_ID NUMBER
,p_PRODUCT_NORM VARCHAR2
,P_PRODUCT_NORM_NODE_ID NUMBER
,P_USAGE_WEIGHT1 NUMBER
,P_USAGE_WEIGHT2 NUMBER
,P_USAGE_WEIGHT3 NUMBER
,P_USAGE_WEIGHT4 NUMBER
,p_DEFAULT_FORECAST_RULE_ID VARCHAR2
,p_DEFAULT_SERVICE_LEVEL VARCHAR2
,p_DEFAULT_EDQ_FACTOR VARCHAR2
,p_DEFAULT_PLANNER_CODE VARCHAR2
,p_DEFAULT_CONDITION_TYPE VARCHAR2
,p_DEFAULT_ASL_FLAG VARCHAR2
,p_DEFAULT_SAFETY_STOCK_FLAG VARCHAR2
,p_DEFAULT_EXCESS_RULE_ID VARCHAR2
,p_DEFAULT_CATEGORY_SET_ID VARCHAR2
,p_DEFAULT_CATEGORY_ID VARCHAR2
,p_DEFAULT_RECOMMEND_METHOD VARCHAR2
,P_DEFAULT_PRODUCT_NORM_NODE_ID VARCHAR2
,P_DEFAULT_USAGE_WEIGHT1 VARCHAR2
,P_DEFAULT_USAGE_WEIGHT2 VARCHAR2
,P_DEFAULT_USAGE_WEIGHT3 VARCHAR2
,P_DEFAULT_USAGE_WEIGHT4 VARCHAR2
,P_DEFAULT_REC_RULE_ID VARCHAR2
,p_OVERRIDE_FORECAST_RULE_ID VARCHAR2
,p_OVERRIDE_SERVICE_LEVEL VARCHAR2
,p_OVERRIDE_EDQ_FACTOR VARCHAR2
,p_OVERRIDE_PLANNER_CODE VARCHAR2
,p_OVERRIDE_CONDITION_TYPE VARCHAR2
,p_OVERRIDE_ASL_FLAG VARCHAR2
,p_OVERRIDE_SAFETY_STOCK_FLAG VARCHAR2
,p_OVERRIDE_EXCESS_RULE_ID VARCHAR2
,p_OVERRIDE_CATEGORY_SET_ID VARCHAR2
,p_OVERRIDE_CATEGORY_ID VARCHAR2
,p_OVERRIDE_RECOMMEND_METHOD VARCHAR2
,P_OVERRIDE_USAGE_WEIGHT1 VARCHAR2
,P_OVERRIDE_USAGE_WEIGHT2 VARCHAR2
,P_OVERRIDE_USAGE_WEIGHT3 VARCHAR2
,P_OVERRIDE_USAGE_WEIGHT4 VARCHAR2
,P_OVERRIDE_REC_RULE_ID VARCHAR2
,p_NODE_TYPE VARCHAR2
,p_NODE_NAME VARCHAR2
,p_PARENT_NODE_ID NUMBER
,p_LEVEL_ID VARCHAR2
,p_EXCESS_EDQ_FACTOR VARCHAR2
,p_REPAIR_EDQ_FACTOR VARCHAR2
,p_NEWBUY_EDQ_FACTOR VARCHAR2
,p_EXCESS_SERVICE_LEVEL VARCHAR2
,p_REPAIR_SERVICE_LEVEL VARCHAR2
,p_NEWBUY_SERVICE_LEVEL VARCHAR2
,p_RESCHEDULE_RULE_ID NUMBER
,p_WRP_RULE_ID NUMBER)
IS
p_PLANNING_PARAMETERS_ID Number;
CURSOR C2 IS SELECT CSP_PLANNING_PARAMETERS_S1.nextval FROM sys.dual;
INSERT INTO CSP_PLANNING_PARAMETERS(
PLANNING_PARAMETERS_ID
,CREATED_BY
,CREATION_DATE
,LAST_UPDATED_BY
,LAST_UPDATE_DATE
,LAST_UPDATE_LOGIN
,FORECAST_RULE_ID
,ORGANIZATION_TYPE
,ORGANIZATION_ID
,SECONDARY_INVENTORY
,SERVICE_LEVEL
,EDQ_FACTOR
,PLANNER_CODE
,CONDITION_TYPE
,ASL_FLAG
,SAFETY_STOCK_FLAG
,EXCESS_RULE_ID
,NOTIFICATION_RULE_ID
,RECOMMENDATION_RULE_ID
,ATTRIBUTE_CATEGORY
,ATTRIBUTE1
,ATTRIBUTE2
,ATTRIBUTE3
,ATTRIBUTE4
,ATTRIBUTE5
,ATTRIBUTE6
,ATTRIBUTE7
,ATTRIBUTE8
,ATTRIBUTE9
,ATTRIBUTE10
,ATTRIBUTE11
,ATTRIBUTE12
,ATTRIBUTE13
,ATTRIBUTE14
,ATTRIBUTE15
,CATEGORY_SET_ID
,CATEGORY_ID
,RECOMMEND_METHOD
,EDQ_MULTIPLE
,MINIMUM_VALUE
,USABLE_ASSIGNMENT_SET_ID
,DEFECTIVE_ASSIGNMENT_SET_ID
,REPAIR_ASSIGNMENT_SET_ID
,PRODUCT_NORM
,PRODUCT_NORM_NODE_ID
,USAGE_WEIGHT1
,USAGE_WEIGHT2
,USAGE_WEIGHT3
,USAGE_WEIGHT4
,DEFAULT_FORECAST_RULE_ID
,DEFAULT_SERVICE_LEVEL
,DEFAULT_EDQ_FACTOR
,DEFAULT_PLANNER_CODE
,DEFAULT_CONDITION_TYPE
,DEFAULT_ASL_FLAG
,DEFAULT_SAFETY_STOCK_FLAG
,DEFAULT_EXCESS_RULE_ID
,DEFAULT_CATEGORY_SET_ID
,DEFAULT_CATEGORY_ID
,DEFAULT_RECOMMEND_METHOD
,DEFAULT_PRODUCT_NORM_NODE_ID
,DEFAULT_USAGE_WEIGHT1
,DEFAULT_USAGE_WEIGHT2
,DEFAULT_USAGE_WEIGHT3
,DEFAULT_USAGE_WEIGHT4
,DEFAULT_REC_RULE_ID
,OVERRIDE_FORECAST_RULE_ID
,OVERRIDE_SERVICE_LEVEL
,OVERRIDE_EDQ_FACTOR
,OVERRIDE_PLANNER_CODE
,OVERRIDE_CONDITION_TYPE
,OVERRIDE_ASL_FLAG
,OVERRIDE_SAFETY_STOCK_FLAG
,OVERRIDE_EXCESS_RULE_ID
,OVERRIDE_CATEGORY_SET_ID
,OVERRIDE_CATEGORY_ID
,OVERRIDE_RECOMMEND_METHOD
,OVERRIDE_USAGE_WEIGHT1
,OVERRIDE_USAGE_WEIGHT2
,OVERRIDE_USAGE_WEIGHT3
,OVERRIDE_USAGE_WEIGHT4
,OVERRIDE_REC_RULE_ID
,NODE_TYPE
,NODE_NAME
,PARENT_NODE_ID
,LEVEL_ID
,EXCESS_EDQ_FACTOR
,REPAIR_EDQ_FACTOR
,NEWBUY_EDQ_FACTOR
,EXCESS_SERVICE_LEVEL
,REPAIR_SERVICE_LEVEL
,NEWBUY_SERVICE_LEVEL
,RESCHEDULE_RULE_ID
,WRP_RULE_ID
) VALUES (
nvl(px_PLANNING_PARAMETERS_ID,p_PLANNING_PARAMETERS_ID)
,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
,decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_RULE_ID)
,decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ORGANIZATION_TYPE)
,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
,decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY)
,decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, NULL, p_SERVICE_LEVEL)
,decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, NULL, p_EDQ_FACTOR)
,decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE)
,decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_CONDITION_TYPE)
,decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_ASL_FLAG)
,decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_SAFETY_STOCK_FLAG)
,decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_EXCESS_RULE_ID)
,decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_NOTIFICATION_RULE_ID)
,decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_RECOMMENDATION_RULE_ID)
,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
,decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID)
,decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID)
,decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_RECOMMEND_METHOD)
,decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_EDQ_MULTIPLE)
,decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, NULL, p_MINIMUM_VALUE)
,decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_USABLE_ASSIGNMENT_SET_ID)
,decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_DEFECTIVE_ASSIGNMENT_SET_ID)
,decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ASSIGNMENT_SET_ID)
,decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, NULL, p_PRODUCT_NORM)
,decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_NORM_NODE_ID)
,decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT1)
,decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT2)
,decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT3)
,decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT4)
,decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FORECAST_RULE_ID)
,decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SERVICE_LEVEL)
,decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EDQ_FACTOR)
,decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PLANNER_CODE)
,decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CONDITION_TYPE)
,decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_ASL_FLAG)
,decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SAFETY_STOCK_FLAG)
,decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EXCESS_RULE_ID)
,decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_SET_ID)
,decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_ID)
,decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_RECOMMEND_METHOD)
,decode( p_DEFAULT_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PRODUCT_NORM_NODE_ID)
,decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT1)
,decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT2)
,decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT3)
,decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT4)
,decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_REC_RULE_ID)
,decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_FORECAST_RULE_ID)
,decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SERVICE_LEVEL)
,decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EDQ_FACTOR)
,decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_PLANNER_CODE)
,decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CONDITION_TYPE)
,decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_ASL_FLAG)
,decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SAFETY_STOCK_FLAG)
,decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EXCESS_RULE_ID)
,decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_SET_ID)
,decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_ID)
,decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_RECOMMEND_METHOD)
,decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT1)
,decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT2)
,decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT3)
,decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT4)
,decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_REC_RULE_ID)
,decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NODE_TYPE)
,decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NULL, p_NODE_NAME)
,decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_NODE_ID)
,decode( p_LEVEL_ID, FND_API.G_MISS_CHAR, NULL, p_LEVEL_ID)
,decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_EXCESS_EDQ_FACTOR)
,decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_REPAIR_EDQ_FACTOR)
,decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_EDQ_FACTOR)
,decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_EXCESS_SERVICE_LEVEL)
,decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_REPAIR_SERVICE_LEVEL)
,decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_SERVICE_LEVEL)
,decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_RESCHEDULE_RULE_ID)
,decode( p_WRP_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_WRP_RULE_ID));
End Insert_Row;
PROCEDURE Update_Row(
p_PLANNING_PARAMETERS_ID NUMBER
,p_CREATED_BY NUMBER
,p_CREATION_DATE DATE
,p_LAST_UPDATED_BY NUMBER
,p_LAST_UPDATE_DATE DATE
,p_LAST_UPDATE_LOGIN NUMBER
,p_FORECAST_RULE_ID NUMBER
,p_ORGANIZATION_TYPE VARCHAR2
,p_ORGANIZATION_ID NUMBER
,p_SECONDARY_INVENTORY VARCHAR2
,p_SERVICE_LEVEL NUMBER
,p_EDQ_FACTOR NUMBER
,p_PLANNER_CODE VARCHAR2
,p_CONDITION_TYPE VARCHAR2
,p_ASL_FLAG VARCHAR2
,p_SAFETY_STOCK_FLAG VARCHAR2
,p_EXCESS_RULE_ID NUMBER
,p_NOTIFICATION_RULE_ID NUMBER
,p_RECOMMENDATION_RULE_ID NUMBER
,p_ATTRIBUTE_CATEGORY VARCHAR2
,p_ATTRIBUTE1 VARCHAR2
,p_ATTRIBUTE2 VARCHAR2
,p_ATTRIBUTE3 VARCHAR2
,p_ATTRIBUTE4 VARCHAR2
,p_ATTRIBUTE5 VARCHAR2
,p_ATTRIBUTE6 VARCHAR2
,p_ATTRIBUTE7 VARCHAR2
,p_ATTRIBUTE8 VARCHAR2
,p_ATTRIBUTE9 VARCHAR2
,p_ATTRIBUTE10 VARCHAR2
,p_ATTRIBUTE11 VARCHAR2
,p_ATTRIBUTE12 VARCHAR2
,p_ATTRIBUTE13 VARCHAR2
,p_ATTRIBUTE14 VARCHAR2
,p_ATTRIBUTE15 VARCHAR2
,p_CATEGORY_SET_ID NUMBER
,p_CATEGORY_ID NUMBER
,p_RECOMMEND_METHOD VARCHAR2
,p_EDQ_MULTIPLE NUMBER
,p_MINIMUM_VALUE NUMBER
,p_USABLE_ASSIGNMENT_SET_ID NUMBER
,p_DEFECTIVE_ASSIGNMENT_SET_ID NUMBER
,p_REPAIR_ASSIGNMENT_SET_ID NUMBER
,p_PRODUCT_NORM VARCHAR2
,P_PRODUCT_NORM_NODE_ID NUMBER
,P_USAGE_WEIGHT1 NUMBER
,P_USAGE_WEIGHT2 NUMBER
,P_USAGE_WEIGHT3 NUMBER
,P_USAGE_WEIGHT4 NUMBER
,p_DEFAULT_FORECAST_RULE_ID VARCHAR2
,p_DEFAULT_SERVICE_LEVEL VARCHAR2
,p_DEFAULT_EDQ_FACTOR VARCHAR2
,p_DEFAULT_PLANNER_CODE VARCHAR2
,p_DEFAULT_CONDITION_TYPE VARCHAR2
,p_DEFAULT_ASL_FLAG VARCHAR2
,p_DEFAULT_SAFETY_STOCK_FLAG VARCHAR2
,p_DEFAULT_EXCESS_RULE_ID VARCHAR2
,p_DEFAULT_CATEGORY_SET_ID VARCHAR2
,p_DEFAULT_CATEGORY_ID VARCHAR2
,p_DEFAULT_RECOMMEND_METHOD VARCHAR2
,P_DEFAULT_PRODUCT_NORM_NODE_ID VARCHAR2
,P_DEFAULT_USAGE_WEIGHT1 VARCHAR2
,P_DEFAULT_USAGE_WEIGHT2 VARCHAR2
,P_DEFAULT_USAGE_WEIGHT3 VARCHAR2
,P_DEFAULT_USAGE_WEIGHT4 VARCHAR2
,P_DEFAULT_REC_RULE_ID VARCHAR2
,p_OVERRIDE_FORECAST_RULE_ID VARCHAR2
,p_OVERRIDE_SERVICE_LEVEL VARCHAR2
,p_OVERRIDE_EDQ_FACTOR VARCHAR2
,p_OVERRIDE_PLANNER_CODE VARCHAR2
,p_OVERRIDE_CONDITION_TYPE VARCHAR2
,p_OVERRIDE_ASL_FLAG VARCHAR2
,p_OVERRIDE_SAFETY_STOCK_FLAG VARCHAR2
,p_OVERRIDE_EXCESS_RULE_ID VARCHAR2
,p_OVERRIDE_CATEGORY_SET_ID VARCHAR2
,p_OVERRIDE_CATEGORY_ID VARCHAR2
,p_OVERRIDE_RECOMMEND_METHOD VARCHAR2
,P_OVERRIDE_USAGE_WEIGHT1 VARCHAR2
,P_OVERRIDE_USAGE_WEIGHT2 VARCHAR2
,P_OVERRIDE_USAGE_WEIGHT3 VARCHAR2
,P_OVERRIDE_USAGE_WEIGHT4 VARCHAR2
,P_OVERRIDE_REC_RULE_ID VARCHAR2
,p_NODE_TYPE VARCHAR2
,p_NODE_NAME VARCHAR2
,p_PARENT_NODE_ID NUMBER
,p_LEVEL_ID VARCHAR2
,p_EXCESS_EDQ_FACTOR VARCHAR2
,p_REPAIR_EDQ_FACTOR VARCHAR2
,p_NEWBUY_EDQ_FACTOR VARCHAR2
,p_EXCESS_SERVICE_LEVEL VARCHAR2
,p_REPAIR_SERVICE_LEVEL VARCHAR2
,p_NEWBUY_SERVICE_LEVEL VARCHAR2
,p_RESCHEDULE_RULE_ID NUMBER
,p_WRP_RULE_ID NUMBER)
IS
BEGIN
Update CSP_PLANNING_PARAMETERS
SET
CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
,FORECAST_RULE_ID = decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, FORECAST_RULE_ID, p_FORECAST_RULE_ID)
,ORGANIZATION_TYPE = decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, ORGANIZATION_TYPE, p_ORGANIZATION_TYPE)
,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
,SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY)
,SERVICE_LEVEL = decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, SERVICE_LEVEL, p_SERVICE_LEVEL)
,EDQ_FACTOR = decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, EDQ_FACTOR, p_EDQ_FACTOR)
,PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE)
,CONDITION_TYPE = decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, CONDITION_TYPE, p_CONDITION_TYPE)
,ASL_FLAG = decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, ASL_FLAG, p_ASL_FLAG)
,SAFETY_STOCK_FLAG = decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, SAFETY_STOCK_FLAG, p_SAFETY_STOCK_FLAG)
,EXCESS_RULE_ID = decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, EXCESS_RULE_ID, p_EXCESS_RULE_ID)
,NOTIFICATION_RULE_ID = decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NOTIFICATION_RULE_ID, p_NOTIFICATION_RULE_ID)
,RECOMMENDATION_RULE_ID = decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, RECOMMENDATION_RULE_ID, p_RECOMMENDATION_RULE_ID)
,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
,CATEGORY_SET_ID = decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, CATEGORY_SET_ID, p_CATEGORY_SET_ID)
,CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID)
,RECOMMEND_METHOD = decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, RECOMMEND_METHOD, p_RECOMMEND_METHOD)
,EDQ_MULTIPLE = decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, EDQ_MULTIPLE, p_EDQ_MULTIPLE)
,MINIMUM_VALUE = decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, MINIMUM_VALUE, p_MINIMUM_VALUE)
,USABLE_ASSIGNMENT_SET_ID = decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, USABLE_ASSIGNMENT_SET_ID, p_USABLE_ASSIGNMENT_SET_ID)
,DEFECTIVE_ASSIGNMENT_SET_ID = decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, DEFECTIVE_ASSIGNMENT_SET_ID, p_DEFECTIVE_ASSIGNMENT_SET_ID)
,REPAIR_ASSIGNMENT_SET_ID = decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, REPAIR_ASSIGNMENT_SET_ID, p_REPAIR_ASSIGNMENT_SET_ID)
,PRODUCT_NORM = decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, PRODUCT_NORM, p_PRODUCT_NORM)
,PRODUCT_NORM_NODE_ID = decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, PRODUCT_NORM_NODE_ID, p_PRODUCT_NORM_NODE_ID)
,USAGE_WEIGHT1 = decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, USAGE_WEIGHT1, p_USAGE_WEIGHT1)
,USAGE_WEIGHT2 = decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, USAGE_WEIGHT2, p_USAGE_WEIGHT2)
,USAGE_WEIGHT3 = decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, USAGE_WEIGHT3, p_USAGE_WEIGHT3)
,USAGE_WEIGHT4 = decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, USAGE_WEIGHT4, p_USAGE_WEIGHT4)
,DEFAULT_FORECAST_RULE_ID = decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_FORECAST_RULE_ID, p_DEFAULT_FORECAST_RULE_ID)
,DEFAULT_SERVICE_LEVEL = decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, DEFAULT_SERVICE_LEVEL, p_DEFAULT_SERVICE_LEVEL)
,DEFAULT_EDQ_FACTOR = decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, DEFAULT_EDQ_FACTOR, p_DEFAULT_EDQ_FACTOR)
,DEFAULT_PLANNER_CODE = decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, DEFAULT_PLANNER_CODE, p_DEFAULT_PLANNER_CODE)
,DEFAULT_CONDITION_TYPE = decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, DEFAULT_CONDITION_TYPE, p_DEFAULT_CONDITION_TYPE)
,DEFAULT_ASL_FLAG = decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, DEFAULT_ASL_FLAG, p_DEFAULT_ASL_FLAG)
,DEFAULT_SAFETY_STOCK_FLAG = decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, DEFAULT_SAFETY_STOCK_FLAG, p_DEFAULT_SAFETY_STOCK_FLAG)
,DEFAULT_EXCESS_RULE_ID = decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_EXCESS_RULE_ID, p_DEFAULT_EXCESS_RULE_ID)
,DEFAULT_CATEGORY_SET_ID = decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_SET_ID, p_DEFAULT_CATEGORY_SET_ID)
,DEFAULT_CATEGORY_ID = decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_ID, p_DEFAULT_CATEGORY_ID)
,DEFAULT_RECOMMEND_METHOD = decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, DEFAULT_RECOMMEND_METHOD, p_DEFAULT_RECOMMEND_METHOD)
,DEFAULT_PRODUCT_NORM_NODE_ID = decode( p_DEFAULT_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_CHAR, DEFAULT_PRODUCT_NORM_NODE_ID, p_DEFAULT_PRODUCT_NORM_NODE_ID)
,DEFAULT_USAGE_WEIGHT1 = decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT1, p_DEFAULT_USAGE_WEIGHT1)
,DEFAULT_USAGE_WEIGHT2 = decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT2, p_DEFAULT_USAGE_WEIGHT2)
,DEFAULT_USAGE_WEIGHT3 = decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT3, p_DEFAULT_USAGE_WEIGHT3)
,DEFAULT_USAGE_WEIGHT4 = decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT4, p_DEFAULT_USAGE_WEIGHT4)
,DEFAULT_REC_RULE_ID = decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_REC_RULE_ID, p_DEFAULT_REC_RULE_ID)
,OVERRIDE_FORECAST_RULE_ID = decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_FORECAST_RULE_ID, p_OVERRIDE_FORECAST_RULE_ID)
,OVERRIDE_SERVICE_LEVEL = decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, OVERRIDE_SERVICE_LEVEL, p_OVERRIDE_SERVICE_LEVEL)
,OVERRIDE_EDQ_FACTOR = decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, OVERRIDE_EDQ_FACTOR, p_OVERRIDE_EDQ_FACTOR)
,OVERRIDE_PLANNER_CODE = decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, OVERRIDE_PLANNER_CODE, p_OVERRIDE_PLANNER_CODE)
,OVERRIDE_CONDITION_TYPE = decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, OVERRIDE_CONDITION_TYPE, p_OVERRIDE_CONDITION_TYPE)
,OVERRIDE_ASL_FLAG = decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_ASL_FLAG, p_OVERRIDE_ASL_FLAG)
,OVERRIDE_SAFETY_STOCK_FLAG = decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_SAFETY_STOCK_FLAG, p_OVERRIDE_SAFETY_STOCK_FLAG)
,OVERRIDE_EXCESS_RULE_ID = decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_EXCESS_RULE_ID, p_OVERRIDE_EXCESS_RULE_ID)
,OVERRIDE_CATEGORY_SET_ID = decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_SET_ID, p_OVERRIDE_CATEGORY_SET_ID)
,OVERRIDE_CATEGORY_ID = decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_ID, p_OVERRIDE_CATEGORY_ID)
,OVERRIDE_RECOMMEND_METHOD = decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, OVERRIDE_RECOMMEND_METHOD, p_OVERRIDE_RECOMMEND_METHOD)
,OVERRIDE_USAGE_WEIGHT1 = decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT1, p_OVERRIDE_USAGE_WEIGHT1)
,OVERRIDE_USAGE_WEIGHT2 = decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT2, p_OVERRIDE_USAGE_WEIGHT2)
,OVERRIDE_USAGE_WEIGHT3 = decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT3, p_OVERRIDE_USAGE_WEIGHT3)
,OVERRIDE_USAGE_WEIGHT4 = decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT4, p_OVERRIDE_USAGE_WEIGHT4)
,OVERRIDE_REC_RULE_ID = decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_REC_RULE_ID, p_OVERRIDE_REC_RULE_ID)
,NODE_TYPE = decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NODE_TYPE, p_NODE_TYPE)
,NODE_NAME = decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NODE_NAME, p_NODE_NAME)
,PARENT_NODE_ID = decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, PARENT_NODE_ID, p_PARENT_NODE_ID)
,EXCESS_EDQ_FACTOR = decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, EXCESS_EDQ_FACTOR, p_EXCESS_EDQ_FACTOR)
,REPAIR_EDQ_FACTOR = decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, REPAIR_EDQ_FACTOR, p_REPAIR_EDQ_FACTOR)
,NEWBUY_EDQ_FACTOR = decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NEWBUY_EDQ_FACTOR, p_NEWBUY_EDQ_FACTOR)
,EXCESS_SERVICE_LEVEL = decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, EXCESS_SERVICE_LEVEL, p_EXCESS_SERVICE_LEVEL)
,REPAIR_SERVICE_LEVEL = decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, REPAIR_SERVICE_LEVEL, p_REPAIR_SERVICE_LEVEL)
,NEWBUY_SERVICE_LEVEL = decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NEWBUY_SERVICE_LEVEL, p_NEWBUY_SERVICE_LEVEL)
,RESCHEDULE_RULE_ID = decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_NUM, RESCHEDULE_RULE_ID, p_RESCHEDULE_RULE_ID)
,WRP_RULE_ID = decode( p_WRP_RULE_ID, FND_API.G_MISS_NUM, WRP_RULE_ID, p_WRP_RULE_ID)
where PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID;
END Update_Row;
PROCEDURE Delete_Row( p_LEVEL_ID VARCHAR2)
IS
BEGIN
DELETE FROM CSP_PLANNING_PARAMETERS
-- WHERE PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID;
END Delete_Row;
,p_LAST_UPDATED_BY NUMBER
,p_LAST_UPDATE_DATE DATE
,p_LAST_UPDATE_LOGIN NUMBER
,p_FORECAST_RULE_ID NUMBER
,p_ORGANIZATION_TYPE VARCHAR2
,p_ORGANIZATION_ID NUMBER
,p_SECONDARY_INVENTORY VARCHAR2
,p_SERVICE_LEVEL NUMBER
,p_EDQ_FACTOR NUMBER
,p_PLANNER_CODE VARCHAR2
,p_CONDITION_TYPE VARCHAR2
,p_ASL_FLAG VARCHAR2
,p_SAFETY_STOCK_FLAG VARCHAR2
,p_EXCESS_RULE_ID NUMBER
,p_NOTIFICATION_RULE_ID NUMBER
,p_RECOMMENDATION_RULE_ID NUMBER
,p_ATTRIBUTE_CATEGORY VARCHAR2
,p_ATTRIBUTE1 VARCHAR2
,p_ATTRIBUTE2 VARCHAR2
,p_ATTRIBUTE3 VARCHAR2
,p_ATTRIBUTE4 VARCHAR2
,p_ATTRIBUTE5 VARCHAR2
,p_ATTRIBUTE6 VARCHAR2
,p_ATTRIBUTE7 VARCHAR2
,p_ATTRIBUTE8 VARCHAR2
,p_ATTRIBUTE9 VARCHAR2
,p_ATTRIBUTE10 VARCHAR2
,p_ATTRIBUTE11 VARCHAR2
,p_ATTRIBUTE12 VARCHAR2
,p_ATTRIBUTE13 VARCHAR2
,p_ATTRIBUTE14 VARCHAR2
,p_ATTRIBUTE15 VARCHAR2
,p_CATEGORY_SET_ID NUMBER
,p_CATEGORY_ID NUMBER
,p_RECOMMEND_METHOD VARCHAR2
,p_EDQ_MULTIPLE NUMBER
,p_MINIMUM_VALUE NUMBER
,p_USABLE_ASSIGNMENT_SET_ID NUMBER
,p_DEFECTIVE_ASSIGNMENT_SET_ID NUMBER
,p_REPAIR_ASSIGNMENT_SET_ID NUMBER
,p_PRODUCT_NORM VARCHAR2
,P_PRODUCT_NORM_NODE_ID NUMBER
,P_USAGE_WEIGHT1 NUMBER
,P_USAGE_WEIGHT2 NUMBER
,P_USAGE_WEIGHT3 NUMBER
,P_USAGE_WEIGHT4 NUMBER
,p_DEFAULT_FORECAST_RULE_ID VARCHAR2
,p_DEFAULT_SERVICE_LEVEL VARCHAR2
,p_DEFAULT_EDQ_FACTOR VARCHAR2
,p_DEFAULT_PLANNER_CODE VARCHAR2
,p_DEFAULT_CONDITION_TYPE VARCHAR2
,p_DEFAULT_ASL_FLAG VARCHAR2
,p_DEFAULT_SAFETY_STOCK_FLAG VARCHAR2
,p_DEFAULT_EXCESS_RULE_ID VARCHAR2
,p_DEFAULT_CATEGORY_SET_ID VARCHAR2
,p_DEFAULT_CATEGORY_ID VARCHAR2
,p_DEFAULT_RECOMMEND_METHOD VARCHAR2
,P_DEFAULT_PRODUCT_NORM_NODE_ID VARCHAR2
,P_DEFAULT_USAGE_WEIGHT1 VARCHAR2
,P_DEFAULT_USAGE_WEIGHT2 VARCHAR2
,P_DEFAULT_USAGE_WEIGHT3 VARCHAR2
,P_DEFAULT_USAGE_WEIGHT4 VARCHAR2
,P_DEFAULT_REC_RULE_ID VARCHAR2
,p_OVERRIDE_FORECAST_RULE_ID VARCHAR2
,p_OVERRIDE_SERVICE_LEVEL VARCHAR2
,p_OVERRIDE_EDQ_FACTOR VARCHAR2
,p_OVERRIDE_PLANNER_CODE VARCHAR2
,p_OVERRIDE_CONDITION_TYPE VARCHAR2
,p_OVERRIDE_ASL_FLAG VARCHAR2
,p_OVERRIDE_SAFETY_STOCK_FLAG VARCHAR2
,p_OVERRIDE_EXCESS_RULE_ID VARCHAR2
,p_OVERRIDE_CATEGORY_SET_ID VARCHAR2
,p_OVERRIDE_CATEGORY_ID VARCHAR2
,p_OVERRIDE_RECOMMEND_METHOD VARCHAR2
,P_OVERRIDE_USAGE_WEIGHT1 VARCHAR2
,P_OVERRIDE_USAGE_WEIGHT2 VARCHAR2
,P_OVERRIDE_USAGE_WEIGHT3 VARCHAR2
,P_OVERRIDE_USAGE_WEIGHT4 VARCHAR2
,P_OVERRIDE_REC_RULE_ID VARCHAR2
,p_NODE_TYPE VARCHAR2
,p_NODE_NAME VARCHAR2
,p_PARENT_NODE_ID NUMBER
,p_LEVEL_ID VARCHAR2
,p_EXCESS_EDQ_FACTOR VARCHAR2
,p_REPAIR_EDQ_FACTOR VARCHAR2
,p_NEWBUY_EDQ_FACTOR VARCHAR2
,p_EXCESS_SERVICE_LEVEL VARCHAR2
,p_REPAIR_SERVICE_LEVEL VARCHAR2
,p_NEWBUY_SERVICE_LEVEL VARCHAR2
,p_RESCHEDULE_RULE_ID NUMBER
,p_WRP_RULE_ID NUMBER)
IS
CURSOR C IS
SELECT *
FROM CSP_PLANNING_PARAMETERS
WHERE PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID
FOR UPDATE of PLANNING_PARAMETERS_ID NOWAIT;
FND_MESSAGE.SET_NAME('FND', 'FORM_RECORD_DELETED');
AND ( ( Recinfo.LAST_UPDATED_BY = p_LAST_UPDATED_BY)
OR ( ( Recinfo.LAST_UPDATED_BY IS NULL )
AND ( p_LAST_UPDATED_BY IS NULL )))
AND ( ( Recinfo.LAST_UPDATE_DATE = p_LAST_UPDATE_DATE)
OR ( ( Recinfo.LAST_UPDATE_DATE IS NULL )
AND ( p_LAST_UPDATE_DATE IS NULL )))
AND ( ( Recinfo.LAST_UPDATE_LOGIN = p_LAST_UPDATE_LOGIN)
OR ( ( Recinfo.LAST_UPDATE_LOGIN IS NULL )
AND ( p_LAST_UPDATE_LOGIN IS NULL )))
AND ( ( Recinfo.FORECAST_RULE_ID = p_FORECAST_RULE_ID)
OR ( ( Recinfo.FORECAST_RULE_ID IS NULL )
AND ( p_FORECAST_RULE_ID IS NULL )))
AND ( ( Recinfo.ORGANIZATION_TYPE = p_ORGANIZATION_TYPE)
OR ( ( Recinfo.ORGANIZATION_TYPE IS NULL )
AND ( p_ORGANIZATION_TYPE IS NULL )))
AND ( ( Recinfo.ORGANIZATION_ID = p_ORGANIZATION_ID)
OR ( ( Recinfo.ORGANIZATION_ID IS NULL )
AND ( p_ORGANIZATION_ID IS NULL )))
AND ( ( Recinfo.SECONDARY_INVENTORY = p_SECONDARY_INVENTORY)
OR ( ( Recinfo.SECONDARY_INVENTORY IS NULL )
AND ( p_SECONDARY_INVENTORY IS NULL )))
AND ( ( Recinfo.SERVICE_LEVEL = p_SERVICE_LEVEL)
OR ( ( Recinfo.SERVICE_LEVEL IS NULL )
AND ( p_SERVICE_LEVEL IS NULL )))
AND ( ( Recinfo.EDQ_FACTOR = p_EDQ_FACTOR)
OR ( ( Recinfo.EDQ_FACTOR IS NULL )
AND ( p_EDQ_FACTOR IS NULL )))
AND ( ( Recinfo.PLANNER_CODE = p_PLANNER_CODE)
OR ( ( Recinfo.PLANNER_CODE IS NULL )
AND ( p_PLANNER_CODE IS NULL )))
AND ( ( Recinfo.CONDITION_TYPE = p_CONDITION_TYPE)
OR ( ( Recinfo.CONDITION_TYPE IS NULL )
AND ( p_CONDITION_TYPE IS NULL )))
AND ( ( Recinfo.ASL_FLAG = p_ASL_FLAG)
OR ( ( Recinfo.ASL_FLAG IS NULL )
AND ( p_ASL_FLAG IS NULL )))
AND ( ( Recinfo.SAFETY_STOCK_FLAG = p_SAFETY_STOCK_FLAG)
OR ( ( Recinfo.SAFETY_STOCK_FLAG IS NULL )
AND ( p_SAFETY_STOCK_FLAG IS NULL )))
AND ( ( Recinfo.EXCESS_RULE_ID = p_EXCESS_RULE_ID)
OR ( ( Recinfo.EXCESS_RULE_ID IS NULL )
AND ( p_EXCESS_RULE_ID IS NULL )))
AND ( ( Recinfo.NOTIFICATION_RULE_ID = p_NOTIFICATION_RULE_ID)
OR ( ( Recinfo.NOTIFICATION_RULE_ID IS NULL )
AND ( p_NOTIFICATION_RULE_ID IS NULL )))
AND ( ( Recinfo.RECOMMENDATION_RULE_ID = p_RECOMMENDATION_RULE_ID)
OR ( ( Recinfo.RECOMMENDATION_RULE_ID IS NULL )
AND ( p_RECOMMENDATION_RULE_ID IS NULL )))
AND ( ( Recinfo.ATTRIBUTE_CATEGORY = p_ATTRIBUTE_CATEGORY)
OR ( ( Recinfo.ATTRIBUTE_CATEGORY IS NULL )
AND ( p_ATTRIBUTE_CATEGORY IS NULL )))
AND ( ( Recinfo.ATTRIBUTE1 = p_ATTRIBUTE1)
OR ( ( Recinfo.ATTRIBUTE1 IS NULL )
AND ( p_ATTRIBUTE1 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE2 = p_ATTRIBUTE2)
OR ( ( Recinfo.ATTRIBUTE2 IS NULL )
AND ( p_ATTRIBUTE2 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE3 = p_ATTRIBUTE3)
OR ( ( Recinfo.ATTRIBUTE3 IS NULL )
AND ( p_ATTRIBUTE3 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE4 = p_ATTRIBUTE4)
OR ( ( Recinfo.ATTRIBUTE4 IS NULL )
AND ( p_ATTRIBUTE4 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE5 = p_ATTRIBUTE5)
OR ( ( Recinfo.ATTRIBUTE5 IS NULL )
AND ( p_ATTRIBUTE5 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE6 = p_ATTRIBUTE6)
OR ( ( Recinfo.ATTRIBUTE6 IS NULL )
AND ( p_ATTRIBUTE6 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE7 = p_ATTRIBUTE7)
OR ( ( Recinfo.ATTRIBUTE7 IS NULL )
AND ( p_ATTRIBUTE7 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE8 = p_ATTRIBUTE8)
OR ( ( Recinfo.ATTRIBUTE8 IS NULL )
AND ( p_ATTRIBUTE8 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE9 = p_ATTRIBUTE9)
OR ( ( Recinfo.ATTRIBUTE9 IS NULL )
AND ( p_ATTRIBUTE9 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE10 = p_ATTRIBUTE10)
OR ( ( Recinfo.ATTRIBUTE10 IS NULL )
AND ( p_ATTRIBUTE10 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE11 = p_ATTRIBUTE11)
OR ( ( Recinfo.ATTRIBUTE11 IS NULL )
AND ( p_ATTRIBUTE11 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE12 = p_ATTRIBUTE12)
OR ( ( Recinfo.ATTRIBUTE12 IS NULL )
AND ( p_ATTRIBUTE12 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE13 = p_ATTRIBUTE13)
OR ( ( Recinfo.ATTRIBUTE13 IS NULL )
AND ( p_ATTRIBUTE13 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE14 = p_ATTRIBUTE14)
OR ( ( Recinfo.ATTRIBUTE14 IS NULL )
AND ( p_ATTRIBUTE14 IS NULL )))
AND ( ( Recinfo.ATTRIBUTE15 = p_ATTRIBUTE15)
OR ( ( Recinfo.ATTRIBUTE15 IS NULL )
AND ( p_ATTRIBUTE15 IS NULL )))
AND ( ( Recinfo.CATEGORY_SET_ID = p_CATEGORY_SET_ID)
OR ( ( Recinfo.CATEGORY_SET_ID IS NULL )
AND ( p_CATEGORY_SET_ID IS NULL )))
AND ( ( Recinfo.CATEGORY_ID = p_CATEGORY_ID)
OR ( ( Recinfo.CATEGORY_ID IS NULL )
AND ( p_CATEGORY_ID IS NULL )))
AND ( ( Recinfo.RECOMMEND_METHOD = p_RECOMMEND_METHOD)
OR ( ( Recinfo.RECOMMEND_METHOD IS NULL )
AND ( p_RECOMMEND_METHOD IS NULL )))
AND ( ( Recinfo.EDQ_MULTIPLE = p_EDQ_MULTIPLE)
OR ( ( Recinfo.EDQ_MULTIPLE IS NULL )
AND ( p_EDQ_MULTIPLE IS NULL )))
AND ( ( Recinfo.MINIMUM_VALUE = p_MINIMUM_VALUE)
OR ( ( Recinfo.MINIMUM_VALUE IS NULL )
AND ( p_MINIMUM_VALUE IS NULL )))
AND ( ( Recinfo.USABLE_ASSIGNMENT_SET_ID = p_USABLE_ASSIGNMENT_SET_ID)
OR ( ( Recinfo.USABLE_ASSIGNMENT_SET_ID IS NULL )
AND ( p_USABLE_ASSIGNMENT_SET_ID IS NULL )))
AND ( ( Recinfo.DEFECTIVE_ASSIGNMENT_SET_ID = p_DEFECTIVE_ASSIGNMENT_SET_ID)
OR ( ( Recinfo.DEFECTIVE_ASSIGNMENT_SET_ID IS NULL )
AND ( p_DEFECTIVE_ASSIGNMENT_SET_ID IS NULL )))
AND ( ( Recinfo.REPAIR_ASSIGNMENT_SET_ID = p_REPAIR_ASSIGNMENT_SET_ID)
OR ( ( Recinfo.REPAIR_ASSIGNMENT_SET_ID IS NULL )
AND ( p_REPAIR_ASSIGNMENT_SET_ID IS NULL )))
AND ( ( Recinfo.PRODUCT_NORM = p_PRODUCT_NORM)
OR ( ( Recinfo.PRODUCT_NORM IS NULL )
AND ( p_PRODUCT_NORM IS NULL )))
AND ( ( Recinfo.PRODUCT_NORM_NODE_ID = p_PRODUCT_NORM_NODE_ID)
OR ( ( Recinfo.PRODUCT_NORM_NODE_ID IS NULL )
AND ( p_PRODUCT_NORM_NODE_ID IS NULL )))
AND ( ( Recinfo.USAGE_WEIGHT1 = p_USAGE_WEIGHT1)
OR ( ( Recinfo.USAGE_WEIGHT1 IS NULL )
AND ( p_USAGE_WEIGHT1 IS NULL )))
AND ( ( Recinfo.USAGE_WEIGHT2 = p_USAGE_WEIGHT2)
OR ( ( Recinfo.USAGE_WEIGHT2 IS NULL )
AND ( p_USAGE_WEIGHT2 IS NULL )))
AND ( ( Recinfo.USAGE_WEIGHT3 = p_USAGE_WEIGHT3)
OR ( ( Recinfo.USAGE_WEIGHT3 IS NULL )
AND ( p_USAGE_WEIGHT3 IS NULL )))
AND ( ( Recinfo.USAGE_WEIGHT4 = p_USAGE_WEIGHT4)
OR ( ( Recinfo.USAGE_WEIGHT4 IS NULL )
AND ( p_USAGE_WEIGHT4 IS NULL )))
AND ( ( Recinfo.DEFAULT_FORECAST_RULE_ID = p_DEFAULT_FORECAST_RULE_ID)
OR ( ( Recinfo.DEFAULT_FORECAST_RULE_ID IS NULL )
AND ( p_DEFAULT_FORECAST_RULE_ID IS NULL )))
AND ( ( Recinfo.DEFAULT_SERVICE_LEVEL = p_DEFAULT_SERVICE_LEVEL)
OR ( ( Recinfo.DEFAULT_SERVICE_LEVEL IS NULL )
AND ( p_DEFAULT_SERVICE_LEVEL IS NULL )))
AND ( ( Recinfo.DEFAULT_EDQ_FACTOR = p_DEFAULT_EDQ_FACTOR)
OR ( ( Recinfo.DEFAULT_EDQ_FACTOR IS NULL )
AND ( p_DEFAULT_EDQ_FACTOR IS NULL )))
AND ( ( Recinfo.DEFAULT_PLANNER_CODE = p_DEFAULT_PLANNER_CODE)
OR ( ( Recinfo.DEFAULT_PLANNER_CODE IS NULL )
AND ( p_DEFAULT_PLANNER_CODE IS NULL )))
AND ( ( Recinfo.DEFAULT_CONDITION_TYPE = p_DEFAULT_CONDITION_TYPE)
OR ( ( Recinfo.DEFAULT_CONDITION_TYPE IS NULL )
AND ( p_DEFAULT_CONDITION_TYPE IS NULL )))
AND ( ( Recinfo.DEFAULT_ASL_FLAG = p_DEFAULT_ASL_FLAG)
OR ( ( Recinfo.DEFAULT_ASL_FLAG IS NULL )
AND ( p_DEFAULT_ASL_FLAG IS NULL )))
AND ( ( Recinfo.DEFAULT_SAFETY_STOCK_FLAG = p_DEFAULT_SAFETY_STOCK_FLAG)
OR ( ( Recinfo.DEFAULT_SAFETY_STOCK_FLAG IS NULL )
AND ( p_DEFAULT_SAFETY_STOCK_FLAG IS NULL )))
AND ( ( Recinfo.DEFAULT_EXCESS_RULE_ID = p_DEFAULT_EXCESS_RULE_ID)
OR ( ( Recinfo.DEFAULT_EXCESS_RULE_ID IS NULL )
AND ( p_DEFAULT_EXCESS_RULE_ID IS NULL )))
AND ( ( Recinfo.DEFAULT_CATEGORY_SET_ID = p_DEFAULT_CATEGORY_SET_ID)
OR ( ( Recinfo.DEFAULT_CATEGORY_SET_ID IS NULL )
AND ( p_DEFAULT_CATEGORY_SET_ID IS NULL )))
AND ( ( Recinfo.DEFAULT_CATEGORY_ID = p_DEFAULT_CATEGORY_ID)
OR ( ( Recinfo.DEFAULT_CATEGORY_ID IS NULL )
AND ( p_DEFAULT_CATEGORY_ID IS NULL )))
AND ( ( Recinfo.DEFAULT_RECOMMEND_METHOD = p_DEFAULT_RECOMMEND_METHOD)
OR ( ( Recinfo.DEFAULT_RECOMMEND_METHOD IS NULL )
AND ( p_DEFAULT_RECOMMEND_METHOD IS NULL )))
AND ( ( Recinfo.DEFAULT_PRODUCT_NORM_NODE_ID = p_DEFAULT_PRODUCT_NORM_NODE_ID)
OR ( ( Recinfo.DEFAULT_PRODUCT_NORM_NODE_ID IS NULL )
AND ( p_DEFAULT_PRODUCT_NORM_NODE_ID IS NULL )))
AND ( ( Recinfo.DEFAULT_USAGE_WEIGHT1 = p_DEFAULT_USAGE_WEIGHT1)
OR ( ( Recinfo.DEFAULT_USAGE_WEIGHT1 IS NULL )
AND ( p_DEFAULT_USAGE_WEIGHT1 IS NULL )))
AND ( ( Recinfo.DEFAULT_USAGE_WEIGHT2 = p_DEFAULT_USAGE_WEIGHT2)
OR ( ( Recinfo.DEFAULT_USAGE_WEIGHT2 IS NULL )
AND ( p_DEFAULT_USAGE_WEIGHT2 IS NULL )))
AND ( ( Recinfo.DEFAULT_USAGE_WEIGHT3 = p_DEFAULT_USAGE_WEIGHT3)
OR ( ( Recinfo.DEFAULT_USAGE_WEIGHT3 IS NULL )
AND ( p_DEFAULT_USAGE_WEIGHT3 IS NULL )))
AND ( ( Recinfo.DEFAULT_USAGE_WEIGHT4 = p_DEFAULT_USAGE_WEIGHT4)
OR ( ( Recinfo.DEFAULT_USAGE_WEIGHT4 IS NULL )
AND ( p_DEFAULT_USAGE_WEIGHT4 IS NULL )))
AND ( ( Recinfo.DEFAULT_REC_RULE_ID = p_DEFAULT_REC_RULE_ID)
OR ( ( Recinfo.DEFAULT_REC_RULE_ID IS NULL )
AND ( p_DEFAULT_REC_RULE_ID IS NULL )))
AND ( ( Recinfo.OVERRIDE_FORECAST_RULE_ID = p_OVERRIDE_FORECAST_RULE_ID)
OR ( ( Recinfo.OVERRIDE_FORECAST_RULE_ID IS NULL )
AND ( p_OVERRIDE_FORECAST_RULE_ID IS NULL )))
AND ( ( Recinfo.OVERRIDE_SERVICE_LEVEL = p_OVERRIDE_SERVICE_LEVEL)
OR ( ( Recinfo.OVERRIDE_SERVICE_LEVEL IS NULL )
AND ( p_OVERRIDE_SERVICE_LEVEL IS NULL )))
AND ( ( Recinfo.OVERRIDE_EDQ_FACTOR = p_OVERRIDE_EDQ_FACTOR)
OR ( ( Recinfo.OVERRIDE_EDQ_FACTOR IS NULL )
AND ( p_OVERRIDE_EDQ_FACTOR IS NULL )))
AND ( ( Recinfo.OVERRIDE_PLANNER_CODE = p_OVERRIDE_PLANNER_CODE)
OR ( ( Recinfo.OVERRIDE_PLANNER_CODE IS NULL )
AND ( p_OVERRIDE_PLANNER_CODE IS NULL )))
AND ( ( Recinfo.OVERRIDE_CONDITION_TYPE = p_OVERRIDE_CONDITION_TYPE)
OR ( ( Recinfo.OVERRIDE_CONDITION_TYPE IS NULL )
AND ( p_OVERRIDE_CONDITION_TYPE IS NULL )))
AND ( ( Recinfo.OVERRIDE_ASL_FLAG = p_OVERRIDE_ASL_FLAG)
OR ( ( Recinfo.OVERRIDE_ASL_FLAG IS NULL )
AND ( p_OVERRIDE_ASL_FLAG IS NULL )))
AND ( ( Recinfo.OVERRIDE_SAFETY_STOCK_FLAG = p_OVERRIDE_SAFETY_STOCK_FLAG)
OR ( ( Recinfo.OVERRIDE_SAFETY_STOCK_FLAG IS NULL )
AND ( p_OVERRIDE_SAFETY_STOCK_FLAG IS NULL )))
AND ( ( Recinfo.OVERRIDE_EXCESS_RULE_ID = p_OVERRIDE_EXCESS_RULE_ID)
OR ( ( Recinfo.OVERRIDE_EXCESS_RULE_ID IS NULL )
AND ( p_OVERRIDE_EXCESS_RULE_ID IS NULL )))
AND ( ( Recinfo.OVERRIDE_CATEGORY_SET_ID = p_OVERRIDE_CATEGORY_SET_ID)
OR ( ( Recinfo.OVERRIDE_CATEGORY_SET_ID IS NULL )
AND ( p_OVERRIDE_CATEGORY_SET_ID IS NULL )))
AND ( ( Recinfo.OVERRIDE_CATEGORY_ID = p_OVERRIDE_CATEGORY_ID)
OR ( ( Recinfo.OVERRIDE_CATEGORY_ID IS NULL )
AND ( p_OVERRIDE_CATEGORY_ID IS NULL )))
AND ( ( Recinfo.OVERRIDE_RECOMMEND_METHOD = p_OVERRIDE_RECOMMEND_METHOD)
OR ( ( Recinfo.OVERRIDE_RECOMMEND_METHOD IS NULL )
AND ( p_OVERRIDE_RECOMMEND_METHOD IS NULL )))
AND ( ( Recinfo.OVERRIDE_USAGE_WEIGHT1 = p_OVERRIDE_USAGE_WEIGHT1)
OR ( ( Recinfo.OVERRIDE_USAGE_WEIGHT1 IS NULL )
AND ( p_OVERRIDE_USAGE_WEIGHT1 IS NULL )))
AND ( ( Recinfo.OVERRIDE_USAGE_WEIGHT2 = p_OVERRIDE_USAGE_WEIGHT2)
OR ( ( Recinfo.OVERRIDE_USAGE_WEIGHT2 IS NULL )
AND ( p_OVERRIDE_USAGE_WEIGHT2 IS NULL )))
AND ( ( Recinfo.OVERRIDE_USAGE_WEIGHT3 = p_OVERRIDE_USAGE_WEIGHT3)
OR ( ( Recinfo.OVERRIDE_USAGE_WEIGHT3 IS NULL )
AND ( p_OVERRIDE_USAGE_WEIGHT3 IS NULL )))
AND ( ( Recinfo.OVERRIDE_USAGE_WEIGHT4 = p_OVERRIDE_USAGE_WEIGHT4)
OR ( ( Recinfo.OVERRIDE_USAGE_WEIGHT4 IS NULL )
AND ( p_OVERRIDE_USAGE_WEIGHT4 IS NULL )))
AND ( ( Recinfo.OVERRIDE_REC_RULE_ID = p_OVERRIDE_REC_RULE_ID)
OR ( ( Recinfo.OVERRIDE_REC_RULE_ID IS NULL )
AND ( p_OVERRIDE_REC_RULE_ID IS NULL )))
AND ( ( Recinfo.NODE_TYPE = p_NODE_TYPE)
OR ( ( Recinfo.NODE_TYPE IS NULL )
AND ( p_NODE_TYPE IS NULL )))
AND ( ( Recinfo.NODE_NAME = p_NODE_NAME)
OR ( ( Recinfo.NODE_NAME IS NULL )
AND ( p_NODE_NAME IS NULL )))
AND ( ( Recinfo.PARENT_NODE_ID = p_PARENT_NODE_ID)
OR ( ( Recinfo.PARENT_NODE_ID IS NULL )
AND ( p_PARENT_NODE_ID IS NULL )))
AND ( ( Recinfo.LEVEL_ID = p_LEVEL_ID)
OR ( ( Recinfo.LEVEL_ID IS NULL )
AND ( p_LEVEL_ID IS NULL )))
AND ( ( Recinfo.EXCESS_EDQ_FACTOR = p_EXCESS_EDQ_FACTOR)
OR ( ( Recinfo.EXCESS_EDQ_FACTOR IS NULL )
AND ( p_EXCESS_EDQ_FACTOR IS NULL )))
AND ( ( Recinfo.REPAIR_EDQ_FACTOR = p_REPAIR_EDQ_FACTOR)
OR ( ( Recinfo.REPAIR_EDQ_FACTOR IS NULL )
AND ( p_REPAIR_EDQ_FACTOR IS NULL )))
AND ( ( Recinfo.NEWBUY_EDQ_FACTOR = p_NEWBUY_EDQ_FACTOR)
OR ( ( Recinfo.NEWBUY_EDQ_FACTOR IS NULL )
AND ( p_NEWBUY_EDQ_FACTOR IS NULL )))
AND ( ( Recinfo.EXCESS_SERVICE_LEVEL = p_EXCESS_SERVICE_LEVEL)
OR ( ( Recinfo.EXCESS_SERVICE_LEVEL IS NULL )
AND ( p_EXCESS_SERVICE_LEVEL IS NULL )))
AND ( ( Recinfo.REPAIR_SERVICE_LEVEL = p_REPAIR_SERVICE_LEVEL)
OR ( ( Recinfo.REPAIR_SERVICE_LEVEL IS NULL )
AND ( p_REPAIR_SERVICE_LEVEL IS NULL )))
AND ( ( Recinfo.NEWBUY_SERVICE_LEVEL = p_NEWBUY_SERVICE_LEVEL)
OR ( ( Recinfo.NEWBUY_SERVICE_LEVEL IS NULL )
AND ( p_NEWBUY_SERVICE_LEVEL IS NULL )))
AND ( ( Recinfo.RESCHEDULE_RULE_ID = p_RESCHEDULE_RULE_ID)
OR ( ( Recinfo.RESCHEDULE_RULE_ID IS NULL )
AND ( p_RESCHEDULE_RULE_ID IS NULL )))
AND ( ( Recinfo.WRP_RULE_ID = p_WRP_RULE_ID)
OR ( ( Recinfo.WRP_RULE_ID IS NULL )
AND ( p_WRP_RULE_ID IS NULL )))
) then
return;