[Home] [Help]
120: p_PLANNING_PARAMETERS_ID Number;
121: CURSOR C2 IS SELECT CSP_PLANNING_PARAMETERS_S1.nextval FROM sys.dual;
122: BEGIN
123:
124: If (px_PLANNING_PARAMETERS_ID IS NULL) OR (px_PLANNING_PARAMETERS_ID = FND_API.G_MISS_NUM) then
125: OPEN C2;
126: FETCH C2 INTO p_PLANNING_PARAMETERS_ID;
127: CLOSE C2;
128: End If;
234: ,SPECIAL_INSTRUCTIONS
235: ,HZ_LOCATION_ID
236: ) VALUES (
237: nvl(px_PLANNING_PARAMETERS_ID,p_PLANNING_PARAMETERS_ID)
238: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
239: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
240: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
241: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
242: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
235: ,HZ_LOCATION_ID
236: ) VALUES (
237: nvl(px_PLANNING_PARAMETERS_ID,p_PLANNING_PARAMETERS_ID)
238: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
239: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
240: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
241: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
242: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
243: ,decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_RULE_ID)
236: ) VALUES (
237: nvl(px_PLANNING_PARAMETERS_ID,p_PLANNING_PARAMETERS_ID)
238: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
239: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
240: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
241: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
242: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
243: ,decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_RULE_ID)
244: ,decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ORGANIZATION_TYPE)
237: nvl(px_PLANNING_PARAMETERS_ID,p_PLANNING_PARAMETERS_ID)
238: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
239: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
240: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
241: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
242: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
243: ,decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_RULE_ID)
244: ,decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ORGANIZATION_TYPE)
245: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
238: ,decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY)
239: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
240: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
241: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
242: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
243: ,decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_RULE_ID)
244: ,decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ORGANIZATION_TYPE)
245: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
246: ,decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY)
239: ,decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE)
240: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
241: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
242: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
243: ,decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_RULE_ID)
244: ,decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ORGANIZATION_TYPE)
245: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
246: ,decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY)
247: ,decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, NULL, p_SERVICE_LEVEL)
240: ,decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY)
241: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
242: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
243: ,decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_RULE_ID)
244: ,decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ORGANIZATION_TYPE)
245: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
246: ,decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY)
247: ,decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, NULL, p_SERVICE_LEVEL)
248: ,decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, NULL, p_EDQ_FACTOR)
241: ,decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE)
242: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
243: ,decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_RULE_ID)
244: ,decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ORGANIZATION_TYPE)
245: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
246: ,decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY)
247: ,decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, NULL, p_SERVICE_LEVEL)
248: ,decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, NULL, p_EDQ_FACTOR)
249: ,decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE)
242: ,decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN)
243: ,decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_RULE_ID)
244: ,decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ORGANIZATION_TYPE)
245: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
246: ,decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY)
247: ,decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, NULL, p_SERVICE_LEVEL)
248: ,decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, NULL, p_EDQ_FACTOR)
249: ,decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE)
250: ,decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_CONDITION_TYPE)
243: ,decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_RULE_ID)
244: ,decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ORGANIZATION_TYPE)
245: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
246: ,decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY)
247: ,decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, NULL, p_SERVICE_LEVEL)
248: ,decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, NULL, p_EDQ_FACTOR)
249: ,decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE)
250: ,decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_CONDITION_TYPE)
251: ,decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_ASL_FLAG)
244: ,decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, NULL, p_ORGANIZATION_TYPE)
245: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
246: ,decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY)
247: ,decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, NULL, p_SERVICE_LEVEL)
248: ,decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, NULL, p_EDQ_FACTOR)
249: ,decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE)
250: ,decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_CONDITION_TYPE)
251: ,decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_ASL_FLAG)
252: ,decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_SAFETY_STOCK_FLAG)
245: ,decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, NULL, p_ORGANIZATION_ID)
246: ,decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY)
247: ,decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, NULL, p_SERVICE_LEVEL)
248: ,decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, NULL, p_EDQ_FACTOR)
249: ,decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE)
250: ,decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_CONDITION_TYPE)
251: ,decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_ASL_FLAG)
252: ,decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_SAFETY_STOCK_FLAG)
253: ,decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_EXCESS_RULE_ID)
246: ,decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, NULL, p_SECONDARY_INVENTORY)
247: ,decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, NULL, p_SERVICE_LEVEL)
248: ,decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, NULL, p_EDQ_FACTOR)
249: ,decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE)
250: ,decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_CONDITION_TYPE)
251: ,decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_ASL_FLAG)
252: ,decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_SAFETY_STOCK_FLAG)
253: ,decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_EXCESS_RULE_ID)
254: ,decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_NOTIFICATION_RULE_ID)
247: ,decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, NULL, p_SERVICE_LEVEL)
248: ,decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, NULL, p_EDQ_FACTOR)
249: ,decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE)
250: ,decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_CONDITION_TYPE)
251: ,decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_ASL_FLAG)
252: ,decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_SAFETY_STOCK_FLAG)
253: ,decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_EXCESS_RULE_ID)
254: ,decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_NOTIFICATION_RULE_ID)
255: ,decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_RECOMMENDATION_RULE_ID)
248: ,decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, NULL, p_EDQ_FACTOR)
249: ,decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE)
250: ,decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_CONDITION_TYPE)
251: ,decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_ASL_FLAG)
252: ,decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_SAFETY_STOCK_FLAG)
253: ,decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_EXCESS_RULE_ID)
254: ,decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_NOTIFICATION_RULE_ID)
255: ,decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_RECOMMENDATION_RULE_ID)
256: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
249: ,decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_PLANNER_CODE)
250: ,decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_CONDITION_TYPE)
251: ,decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_ASL_FLAG)
252: ,decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_SAFETY_STOCK_FLAG)
253: ,decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_EXCESS_RULE_ID)
254: ,decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_NOTIFICATION_RULE_ID)
255: ,decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_RECOMMENDATION_RULE_ID)
256: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
257: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
250: ,decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_CONDITION_TYPE)
251: ,decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_ASL_FLAG)
252: ,decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_SAFETY_STOCK_FLAG)
253: ,decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_EXCESS_RULE_ID)
254: ,decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_NOTIFICATION_RULE_ID)
255: ,decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_RECOMMENDATION_RULE_ID)
256: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
257: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
258: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
251: ,decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_ASL_FLAG)
252: ,decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_SAFETY_STOCK_FLAG)
253: ,decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_EXCESS_RULE_ID)
254: ,decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_NOTIFICATION_RULE_ID)
255: ,decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_RECOMMENDATION_RULE_ID)
256: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
257: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
258: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
259: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
252: ,decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_SAFETY_STOCK_FLAG)
253: ,decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_EXCESS_RULE_ID)
254: ,decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_NOTIFICATION_RULE_ID)
255: ,decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_RECOMMENDATION_RULE_ID)
256: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
257: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
258: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
259: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
260: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
253: ,decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, NULL, p_EXCESS_RULE_ID)
254: ,decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_NOTIFICATION_RULE_ID)
255: ,decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_RECOMMENDATION_RULE_ID)
256: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
257: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
258: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
259: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
260: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
261: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
254: ,decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_NOTIFICATION_RULE_ID)
255: ,decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_RECOMMENDATION_RULE_ID)
256: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
257: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
258: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
259: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
260: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
261: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
262: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
255: ,decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, NULL, p_RECOMMENDATION_RULE_ID)
256: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
257: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
258: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
259: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
260: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
261: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
262: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
263: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
256: ,decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY)
257: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
258: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
259: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
260: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
261: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
262: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
263: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
264: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
257: ,decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1)
258: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
259: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
260: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
261: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
262: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
263: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
264: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
265: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
258: ,decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2)
259: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
260: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
261: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
262: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
263: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
264: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
265: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
266: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
259: ,decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3)
260: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
261: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
262: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
263: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
264: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
265: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
266: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
267: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
260: ,decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4)
261: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
262: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
263: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
264: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
265: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
266: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
267: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
268: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
261: ,decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5)
262: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
263: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
264: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
265: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
266: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
267: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
268: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
269: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
262: ,decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6)
263: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
264: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
265: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
266: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
267: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
268: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
269: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
270: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
263: ,decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7)
264: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
265: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
266: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
267: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
268: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
269: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
270: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
271: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
264: ,decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8)
265: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
266: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
267: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
268: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
269: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
270: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
271: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
272: ,decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID)
265: ,decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9)
266: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
267: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
268: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
269: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
270: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
271: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
272: ,decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID)
273: ,decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID)
266: ,decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10)
267: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
268: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
269: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
270: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
271: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
272: ,decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID)
273: ,decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID)
274: ,decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_RECOMMEND_METHOD)
267: ,decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11)
268: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
269: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
270: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
271: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
272: ,decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID)
273: ,decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID)
274: ,decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_RECOMMEND_METHOD)
275: ,decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_EDQ_MULTIPLE)
268: ,decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12)
269: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
270: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
271: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
272: ,decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID)
273: ,decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID)
274: ,decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_RECOMMEND_METHOD)
275: ,decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_EDQ_MULTIPLE)
276: ,decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, NULL, p_MINIMUM_VALUE)
269: ,decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13)
270: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
271: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
272: ,decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID)
273: ,decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID)
274: ,decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_RECOMMEND_METHOD)
275: ,decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_EDQ_MULTIPLE)
276: ,decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, NULL, p_MINIMUM_VALUE)
277: ,decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_USABLE_ASSIGNMENT_SET_ID)
270: ,decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14)
271: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
272: ,decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID)
273: ,decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID)
274: ,decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_RECOMMEND_METHOD)
275: ,decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_EDQ_MULTIPLE)
276: ,decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, NULL, p_MINIMUM_VALUE)
277: ,decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_USABLE_ASSIGNMENT_SET_ID)
278: ,decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_DEFECTIVE_ASSIGNMENT_SET_ID)
271: ,decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
272: ,decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID)
273: ,decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID)
274: ,decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_RECOMMEND_METHOD)
275: ,decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_EDQ_MULTIPLE)
276: ,decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, NULL, p_MINIMUM_VALUE)
277: ,decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_USABLE_ASSIGNMENT_SET_ID)
278: ,decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_DEFECTIVE_ASSIGNMENT_SET_ID)
279: ,decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ASSIGNMENT_SET_ID)
272: ,decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_SET_ID)
273: ,decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID)
274: ,decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_RECOMMEND_METHOD)
275: ,decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_EDQ_MULTIPLE)
276: ,decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, NULL, p_MINIMUM_VALUE)
277: ,decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_USABLE_ASSIGNMENT_SET_ID)
278: ,decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_DEFECTIVE_ASSIGNMENT_SET_ID)
279: ,decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ASSIGNMENT_SET_ID)
280: ,decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, NULL, p_PRODUCT_NORM)
273: ,decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_CATEGORY_ID)
274: ,decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_RECOMMEND_METHOD)
275: ,decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_EDQ_MULTIPLE)
276: ,decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, NULL, p_MINIMUM_VALUE)
277: ,decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_USABLE_ASSIGNMENT_SET_ID)
278: ,decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_DEFECTIVE_ASSIGNMENT_SET_ID)
279: ,decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ASSIGNMENT_SET_ID)
280: ,decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, NULL, p_PRODUCT_NORM)
281: ,decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_NORM_NODE_ID)
274: ,decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_RECOMMEND_METHOD)
275: ,decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_EDQ_MULTIPLE)
276: ,decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, NULL, p_MINIMUM_VALUE)
277: ,decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_USABLE_ASSIGNMENT_SET_ID)
278: ,decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_DEFECTIVE_ASSIGNMENT_SET_ID)
279: ,decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ASSIGNMENT_SET_ID)
280: ,decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, NULL, p_PRODUCT_NORM)
281: ,decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_NORM_NODE_ID)
282: ,decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT1)
275: ,decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, NULL, p_EDQ_MULTIPLE)
276: ,decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, NULL, p_MINIMUM_VALUE)
277: ,decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_USABLE_ASSIGNMENT_SET_ID)
278: ,decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_DEFECTIVE_ASSIGNMENT_SET_ID)
279: ,decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ASSIGNMENT_SET_ID)
280: ,decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, NULL, p_PRODUCT_NORM)
281: ,decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_NORM_NODE_ID)
282: ,decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT1)
283: ,decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT2)
276: ,decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, NULL, p_MINIMUM_VALUE)
277: ,decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_USABLE_ASSIGNMENT_SET_ID)
278: ,decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_DEFECTIVE_ASSIGNMENT_SET_ID)
279: ,decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ASSIGNMENT_SET_ID)
280: ,decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, NULL, p_PRODUCT_NORM)
281: ,decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_NORM_NODE_ID)
282: ,decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT1)
283: ,decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT2)
284: ,decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT3)
277: ,decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_USABLE_ASSIGNMENT_SET_ID)
278: ,decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_DEFECTIVE_ASSIGNMENT_SET_ID)
279: ,decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ASSIGNMENT_SET_ID)
280: ,decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, NULL, p_PRODUCT_NORM)
281: ,decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_NORM_NODE_ID)
282: ,decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT1)
283: ,decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT2)
284: ,decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT3)
285: ,decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT4)
278: ,decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_DEFECTIVE_ASSIGNMENT_SET_ID)
279: ,decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ASSIGNMENT_SET_ID)
280: ,decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, NULL, p_PRODUCT_NORM)
281: ,decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_NORM_NODE_ID)
282: ,decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT1)
283: ,decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT2)
284: ,decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT3)
285: ,decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT4)
286: ,decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FORECAST_RULE_ID)
279: ,decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, NULL, p_REPAIR_ASSIGNMENT_SET_ID)
280: ,decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, NULL, p_PRODUCT_NORM)
281: ,decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_NORM_NODE_ID)
282: ,decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT1)
283: ,decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT2)
284: ,decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT3)
285: ,decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT4)
286: ,decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FORECAST_RULE_ID)
287: ,decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SERVICE_LEVEL)
280: ,decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, NULL, p_PRODUCT_NORM)
281: ,decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_NORM_NODE_ID)
282: ,decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT1)
283: ,decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT2)
284: ,decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT3)
285: ,decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT4)
286: ,decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FORECAST_RULE_ID)
287: ,decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SERVICE_LEVEL)
288: ,decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EDQ_FACTOR)
281: ,decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PRODUCT_NORM_NODE_ID)
282: ,decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT1)
283: ,decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT2)
284: ,decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT3)
285: ,decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT4)
286: ,decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FORECAST_RULE_ID)
287: ,decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SERVICE_LEVEL)
288: ,decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EDQ_FACTOR)
289: ,decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PLANNER_CODE)
282: ,decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT1)
283: ,decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT2)
284: ,decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT3)
285: ,decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT4)
286: ,decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FORECAST_RULE_ID)
287: ,decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SERVICE_LEVEL)
288: ,decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EDQ_FACTOR)
289: ,decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PLANNER_CODE)
290: ,decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CONDITION_TYPE)
283: ,decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT2)
284: ,decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT3)
285: ,decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT4)
286: ,decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FORECAST_RULE_ID)
287: ,decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SERVICE_LEVEL)
288: ,decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EDQ_FACTOR)
289: ,decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PLANNER_CODE)
290: ,decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CONDITION_TYPE)
291: ,decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_ASL_FLAG)
284: ,decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT3)
285: ,decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT4)
286: ,decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FORECAST_RULE_ID)
287: ,decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SERVICE_LEVEL)
288: ,decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EDQ_FACTOR)
289: ,decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PLANNER_CODE)
290: ,decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CONDITION_TYPE)
291: ,decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_ASL_FLAG)
292: ,decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SAFETY_STOCK_FLAG)
285: ,decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, NULL, p_USAGE_WEIGHT4)
286: ,decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FORECAST_RULE_ID)
287: ,decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SERVICE_LEVEL)
288: ,decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EDQ_FACTOR)
289: ,decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PLANNER_CODE)
290: ,decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CONDITION_TYPE)
291: ,decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_ASL_FLAG)
292: ,decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SAFETY_STOCK_FLAG)
293: ,decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EXCESS_RULE_ID)
286: ,decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_FORECAST_RULE_ID)
287: ,decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SERVICE_LEVEL)
288: ,decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EDQ_FACTOR)
289: ,decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PLANNER_CODE)
290: ,decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CONDITION_TYPE)
291: ,decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_ASL_FLAG)
292: ,decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SAFETY_STOCK_FLAG)
293: ,decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EXCESS_RULE_ID)
294: ,decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_SET_ID)
287: ,decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SERVICE_LEVEL)
288: ,decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EDQ_FACTOR)
289: ,decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PLANNER_CODE)
290: ,decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CONDITION_TYPE)
291: ,decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_ASL_FLAG)
292: ,decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SAFETY_STOCK_FLAG)
293: ,decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EXCESS_RULE_ID)
294: ,decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_SET_ID)
295: ,decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_ID)
288: ,decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EDQ_FACTOR)
289: ,decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PLANNER_CODE)
290: ,decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CONDITION_TYPE)
291: ,decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_ASL_FLAG)
292: ,decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SAFETY_STOCK_FLAG)
293: ,decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EXCESS_RULE_ID)
294: ,decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_SET_ID)
295: ,decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_ID)
296: ,decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_RECOMMEND_METHOD)
289: ,decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PLANNER_CODE)
290: ,decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CONDITION_TYPE)
291: ,decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_ASL_FLAG)
292: ,decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SAFETY_STOCK_FLAG)
293: ,decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EXCESS_RULE_ID)
294: ,decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_SET_ID)
295: ,decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_ID)
296: ,decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_RECOMMEND_METHOD)
297: ,decode( p_DEFAULT_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PRODUCT_NORM_NODE_ID)
290: ,decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CONDITION_TYPE)
291: ,decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_ASL_FLAG)
292: ,decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SAFETY_STOCK_FLAG)
293: ,decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EXCESS_RULE_ID)
294: ,decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_SET_ID)
295: ,decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_ID)
296: ,decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_RECOMMEND_METHOD)
297: ,decode( p_DEFAULT_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PRODUCT_NORM_NODE_ID)
298: ,decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT1)
291: ,decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_ASL_FLAG)
292: ,decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SAFETY_STOCK_FLAG)
293: ,decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EXCESS_RULE_ID)
294: ,decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_SET_ID)
295: ,decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_ID)
296: ,decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_RECOMMEND_METHOD)
297: ,decode( p_DEFAULT_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PRODUCT_NORM_NODE_ID)
298: ,decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT1)
299: ,decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT2)
292: ,decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_SAFETY_STOCK_FLAG)
293: ,decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EXCESS_RULE_ID)
294: ,decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_SET_ID)
295: ,decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_ID)
296: ,decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_RECOMMEND_METHOD)
297: ,decode( p_DEFAULT_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PRODUCT_NORM_NODE_ID)
298: ,decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT1)
299: ,decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT2)
300: ,decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT3)
293: ,decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_EXCESS_RULE_ID)
294: ,decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_SET_ID)
295: ,decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_ID)
296: ,decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_RECOMMEND_METHOD)
297: ,decode( p_DEFAULT_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PRODUCT_NORM_NODE_ID)
298: ,decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT1)
299: ,decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT2)
300: ,decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT3)
301: ,decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT4)
294: ,decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_SET_ID)
295: ,decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_ID)
296: ,decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_RECOMMEND_METHOD)
297: ,decode( p_DEFAULT_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PRODUCT_NORM_NODE_ID)
298: ,decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT1)
299: ,decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT2)
300: ,decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT3)
301: ,decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT4)
302: ,decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_REC_RULE_ID)
295: ,decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_CATEGORY_ID)
296: ,decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_RECOMMEND_METHOD)
297: ,decode( p_DEFAULT_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PRODUCT_NORM_NODE_ID)
298: ,decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT1)
299: ,decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT2)
300: ,decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT3)
301: ,decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT4)
302: ,decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_REC_RULE_ID)
303: ,decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_FORECAST_RULE_ID)
296: ,decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_RECOMMEND_METHOD)
297: ,decode( p_DEFAULT_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PRODUCT_NORM_NODE_ID)
298: ,decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT1)
299: ,decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT2)
300: ,decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT3)
301: ,decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT4)
302: ,decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_REC_RULE_ID)
303: ,decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_FORECAST_RULE_ID)
304: ,decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SERVICE_LEVEL)
297: ,decode( p_DEFAULT_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_PRODUCT_NORM_NODE_ID)
298: ,decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT1)
299: ,decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT2)
300: ,decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT3)
301: ,decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT4)
302: ,decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_REC_RULE_ID)
303: ,decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_FORECAST_RULE_ID)
304: ,decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SERVICE_LEVEL)
305: ,decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EDQ_FACTOR)
298: ,decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT1)
299: ,decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT2)
300: ,decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT3)
301: ,decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT4)
302: ,decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_REC_RULE_ID)
303: ,decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_FORECAST_RULE_ID)
304: ,decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SERVICE_LEVEL)
305: ,decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EDQ_FACTOR)
306: ,decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_PLANNER_CODE)
299: ,decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT2)
300: ,decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT3)
301: ,decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT4)
302: ,decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_REC_RULE_ID)
303: ,decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_FORECAST_RULE_ID)
304: ,decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SERVICE_LEVEL)
305: ,decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EDQ_FACTOR)
306: ,decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_PLANNER_CODE)
307: ,decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CONDITION_TYPE)
300: ,decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT3)
301: ,decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT4)
302: ,decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_REC_RULE_ID)
303: ,decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_FORECAST_RULE_ID)
304: ,decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SERVICE_LEVEL)
305: ,decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EDQ_FACTOR)
306: ,decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_PLANNER_CODE)
307: ,decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CONDITION_TYPE)
308: ,decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_ASL_FLAG)
301: ,decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_USAGE_WEIGHT4)
302: ,decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_REC_RULE_ID)
303: ,decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_FORECAST_RULE_ID)
304: ,decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SERVICE_LEVEL)
305: ,decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EDQ_FACTOR)
306: ,decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_PLANNER_CODE)
307: ,decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CONDITION_TYPE)
308: ,decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_ASL_FLAG)
309: ,decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SAFETY_STOCK_FLAG)
302: ,decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_DEFAULT_REC_RULE_ID)
303: ,decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_FORECAST_RULE_ID)
304: ,decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SERVICE_LEVEL)
305: ,decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EDQ_FACTOR)
306: ,decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_PLANNER_CODE)
307: ,decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CONDITION_TYPE)
308: ,decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_ASL_FLAG)
309: ,decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SAFETY_STOCK_FLAG)
310: ,decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EXCESS_RULE_ID)
303: ,decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_FORECAST_RULE_ID)
304: ,decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SERVICE_LEVEL)
305: ,decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EDQ_FACTOR)
306: ,decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_PLANNER_CODE)
307: ,decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CONDITION_TYPE)
308: ,decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_ASL_FLAG)
309: ,decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SAFETY_STOCK_FLAG)
310: ,decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EXCESS_RULE_ID)
311: ,decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_SET_ID)
304: ,decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SERVICE_LEVEL)
305: ,decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EDQ_FACTOR)
306: ,decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_PLANNER_CODE)
307: ,decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CONDITION_TYPE)
308: ,decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_ASL_FLAG)
309: ,decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SAFETY_STOCK_FLAG)
310: ,decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EXCESS_RULE_ID)
311: ,decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_SET_ID)
312: ,decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_ID)
305: ,decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EDQ_FACTOR)
306: ,decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_PLANNER_CODE)
307: ,decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CONDITION_TYPE)
308: ,decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_ASL_FLAG)
309: ,decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SAFETY_STOCK_FLAG)
310: ,decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EXCESS_RULE_ID)
311: ,decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_SET_ID)
312: ,decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_ID)
313: ,decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_RECOMMEND_METHOD)
306: ,decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_PLANNER_CODE)
307: ,decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CONDITION_TYPE)
308: ,decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_ASL_FLAG)
309: ,decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SAFETY_STOCK_FLAG)
310: ,decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EXCESS_RULE_ID)
311: ,decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_SET_ID)
312: ,decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_ID)
313: ,decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_RECOMMEND_METHOD)
314: ,decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT1)
307: ,decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CONDITION_TYPE)
308: ,decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_ASL_FLAG)
309: ,decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SAFETY_STOCK_FLAG)
310: ,decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EXCESS_RULE_ID)
311: ,decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_SET_ID)
312: ,decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_ID)
313: ,decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_RECOMMEND_METHOD)
314: ,decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT1)
315: ,decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT2)
308: ,decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_ASL_FLAG)
309: ,decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SAFETY_STOCK_FLAG)
310: ,decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EXCESS_RULE_ID)
311: ,decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_SET_ID)
312: ,decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_ID)
313: ,decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_RECOMMEND_METHOD)
314: ,decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT1)
315: ,decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT2)
316: ,decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT3)
309: ,decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_SAFETY_STOCK_FLAG)
310: ,decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EXCESS_RULE_ID)
311: ,decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_SET_ID)
312: ,decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_ID)
313: ,decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_RECOMMEND_METHOD)
314: ,decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT1)
315: ,decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT2)
316: ,decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT3)
317: ,decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT4)
310: ,decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_EXCESS_RULE_ID)
311: ,decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_SET_ID)
312: ,decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_ID)
313: ,decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_RECOMMEND_METHOD)
314: ,decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT1)
315: ,decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT2)
316: ,decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT3)
317: ,decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT4)
318: ,decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_REC_RULE_ID)
311: ,decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_SET_ID)
312: ,decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_ID)
313: ,decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_RECOMMEND_METHOD)
314: ,decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT1)
315: ,decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT2)
316: ,decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT3)
317: ,decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT4)
318: ,decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_REC_RULE_ID)
319: ,decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NODE_TYPE)
312: ,decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_CATEGORY_ID)
313: ,decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_RECOMMEND_METHOD)
314: ,decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT1)
315: ,decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT2)
316: ,decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT3)
317: ,decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT4)
318: ,decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_REC_RULE_ID)
319: ,decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NODE_TYPE)
320: ,decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NULL, p_NODE_NAME)
313: ,decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_RECOMMEND_METHOD)
314: ,decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT1)
315: ,decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT2)
316: ,decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT3)
317: ,decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT4)
318: ,decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_REC_RULE_ID)
319: ,decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NODE_TYPE)
320: ,decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NULL, p_NODE_NAME)
321: ,decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_NODE_ID)
314: ,decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT1)
315: ,decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT2)
316: ,decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT3)
317: ,decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT4)
318: ,decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_REC_RULE_ID)
319: ,decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NODE_TYPE)
320: ,decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NULL, p_NODE_NAME)
321: ,decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_NODE_ID)
322: ,decode( p_LEVEL_ID, FND_API.G_MISS_CHAR, NULL, p_LEVEL_ID)
315: ,decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT2)
316: ,decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT3)
317: ,decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT4)
318: ,decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_REC_RULE_ID)
319: ,decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NODE_TYPE)
320: ,decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NULL, p_NODE_NAME)
321: ,decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_NODE_ID)
322: ,decode( p_LEVEL_ID, FND_API.G_MISS_CHAR, NULL, p_LEVEL_ID)
323: ,decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_EXCESS_EDQ_FACTOR)
316: ,decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT3)
317: ,decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT4)
318: ,decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_REC_RULE_ID)
319: ,decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NODE_TYPE)
320: ,decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NULL, p_NODE_NAME)
321: ,decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_NODE_ID)
322: ,decode( p_LEVEL_ID, FND_API.G_MISS_CHAR, NULL, p_LEVEL_ID)
323: ,decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_EXCESS_EDQ_FACTOR)
324: ,decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_REPAIR_EDQ_FACTOR)
317: ,decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_USAGE_WEIGHT4)
318: ,decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_REC_RULE_ID)
319: ,decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NODE_TYPE)
320: ,decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NULL, p_NODE_NAME)
321: ,decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_NODE_ID)
322: ,decode( p_LEVEL_ID, FND_API.G_MISS_CHAR, NULL, p_LEVEL_ID)
323: ,decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_EXCESS_EDQ_FACTOR)
324: ,decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_REPAIR_EDQ_FACTOR)
325: ,decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_EDQ_FACTOR)
318: ,decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_OVERRIDE_REC_RULE_ID)
319: ,decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NODE_TYPE)
320: ,decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NULL, p_NODE_NAME)
321: ,decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_NODE_ID)
322: ,decode( p_LEVEL_ID, FND_API.G_MISS_CHAR, NULL, p_LEVEL_ID)
323: ,decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_EXCESS_EDQ_FACTOR)
324: ,decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_REPAIR_EDQ_FACTOR)
325: ,decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_EDQ_FACTOR)
326: ,decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_EXCESS_SERVICE_LEVEL)
319: ,decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NULL, p_NODE_TYPE)
320: ,decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NULL, p_NODE_NAME)
321: ,decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_NODE_ID)
322: ,decode( p_LEVEL_ID, FND_API.G_MISS_CHAR, NULL, p_LEVEL_ID)
323: ,decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_EXCESS_EDQ_FACTOR)
324: ,decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_REPAIR_EDQ_FACTOR)
325: ,decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_EDQ_FACTOR)
326: ,decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_EXCESS_SERVICE_LEVEL)
327: ,decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_REPAIR_SERVICE_LEVEL)
320: ,decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NULL, p_NODE_NAME)
321: ,decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_NODE_ID)
322: ,decode( p_LEVEL_ID, FND_API.G_MISS_CHAR, NULL, p_LEVEL_ID)
323: ,decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_EXCESS_EDQ_FACTOR)
324: ,decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_REPAIR_EDQ_FACTOR)
325: ,decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_EDQ_FACTOR)
326: ,decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_EXCESS_SERVICE_LEVEL)
327: ,decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_REPAIR_SERVICE_LEVEL)
328: ,decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_SERVICE_LEVEL)
321: ,decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, NULL, p_PARENT_NODE_ID)
322: ,decode( p_LEVEL_ID, FND_API.G_MISS_CHAR, NULL, p_LEVEL_ID)
323: ,decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_EXCESS_EDQ_FACTOR)
324: ,decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_REPAIR_EDQ_FACTOR)
325: ,decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_EDQ_FACTOR)
326: ,decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_EXCESS_SERVICE_LEVEL)
327: ,decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_REPAIR_SERVICE_LEVEL)
328: ,decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_SERVICE_LEVEL)
329: ,decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_RESCHEDULE_RULE_ID)
322: ,decode( p_LEVEL_ID, FND_API.G_MISS_CHAR, NULL, p_LEVEL_ID)
323: ,decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_EXCESS_EDQ_FACTOR)
324: ,decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_REPAIR_EDQ_FACTOR)
325: ,decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_EDQ_FACTOR)
326: ,decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_EXCESS_SERVICE_LEVEL)
327: ,decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_REPAIR_SERVICE_LEVEL)
328: ,decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_SERVICE_LEVEL)
329: ,decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_RESCHEDULE_RULE_ID)
330: ,decode( p_WRP_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_WRP_RULE_ID)
323: ,decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_EXCESS_EDQ_FACTOR)
324: ,decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_REPAIR_EDQ_FACTOR)
325: ,decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_EDQ_FACTOR)
326: ,decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_EXCESS_SERVICE_LEVEL)
327: ,decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_REPAIR_SERVICE_LEVEL)
328: ,decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_SERVICE_LEVEL)
329: ,decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_RESCHEDULE_RULE_ID)
330: ,decode( p_WRP_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_WRP_RULE_ID)
331: ,decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_TYPE)
324: ,decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_REPAIR_EDQ_FACTOR)
325: ,decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_EDQ_FACTOR)
326: ,decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_EXCESS_SERVICE_LEVEL)
327: ,decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_REPAIR_SERVICE_LEVEL)
328: ,decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_SERVICE_LEVEL)
329: ,decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_RESCHEDULE_RULE_ID)
330: ,decode( p_WRP_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_WRP_RULE_ID)
331: ,decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_TYPE)
332: ,decode( P_CALENDAR_ID, FND_API.G_MISS_NUM, NULL,P_CALENDAR_ID)
325: ,decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_EDQ_FACTOR)
326: ,decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_EXCESS_SERVICE_LEVEL)
327: ,decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_REPAIR_SERVICE_LEVEL)
328: ,decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_SERVICE_LEVEL)
329: ,decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_RESCHEDULE_RULE_ID)
330: ,decode( p_WRP_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_WRP_RULE_ID)
331: ,decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_TYPE)
332: ,decode( P_CALENDAR_ID, FND_API.G_MISS_NUM, NULL,P_CALENDAR_ID)
333: ,decode( P_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,P_TIMEZONE_ID)
326: ,decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_EXCESS_SERVICE_LEVEL)
327: ,decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_REPAIR_SERVICE_LEVEL)
328: ,decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_SERVICE_LEVEL)
329: ,decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_RESCHEDULE_RULE_ID)
330: ,decode( p_WRP_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_WRP_RULE_ID)
331: ,decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_TYPE)
332: ,decode( P_CALENDAR_ID, FND_API.G_MISS_NUM, NULL,P_CALENDAR_ID)
333: ,decode( P_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,P_TIMEZONE_ID)
334: ,decode( P_MANAGED_BY, FND_API.G_MISS_CHAR, NULL,P_MANAGED_BY)
327: ,decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_REPAIR_SERVICE_LEVEL)
328: ,decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_SERVICE_LEVEL)
329: ,decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_RESCHEDULE_RULE_ID)
330: ,decode( p_WRP_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_WRP_RULE_ID)
331: ,decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_TYPE)
332: ,decode( P_CALENDAR_ID, FND_API.G_MISS_NUM, NULL,P_CALENDAR_ID)
333: ,decode( P_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,P_TIMEZONE_ID)
334: ,decode( P_MANAGED_BY, FND_API.G_MISS_CHAR, NULL,P_MANAGED_BY)
335: ,decode( P_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_CONTACT_NAME)
328: ,decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NULL, p_NEWBUY_SERVICE_LEVEL)
329: ,decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_RESCHEDULE_RULE_ID)
330: ,decode( p_WRP_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_WRP_RULE_ID)
331: ,decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_TYPE)
332: ,decode( P_CALENDAR_ID, FND_API.G_MISS_NUM, NULL,P_CALENDAR_ID)
333: ,decode( P_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,P_TIMEZONE_ID)
334: ,decode( P_MANAGED_BY, FND_API.G_MISS_CHAR, NULL,P_MANAGED_BY)
335: ,decode( P_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_CONTACT_NAME)
336: ,decode( P_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_CONTACT_PHONE)
329: ,decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_RESCHEDULE_RULE_ID)
330: ,decode( p_WRP_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_WRP_RULE_ID)
331: ,decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_TYPE)
332: ,decode( P_CALENDAR_ID, FND_API.G_MISS_NUM, NULL,P_CALENDAR_ID)
333: ,decode( P_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,P_TIMEZONE_ID)
334: ,decode( P_MANAGED_BY, FND_API.G_MISS_CHAR, NULL,P_MANAGED_BY)
335: ,decode( P_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_CONTACT_NAME)
336: ,decode( P_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_CONTACT_PHONE)
337: ,decode( P_AH_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_NAME)
330: ,decode( p_WRP_RULE_ID, FND_API.G_MISS_CHAR, NULL, p_WRP_RULE_ID)
331: ,decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_TYPE)
332: ,decode( P_CALENDAR_ID, FND_API.G_MISS_NUM, NULL,P_CALENDAR_ID)
333: ,decode( P_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,P_TIMEZONE_ID)
334: ,decode( P_MANAGED_BY, FND_API.G_MISS_CHAR, NULL,P_MANAGED_BY)
335: ,decode( P_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_CONTACT_NAME)
336: ,decode( P_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_CONTACT_PHONE)
337: ,decode( P_AH_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_NAME)
338: ,decode( P_AH_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_PHONE)
331: ,decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_TYPE)
332: ,decode( P_CALENDAR_ID, FND_API.G_MISS_NUM, NULL,P_CALENDAR_ID)
333: ,decode( P_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,P_TIMEZONE_ID)
334: ,decode( P_MANAGED_BY, FND_API.G_MISS_CHAR, NULL,P_MANAGED_BY)
335: ,decode( P_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_CONTACT_NAME)
336: ,decode( P_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_CONTACT_PHONE)
337: ,decode( P_AH_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_NAME)
338: ,decode( P_AH_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_PHONE)
339: ,decode( P_STOCKING_SITE_EXCL, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_EXCL)
332: ,decode( P_CALENDAR_ID, FND_API.G_MISS_NUM, NULL,P_CALENDAR_ID)
333: ,decode( P_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,P_TIMEZONE_ID)
334: ,decode( P_MANAGED_BY, FND_API.G_MISS_CHAR, NULL,P_MANAGED_BY)
335: ,decode( P_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_CONTACT_NAME)
336: ,decode( P_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_CONTACT_PHONE)
337: ,decode( P_AH_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_NAME)
338: ,decode( P_AH_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_PHONE)
339: ,decode( P_STOCKING_SITE_EXCL, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_EXCL)
340: ,decode( P_SPECIAL_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL,P_SPECIAL_INSTRUCTIONS)
333: ,decode( P_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL,P_TIMEZONE_ID)
334: ,decode( P_MANAGED_BY, FND_API.G_MISS_CHAR, NULL,P_MANAGED_BY)
335: ,decode( P_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_CONTACT_NAME)
336: ,decode( P_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_CONTACT_PHONE)
337: ,decode( P_AH_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_NAME)
338: ,decode( P_AH_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_PHONE)
339: ,decode( P_STOCKING_SITE_EXCL, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_EXCL)
340: ,decode( P_SPECIAL_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL,P_SPECIAL_INSTRUCTIONS)
341: ,decode( P_HZ_LOCATION_ID, FND_API.G_MISS_NUM, NULL,P_HZ_LOCATION_ID)
334: ,decode( P_MANAGED_BY, FND_API.G_MISS_CHAR, NULL,P_MANAGED_BY)
335: ,decode( P_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_CONTACT_NAME)
336: ,decode( P_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_CONTACT_PHONE)
337: ,decode( P_AH_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_NAME)
338: ,decode( P_AH_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_PHONE)
339: ,decode( P_STOCKING_SITE_EXCL, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_EXCL)
340: ,decode( P_SPECIAL_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL,P_SPECIAL_INSTRUCTIONS)
341: ,decode( P_HZ_LOCATION_ID, FND_API.G_MISS_NUM, NULL,P_HZ_LOCATION_ID)
342: );
335: ,decode( P_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_CONTACT_NAME)
336: ,decode( P_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_CONTACT_PHONE)
337: ,decode( P_AH_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_NAME)
338: ,decode( P_AH_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_PHONE)
339: ,decode( P_STOCKING_SITE_EXCL, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_EXCL)
340: ,decode( P_SPECIAL_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL,P_SPECIAL_INSTRUCTIONS)
341: ,decode( P_HZ_LOCATION_ID, FND_API.G_MISS_NUM, NULL,P_HZ_LOCATION_ID)
342: );
343: End Insert_Row;
336: ,decode( P_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_CONTACT_PHONE)
337: ,decode( P_AH_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_NAME)
338: ,decode( P_AH_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_PHONE)
339: ,decode( P_STOCKING_SITE_EXCL, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_EXCL)
340: ,decode( P_SPECIAL_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL,P_SPECIAL_INSTRUCTIONS)
341: ,decode( P_HZ_LOCATION_ID, FND_API.G_MISS_NUM, NULL,P_HZ_LOCATION_ID)
342: );
343: End Insert_Row;
344:
337: ,decode( P_AH_CONTACT_NAME, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_NAME)
338: ,decode( P_AH_CONTACT_PHONE, FND_API.G_MISS_CHAR, NULL,P_AH_CONTACT_PHONE)
339: ,decode( P_STOCKING_SITE_EXCL, FND_API.G_MISS_CHAR, NULL,P_STOCKING_SITE_EXCL)
340: ,decode( P_SPECIAL_INSTRUCTIONS, FND_API.G_MISS_CHAR, NULL,P_SPECIAL_INSTRUCTIONS)
341: ,decode( P_HZ_LOCATION_ID, FND_API.G_MISS_NUM, NULL,P_HZ_LOCATION_ID)
342: );
343: End Insert_Row;
344:
345: PROCEDURE Update_Row(
452: IS
453: BEGIN
454: Update CSP_PLANNING_PARAMETERS
455: SET
456: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
457: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
458: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
459: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
460: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
453: BEGIN
454: Update CSP_PLANNING_PARAMETERS
455: SET
456: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
457: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
458: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
459: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
460: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
461: ,FORECAST_RULE_ID = decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, FORECAST_RULE_ID, p_FORECAST_RULE_ID)
454: Update CSP_PLANNING_PARAMETERS
455: SET
456: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
457: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
458: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
459: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
460: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
461: ,FORECAST_RULE_ID = decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, FORECAST_RULE_ID, p_FORECAST_RULE_ID)
462: ,ORGANIZATION_TYPE = decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, ORGANIZATION_TYPE, p_ORGANIZATION_TYPE)
455: SET
456: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
457: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
458: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
459: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
460: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
461: ,FORECAST_RULE_ID = decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, FORECAST_RULE_ID, p_FORECAST_RULE_ID)
462: ,ORGANIZATION_TYPE = decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, ORGANIZATION_TYPE, p_ORGANIZATION_TYPE)
463: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
456: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY)
457: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
458: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
459: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
460: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
461: ,FORECAST_RULE_ID = decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, FORECAST_RULE_ID, p_FORECAST_RULE_ID)
462: ,ORGANIZATION_TYPE = decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, ORGANIZATION_TYPE, p_ORGANIZATION_TYPE)
463: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
464: ,SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY)
457: ,CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE)
458: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
459: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
460: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
461: ,FORECAST_RULE_ID = decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, FORECAST_RULE_ID, p_FORECAST_RULE_ID)
462: ,ORGANIZATION_TYPE = decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, ORGANIZATION_TYPE, p_ORGANIZATION_TYPE)
463: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
464: ,SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY)
465: ,SERVICE_LEVEL = decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, SERVICE_LEVEL, p_SERVICE_LEVEL)
458: ,LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY)
459: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
460: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
461: ,FORECAST_RULE_ID = decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, FORECAST_RULE_ID, p_FORECAST_RULE_ID)
462: ,ORGANIZATION_TYPE = decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, ORGANIZATION_TYPE, p_ORGANIZATION_TYPE)
463: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
464: ,SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY)
465: ,SERVICE_LEVEL = decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, SERVICE_LEVEL, p_SERVICE_LEVEL)
466: ,EDQ_FACTOR = decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, EDQ_FACTOR, p_EDQ_FACTOR)
459: ,LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE)
460: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
461: ,FORECAST_RULE_ID = decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, FORECAST_RULE_ID, p_FORECAST_RULE_ID)
462: ,ORGANIZATION_TYPE = decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, ORGANIZATION_TYPE, p_ORGANIZATION_TYPE)
463: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
464: ,SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY)
465: ,SERVICE_LEVEL = decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, SERVICE_LEVEL, p_SERVICE_LEVEL)
466: ,EDQ_FACTOR = decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, EDQ_FACTOR, p_EDQ_FACTOR)
467: ,PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE)
460: ,LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN)
461: ,FORECAST_RULE_ID = decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, FORECAST_RULE_ID, p_FORECAST_RULE_ID)
462: ,ORGANIZATION_TYPE = decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, ORGANIZATION_TYPE, p_ORGANIZATION_TYPE)
463: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
464: ,SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY)
465: ,SERVICE_LEVEL = decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, SERVICE_LEVEL, p_SERVICE_LEVEL)
466: ,EDQ_FACTOR = decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, EDQ_FACTOR, p_EDQ_FACTOR)
467: ,PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE)
468: ,CONDITION_TYPE = decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, CONDITION_TYPE, p_CONDITION_TYPE)
461: ,FORECAST_RULE_ID = decode( p_FORECAST_RULE_ID, FND_API.G_MISS_NUM, FORECAST_RULE_ID, p_FORECAST_RULE_ID)
462: ,ORGANIZATION_TYPE = decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, ORGANIZATION_TYPE, p_ORGANIZATION_TYPE)
463: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
464: ,SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY)
465: ,SERVICE_LEVEL = decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, SERVICE_LEVEL, p_SERVICE_LEVEL)
466: ,EDQ_FACTOR = decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, EDQ_FACTOR, p_EDQ_FACTOR)
467: ,PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE)
468: ,CONDITION_TYPE = decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, CONDITION_TYPE, p_CONDITION_TYPE)
469: ,ASL_FLAG = decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, ASL_FLAG, p_ASL_FLAG)
462: ,ORGANIZATION_TYPE = decode( p_ORGANIZATION_TYPE, FND_API.G_MISS_CHAR, ORGANIZATION_TYPE, p_ORGANIZATION_TYPE)
463: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
464: ,SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY)
465: ,SERVICE_LEVEL = decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, SERVICE_LEVEL, p_SERVICE_LEVEL)
466: ,EDQ_FACTOR = decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, EDQ_FACTOR, p_EDQ_FACTOR)
467: ,PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE)
468: ,CONDITION_TYPE = decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, CONDITION_TYPE, p_CONDITION_TYPE)
469: ,ASL_FLAG = decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, ASL_FLAG, p_ASL_FLAG)
470: ,SAFETY_STOCK_FLAG = decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, SAFETY_STOCK_FLAG, p_SAFETY_STOCK_FLAG)
463: ,ORGANIZATION_ID = decode( p_ORGANIZATION_ID, FND_API.G_MISS_NUM, ORGANIZATION_ID, p_ORGANIZATION_ID)
464: ,SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY)
465: ,SERVICE_LEVEL = decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, SERVICE_LEVEL, p_SERVICE_LEVEL)
466: ,EDQ_FACTOR = decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, EDQ_FACTOR, p_EDQ_FACTOR)
467: ,PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE)
468: ,CONDITION_TYPE = decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, CONDITION_TYPE, p_CONDITION_TYPE)
469: ,ASL_FLAG = decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, ASL_FLAG, p_ASL_FLAG)
470: ,SAFETY_STOCK_FLAG = decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, SAFETY_STOCK_FLAG, p_SAFETY_STOCK_FLAG)
471: ,EXCESS_RULE_ID = decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, EXCESS_RULE_ID, p_EXCESS_RULE_ID)
464: ,SECONDARY_INVENTORY = decode( p_SECONDARY_INVENTORY, FND_API.G_MISS_CHAR, SECONDARY_INVENTORY, p_SECONDARY_INVENTORY)
465: ,SERVICE_LEVEL = decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, SERVICE_LEVEL, p_SERVICE_LEVEL)
466: ,EDQ_FACTOR = decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, EDQ_FACTOR, p_EDQ_FACTOR)
467: ,PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE)
468: ,CONDITION_TYPE = decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, CONDITION_TYPE, p_CONDITION_TYPE)
469: ,ASL_FLAG = decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, ASL_FLAG, p_ASL_FLAG)
470: ,SAFETY_STOCK_FLAG = decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, SAFETY_STOCK_FLAG, p_SAFETY_STOCK_FLAG)
471: ,EXCESS_RULE_ID = decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, EXCESS_RULE_ID, p_EXCESS_RULE_ID)
472: ,NOTIFICATION_RULE_ID = decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NOTIFICATION_RULE_ID, p_NOTIFICATION_RULE_ID)
465: ,SERVICE_LEVEL = decode( p_SERVICE_LEVEL, FND_API.G_MISS_NUM, SERVICE_LEVEL, p_SERVICE_LEVEL)
466: ,EDQ_FACTOR = decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, EDQ_FACTOR, p_EDQ_FACTOR)
467: ,PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE)
468: ,CONDITION_TYPE = decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, CONDITION_TYPE, p_CONDITION_TYPE)
469: ,ASL_FLAG = decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, ASL_FLAG, p_ASL_FLAG)
470: ,SAFETY_STOCK_FLAG = decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, SAFETY_STOCK_FLAG, p_SAFETY_STOCK_FLAG)
471: ,EXCESS_RULE_ID = decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, EXCESS_RULE_ID, p_EXCESS_RULE_ID)
472: ,NOTIFICATION_RULE_ID = decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NOTIFICATION_RULE_ID, p_NOTIFICATION_RULE_ID)
473: ,RECOMMENDATION_RULE_ID = decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, RECOMMENDATION_RULE_ID, p_RECOMMENDATION_RULE_ID)
466: ,EDQ_FACTOR = decode( p_EDQ_FACTOR, FND_API.G_MISS_NUM, EDQ_FACTOR, p_EDQ_FACTOR)
467: ,PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE)
468: ,CONDITION_TYPE = decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, CONDITION_TYPE, p_CONDITION_TYPE)
469: ,ASL_FLAG = decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, ASL_FLAG, p_ASL_FLAG)
470: ,SAFETY_STOCK_FLAG = decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, SAFETY_STOCK_FLAG, p_SAFETY_STOCK_FLAG)
471: ,EXCESS_RULE_ID = decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, EXCESS_RULE_ID, p_EXCESS_RULE_ID)
472: ,NOTIFICATION_RULE_ID = decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NOTIFICATION_RULE_ID, p_NOTIFICATION_RULE_ID)
473: ,RECOMMENDATION_RULE_ID = decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, RECOMMENDATION_RULE_ID, p_RECOMMENDATION_RULE_ID)
474: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
467: ,PLANNER_CODE = decode( p_PLANNER_CODE, FND_API.G_MISS_CHAR, PLANNER_CODE, p_PLANNER_CODE)
468: ,CONDITION_TYPE = decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, CONDITION_TYPE, p_CONDITION_TYPE)
469: ,ASL_FLAG = decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, ASL_FLAG, p_ASL_FLAG)
470: ,SAFETY_STOCK_FLAG = decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, SAFETY_STOCK_FLAG, p_SAFETY_STOCK_FLAG)
471: ,EXCESS_RULE_ID = decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, EXCESS_RULE_ID, p_EXCESS_RULE_ID)
472: ,NOTIFICATION_RULE_ID = decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NOTIFICATION_RULE_ID, p_NOTIFICATION_RULE_ID)
473: ,RECOMMENDATION_RULE_ID = decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, RECOMMENDATION_RULE_ID, p_RECOMMENDATION_RULE_ID)
474: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
475: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
468: ,CONDITION_TYPE = decode( p_CONDITION_TYPE, FND_API.G_MISS_CHAR, CONDITION_TYPE, p_CONDITION_TYPE)
469: ,ASL_FLAG = decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, ASL_FLAG, p_ASL_FLAG)
470: ,SAFETY_STOCK_FLAG = decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, SAFETY_STOCK_FLAG, p_SAFETY_STOCK_FLAG)
471: ,EXCESS_RULE_ID = decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, EXCESS_RULE_ID, p_EXCESS_RULE_ID)
472: ,NOTIFICATION_RULE_ID = decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NOTIFICATION_RULE_ID, p_NOTIFICATION_RULE_ID)
473: ,RECOMMENDATION_RULE_ID = decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, RECOMMENDATION_RULE_ID, p_RECOMMENDATION_RULE_ID)
474: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
475: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
476: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
469: ,ASL_FLAG = decode( p_ASL_FLAG, FND_API.G_MISS_CHAR, ASL_FLAG, p_ASL_FLAG)
470: ,SAFETY_STOCK_FLAG = decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, SAFETY_STOCK_FLAG, p_SAFETY_STOCK_FLAG)
471: ,EXCESS_RULE_ID = decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, EXCESS_RULE_ID, p_EXCESS_RULE_ID)
472: ,NOTIFICATION_RULE_ID = decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NOTIFICATION_RULE_ID, p_NOTIFICATION_RULE_ID)
473: ,RECOMMENDATION_RULE_ID = decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, RECOMMENDATION_RULE_ID, p_RECOMMENDATION_RULE_ID)
474: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
475: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
476: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
477: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
470: ,SAFETY_STOCK_FLAG = decode( p_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, SAFETY_STOCK_FLAG, p_SAFETY_STOCK_FLAG)
471: ,EXCESS_RULE_ID = decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, EXCESS_RULE_ID, p_EXCESS_RULE_ID)
472: ,NOTIFICATION_RULE_ID = decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NOTIFICATION_RULE_ID, p_NOTIFICATION_RULE_ID)
473: ,RECOMMENDATION_RULE_ID = decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, RECOMMENDATION_RULE_ID, p_RECOMMENDATION_RULE_ID)
474: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
475: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
476: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
477: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
478: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
471: ,EXCESS_RULE_ID = decode( p_EXCESS_RULE_ID, FND_API.G_MISS_NUM, EXCESS_RULE_ID, p_EXCESS_RULE_ID)
472: ,NOTIFICATION_RULE_ID = decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NOTIFICATION_RULE_ID, p_NOTIFICATION_RULE_ID)
473: ,RECOMMENDATION_RULE_ID = decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, RECOMMENDATION_RULE_ID, p_RECOMMENDATION_RULE_ID)
474: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
475: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
476: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
477: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
478: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
479: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
472: ,NOTIFICATION_RULE_ID = decode( p_NOTIFICATION_RULE_ID, FND_API.G_MISS_NUM, NOTIFICATION_RULE_ID, p_NOTIFICATION_RULE_ID)
473: ,RECOMMENDATION_RULE_ID = decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, RECOMMENDATION_RULE_ID, p_RECOMMENDATION_RULE_ID)
474: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
475: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
476: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
477: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
478: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
479: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
480: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
473: ,RECOMMENDATION_RULE_ID = decode( p_RECOMMENDATION_RULE_ID, FND_API.G_MISS_NUM, RECOMMENDATION_RULE_ID, p_RECOMMENDATION_RULE_ID)
474: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
475: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
476: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
477: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
478: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
479: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
480: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
481: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
474: ,ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY)
475: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
476: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
477: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
478: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
479: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
480: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
481: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
482: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
475: ,ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1)
476: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
477: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
478: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
479: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
480: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
481: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
482: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
483: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
476: ,ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2)
477: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
478: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
479: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
480: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
481: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
482: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
483: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
484: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
477: ,ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3)
478: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
479: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
480: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
481: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
482: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
483: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
484: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
485: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
478: ,ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4)
479: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
480: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
481: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
482: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
483: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
484: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
485: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
486: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
479: ,ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5)
480: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
481: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
482: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
483: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
484: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
485: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
486: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
487: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
480: ,ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6)
481: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
482: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
483: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
484: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
485: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
486: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
487: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
488: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
481: ,ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7)
482: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
483: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
484: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
485: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
486: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
487: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
488: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
489: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
482: ,ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8)
483: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
484: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
485: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
486: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
487: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
488: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
489: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
490: ,CATEGORY_SET_ID = decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, CATEGORY_SET_ID, p_CATEGORY_SET_ID)
483: ,ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9)
484: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
485: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
486: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
487: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
488: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
489: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
490: ,CATEGORY_SET_ID = decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, CATEGORY_SET_ID, p_CATEGORY_SET_ID)
491: ,CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID)
484: ,ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10)
485: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
486: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
487: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
488: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
489: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
490: ,CATEGORY_SET_ID = decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, CATEGORY_SET_ID, p_CATEGORY_SET_ID)
491: ,CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID)
492: ,RECOMMEND_METHOD = decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, RECOMMEND_METHOD, p_RECOMMEND_METHOD)
485: ,ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11)
486: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
487: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
488: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
489: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
490: ,CATEGORY_SET_ID = decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, CATEGORY_SET_ID, p_CATEGORY_SET_ID)
491: ,CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID)
492: ,RECOMMEND_METHOD = decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, RECOMMEND_METHOD, p_RECOMMEND_METHOD)
493: ,EDQ_MULTIPLE = decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, EDQ_MULTIPLE, p_EDQ_MULTIPLE)
486: ,ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12)
487: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
488: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
489: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
490: ,CATEGORY_SET_ID = decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, CATEGORY_SET_ID, p_CATEGORY_SET_ID)
491: ,CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID)
492: ,RECOMMEND_METHOD = decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, RECOMMEND_METHOD, p_RECOMMEND_METHOD)
493: ,EDQ_MULTIPLE = decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, EDQ_MULTIPLE, p_EDQ_MULTIPLE)
494: ,MINIMUM_VALUE = decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, MINIMUM_VALUE, p_MINIMUM_VALUE)
487: ,ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13)
488: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
489: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
490: ,CATEGORY_SET_ID = decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, CATEGORY_SET_ID, p_CATEGORY_SET_ID)
491: ,CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID)
492: ,RECOMMEND_METHOD = decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, RECOMMEND_METHOD, p_RECOMMEND_METHOD)
493: ,EDQ_MULTIPLE = decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, EDQ_MULTIPLE, p_EDQ_MULTIPLE)
494: ,MINIMUM_VALUE = decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, MINIMUM_VALUE, p_MINIMUM_VALUE)
495: ,USABLE_ASSIGNMENT_SET_ID = decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, USABLE_ASSIGNMENT_SET_ID, p_USABLE_ASSIGNMENT_SET_ID)
488: ,ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14)
489: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
490: ,CATEGORY_SET_ID = decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, CATEGORY_SET_ID, p_CATEGORY_SET_ID)
491: ,CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID)
492: ,RECOMMEND_METHOD = decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, RECOMMEND_METHOD, p_RECOMMEND_METHOD)
493: ,EDQ_MULTIPLE = decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, EDQ_MULTIPLE, p_EDQ_MULTIPLE)
494: ,MINIMUM_VALUE = decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, MINIMUM_VALUE, p_MINIMUM_VALUE)
495: ,USABLE_ASSIGNMENT_SET_ID = decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, USABLE_ASSIGNMENT_SET_ID, p_USABLE_ASSIGNMENT_SET_ID)
496: ,DEFECTIVE_ASSIGNMENT_SET_ID = decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, DEFECTIVE_ASSIGNMENT_SET_ID, p_DEFECTIVE_ASSIGNMENT_SET_ID)
489: ,ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
490: ,CATEGORY_SET_ID = decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, CATEGORY_SET_ID, p_CATEGORY_SET_ID)
491: ,CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID)
492: ,RECOMMEND_METHOD = decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, RECOMMEND_METHOD, p_RECOMMEND_METHOD)
493: ,EDQ_MULTIPLE = decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, EDQ_MULTIPLE, p_EDQ_MULTIPLE)
494: ,MINIMUM_VALUE = decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, MINIMUM_VALUE, p_MINIMUM_VALUE)
495: ,USABLE_ASSIGNMENT_SET_ID = decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, USABLE_ASSIGNMENT_SET_ID, p_USABLE_ASSIGNMENT_SET_ID)
496: ,DEFECTIVE_ASSIGNMENT_SET_ID = decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, DEFECTIVE_ASSIGNMENT_SET_ID, p_DEFECTIVE_ASSIGNMENT_SET_ID)
497: ,REPAIR_ASSIGNMENT_SET_ID = decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, REPAIR_ASSIGNMENT_SET_ID, p_REPAIR_ASSIGNMENT_SET_ID)
490: ,CATEGORY_SET_ID = decode( p_CATEGORY_SET_ID, FND_API.G_MISS_NUM, CATEGORY_SET_ID, p_CATEGORY_SET_ID)
491: ,CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID)
492: ,RECOMMEND_METHOD = decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, RECOMMEND_METHOD, p_RECOMMEND_METHOD)
493: ,EDQ_MULTIPLE = decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, EDQ_MULTIPLE, p_EDQ_MULTIPLE)
494: ,MINIMUM_VALUE = decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, MINIMUM_VALUE, p_MINIMUM_VALUE)
495: ,USABLE_ASSIGNMENT_SET_ID = decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, USABLE_ASSIGNMENT_SET_ID, p_USABLE_ASSIGNMENT_SET_ID)
496: ,DEFECTIVE_ASSIGNMENT_SET_ID = decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, DEFECTIVE_ASSIGNMENT_SET_ID, p_DEFECTIVE_ASSIGNMENT_SET_ID)
497: ,REPAIR_ASSIGNMENT_SET_ID = decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, REPAIR_ASSIGNMENT_SET_ID, p_REPAIR_ASSIGNMENT_SET_ID)
498: ,PRODUCT_NORM = decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, PRODUCT_NORM, p_PRODUCT_NORM)
491: ,CATEGORY_ID = decode( p_CATEGORY_ID, FND_API.G_MISS_NUM, CATEGORY_ID, p_CATEGORY_ID)
492: ,RECOMMEND_METHOD = decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, RECOMMEND_METHOD, p_RECOMMEND_METHOD)
493: ,EDQ_MULTIPLE = decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, EDQ_MULTIPLE, p_EDQ_MULTIPLE)
494: ,MINIMUM_VALUE = decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, MINIMUM_VALUE, p_MINIMUM_VALUE)
495: ,USABLE_ASSIGNMENT_SET_ID = decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, USABLE_ASSIGNMENT_SET_ID, p_USABLE_ASSIGNMENT_SET_ID)
496: ,DEFECTIVE_ASSIGNMENT_SET_ID = decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, DEFECTIVE_ASSIGNMENT_SET_ID, p_DEFECTIVE_ASSIGNMENT_SET_ID)
497: ,REPAIR_ASSIGNMENT_SET_ID = decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, REPAIR_ASSIGNMENT_SET_ID, p_REPAIR_ASSIGNMENT_SET_ID)
498: ,PRODUCT_NORM = decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, PRODUCT_NORM, p_PRODUCT_NORM)
499: ,PRODUCT_NORM_NODE_ID = decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, PRODUCT_NORM_NODE_ID, p_PRODUCT_NORM_NODE_ID)
492: ,RECOMMEND_METHOD = decode( p_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, RECOMMEND_METHOD, p_RECOMMEND_METHOD)
493: ,EDQ_MULTIPLE = decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, EDQ_MULTIPLE, p_EDQ_MULTIPLE)
494: ,MINIMUM_VALUE = decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, MINIMUM_VALUE, p_MINIMUM_VALUE)
495: ,USABLE_ASSIGNMENT_SET_ID = decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, USABLE_ASSIGNMENT_SET_ID, p_USABLE_ASSIGNMENT_SET_ID)
496: ,DEFECTIVE_ASSIGNMENT_SET_ID = decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, DEFECTIVE_ASSIGNMENT_SET_ID, p_DEFECTIVE_ASSIGNMENT_SET_ID)
497: ,REPAIR_ASSIGNMENT_SET_ID = decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, REPAIR_ASSIGNMENT_SET_ID, p_REPAIR_ASSIGNMENT_SET_ID)
498: ,PRODUCT_NORM = decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, PRODUCT_NORM, p_PRODUCT_NORM)
499: ,PRODUCT_NORM_NODE_ID = decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, PRODUCT_NORM_NODE_ID, p_PRODUCT_NORM_NODE_ID)
500: ,USAGE_WEIGHT1 = decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, USAGE_WEIGHT1, p_USAGE_WEIGHT1)
493: ,EDQ_MULTIPLE = decode( p_EDQ_MULTIPLE, FND_API.G_MISS_NUM, EDQ_MULTIPLE, p_EDQ_MULTIPLE)
494: ,MINIMUM_VALUE = decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, MINIMUM_VALUE, p_MINIMUM_VALUE)
495: ,USABLE_ASSIGNMENT_SET_ID = decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, USABLE_ASSIGNMENT_SET_ID, p_USABLE_ASSIGNMENT_SET_ID)
496: ,DEFECTIVE_ASSIGNMENT_SET_ID = decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, DEFECTIVE_ASSIGNMENT_SET_ID, p_DEFECTIVE_ASSIGNMENT_SET_ID)
497: ,REPAIR_ASSIGNMENT_SET_ID = decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, REPAIR_ASSIGNMENT_SET_ID, p_REPAIR_ASSIGNMENT_SET_ID)
498: ,PRODUCT_NORM = decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, PRODUCT_NORM, p_PRODUCT_NORM)
499: ,PRODUCT_NORM_NODE_ID = decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, PRODUCT_NORM_NODE_ID, p_PRODUCT_NORM_NODE_ID)
500: ,USAGE_WEIGHT1 = decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, USAGE_WEIGHT1, p_USAGE_WEIGHT1)
501: ,USAGE_WEIGHT2 = decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, USAGE_WEIGHT2, p_USAGE_WEIGHT2)
494: ,MINIMUM_VALUE = decode( p_MINIMUM_VALUE, FND_API.G_MISS_NUM, MINIMUM_VALUE, p_MINIMUM_VALUE)
495: ,USABLE_ASSIGNMENT_SET_ID = decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, USABLE_ASSIGNMENT_SET_ID, p_USABLE_ASSIGNMENT_SET_ID)
496: ,DEFECTIVE_ASSIGNMENT_SET_ID = decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, DEFECTIVE_ASSIGNMENT_SET_ID, p_DEFECTIVE_ASSIGNMENT_SET_ID)
497: ,REPAIR_ASSIGNMENT_SET_ID = decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, REPAIR_ASSIGNMENT_SET_ID, p_REPAIR_ASSIGNMENT_SET_ID)
498: ,PRODUCT_NORM = decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, PRODUCT_NORM, p_PRODUCT_NORM)
499: ,PRODUCT_NORM_NODE_ID = decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, PRODUCT_NORM_NODE_ID, p_PRODUCT_NORM_NODE_ID)
500: ,USAGE_WEIGHT1 = decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, USAGE_WEIGHT1, p_USAGE_WEIGHT1)
501: ,USAGE_WEIGHT2 = decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, USAGE_WEIGHT2, p_USAGE_WEIGHT2)
502: ,USAGE_WEIGHT3 = decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, USAGE_WEIGHT3, p_USAGE_WEIGHT3)
495: ,USABLE_ASSIGNMENT_SET_ID = decode( p_USABLE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, USABLE_ASSIGNMENT_SET_ID, p_USABLE_ASSIGNMENT_SET_ID)
496: ,DEFECTIVE_ASSIGNMENT_SET_ID = decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, DEFECTIVE_ASSIGNMENT_SET_ID, p_DEFECTIVE_ASSIGNMENT_SET_ID)
497: ,REPAIR_ASSIGNMENT_SET_ID = decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, REPAIR_ASSIGNMENT_SET_ID, p_REPAIR_ASSIGNMENT_SET_ID)
498: ,PRODUCT_NORM = decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, PRODUCT_NORM, p_PRODUCT_NORM)
499: ,PRODUCT_NORM_NODE_ID = decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, PRODUCT_NORM_NODE_ID, p_PRODUCT_NORM_NODE_ID)
500: ,USAGE_WEIGHT1 = decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, USAGE_WEIGHT1, p_USAGE_WEIGHT1)
501: ,USAGE_WEIGHT2 = decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, USAGE_WEIGHT2, p_USAGE_WEIGHT2)
502: ,USAGE_WEIGHT3 = decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, USAGE_WEIGHT3, p_USAGE_WEIGHT3)
503: ,USAGE_WEIGHT4 = decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, USAGE_WEIGHT4, p_USAGE_WEIGHT4)
496: ,DEFECTIVE_ASSIGNMENT_SET_ID = decode( p_DEFECTIVE_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, DEFECTIVE_ASSIGNMENT_SET_ID, p_DEFECTIVE_ASSIGNMENT_SET_ID)
497: ,REPAIR_ASSIGNMENT_SET_ID = decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, REPAIR_ASSIGNMENT_SET_ID, p_REPAIR_ASSIGNMENT_SET_ID)
498: ,PRODUCT_NORM = decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, PRODUCT_NORM, p_PRODUCT_NORM)
499: ,PRODUCT_NORM_NODE_ID = decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, PRODUCT_NORM_NODE_ID, p_PRODUCT_NORM_NODE_ID)
500: ,USAGE_WEIGHT1 = decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, USAGE_WEIGHT1, p_USAGE_WEIGHT1)
501: ,USAGE_WEIGHT2 = decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, USAGE_WEIGHT2, p_USAGE_WEIGHT2)
502: ,USAGE_WEIGHT3 = decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, USAGE_WEIGHT3, p_USAGE_WEIGHT3)
503: ,USAGE_WEIGHT4 = decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, USAGE_WEIGHT4, p_USAGE_WEIGHT4)
504: ,DEFAULT_FORECAST_RULE_ID = decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_FORECAST_RULE_ID, p_DEFAULT_FORECAST_RULE_ID)
497: ,REPAIR_ASSIGNMENT_SET_ID = decode( p_REPAIR_ASSIGNMENT_SET_ID, FND_API.G_MISS_NUM, REPAIR_ASSIGNMENT_SET_ID, p_REPAIR_ASSIGNMENT_SET_ID)
498: ,PRODUCT_NORM = decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, PRODUCT_NORM, p_PRODUCT_NORM)
499: ,PRODUCT_NORM_NODE_ID = decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, PRODUCT_NORM_NODE_ID, p_PRODUCT_NORM_NODE_ID)
500: ,USAGE_WEIGHT1 = decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, USAGE_WEIGHT1, p_USAGE_WEIGHT1)
501: ,USAGE_WEIGHT2 = decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, USAGE_WEIGHT2, p_USAGE_WEIGHT2)
502: ,USAGE_WEIGHT3 = decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, USAGE_WEIGHT3, p_USAGE_WEIGHT3)
503: ,USAGE_WEIGHT4 = decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, USAGE_WEIGHT4, p_USAGE_WEIGHT4)
504: ,DEFAULT_FORECAST_RULE_ID = decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_FORECAST_RULE_ID, p_DEFAULT_FORECAST_RULE_ID)
505: ,DEFAULT_SERVICE_LEVEL = decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, DEFAULT_SERVICE_LEVEL, p_DEFAULT_SERVICE_LEVEL)
498: ,PRODUCT_NORM = decode( p_PRODUCT_NORM, FND_API.G_MISS_CHAR, PRODUCT_NORM, p_PRODUCT_NORM)
499: ,PRODUCT_NORM_NODE_ID = decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, PRODUCT_NORM_NODE_ID, p_PRODUCT_NORM_NODE_ID)
500: ,USAGE_WEIGHT1 = decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, USAGE_WEIGHT1, p_USAGE_WEIGHT1)
501: ,USAGE_WEIGHT2 = decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, USAGE_WEIGHT2, p_USAGE_WEIGHT2)
502: ,USAGE_WEIGHT3 = decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, USAGE_WEIGHT3, p_USAGE_WEIGHT3)
503: ,USAGE_WEIGHT4 = decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, USAGE_WEIGHT4, p_USAGE_WEIGHT4)
504: ,DEFAULT_FORECAST_RULE_ID = decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_FORECAST_RULE_ID, p_DEFAULT_FORECAST_RULE_ID)
505: ,DEFAULT_SERVICE_LEVEL = decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, DEFAULT_SERVICE_LEVEL, p_DEFAULT_SERVICE_LEVEL)
506: ,DEFAULT_EDQ_FACTOR = decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, DEFAULT_EDQ_FACTOR, p_DEFAULT_EDQ_FACTOR)
499: ,PRODUCT_NORM_NODE_ID = decode( p_PRODUCT_NORM_NODE_ID, FND_API.G_MISS_NUM, PRODUCT_NORM_NODE_ID, p_PRODUCT_NORM_NODE_ID)
500: ,USAGE_WEIGHT1 = decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, USAGE_WEIGHT1, p_USAGE_WEIGHT1)
501: ,USAGE_WEIGHT2 = decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, USAGE_WEIGHT2, p_USAGE_WEIGHT2)
502: ,USAGE_WEIGHT3 = decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, USAGE_WEIGHT3, p_USAGE_WEIGHT3)
503: ,USAGE_WEIGHT4 = decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, USAGE_WEIGHT4, p_USAGE_WEIGHT4)
504: ,DEFAULT_FORECAST_RULE_ID = decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_FORECAST_RULE_ID, p_DEFAULT_FORECAST_RULE_ID)
505: ,DEFAULT_SERVICE_LEVEL = decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, DEFAULT_SERVICE_LEVEL, p_DEFAULT_SERVICE_LEVEL)
506: ,DEFAULT_EDQ_FACTOR = decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, DEFAULT_EDQ_FACTOR, p_DEFAULT_EDQ_FACTOR)
507: ,DEFAULT_PLANNER_CODE = decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, DEFAULT_PLANNER_CODE, p_DEFAULT_PLANNER_CODE)
500: ,USAGE_WEIGHT1 = decode( p_USAGE_WEIGHT1, FND_API.G_MISS_NUM, USAGE_WEIGHT1, p_USAGE_WEIGHT1)
501: ,USAGE_WEIGHT2 = decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, USAGE_WEIGHT2, p_USAGE_WEIGHT2)
502: ,USAGE_WEIGHT3 = decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, USAGE_WEIGHT3, p_USAGE_WEIGHT3)
503: ,USAGE_WEIGHT4 = decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, USAGE_WEIGHT4, p_USAGE_WEIGHT4)
504: ,DEFAULT_FORECAST_RULE_ID = decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_FORECAST_RULE_ID, p_DEFAULT_FORECAST_RULE_ID)
505: ,DEFAULT_SERVICE_LEVEL = decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, DEFAULT_SERVICE_LEVEL, p_DEFAULT_SERVICE_LEVEL)
506: ,DEFAULT_EDQ_FACTOR = decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, DEFAULT_EDQ_FACTOR, p_DEFAULT_EDQ_FACTOR)
507: ,DEFAULT_PLANNER_CODE = decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, DEFAULT_PLANNER_CODE, p_DEFAULT_PLANNER_CODE)
508: ,DEFAULT_CONDITION_TYPE = decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, DEFAULT_CONDITION_TYPE, p_DEFAULT_CONDITION_TYPE)
501: ,USAGE_WEIGHT2 = decode( p_USAGE_WEIGHT2, FND_API.G_MISS_NUM, USAGE_WEIGHT2, p_USAGE_WEIGHT2)
502: ,USAGE_WEIGHT3 = decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, USAGE_WEIGHT3, p_USAGE_WEIGHT3)
503: ,USAGE_WEIGHT4 = decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, USAGE_WEIGHT4, p_USAGE_WEIGHT4)
504: ,DEFAULT_FORECAST_RULE_ID = decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_FORECAST_RULE_ID, p_DEFAULT_FORECAST_RULE_ID)
505: ,DEFAULT_SERVICE_LEVEL = decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, DEFAULT_SERVICE_LEVEL, p_DEFAULT_SERVICE_LEVEL)
506: ,DEFAULT_EDQ_FACTOR = decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, DEFAULT_EDQ_FACTOR, p_DEFAULT_EDQ_FACTOR)
507: ,DEFAULT_PLANNER_CODE = decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, DEFAULT_PLANNER_CODE, p_DEFAULT_PLANNER_CODE)
508: ,DEFAULT_CONDITION_TYPE = decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, DEFAULT_CONDITION_TYPE, p_DEFAULT_CONDITION_TYPE)
509: ,DEFAULT_ASL_FLAG = decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, DEFAULT_ASL_FLAG, p_DEFAULT_ASL_FLAG)
502: ,USAGE_WEIGHT3 = decode( p_USAGE_WEIGHT3, FND_API.G_MISS_NUM, USAGE_WEIGHT3, p_USAGE_WEIGHT3)
503: ,USAGE_WEIGHT4 = decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, USAGE_WEIGHT4, p_USAGE_WEIGHT4)
504: ,DEFAULT_FORECAST_RULE_ID = decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_FORECAST_RULE_ID, p_DEFAULT_FORECAST_RULE_ID)
505: ,DEFAULT_SERVICE_LEVEL = decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, DEFAULT_SERVICE_LEVEL, p_DEFAULT_SERVICE_LEVEL)
506: ,DEFAULT_EDQ_FACTOR = decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, DEFAULT_EDQ_FACTOR, p_DEFAULT_EDQ_FACTOR)
507: ,DEFAULT_PLANNER_CODE = decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, DEFAULT_PLANNER_CODE, p_DEFAULT_PLANNER_CODE)
508: ,DEFAULT_CONDITION_TYPE = decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, DEFAULT_CONDITION_TYPE, p_DEFAULT_CONDITION_TYPE)
509: ,DEFAULT_ASL_FLAG = decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, DEFAULT_ASL_FLAG, p_DEFAULT_ASL_FLAG)
510: ,DEFAULT_SAFETY_STOCK_FLAG = decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, DEFAULT_SAFETY_STOCK_FLAG, p_DEFAULT_SAFETY_STOCK_FLAG)
503: ,USAGE_WEIGHT4 = decode( p_USAGE_WEIGHT4, FND_API.G_MISS_NUM, USAGE_WEIGHT4, p_USAGE_WEIGHT4)
504: ,DEFAULT_FORECAST_RULE_ID = decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_FORECAST_RULE_ID, p_DEFAULT_FORECAST_RULE_ID)
505: ,DEFAULT_SERVICE_LEVEL = decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, DEFAULT_SERVICE_LEVEL, p_DEFAULT_SERVICE_LEVEL)
506: ,DEFAULT_EDQ_FACTOR = decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, DEFAULT_EDQ_FACTOR, p_DEFAULT_EDQ_FACTOR)
507: ,DEFAULT_PLANNER_CODE = decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, DEFAULT_PLANNER_CODE, p_DEFAULT_PLANNER_CODE)
508: ,DEFAULT_CONDITION_TYPE = decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, DEFAULT_CONDITION_TYPE, p_DEFAULT_CONDITION_TYPE)
509: ,DEFAULT_ASL_FLAG = decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, DEFAULT_ASL_FLAG, p_DEFAULT_ASL_FLAG)
510: ,DEFAULT_SAFETY_STOCK_FLAG = decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, DEFAULT_SAFETY_STOCK_FLAG, p_DEFAULT_SAFETY_STOCK_FLAG)
511: ,DEFAULT_EXCESS_RULE_ID = decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_EXCESS_RULE_ID, p_DEFAULT_EXCESS_RULE_ID)
504: ,DEFAULT_FORECAST_RULE_ID = decode( p_DEFAULT_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_FORECAST_RULE_ID, p_DEFAULT_FORECAST_RULE_ID)
505: ,DEFAULT_SERVICE_LEVEL = decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, DEFAULT_SERVICE_LEVEL, p_DEFAULT_SERVICE_LEVEL)
506: ,DEFAULT_EDQ_FACTOR = decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, DEFAULT_EDQ_FACTOR, p_DEFAULT_EDQ_FACTOR)
507: ,DEFAULT_PLANNER_CODE = decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, DEFAULT_PLANNER_CODE, p_DEFAULT_PLANNER_CODE)
508: ,DEFAULT_CONDITION_TYPE = decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, DEFAULT_CONDITION_TYPE, p_DEFAULT_CONDITION_TYPE)
509: ,DEFAULT_ASL_FLAG = decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, DEFAULT_ASL_FLAG, p_DEFAULT_ASL_FLAG)
510: ,DEFAULT_SAFETY_STOCK_FLAG = decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, DEFAULT_SAFETY_STOCK_FLAG, p_DEFAULT_SAFETY_STOCK_FLAG)
511: ,DEFAULT_EXCESS_RULE_ID = decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_EXCESS_RULE_ID, p_DEFAULT_EXCESS_RULE_ID)
512: ,DEFAULT_CATEGORY_SET_ID = decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_SET_ID, p_DEFAULT_CATEGORY_SET_ID)
505: ,DEFAULT_SERVICE_LEVEL = decode( p_DEFAULT_SERVICE_LEVEL, FND_API.G_MISS_CHAR, DEFAULT_SERVICE_LEVEL, p_DEFAULT_SERVICE_LEVEL)
506: ,DEFAULT_EDQ_FACTOR = decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, DEFAULT_EDQ_FACTOR, p_DEFAULT_EDQ_FACTOR)
507: ,DEFAULT_PLANNER_CODE = decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, DEFAULT_PLANNER_CODE, p_DEFAULT_PLANNER_CODE)
508: ,DEFAULT_CONDITION_TYPE = decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, DEFAULT_CONDITION_TYPE, p_DEFAULT_CONDITION_TYPE)
509: ,DEFAULT_ASL_FLAG = decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, DEFAULT_ASL_FLAG, p_DEFAULT_ASL_FLAG)
510: ,DEFAULT_SAFETY_STOCK_FLAG = decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, DEFAULT_SAFETY_STOCK_FLAG, p_DEFAULT_SAFETY_STOCK_FLAG)
511: ,DEFAULT_EXCESS_RULE_ID = decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_EXCESS_RULE_ID, p_DEFAULT_EXCESS_RULE_ID)
512: ,DEFAULT_CATEGORY_SET_ID = decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_SET_ID, p_DEFAULT_CATEGORY_SET_ID)
513: ,DEFAULT_CATEGORY_ID = decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_ID, p_DEFAULT_CATEGORY_ID)
506: ,DEFAULT_EDQ_FACTOR = decode( p_DEFAULT_EDQ_FACTOR, FND_API.G_MISS_CHAR, DEFAULT_EDQ_FACTOR, p_DEFAULT_EDQ_FACTOR)
507: ,DEFAULT_PLANNER_CODE = decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, DEFAULT_PLANNER_CODE, p_DEFAULT_PLANNER_CODE)
508: ,DEFAULT_CONDITION_TYPE = decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, DEFAULT_CONDITION_TYPE, p_DEFAULT_CONDITION_TYPE)
509: ,DEFAULT_ASL_FLAG = decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, DEFAULT_ASL_FLAG, p_DEFAULT_ASL_FLAG)
510: ,DEFAULT_SAFETY_STOCK_FLAG = decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, DEFAULT_SAFETY_STOCK_FLAG, p_DEFAULT_SAFETY_STOCK_FLAG)
511: ,DEFAULT_EXCESS_RULE_ID = decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_EXCESS_RULE_ID, p_DEFAULT_EXCESS_RULE_ID)
512: ,DEFAULT_CATEGORY_SET_ID = decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_SET_ID, p_DEFAULT_CATEGORY_SET_ID)
513: ,DEFAULT_CATEGORY_ID = decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_ID, p_DEFAULT_CATEGORY_ID)
514: ,DEFAULT_RECOMMEND_METHOD = decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, DEFAULT_RECOMMEND_METHOD, p_DEFAULT_RECOMMEND_METHOD)
507: ,DEFAULT_PLANNER_CODE = decode( p_DEFAULT_PLANNER_CODE, FND_API.G_MISS_CHAR, DEFAULT_PLANNER_CODE, p_DEFAULT_PLANNER_CODE)
508: ,DEFAULT_CONDITION_TYPE = decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, DEFAULT_CONDITION_TYPE, p_DEFAULT_CONDITION_TYPE)
509: ,DEFAULT_ASL_FLAG = decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, DEFAULT_ASL_FLAG, p_DEFAULT_ASL_FLAG)
510: ,DEFAULT_SAFETY_STOCK_FLAG = decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, DEFAULT_SAFETY_STOCK_FLAG, p_DEFAULT_SAFETY_STOCK_FLAG)
511: ,DEFAULT_EXCESS_RULE_ID = decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_EXCESS_RULE_ID, p_DEFAULT_EXCESS_RULE_ID)
512: ,DEFAULT_CATEGORY_SET_ID = decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_SET_ID, p_DEFAULT_CATEGORY_SET_ID)
513: ,DEFAULT_CATEGORY_ID = decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_ID, p_DEFAULT_CATEGORY_ID)
514: ,DEFAULT_RECOMMEND_METHOD = decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, DEFAULT_RECOMMEND_METHOD, p_DEFAULT_RECOMMEND_METHOD)
515: ,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)
508: ,DEFAULT_CONDITION_TYPE = decode( p_DEFAULT_CONDITION_TYPE, FND_API.G_MISS_CHAR, DEFAULT_CONDITION_TYPE, p_DEFAULT_CONDITION_TYPE)
509: ,DEFAULT_ASL_FLAG = decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, DEFAULT_ASL_FLAG, p_DEFAULT_ASL_FLAG)
510: ,DEFAULT_SAFETY_STOCK_FLAG = decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, DEFAULT_SAFETY_STOCK_FLAG, p_DEFAULT_SAFETY_STOCK_FLAG)
511: ,DEFAULT_EXCESS_RULE_ID = decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_EXCESS_RULE_ID, p_DEFAULT_EXCESS_RULE_ID)
512: ,DEFAULT_CATEGORY_SET_ID = decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_SET_ID, p_DEFAULT_CATEGORY_SET_ID)
513: ,DEFAULT_CATEGORY_ID = decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_ID, p_DEFAULT_CATEGORY_ID)
514: ,DEFAULT_RECOMMEND_METHOD = decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, DEFAULT_RECOMMEND_METHOD, p_DEFAULT_RECOMMEND_METHOD)
515: ,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)
516: ,DEFAULT_USAGE_WEIGHT1 = decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT1, p_DEFAULT_USAGE_WEIGHT1)
509: ,DEFAULT_ASL_FLAG = decode( p_DEFAULT_ASL_FLAG, FND_API.G_MISS_CHAR, DEFAULT_ASL_FLAG, p_DEFAULT_ASL_FLAG)
510: ,DEFAULT_SAFETY_STOCK_FLAG = decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, DEFAULT_SAFETY_STOCK_FLAG, p_DEFAULT_SAFETY_STOCK_FLAG)
511: ,DEFAULT_EXCESS_RULE_ID = decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_EXCESS_RULE_ID, p_DEFAULT_EXCESS_RULE_ID)
512: ,DEFAULT_CATEGORY_SET_ID = decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_SET_ID, p_DEFAULT_CATEGORY_SET_ID)
513: ,DEFAULT_CATEGORY_ID = decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_ID, p_DEFAULT_CATEGORY_ID)
514: ,DEFAULT_RECOMMEND_METHOD = decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, DEFAULT_RECOMMEND_METHOD, p_DEFAULT_RECOMMEND_METHOD)
515: ,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)
516: ,DEFAULT_USAGE_WEIGHT1 = decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT1, p_DEFAULT_USAGE_WEIGHT1)
517: ,DEFAULT_USAGE_WEIGHT2 = decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT2, p_DEFAULT_USAGE_WEIGHT2)
510: ,DEFAULT_SAFETY_STOCK_FLAG = decode( p_DEFAULT_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, DEFAULT_SAFETY_STOCK_FLAG, p_DEFAULT_SAFETY_STOCK_FLAG)
511: ,DEFAULT_EXCESS_RULE_ID = decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_EXCESS_RULE_ID, p_DEFAULT_EXCESS_RULE_ID)
512: ,DEFAULT_CATEGORY_SET_ID = decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_SET_ID, p_DEFAULT_CATEGORY_SET_ID)
513: ,DEFAULT_CATEGORY_ID = decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_ID, p_DEFAULT_CATEGORY_ID)
514: ,DEFAULT_RECOMMEND_METHOD = decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, DEFAULT_RECOMMEND_METHOD, p_DEFAULT_RECOMMEND_METHOD)
515: ,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)
516: ,DEFAULT_USAGE_WEIGHT1 = decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT1, p_DEFAULT_USAGE_WEIGHT1)
517: ,DEFAULT_USAGE_WEIGHT2 = decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT2, p_DEFAULT_USAGE_WEIGHT2)
518: ,DEFAULT_USAGE_WEIGHT3 = decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT3, p_DEFAULT_USAGE_WEIGHT3)
511: ,DEFAULT_EXCESS_RULE_ID = decode( p_DEFAULT_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_EXCESS_RULE_ID, p_DEFAULT_EXCESS_RULE_ID)
512: ,DEFAULT_CATEGORY_SET_ID = decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_SET_ID, p_DEFAULT_CATEGORY_SET_ID)
513: ,DEFAULT_CATEGORY_ID = decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_ID, p_DEFAULT_CATEGORY_ID)
514: ,DEFAULT_RECOMMEND_METHOD = decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, DEFAULT_RECOMMEND_METHOD, p_DEFAULT_RECOMMEND_METHOD)
515: ,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)
516: ,DEFAULT_USAGE_WEIGHT1 = decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT1, p_DEFAULT_USAGE_WEIGHT1)
517: ,DEFAULT_USAGE_WEIGHT2 = decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT2, p_DEFAULT_USAGE_WEIGHT2)
518: ,DEFAULT_USAGE_WEIGHT3 = decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT3, p_DEFAULT_USAGE_WEIGHT3)
519: ,DEFAULT_USAGE_WEIGHT4 = decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT4, p_DEFAULT_USAGE_WEIGHT4)
512: ,DEFAULT_CATEGORY_SET_ID = decode( p_DEFAULT_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_SET_ID, p_DEFAULT_CATEGORY_SET_ID)
513: ,DEFAULT_CATEGORY_ID = decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_ID, p_DEFAULT_CATEGORY_ID)
514: ,DEFAULT_RECOMMEND_METHOD = decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, DEFAULT_RECOMMEND_METHOD, p_DEFAULT_RECOMMEND_METHOD)
515: ,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)
516: ,DEFAULT_USAGE_WEIGHT1 = decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT1, p_DEFAULT_USAGE_WEIGHT1)
517: ,DEFAULT_USAGE_WEIGHT2 = decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT2, p_DEFAULT_USAGE_WEIGHT2)
518: ,DEFAULT_USAGE_WEIGHT3 = decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT3, p_DEFAULT_USAGE_WEIGHT3)
519: ,DEFAULT_USAGE_WEIGHT4 = decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT4, p_DEFAULT_USAGE_WEIGHT4)
520: ,DEFAULT_REC_RULE_ID = decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_REC_RULE_ID, p_DEFAULT_REC_RULE_ID)
513: ,DEFAULT_CATEGORY_ID = decode( p_DEFAULT_CATEGORY_ID, FND_API.G_MISS_CHAR, DEFAULT_CATEGORY_ID, p_DEFAULT_CATEGORY_ID)
514: ,DEFAULT_RECOMMEND_METHOD = decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, DEFAULT_RECOMMEND_METHOD, p_DEFAULT_RECOMMEND_METHOD)
515: ,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)
516: ,DEFAULT_USAGE_WEIGHT1 = decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT1, p_DEFAULT_USAGE_WEIGHT1)
517: ,DEFAULT_USAGE_WEIGHT2 = decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT2, p_DEFAULT_USAGE_WEIGHT2)
518: ,DEFAULT_USAGE_WEIGHT3 = decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT3, p_DEFAULT_USAGE_WEIGHT3)
519: ,DEFAULT_USAGE_WEIGHT4 = decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT4, p_DEFAULT_USAGE_WEIGHT4)
520: ,DEFAULT_REC_RULE_ID = decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_REC_RULE_ID, p_DEFAULT_REC_RULE_ID)
521: ,OVERRIDE_FORECAST_RULE_ID = decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_FORECAST_RULE_ID, p_OVERRIDE_FORECAST_RULE_ID)
514: ,DEFAULT_RECOMMEND_METHOD = decode( p_DEFAULT_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, DEFAULT_RECOMMEND_METHOD, p_DEFAULT_RECOMMEND_METHOD)
515: ,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)
516: ,DEFAULT_USAGE_WEIGHT1 = decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT1, p_DEFAULT_USAGE_WEIGHT1)
517: ,DEFAULT_USAGE_WEIGHT2 = decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT2, p_DEFAULT_USAGE_WEIGHT2)
518: ,DEFAULT_USAGE_WEIGHT3 = decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT3, p_DEFAULT_USAGE_WEIGHT3)
519: ,DEFAULT_USAGE_WEIGHT4 = decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT4, p_DEFAULT_USAGE_WEIGHT4)
520: ,DEFAULT_REC_RULE_ID = decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_REC_RULE_ID, p_DEFAULT_REC_RULE_ID)
521: ,OVERRIDE_FORECAST_RULE_ID = decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_FORECAST_RULE_ID, p_OVERRIDE_FORECAST_RULE_ID)
522: ,OVERRIDE_SERVICE_LEVEL = decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, OVERRIDE_SERVICE_LEVEL, p_OVERRIDE_SERVICE_LEVEL)
515: ,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)
516: ,DEFAULT_USAGE_WEIGHT1 = decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT1, p_DEFAULT_USAGE_WEIGHT1)
517: ,DEFAULT_USAGE_WEIGHT2 = decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT2, p_DEFAULT_USAGE_WEIGHT2)
518: ,DEFAULT_USAGE_WEIGHT3 = decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT3, p_DEFAULT_USAGE_WEIGHT3)
519: ,DEFAULT_USAGE_WEIGHT4 = decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT4, p_DEFAULT_USAGE_WEIGHT4)
520: ,DEFAULT_REC_RULE_ID = decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_REC_RULE_ID, p_DEFAULT_REC_RULE_ID)
521: ,OVERRIDE_FORECAST_RULE_ID = decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_FORECAST_RULE_ID, p_OVERRIDE_FORECAST_RULE_ID)
522: ,OVERRIDE_SERVICE_LEVEL = decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, OVERRIDE_SERVICE_LEVEL, p_OVERRIDE_SERVICE_LEVEL)
523: ,OVERRIDE_EDQ_FACTOR = decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, OVERRIDE_EDQ_FACTOR, p_OVERRIDE_EDQ_FACTOR)
516: ,DEFAULT_USAGE_WEIGHT1 = decode( p_DEFAULT_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT1, p_DEFAULT_USAGE_WEIGHT1)
517: ,DEFAULT_USAGE_WEIGHT2 = decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT2, p_DEFAULT_USAGE_WEIGHT2)
518: ,DEFAULT_USAGE_WEIGHT3 = decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT3, p_DEFAULT_USAGE_WEIGHT3)
519: ,DEFAULT_USAGE_WEIGHT4 = decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT4, p_DEFAULT_USAGE_WEIGHT4)
520: ,DEFAULT_REC_RULE_ID = decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_REC_RULE_ID, p_DEFAULT_REC_RULE_ID)
521: ,OVERRIDE_FORECAST_RULE_ID = decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_FORECAST_RULE_ID, p_OVERRIDE_FORECAST_RULE_ID)
522: ,OVERRIDE_SERVICE_LEVEL = decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, OVERRIDE_SERVICE_LEVEL, p_OVERRIDE_SERVICE_LEVEL)
523: ,OVERRIDE_EDQ_FACTOR = decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, OVERRIDE_EDQ_FACTOR, p_OVERRIDE_EDQ_FACTOR)
524: ,OVERRIDE_PLANNER_CODE = decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, OVERRIDE_PLANNER_CODE, p_OVERRIDE_PLANNER_CODE)
517: ,DEFAULT_USAGE_WEIGHT2 = decode( p_DEFAULT_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT2, p_DEFAULT_USAGE_WEIGHT2)
518: ,DEFAULT_USAGE_WEIGHT3 = decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT3, p_DEFAULT_USAGE_WEIGHT3)
519: ,DEFAULT_USAGE_WEIGHT4 = decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT4, p_DEFAULT_USAGE_WEIGHT4)
520: ,DEFAULT_REC_RULE_ID = decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_REC_RULE_ID, p_DEFAULT_REC_RULE_ID)
521: ,OVERRIDE_FORECAST_RULE_ID = decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_FORECAST_RULE_ID, p_OVERRIDE_FORECAST_RULE_ID)
522: ,OVERRIDE_SERVICE_LEVEL = decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, OVERRIDE_SERVICE_LEVEL, p_OVERRIDE_SERVICE_LEVEL)
523: ,OVERRIDE_EDQ_FACTOR = decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, OVERRIDE_EDQ_FACTOR, p_OVERRIDE_EDQ_FACTOR)
524: ,OVERRIDE_PLANNER_CODE = decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, OVERRIDE_PLANNER_CODE, p_OVERRIDE_PLANNER_CODE)
525: ,OVERRIDE_CONDITION_TYPE = decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, OVERRIDE_CONDITION_TYPE, p_OVERRIDE_CONDITION_TYPE)
518: ,DEFAULT_USAGE_WEIGHT3 = decode( p_DEFAULT_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT3, p_DEFAULT_USAGE_WEIGHT3)
519: ,DEFAULT_USAGE_WEIGHT4 = decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT4, p_DEFAULT_USAGE_WEIGHT4)
520: ,DEFAULT_REC_RULE_ID = decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_REC_RULE_ID, p_DEFAULT_REC_RULE_ID)
521: ,OVERRIDE_FORECAST_RULE_ID = decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_FORECAST_RULE_ID, p_OVERRIDE_FORECAST_RULE_ID)
522: ,OVERRIDE_SERVICE_LEVEL = decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, OVERRIDE_SERVICE_LEVEL, p_OVERRIDE_SERVICE_LEVEL)
523: ,OVERRIDE_EDQ_FACTOR = decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, OVERRIDE_EDQ_FACTOR, p_OVERRIDE_EDQ_FACTOR)
524: ,OVERRIDE_PLANNER_CODE = decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, OVERRIDE_PLANNER_CODE, p_OVERRIDE_PLANNER_CODE)
525: ,OVERRIDE_CONDITION_TYPE = decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, OVERRIDE_CONDITION_TYPE, p_OVERRIDE_CONDITION_TYPE)
526: ,OVERRIDE_ASL_FLAG = decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_ASL_FLAG, p_OVERRIDE_ASL_FLAG)
519: ,DEFAULT_USAGE_WEIGHT4 = decode( p_DEFAULT_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, DEFAULT_USAGE_WEIGHT4, p_DEFAULT_USAGE_WEIGHT4)
520: ,DEFAULT_REC_RULE_ID = decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_REC_RULE_ID, p_DEFAULT_REC_RULE_ID)
521: ,OVERRIDE_FORECAST_RULE_ID = decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_FORECAST_RULE_ID, p_OVERRIDE_FORECAST_RULE_ID)
522: ,OVERRIDE_SERVICE_LEVEL = decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, OVERRIDE_SERVICE_LEVEL, p_OVERRIDE_SERVICE_LEVEL)
523: ,OVERRIDE_EDQ_FACTOR = decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, OVERRIDE_EDQ_FACTOR, p_OVERRIDE_EDQ_FACTOR)
524: ,OVERRIDE_PLANNER_CODE = decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, OVERRIDE_PLANNER_CODE, p_OVERRIDE_PLANNER_CODE)
525: ,OVERRIDE_CONDITION_TYPE = decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, OVERRIDE_CONDITION_TYPE, p_OVERRIDE_CONDITION_TYPE)
526: ,OVERRIDE_ASL_FLAG = decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_ASL_FLAG, p_OVERRIDE_ASL_FLAG)
527: ,OVERRIDE_SAFETY_STOCK_FLAG = decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_SAFETY_STOCK_FLAG, p_OVERRIDE_SAFETY_STOCK_FLAG)
520: ,DEFAULT_REC_RULE_ID = decode( p_DEFAULT_REC_RULE_ID, FND_API.G_MISS_CHAR, DEFAULT_REC_RULE_ID, p_DEFAULT_REC_RULE_ID)
521: ,OVERRIDE_FORECAST_RULE_ID = decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_FORECAST_RULE_ID, p_OVERRIDE_FORECAST_RULE_ID)
522: ,OVERRIDE_SERVICE_LEVEL = decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, OVERRIDE_SERVICE_LEVEL, p_OVERRIDE_SERVICE_LEVEL)
523: ,OVERRIDE_EDQ_FACTOR = decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, OVERRIDE_EDQ_FACTOR, p_OVERRIDE_EDQ_FACTOR)
524: ,OVERRIDE_PLANNER_CODE = decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, OVERRIDE_PLANNER_CODE, p_OVERRIDE_PLANNER_CODE)
525: ,OVERRIDE_CONDITION_TYPE = decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, OVERRIDE_CONDITION_TYPE, p_OVERRIDE_CONDITION_TYPE)
526: ,OVERRIDE_ASL_FLAG = decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_ASL_FLAG, p_OVERRIDE_ASL_FLAG)
527: ,OVERRIDE_SAFETY_STOCK_FLAG = decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_SAFETY_STOCK_FLAG, p_OVERRIDE_SAFETY_STOCK_FLAG)
528: ,OVERRIDE_EXCESS_RULE_ID = decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_EXCESS_RULE_ID, p_OVERRIDE_EXCESS_RULE_ID)
521: ,OVERRIDE_FORECAST_RULE_ID = decode( p_OVERRIDE_FORECAST_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_FORECAST_RULE_ID, p_OVERRIDE_FORECAST_RULE_ID)
522: ,OVERRIDE_SERVICE_LEVEL = decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, OVERRIDE_SERVICE_LEVEL, p_OVERRIDE_SERVICE_LEVEL)
523: ,OVERRIDE_EDQ_FACTOR = decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, OVERRIDE_EDQ_FACTOR, p_OVERRIDE_EDQ_FACTOR)
524: ,OVERRIDE_PLANNER_CODE = decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, OVERRIDE_PLANNER_CODE, p_OVERRIDE_PLANNER_CODE)
525: ,OVERRIDE_CONDITION_TYPE = decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, OVERRIDE_CONDITION_TYPE, p_OVERRIDE_CONDITION_TYPE)
526: ,OVERRIDE_ASL_FLAG = decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_ASL_FLAG, p_OVERRIDE_ASL_FLAG)
527: ,OVERRIDE_SAFETY_STOCK_FLAG = decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_SAFETY_STOCK_FLAG, p_OVERRIDE_SAFETY_STOCK_FLAG)
528: ,OVERRIDE_EXCESS_RULE_ID = decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_EXCESS_RULE_ID, p_OVERRIDE_EXCESS_RULE_ID)
529: ,OVERRIDE_CATEGORY_SET_ID = decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_SET_ID, p_OVERRIDE_CATEGORY_SET_ID)
522: ,OVERRIDE_SERVICE_LEVEL = decode( p_OVERRIDE_SERVICE_LEVEL, FND_API.G_MISS_CHAR, OVERRIDE_SERVICE_LEVEL, p_OVERRIDE_SERVICE_LEVEL)
523: ,OVERRIDE_EDQ_FACTOR = decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, OVERRIDE_EDQ_FACTOR, p_OVERRIDE_EDQ_FACTOR)
524: ,OVERRIDE_PLANNER_CODE = decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, OVERRIDE_PLANNER_CODE, p_OVERRIDE_PLANNER_CODE)
525: ,OVERRIDE_CONDITION_TYPE = decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, OVERRIDE_CONDITION_TYPE, p_OVERRIDE_CONDITION_TYPE)
526: ,OVERRIDE_ASL_FLAG = decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_ASL_FLAG, p_OVERRIDE_ASL_FLAG)
527: ,OVERRIDE_SAFETY_STOCK_FLAG = decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_SAFETY_STOCK_FLAG, p_OVERRIDE_SAFETY_STOCK_FLAG)
528: ,OVERRIDE_EXCESS_RULE_ID = decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_EXCESS_RULE_ID, p_OVERRIDE_EXCESS_RULE_ID)
529: ,OVERRIDE_CATEGORY_SET_ID = decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_SET_ID, p_OVERRIDE_CATEGORY_SET_ID)
530: ,OVERRIDE_CATEGORY_ID = decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_ID, p_OVERRIDE_CATEGORY_ID)
523: ,OVERRIDE_EDQ_FACTOR = decode( p_OVERRIDE_EDQ_FACTOR, FND_API.G_MISS_CHAR, OVERRIDE_EDQ_FACTOR, p_OVERRIDE_EDQ_FACTOR)
524: ,OVERRIDE_PLANNER_CODE = decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, OVERRIDE_PLANNER_CODE, p_OVERRIDE_PLANNER_CODE)
525: ,OVERRIDE_CONDITION_TYPE = decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, OVERRIDE_CONDITION_TYPE, p_OVERRIDE_CONDITION_TYPE)
526: ,OVERRIDE_ASL_FLAG = decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_ASL_FLAG, p_OVERRIDE_ASL_FLAG)
527: ,OVERRIDE_SAFETY_STOCK_FLAG = decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_SAFETY_STOCK_FLAG, p_OVERRIDE_SAFETY_STOCK_FLAG)
528: ,OVERRIDE_EXCESS_RULE_ID = decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_EXCESS_RULE_ID, p_OVERRIDE_EXCESS_RULE_ID)
529: ,OVERRIDE_CATEGORY_SET_ID = decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_SET_ID, p_OVERRIDE_CATEGORY_SET_ID)
530: ,OVERRIDE_CATEGORY_ID = decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_ID, p_OVERRIDE_CATEGORY_ID)
531: ,OVERRIDE_RECOMMEND_METHOD = decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, OVERRIDE_RECOMMEND_METHOD, p_OVERRIDE_RECOMMEND_METHOD)
524: ,OVERRIDE_PLANNER_CODE = decode( p_OVERRIDE_PLANNER_CODE, FND_API.G_MISS_CHAR, OVERRIDE_PLANNER_CODE, p_OVERRIDE_PLANNER_CODE)
525: ,OVERRIDE_CONDITION_TYPE = decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, OVERRIDE_CONDITION_TYPE, p_OVERRIDE_CONDITION_TYPE)
526: ,OVERRIDE_ASL_FLAG = decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_ASL_FLAG, p_OVERRIDE_ASL_FLAG)
527: ,OVERRIDE_SAFETY_STOCK_FLAG = decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_SAFETY_STOCK_FLAG, p_OVERRIDE_SAFETY_STOCK_FLAG)
528: ,OVERRIDE_EXCESS_RULE_ID = decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_EXCESS_RULE_ID, p_OVERRIDE_EXCESS_RULE_ID)
529: ,OVERRIDE_CATEGORY_SET_ID = decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_SET_ID, p_OVERRIDE_CATEGORY_SET_ID)
530: ,OVERRIDE_CATEGORY_ID = decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_ID, p_OVERRIDE_CATEGORY_ID)
531: ,OVERRIDE_RECOMMEND_METHOD = decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, OVERRIDE_RECOMMEND_METHOD, p_OVERRIDE_RECOMMEND_METHOD)
532: ,OVERRIDE_USAGE_WEIGHT1 = decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT1, p_OVERRIDE_USAGE_WEIGHT1)
525: ,OVERRIDE_CONDITION_TYPE = decode( p_OVERRIDE_CONDITION_TYPE, FND_API.G_MISS_CHAR, OVERRIDE_CONDITION_TYPE, p_OVERRIDE_CONDITION_TYPE)
526: ,OVERRIDE_ASL_FLAG = decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_ASL_FLAG, p_OVERRIDE_ASL_FLAG)
527: ,OVERRIDE_SAFETY_STOCK_FLAG = decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_SAFETY_STOCK_FLAG, p_OVERRIDE_SAFETY_STOCK_FLAG)
528: ,OVERRIDE_EXCESS_RULE_ID = decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_EXCESS_RULE_ID, p_OVERRIDE_EXCESS_RULE_ID)
529: ,OVERRIDE_CATEGORY_SET_ID = decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_SET_ID, p_OVERRIDE_CATEGORY_SET_ID)
530: ,OVERRIDE_CATEGORY_ID = decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_ID, p_OVERRIDE_CATEGORY_ID)
531: ,OVERRIDE_RECOMMEND_METHOD = decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, OVERRIDE_RECOMMEND_METHOD, p_OVERRIDE_RECOMMEND_METHOD)
532: ,OVERRIDE_USAGE_WEIGHT1 = decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT1, p_OVERRIDE_USAGE_WEIGHT1)
533: ,OVERRIDE_USAGE_WEIGHT2 = decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT2, p_OVERRIDE_USAGE_WEIGHT2)
526: ,OVERRIDE_ASL_FLAG = decode( p_OVERRIDE_ASL_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_ASL_FLAG, p_OVERRIDE_ASL_FLAG)
527: ,OVERRIDE_SAFETY_STOCK_FLAG = decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_SAFETY_STOCK_FLAG, p_OVERRIDE_SAFETY_STOCK_FLAG)
528: ,OVERRIDE_EXCESS_RULE_ID = decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_EXCESS_RULE_ID, p_OVERRIDE_EXCESS_RULE_ID)
529: ,OVERRIDE_CATEGORY_SET_ID = decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_SET_ID, p_OVERRIDE_CATEGORY_SET_ID)
530: ,OVERRIDE_CATEGORY_ID = decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_ID, p_OVERRIDE_CATEGORY_ID)
531: ,OVERRIDE_RECOMMEND_METHOD = decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, OVERRIDE_RECOMMEND_METHOD, p_OVERRIDE_RECOMMEND_METHOD)
532: ,OVERRIDE_USAGE_WEIGHT1 = decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT1, p_OVERRIDE_USAGE_WEIGHT1)
533: ,OVERRIDE_USAGE_WEIGHT2 = decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT2, p_OVERRIDE_USAGE_WEIGHT2)
534: ,OVERRIDE_USAGE_WEIGHT3 = decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT3, p_OVERRIDE_USAGE_WEIGHT3)
527: ,OVERRIDE_SAFETY_STOCK_FLAG = decode( p_OVERRIDE_SAFETY_STOCK_FLAG, FND_API.G_MISS_CHAR, OVERRIDE_SAFETY_STOCK_FLAG, p_OVERRIDE_SAFETY_STOCK_FLAG)
528: ,OVERRIDE_EXCESS_RULE_ID = decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_EXCESS_RULE_ID, p_OVERRIDE_EXCESS_RULE_ID)
529: ,OVERRIDE_CATEGORY_SET_ID = decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_SET_ID, p_OVERRIDE_CATEGORY_SET_ID)
530: ,OVERRIDE_CATEGORY_ID = decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_ID, p_OVERRIDE_CATEGORY_ID)
531: ,OVERRIDE_RECOMMEND_METHOD = decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, OVERRIDE_RECOMMEND_METHOD, p_OVERRIDE_RECOMMEND_METHOD)
532: ,OVERRIDE_USAGE_WEIGHT1 = decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT1, p_OVERRIDE_USAGE_WEIGHT1)
533: ,OVERRIDE_USAGE_WEIGHT2 = decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT2, p_OVERRIDE_USAGE_WEIGHT2)
534: ,OVERRIDE_USAGE_WEIGHT3 = decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT3, p_OVERRIDE_USAGE_WEIGHT3)
535: ,OVERRIDE_USAGE_WEIGHT4 = decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT4, p_OVERRIDE_USAGE_WEIGHT4)
528: ,OVERRIDE_EXCESS_RULE_ID = decode( p_OVERRIDE_EXCESS_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_EXCESS_RULE_ID, p_OVERRIDE_EXCESS_RULE_ID)
529: ,OVERRIDE_CATEGORY_SET_ID = decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_SET_ID, p_OVERRIDE_CATEGORY_SET_ID)
530: ,OVERRIDE_CATEGORY_ID = decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_ID, p_OVERRIDE_CATEGORY_ID)
531: ,OVERRIDE_RECOMMEND_METHOD = decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, OVERRIDE_RECOMMEND_METHOD, p_OVERRIDE_RECOMMEND_METHOD)
532: ,OVERRIDE_USAGE_WEIGHT1 = decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT1, p_OVERRIDE_USAGE_WEIGHT1)
533: ,OVERRIDE_USAGE_WEIGHT2 = decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT2, p_OVERRIDE_USAGE_WEIGHT2)
534: ,OVERRIDE_USAGE_WEIGHT3 = decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT3, p_OVERRIDE_USAGE_WEIGHT3)
535: ,OVERRIDE_USAGE_WEIGHT4 = decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT4, p_OVERRIDE_USAGE_WEIGHT4)
536: ,OVERRIDE_REC_RULE_ID = decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_REC_RULE_ID, p_OVERRIDE_REC_RULE_ID)
529: ,OVERRIDE_CATEGORY_SET_ID = decode( p_OVERRIDE_CATEGORY_SET_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_SET_ID, p_OVERRIDE_CATEGORY_SET_ID)
530: ,OVERRIDE_CATEGORY_ID = decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_ID, p_OVERRIDE_CATEGORY_ID)
531: ,OVERRIDE_RECOMMEND_METHOD = decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, OVERRIDE_RECOMMEND_METHOD, p_OVERRIDE_RECOMMEND_METHOD)
532: ,OVERRIDE_USAGE_WEIGHT1 = decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT1, p_OVERRIDE_USAGE_WEIGHT1)
533: ,OVERRIDE_USAGE_WEIGHT2 = decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT2, p_OVERRIDE_USAGE_WEIGHT2)
534: ,OVERRIDE_USAGE_WEIGHT3 = decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT3, p_OVERRIDE_USAGE_WEIGHT3)
535: ,OVERRIDE_USAGE_WEIGHT4 = decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT4, p_OVERRIDE_USAGE_WEIGHT4)
536: ,OVERRIDE_REC_RULE_ID = decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_REC_RULE_ID, p_OVERRIDE_REC_RULE_ID)
537: ,NODE_TYPE = decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NODE_TYPE, p_NODE_TYPE)
530: ,OVERRIDE_CATEGORY_ID = decode( p_OVERRIDE_CATEGORY_ID, FND_API.G_MISS_CHAR, OVERRIDE_CATEGORY_ID, p_OVERRIDE_CATEGORY_ID)
531: ,OVERRIDE_RECOMMEND_METHOD = decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, OVERRIDE_RECOMMEND_METHOD, p_OVERRIDE_RECOMMEND_METHOD)
532: ,OVERRIDE_USAGE_WEIGHT1 = decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT1, p_OVERRIDE_USAGE_WEIGHT1)
533: ,OVERRIDE_USAGE_WEIGHT2 = decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT2, p_OVERRIDE_USAGE_WEIGHT2)
534: ,OVERRIDE_USAGE_WEIGHT3 = decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT3, p_OVERRIDE_USAGE_WEIGHT3)
535: ,OVERRIDE_USAGE_WEIGHT4 = decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT4, p_OVERRIDE_USAGE_WEIGHT4)
536: ,OVERRIDE_REC_RULE_ID = decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_REC_RULE_ID, p_OVERRIDE_REC_RULE_ID)
537: ,NODE_TYPE = decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NODE_TYPE, p_NODE_TYPE)
538: ,NODE_NAME = decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NODE_NAME, p_NODE_NAME)
531: ,OVERRIDE_RECOMMEND_METHOD = decode( p_OVERRIDE_RECOMMEND_METHOD, FND_API.G_MISS_CHAR, OVERRIDE_RECOMMEND_METHOD, p_OVERRIDE_RECOMMEND_METHOD)
532: ,OVERRIDE_USAGE_WEIGHT1 = decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT1, p_OVERRIDE_USAGE_WEIGHT1)
533: ,OVERRIDE_USAGE_WEIGHT2 = decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT2, p_OVERRIDE_USAGE_WEIGHT2)
534: ,OVERRIDE_USAGE_WEIGHT3 = decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT3, p_OVERRIDE_USAGE_WEIGHT3)
535: ,OVERRIDE_USAGE_WEIGHT4 = decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT4, p_OVERRIDE_USAGE_WEIGHT4)
536: ,OVERRIDE_REC_RULE_ID = decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_REC_RULE_ID, p_OVERRIDE_REC_RULE_ID)
537: ,NODE_TYPE = decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NODE_TYPE, p_NODE_TYPE)
538: ,NODE_NAME = decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NODE_NAME, p_NODE_NAME)
539: ,PARENT_NODE_ID = decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, PARENT_NODE_ID, p_PARENT_NODE_ID)
532: ,OVERRIDE_USAGE_WEIGHT1 = decode( p_OVERRIDE_USAGE_WEIGHT1, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT1, p_OVERRIDE_USAGE_WEIGHT1)
533: ,OVERRIDE_USAGE_WEIGHT2 = decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT2, p_OVERRIDE_USAGE_WEIGHT2)
534: ,OVERRIDE_USAGE_WEIGHT3 = decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT3, p_OVERRIDE_USAGE_WEIGHT3)
535: ,OVERRIDE_USAGE_WEIGHT4 = decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT4, p_OVERRIDE_USAGE_WEIGHT4)
536: ,OVERRIDE_REC_RULE_ID = decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_REC_RULE_ID, p_OVERRIDE_REC_RULE_ID)
537: ,NODE_TYPE = decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NODE_TYPE, p_NODE_TYPE)
538: ,NODE_NAME = decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NODE_NAME, p_NODE_NAME)
539: ,PARENT_NODE_ID = decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, PARENT_NODE_ID, p_PARENT_NODE_ID)
540: ,EXCESS_EDQ_FACTOR = decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, EXCESS_EDQ_FACTOR, p_EXCESS_EDQ_FACTOR)
533: ,OVERRIDE_USAGE_WEIGHT2 = decode( p_OVERRIDE_USAGE_WEIGHT2, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT2, p_OVERRIDE_USAGE_WEIGHT2)
534: ,OVERRIDE_USAGE_WEIGHT3 = decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT3, p_OVERRIDE_USAGE_WEIGHT3)
535: ,OVERRIDE_USAGE_WEIGHT4 = decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT4, p_OVERRIDE_USAGE_WEIGHT4)
536: ,OVERRIDE_REC_RULE_ID = decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_REC_RULE_ID, p_OVERRIDE_REC_RULE_ID)
537: ,NODE_TYPE = decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NODE_TYPE, p_NODE_TYPE)
538: ,NODE_NAME = decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NODE_NAME, p_NODE_NAME)
539: ,PARENT_NODE_ID = decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, PARENT_NODE_ID, p_PARENT_NODE_ID)
540: ,EXCESS_EDQ_FACTOR = decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, EXCESS_EDQ_FACTOR, p_EXCESS_EDQ_FACTOR)
541: ,REPAIR_EDQ_FACTOR = decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, REPAIR_EDQ_FACTOR, p_REPAIR_EDQ_FACTOR)
534: ,OVERRIDE_USAGE_WEIGHT3 = decode( p_OVERRIDE_USAGE_WEIGHT3, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT3, p_OVERRIDE_USAGE_WEIGHT3)
535: ,OVERRIDE_USAGE_WEIGHT4 = decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT4, p_OVERRIDE_USAGE_WEIGHT4)
536: ,OVERRIDE_REC_RULE_ID = decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_REC_RULE_ID, p_OVERRIDE_REC_RULE_ID)
537: ,NODE_TYPE = decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NODE_TYPE, p_NODE_TYPE)
538: ,NODE_NAME = decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NODE_NAME, p_NODE_NAME)
539: ,PARENT_NODE_ID = decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, PARENT_NODE_ID, p_PARENT_NODE_ID)
540: ,EXCESS_EDQ_FACTOR = decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, EXCESS_EDQ_FACTOR, p_EXCESS_EDQ_FACTOR)
541: ,REPAIR_EDQ_FACTOR = decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, REPAIR_EDQ_FACTOR, p_REPAIR_EDQ_FACTOR)
542: ,NEWBUY_EDQ_FACTOR = decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NEWBUY_EDQ_FACTOR, p_NEWBUY_EDQ_FACTOR)
535: ,OVERRIDE_USAGE_WEIGHT4 = decode( p_OVERRIDE_USAGE_WEIGHT4, FND_API.G_MISS_CHAR, OVERRIDE_USAGE_WEIGHT4, p_OVERRIDE_USAGE_WEIGHT4)
536: ,OVERRIDE_REC_RULE_ID = decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_REC_RULE_ID, p_OVERRIDE_REC_RULE_ID)
537: ,NODE_TYPE = decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NODE_TYPE, p_NODE_TYPE)
538: ,NODE_NAME = decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NODE_NAME, p_NODE_NAME)
539: ,PARENT_NODE_ID = decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, PARENT_NODE_ID, p_PARENT_NODE_ID)
540: ,EXCESS_EDQ_FACTOR = decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, EXCESS_EDQ_FACTOR, p_EXCESS_EDQ_FACTOR)
541: ,REPAIR_EDQ_FACTOR = decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, REPAIR_EDQ_FACTOR, p_REPAIR_EDQ_FACTOR)
542: ,NEWBUY_EDQ_FACTOR = decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NEWBUY_EDQ_FACTOR, p_NEWBUY_EDQ_FACTOR)
543: ,EXCESS_SERVICE_LEVEL = decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, EXCESS_SERVICE_LEVEL, p_EXCESS_SERVICE_LEVEL)
536: ,OVERRIDE_REC_RULE_ID = decode( p_OVERRIDE_REC_RULE_ID, FND_API.G_MISS_CHAR, OVERRIDE_REC_RULE_ID, p_OVERRIDE_REC_RULE_ID)
537: ,NODE_TYPE = decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NODE_TYPE, p_NODE_TYPE)
538: ,NODE_NAME = decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NODE_NAME, p_NODE_NAME)
539: ,PARENT_NODE_ID = decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, PARENT_NODE_ID, p_PARENT_NODE_ID)
540: ,EXCESS_EDQ_FACTOR = decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, EXCESS_EDQ_FACTOR, p_EXCESS_EDQ_FACTOR)
541: ,REPAIR_EDQ_FACTOR = decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, REPAIR_EDQ_FACTOR, p_REPAIR_EDQ_FACTOR)
542: ,NEWBUY_EDQ_FACTOR = decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NEWBUY_EDQ_FACTOR, p_NEWBUY_EDQ_FACTOR)
543: ,EXCESS_SERVICE_LEVEL = decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, EXCESS_SERVICE_LEVEL, p_EXCESS_SERVICE_LEVEL)
544: ,REPAIR_SERVICE_LEVEL = decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, REPAIR_SERVICE_LEVEL, p_REPAIR_SERVICE_LEVEL)
537: ,NODE_TYPE = decode( p_NODE_TYPE, FND_API.G_MISS_CHAR, NODE_TYPE, p_NODE_TYPE)
538: ,NODE_NAME = decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NODE_NAME, p_NODE_NAME)
539: ,PARENT_NODE_ID = decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, PARENT_NODE_ID, p_PARENT_NODE_ID)
540: ,EXCESS_EDQ_FACTOR = decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, EXCESS_EDQ_FACTOR, p_EXCESS_EDQ_FACTOR)
541: ,REPAIR_EDQ_FACTOR = decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, REPAIR_EDQ_FACTOR, p_REPAIR_EDQ_FACTOR)
542: ,NEWBUY_EDQ_FACTOR = decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NEWBUY_EDQ_FACTOR, p_NEWBUY_EDQ_FACTOR)
543: ,EXCESS_SERVICE_LEVEL = decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, EXCESS_SERVICE_LEVEL, p_EXCESS_SERVICE_LEVEL)
544: ,REPAIR_SERVICE_LEVEL = decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, REPAIR_SERVICE_LEVEL, p_REPAIR_SERVICE_LEVEL)
545: ,NEWBUY_SERVICE_LEVEL = decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NEWBUY_SERVICE_LEVEL, p_NEWBUY_SERVICE_LEVEL)
538: ,NODE_NAME = decode( p_NODE_NAME, FND_API.G_MISS_CHAR, NODE_NAME, p_NODE_NAME)
539: ,PARENT_NODE_ID = decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, PARENT_NODE_ID, p_PARENT_NODE_ID)
540: ,EXCESS_EDQ_FACTOR = decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, EXCESS_EDQ_FACTOR, p_EXCESS_EDQ_FACTOR)
541: ,REPAIR_EDQ_FACTOR = decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, REPAIR_EDQ_FACTOR, p_REPAIR_EDQ_FACTOR)
542: ,NEWBUY_EDQ_FACTOR = decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NEWBUY_EDQ_FACTOR, p_NEWBUY_EDQ_FACTOR)
543: ,EXCESS_SERVICE_LEVEL = decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, EXCESS_SERVICE_LEVEL, p_EXCESS_SERVICE_LEVEL)
544: ,REPAIR_SERVICE_LEVEL = decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, REPAIR_SERVICE_LEVEL, p_REPAIR_SERVICE_LEVEL)
545: ,NEWBUY_SERVICE_LEVEL = decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NEWBUY_SERVICE_LEVEL, p_NEWBUY_SERVICE_LEVEL)
546: ,RESCHEDULE_RULE_ID = decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_NUM, RESCHEDULE_RULE_ID, p_RESCHEDULE_RULE_ID)
539: ,PARENT_NODE_ID = decode( p_PARENT_NODE_ID, FND_API.G_MISS_NUM, PARENT_NODE_ID, p_PARENT_NODE_ID)
540: ,EXCESS_EDQ_FACTOR = decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, EXCESS_EDQ_FACTOR, p_EXCESS_EDQ_FACTOR)
541: ,REPAIR_EDQ_FACTOR = decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, REPAIR_EDQ_FACTOR, p_REPAIR_EDQ_FACTOR)
542: ,NEWBUY_EDQ_FACTOR = decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NEWBUY_EDQ_FACTOR, p_NEWBUY_EDQ_FACTOR)
543: ,EXCESS_SERVICE_LEVEL = decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, EXCESS_SERVICE_LEVEL, p_EXCESS_SERVICE_LEVEL)
544: ,REPAIR_SERVICE_LEVEL = decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, REPAIR_SERVICE_LEVEL, p_REPAIR_SERVICE_LEVEL)
545: ,NEWBUY_SERVICE_LEVEL = decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NEWBUY_SERVICE_LEVEL, p_NEWBUY_SERVICE_LEVEL)
546: ,RESCHEDULE_RULE_ID = decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_NUM, RESCHEDULE_RULE_ID, p_RESCHEDULE_RULE_ID)
547: ,WRP_RULE_ID = decode( p_WRP_RULE_ID, FND_API.G_MISS_NUM, WRP_RULE_ID, p_WRP_RULE_ID)
540: ,EXCESS_EDQ_FACTOR = decode( p_EXCESS_EDQ_FACTOR, FND_API.G_MISS_CHAR, EXCESS_EDQ_FACTOR, p_EXCESS_EDQ_FACTOR)
541: ,REPAIR_EDQ_FACTOR = decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, REPAIR_EDQ_FACTOR, p_REPAIR_EDQ_FACTOR)
542: ,NEWBUY_EDQ_FACTOR = decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NEWBUY_EDQ_FACTOR, p_NEWBUY_EDQ_FACTOR)
543: ,EXCESS_SERVICE_LEVEL = decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, EXCESS_SERVICE_LEVEL, p_EXCESS_SERVICE_LEVEL)
544: ,REPAIR_SERVICE_LEVEL = decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, REPAIR_SERVICE_LEVEL, p_REPAIR_SERVICE_LEVEL)
545: ,NEWBUY_SERVICE_LEVEL = decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NEWBUY_SERVICE_LEVEL, p_NEWBUY_SERVICE_LEVEL)
546: ,RESCHEDULE_RULE_ID = decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_NUM, RESCHEDULE_RULE_ID, p_RESCHEDULE_RULE_ID)
547: ,WRP_RULE_ID = decode( p_WRP_RULE_ID, FND_API.G_MISS_NUM, WRP_RULE_ID, p_WRP_RULE_ID)
548: ,STOCKING_SITE_TYPE = decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, STOCKING_SITE_TYPE, P_STOCKING_SITE_TYPE)
541: ,REPAIR_EDQ_FACTOR = decode( p_REPAIR_EDQ_FACTOR, FND_API.G_MISS_CHAR, REPAIR_EDQ_FACTOR, p_REPAIR_EDQ_FACTOR)
542: ,NEWBUY_EDQ_FACTOR = decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NEWBUY_EDQ_FACTOR, p_NEWBUY_EDQ_FACTOR)
543: ,EXCESS_SERVICE_LEVEL = decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, EXCESS_SERVICE_LEVEL, p_EXCESS_SERVICE_LEVEL)
544: ,REPAIR_SERVICE_LEVEL = decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, REPAIR_SERVICE_LEVEL, p_REPAIR_SERVICE_LEVEL)
545: ,NEWBUY_SERVICE_LEVEL = decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NEWBUY_SERVICE_LEVEL, p_NEWBUY_SERVICE_LEVEL)
546: ,RESCHEDULE_RULE_ID = decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_NUM, RESCHEDULE_RULE_ID, p_RESCHEDULE_RULE_ID)
547: ,WRP_RULE_ID = decode( p_WRP_RULE_ID, FND_API.G_MISS_NUM, WRP_RULE_ID, p_WRP_RULE_ID)
548: ,STOCKING_SITE_TYPE = decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, STOCKING_SITE_TYPE, P_STOCKING_SITE_TYPE)
549: ,CALENDAR_ID = decode( P_CALENDAR_ID , FND_API.G_MISS_NUM, CALENDAR_ID , P_CALENDAR_ID )
542: ,NEWBUY_EDQ_FACTOR = decode( p_NEWBUY_EDQ_FACTOR, FND_API.G_MISS_CHAR, NEWBUY_EDQ_FACTOR, p_NEWBUY_EDQ_FACTOR)
543: ,EXCESS_SERVICE_LEVEL = decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, EXCESS_SERVICE_LEVEL, p_EXCESS_SERVICE_LEVEL)
544: ,REPAIR_SERVICE_LEVEL = decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, REPAIR_SERVICE_LEVEL, p_REPAIR_SERVICE_LEVEL)
545: ,NEWBUY_SERVICE_LEVEL = decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NEWBUY_SERVICE_LEVEL, p_NEWBUY_SERVICE_LEVEL)
546: ,RESCHEDULE_RULE_ID = decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_NUM, RESCHEDULE_RULE_ID, p_RESCHEDULE_RULE_ID)
547: ,WRP_RULE_ID = decode( p_WRP_RULE_ID, FND_API.G_MISS_NUM, WRP_RULE_ID, p_WRP_RULE_ID)
548: ,STOCKING_SITE_TYPE = decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, STOCKING_SITE_TYPE, P_STOCKING_SITE_TYPE)
549: ,CALENDAR_ID = decode( P_CALENDAR_ID , FND_API.G_MISS_NUM, CALENDAR_ID , P_CALENDAR_ID )
550: ,TIMEZONE_ID = decode( P_TIMEZONE_ID , FND_API.G_MISS_NUM, TIMEZONE_ID , P_TIMEZONE_ID )
543: ,EXCESS_SERVICE_LEVEL = decode( p_EXCESS_SERVICE_LEVEL, FND_API.G_MISS_CHAR, EXCESS_SERVICE_LEVEL, p_EXCESS_SERVICE_LEVEL)
544: ,REPAIR_SERVICE_LEVEL = decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, REPAIR_SERVICE_LEVEL, p_REPAIR_SERVICE_LEVEL)
545: ,NEWBUY_SERVICE_LEVEL = decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NEWBUY_SERVICE_LEVEL, p_NEWBUY_SERVICE_LEVEL)
546: ,RESCHEDULE_RULE_ID = decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_NUM, RESCHEDULE_RULE_ID, p_RESCHEDULE_RULE_ID)
547: ,WRP_RULE_ID = decode( p_WRP_RULE_ID, FND_API.G_MISS_NUM, WRP_RULE_ID, p_WRP_RULE_ID)
548: ,STOCKING_SITE_TYPE = decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, STOCKING_SITE_TYPE, P_STOCKING_SITE_TYPE)
549: ,CALENDAR_ID = decode( P_CALENDAR_ID , FND_API.G_MISS_NUM, CALENDAR_ID , P_CALENDAR_ID )
550: ,TIMEZONE_ID = decode( P_TIMEZONE_ID , FND_API.G_MISS_NUM, TIMEZONE_ID , P_TIMEZONE_ID )
551: ,MANAGED_BY = decode( P_MANAGED_BY , FND_API.G_MISS_CHAR, MANAGED_BY , P_MANAGED_BY )
544: ,REPAIR_SERVICE_LEVEL = decode( p_REPAIR_SERVICE_LEVEL, FND_API.G_MISS_CHAR, REPAIR_SERVICE_LEVEL, p_REPAIR_SERVICE_LEVEL)
545: ,NEWBUY_SERVICE_LEVEL = decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NEWBUY_SERVICE_LEVEL, p_NEWBUY_SERVICE_LEVEL)
546: ,RESCHEDULE_RULE_ID = decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_NUM, RESCHEDULE_RULE_ID, p_RESCHEDULE_RULE_ID)
547: ,WRP_RULE_ID = decode( p_WRP_RULE_ID, FND_API.G_MISS_NUM, WRP_RULE_ID, p_WRP_RULE_ID)
548: ,STOCKING_SITE_TYPE = decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, STOCKING_SITE_TYPE, P_STOCKING_SITE_TYPE)
549: ,CALENDAR_ID = decode( P_CALENDAR_ID , FND_API.G_MISS_NUM, CALENDAR_ID , P_CALENDAR_ID )
550: ,TIMEZONE_ID = decode( P_TIMEZONE_ID , FND_API.G_MISS_NUM, TIMEZONE_ID , P_TIMEZONE_ID )
551: ,MANAGED_BY = decode( P_MANAGED_BY , FND_API.G_MISS_CHAR, MANAGED_BY , P_MANAGED_BY )
552: ,CONTACT_NAME = decode(P_CONTACT_NAME , FND_API.G_MISS_CHAR, CONTACT_NAME , P_CONTACT_NAME )
545: ,NEWBUY_SERVICE_LEVEL = decode( p_NEWBUY_SERVICE_LEVEL, FND_API.G_MISS_CHAR, NEWBUY_SERVICE_LEVEL, p_NEWBUY_SERVICE_LEVEL)
546: ,RESCHEDULE_RULE_ID = decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_NUM, RESCHEDULE_RULE_ID, p_RESCHEDULE_RULE_ID)
547: ,WRP_RULE_ID = decode( p_WRP_RULE_ID, FND_API.G_MISS_NUM, WRP_RULE_ID, p_WRP_RULE_ID)
548: ,STOCKING_SITE_TYPE = decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, STOCKING_SITE_TYPE, P_STOCKING_SITE_TYPE)
549: ,CALENDAR_ID = decode( P_CALENDAR_ID , FND_API.G_MISS_NUM, CALENDAR_ID , P_CALENDAR_ID )
550: ,TIMEZONE_ID = decode( P_TIMEZONE_ID , FND_API.G_MISS_NUM, TIMEZONE_ID , P_TIMEZONE_ID )
551: ,MANAGED_BY = decode( P_MANAGED_BY , FND_API.G_MISS_CHAR, MANAGED_BY , P_MANAGED_BY )
552: ,CONTACT_NAME = decode(P_CONTACT_NAME , FND_API.G_MISS_CHAR, CONTACT_NAME , P_CONTACT_NAME )
553: ,CONTACT_PHONE = decode(P_CONTACT_PHONE , FND_API.G_MISS_CHAR,CONTACT_PHONE ,P_CONTACT_PHONE )
546: ,RESCHEDULE_RULE_ID = decode( p_RESCHEDULE_RULE_ID, FND_API.G_MISS_NUM, RESCHEDULE_RULE_ID, p_RESCHEDULE_RULE_ID)
547: ,WRP_RULE_ID = decode( p_WRP_RULE_ID, FND_API.G_MISS_NUM, WRP_RULE_ID, p_WRP_RULE_ID)
548: ,STOCKING_SITE_TYPE = decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, STOCKING_SITE_TYPE, P_STOCKING_SITE_TYPE)
549: ,CALENDAR_ID = decode( P_CALENDAR_ID , FND_API.G_MISS_NUM, CALENDAR_ID , P_CALENDAR_ID )
550: ,TIMEZONE_ID = decode( P_TIMEZONE_ID , FND_API.G_MISS_NUM, TIMEZONE_ID , P_TIMEZONE_ID )
551: ,MANAGED_BY = decode( P_MANAGED_BY , FND_API.G_MISS_CHAR, MANAGED_BY , P_MANAGED_BY )
552: ,CONTACT_NAME = decode(P_CONTACT_NAME , FND_API.G_MISS_CHAR, CONTACT_NAME , P_CONTACT_NAME )
553: ,CONTACT_PHONE = decode(P_CONTACT_PHONE , FND_API.G_MISS_CHAR,CONTACT_PHONE ,P_CONTACT_PHONE )
554: ,AH_CONTACT_NAME = decode(P_AH_CONTACT_NAME , FND_API.G_MISS_CHAR, AH_CONTACT_NAME , P_AH_CONTACT_NAME )
547: ,WRP_RULE_ID = decode( p_WRP_RULE_ID, FND_API.G_MISS_NUM, WRP_RULE_ID, p_WRP_RULE_ID)
548: ,STOCKING_SITE_TYPE = decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, STOCKING_SITE_TYPE, P_STOCKING_SITE_TYPE)
549: ,CALENDAR_ID = decode( P_CALENDAR_ID , FND_API.G_MISS_NUM, CALENDAR_ID , P_CALENDAR_ID )
550: ,TIMEZONE_ID = decode( P_TIMEZONE_ID , FND_API.G_MISS_NUM, TIMEZONE_ID , P_TIMEZONE_ID )
551: ,MANAGED_BY = decode( P_MANAGED_BY , FND_API.G_MISS_CHAR, MANAGED_BY , P_MANAGED_BY )
552: ,CONTACT_NAME = decode(P_CONTACT_NAME , FND_API.G_MISS_CHAR, CONTACT_NAME , P_CONTACT_NAME )
553: ,CONTACT_PHONE = decode(P_CONTACT_PHONE , FND_API.G_MISS_CHAR,CONTACT_PHONE ,P_CONTACT_PHONE )
554: ,AH_CONTACT_NAME = decode(P_AH_CONTACT_NAME , FND_API.G_MISS_CHAR, AH_CONTACT_NAME , P_AH_CONTACT_NAME )
555: ,AH_CONTACT_PHONE = decode(P_AH_CONTACT_PHONE , FND_API.G_MISS_CHAR, AH_CONTACT_PHONE , P_AH_CONTACT_PHONE )
548: ,STOCKING_SITE_TYPE = decode( P_STOCKING_SITE_TYPE, FND_API.G_MISS_CHAR, STOCKING_SITE_TYPE, P_STOCKING_SITE_TYPE)
549: ,CALENDAR_ID = decode( P_CALENDAR_ID , FND_API.G_MISS_NUM, CALENDAR_ID , P_CALENDAR_ID )
550: ,TIMEZONE_ID = decode( P_TIMEZONE_ID , FND_API.G_MISS_NUM, TIMEZONE_ID , P_TIMEZONE_ID )
551: ,MANAGED_BY = decode( P_MANAGED_BY , FND_API.G_MISS_CHAR, MANAGED_BY , P_MANAGED_BY )
552: ,CONTACT_NAME = decode(P_CONTACT_NAME , FND_API.G_MISS_CHAR, CONTACT_NAME , P_CONTACT_NAME )
553: ,CONTACT_PHONE = decode(P_CONTACT_PHONE , FND_API.G_MISS_CHAR,CONTACT_PHONE ,P_CONTACT_PHONE )
554: ,AH_CONTACT_NAME = decode(P_AH_CONTACT_NAME , FND_API.G_MISS_CHAR, AH_CONTACT_NAME , P_AH_CONTACT_NAME )
555: ,AH_CONTACT_PHONE = decode(P_AH_CONTACT_PHONE , FND_API.G_MISS_CHAR, AH_CONTACT_PHONE , P_AH_CONTACT_PHONE )
556: ,STOCKING_SITE_EXCL = decode( P_STOCKING_SITE_EXCL , FND_API.G_MISS_CHAR, STOCKING_SITE_EXCL , P_STOCKING_SITE_EXCL )
549: ,CALENDAR_ID = decode( P_CALENDAR_ID , FND_API.G_MISS_NUM, CALENDAR_ID , P_CALENDAR_ID )
550: ,TIMEZONE_ID = decode( P_TIMEZONE_ID , FND_API.G_MISS_NUM, TIMEZONE_ID , P_TIMEZONE_ID )
551: ,MANAGED_BY = decode( P_MANAGED_BY , FND_API.G_MISS_CHAR, MANAGED_BY , P_MANAGED_BY )
552: ,CONTACT_NAME = decode(P_CONTACT_NAME , FND_API.G_MISS_CHAR, CONTACT_NAME , P_CONTACT_NAME )
553: ,CONTACT_PHONE = decode(P_CONTACT_PHONE , FND_API.G_MISS_CHAR,CONTACT_PHONE ,P_CONTACT_PHONE )
554: ,AH_CONTACT_NAME = decode(P_AH_CONTACT_NAME , FND_API.G_MISS_CHAR, AH_CONTACT_NAME , P_AH_CONTACT_NAME )
555: ,AH_CONTACT_PHONE = decode(P_AH_CONTACT_PHONE , FND_API.G_MISS_CHAR, AH_CONTACT_PHONE , P_AH_CONTACT_PHONE )
556: ,STOCKING_SITE_EXCL = decode( P_STOCKING_SITE_EXCL , FND_API.G_MISS_CHAR, STOCKING_SITE_EXCL , P_STOCKING_SITE_EXCL )
557: ,SPECIAL_INSTRUCTIONS = decode(P_SPECIAL_INSTRUCTIONS , FND_API.G_MISS_CHAR, SPECIAL_INSTRUCTIONS , P_SPECIAL_INSTRUCTIONS )
550: ,TIMEZONE_ID = decode( P_TIMEZONE_ID , FND_API.G_MISS_NUM, TIMEZONE_ID , P_TIMEZONE_ID )
551: ,MANAGED_BY = decode( P_MANAGED_BY , FND_API.G_MISS_CHAR, MANAGED_BY , P_MANAGED_BY )
552: ,CONTACT_NAME = decode(P_CONTACT_NAME , FND_API.G_MISS_CHAR, CONTACT_NAME , P_CONTACT_NAME )
553: ,CONTACT_PHONE = decode(P_CONTACT_PHONE , FND_API.G_MISS_CHAR,CONTACT_PHONE ,P_CONTACT_PHONE )
554: ,AH_CONTACT_NAME = decode(P_AH_CONTACT_NAME , FND_API.G_MISS_CHAR, AH_CONTACT_NAME , P_AH_CONTACT_NAME )
555: ,AH_CONTACT_PHONE = decode(P_AH_CONTACT_PHONE , FND_API.G_MISS_CHAR, AH_CONTACT_PHONE , P_AH_CONTACT_PHONE )
556: ,STOCKING_SITE_EXCL = decode( P_STOCKING_SITE_EXCL , FND_API.G_MISS_CHAR, STOCKING_SITE_EXCL , P_STOCKING_SITE_EXCL )
557: ,SPECIAL_INSTRUCTIONS = decode(P_SPECIAL_INSTRUCTIONS , FND_API.G_MISS_CHAR, SPECIAL_INSTRUCTIONS , P_SPECIAL_INSTRUCTIONS )
558: ,HZ_LOCATION_ID = decode(P_HZ_LOCATION_ID , FND_API.G_MISS_NUM, HZ_LOCATION_ID , P_HZ_LOCATION_ID )
551: ,MANAGED_BY = decode( P_MANAGED_BY , FND_API.G_MISS_CHAR, MANAGED_BY , P_MANAGED_BY )
552: ,CONTACT_NAME = decode(P_CONTACT_NAME , FND_API.G_MISS_CHAR, CONTACT_NAME , P_CONTACT_NAME )
553: ,CONTACT_PHONE = decode(P_CONTACT_PHONE , FND_API.G_MISS_CHAR,CONTACT_PHONE ,P_CONTACT_PHONE )
554: ,AH_CONTACT_NAME = decode(P_AH_CONTACT_NAME , FND_API.G_MISS_CHAR, AH_CONTACT_NAME , P_AH_CONTACT_NAME )
555: ,AH_CONTACT_PHONE = decode(P_AH_CONTACT_PHONE , FND_API.G_MISS_CHAR, AH_CONTACT_PHONE , P_AH_CONTACT_PHONE )
556: ,STOCKING_SITE_EXCL = decode( P_STOCKING_SITE_EXCL , FND_API.G_MISS_CHAR, STOCKING_SITE_EXCL , P_STOCKING_SITE_EXCL )
557: ,SPECIAL_INSTRUCTIONS = decode(P_SPECIAL_INSTRUCTIONS , FND_API.G_MISS_CHAR, SPECIAL_INSTRUCTIONS , P_SPECIAL_INSTRUCTIONS )
558: ,HZ_LOCATION_ID = decode(P_HZ_LOCATION_ID , FND_API.G_MISS_NUM, HZ_LOCATION_ID , P_HZ_LOCATION_ID )
559:
552: ,CONTACT_NAME = decode(P_CONTACT_NAME , FND_API.G_MISS_CHAR, CONTACT_NAME , P_CONTACT_NAME )
553: ,CONTACT_PHONE = decode(P_CONTACT_PHONE , FND_API.G_MISS_CHAR,CONTACT_PHONE ,P_CONTACT_PHONE )
554: ,AH_CONTACT_NAME = decode(P_AH_CONTACT_NAME , FND_API.G_MISS_CHAR, AH_CONTACT_NAME , P_AH_CONTACT_NAME )
555: ,AH_CONTACT_PHONE = decode(P_AH_CONTACT_PHONE , FND_API.G_MISS_CHAR, AH_CONTACT_PHONE , P_AH_CONTACT_PHONE )
556: ,STOCKING_SITE_EXCL = decode( P_STOCKING_SITE_EXCL , FND_API.G_MISS_CHAR, STOCKING_SITE_EXCL , P_STOCKING_SITE_EXCL )
557: ,SPECIAL_INSTRUCTIONS = decode(P_SPECIAL_INSTRUCTIONS , FND_API.G_MISS_CHAR, SPECIAL_INSTRUCTIONS , P_SPECIAL_INSTRUCTIONS )
558: ,HZ_LOCATION_ID = decode(P_HZ_LOCATION_ID , FND_API.G_MISS_NUM, HZ_LOCATION_ID , P_HZ_LOCATION_ID )
559:
560: where PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID;
553: ,CONTACT_PHONE = decode(P_CONTACT_PHONE , FND_API.G_MISS_CHAR,CONTACT_PHONE ,P_CONTACT_PHONE )
554: ,AH_CONTACT_NAME = decode(P_AH_CONTACT_NAME , FND_API.G_MISS_CHAR, AH_CONTACT_NAME , P_AH_CONTACT_NAME )
555: ,AH_CONTACT_PHONE = decode(P_AH_CONTACT_PHONE , FND_API.G_MISS_CHAR, AH_CONTACT_PHONE , P_AH_CONTACT_PHONE )
556: ,STOCKING_SITE_EXCL = decode( P_STOCKING_SITE_EXCL , FND_API.G_MISS_CHAR, STOCKING_SITE_EXCL , P_STOCKING_SITE_EXCL )
557: ,SPECIAL_INSTRUCTIONS = decode(P_SPECIAL_INSTRUCTIONS , FND_API.G_MISS_CHAR, SPECIAL_INSTRUCTIONS , P_SPECIAL_INSTRUCTIONS )
558: ,HZ_LOCATION_ID = decode(P_HZ_LOCATION_ID , FND_API.G_MISS_NUM, HZ_LOCATION_ID , P_HZ_LOCATION_ID )
559:
560: where PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID;
561: If (SQL%NOTFOUND) then
554: ,AH_CONTACT_NAME = decode(P_AH_CONTACT_NAME , FND_API.G_MISS_CHAR, AH_CONTACT_NAME , P_AH_CONTACT_NAME )
555: ,AH_CONTACT_PHONE = decode(P_AH_CONTACT_PHONE , FND_API.G_MISS_CHAR, AH_CONTACT_PHONE , P_AH_CONTACT_PHONE )
556: ,STOCKING_SITE_EXCL = decode( P_STOCKING_SITE_EXCL , FND_API.G_MISS_CHAR, STOCKING_SITE_EXCL , P_STOCKING_SITE_EXCL )
557: ,SPECIAL_INSTRUCTIONS = decode(P_SPECIAL_INSTRUCTIONS , FND_API.G_MISS_CHAR, SPECIAL_INSTRUCTIONS , P_SPECIAL_INSTRUCTIONS )
558: ,HZ_LOCATION_ID = decode(P_HZ_LOCATION_ID , FND_API.G_MISS_NUM, HZ_LOCATION_ID , P_HZ_LOCATION_ID )
559:
560: where PLANNING_PARAMETERS_ID = p_PLANNING_PARAMETERS_ID;
561: If (SQL%NOTFOUND) then
562: RAISE NO_DATA_FOUND;