60:
61: p_ROWID VARCHAR2(30);
62:
63: BEGIN
64: If (px_CALCULATION_RULE_ID IS NULL) OR (px_CALCULATION_RULE_ID = FND_API.G_MISS_NUM) then
65: OPEN C2;
66: FETCH C2 INTO px_CALCULATION_RULE_ID;
67: CLOSE C2;
68: End If;
106: ATTRIBUTE14,
107: ATTRIBUTE15
108: ) VALUES (
109: px_CALCULATION_RULE_ID,
110: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
111: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, to_date(null), p_CREATION_DATE),
112: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
107: ATTRIBUTE15
108: ) VALUES (
109: px_CALCULATION_RULE_ID,
110: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
111: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, to_date(null), p_CREATION_DATE),
112: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
115: decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_CALCULATION_RULE_NAME),
108: ) VALUES (
109: px_CALCULATION_RULE_ID,
110: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
111: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, to_date(null), p_CREATION_DATE),
112: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
115: decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_CALCULATION_RULE_NAME),
116: decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_SALES_ORDERS),
109: px_CALCULATION_RULE_ID,
110: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
111: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, to_date(null), p_CREATION_DATE),
112: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
115: decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_CALCULATION_RULE_NAME),
116: decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_SALES_ORDERS),
117: decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_MOVE_ORDERS),
110: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
111: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, to_date(null), p_CREATION_DATE),
112: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
115: decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_CALCULATION_RULE_NAME),
116: decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_SALES_ORDERS),
117: decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_MOVE_ORDERS),
118: decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REPAIR_ORDERS),
111: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, to_date(null), p_CREATION_DATE),
112: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
115: decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_CALCULATION_RULE_NAME),
116: decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_SALES_ORDERS),
117: decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_MOVE_ORDERS),
118: decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REPAIR_ORDERS),
119: decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_WORK_ORDERS),
112: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
115: decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_CALCULATION_RULE_NAME),
116: decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_SALES_ORDERS),
117: decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_MOVE_ORDERS),
118: decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REPAIR_ORDERS),
119: decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_WORK_ORDERS),
120: decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_PURCHASE_ORDERS),
113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), p_LAST_UPDATE_DATE),
114: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
115: decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_CALCULATION_RULE_NAME),
116: decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_SALES_ORDERS),
117: decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_MOVE_ORDERS),
118: decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REPAIR_ORDERS),
119: decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_WORK_ORDERS),
120: decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_PURCHASE_ORDERS),
121: decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REQUISITIONS),
114: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
115: decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_CALCULATION_RULE_NAME),
116: decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_SALES_ORDERS),
117: decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_MOVE_ORDERS),
118: decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REPAIR_ORDERS),
119: decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_WORK_ORDERS),
120: decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_PURCHASE_ORDERS),
121: decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REQUISITIONS),
122: decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTERORG_TRANSFERS),
115: decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_CALCULATION_RULE_NAME),
116: decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_SALES_ORDERS),
117: decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_MOVE_ORDERS),
118: decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REPAIR_ORDERS),
119: decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_WORK_ORDERS),
120: decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_PURCHASE_ORDERS),
121: decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REQUISITIONS),
122: decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTERORG_TRANSFERS),
123: decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_GOOD),
116: decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_SALES_ORDERS),
117: decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_MOVE_ORDERS),
118: decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REPAIR_ORDERS),
119: decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_WORK_ORDERS),
120: decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_PURCHASE_ORDERS),
121: decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REQUISITIONS),
122: decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTERORG_TRANSFERS),
123: decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_GOOD),
124: decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_BAD),
117: decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_MOVE_ORDERS),
118: decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REPAIR_ORDERS),
119: decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_WORK_ORDERS),
120: decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_PURCHASE_ORDERS),
121: decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REQUISITIONS),
122: decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTERORG_TRANSFERS),
123: decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_GOOD),
124: decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_BAD),
125: decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTRANSIT_MOVE_ORD),
118: decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REPAIR_ORDERS),
119: decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_WORK_ORDERS),
120: decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_PURCHASE_ORDERS),
121: decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REQUISITIONS),
122: decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTERORG_TRANSFERS),
123: decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_GOOD),
124: decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_BAD),
125: decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTRANSIT_MOVE_ORD),
126: decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PERCENT),
119: decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_WORK_ORDERS),
120: decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_PURCHASE_ORDERS),
121: decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REQUISITIONS),
122: decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTERORG_TRANSFERS),
123: decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_GOOD),
124: decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_BAD),
125: decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTRANSIT_MOVE_ORD),
126: decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PERCENT),
127: decode( p_TIME_FENCE, FND_API.G_MISS_NUM, NULL, p_TIME_FENCE),
120: decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_PURCHASE_ORDERS),
121: decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REQUISITIONS),
122: decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTERORG_TRANSFERS),
123: decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_GOOD),
124: decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_BAD),
125: decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTRANSIT_MOVE_ORD),
126: decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PERCENT),
127: decode( p_TIME_FENCE, FND_API.G_MISS_NUM, NULL, p_TIME_FENCE),
128: decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_DOA),
121: decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REQUISITIONS),
122: decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTERORG_TRANSFERS),
123: decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_GOOD),
124: decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_BAD),
125: decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTRANSIT_MOVE_ORD),
126: decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PERCENT),
127: decode( p_TIME_FENCE, FND_API.G_MISS_NUM, NULL, p_TIME_FENCE),
128: decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_DOA),
129: decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_ROLLUP_SUPERCESSION),
122: decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTERORG_TRANSFERS),
123: decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_GOOD),
124: decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_BAD),
125: decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTRANSIT_MOVE_ORD),
126: decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PERCENT),
127: decode( p_TIME_FENCE, FND_API.G_MISS_NUM, NULL, p_TIME_FENCE),
128: decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_DOA),
129: decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_ROLLUP_SUPERCESSION),
130: decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_FORECAST_LOWER_SUPERCESSION),
123: decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_GOOD),
124: decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_BAD),
125: decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTRANSIT_MOVE_ORD),
126: decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PERCENT),
127: decode( p_TIME_FENCE, FND_API.G_MISS_NUM, NULL, p_TIME_FENCE),
128: decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_DOA),
129: decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_ROLLUP_SUPERCESSION),
130: decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_FORECAST_LOWER_SUPERCESSION),
131: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
124: decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_BAD),
125: decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTRANSIT_MOVE_ORD),
126: decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PERCENT),
127: decode( p_TIME_FENCE, FND_API.G_MISS_NUM, NULL, p_TIME_FENCE),
128: decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_DOA),
129: decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_ROLLUP_SUPERCESSION),
130: decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_FORECAST_LOWER_SUPERCESSION),
131: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
132: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
125: decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTRANSIT_MOVE_ORD),
126: decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PERCENT),
127: decode( p_TIME_FENCE, FND_API.G_MISS_NUM, NULL, p_TIME_FENCE),
128: decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_DOA),
129: decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_ROLLUP_SUPERCESSION),
130: decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_FORECAST_LOWER_SUPERCESSION),
131: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
132: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
133: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
126: decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PERCENT),
127: decode( p_TIME_FENCE, FND_API.G_MISS_NUM, NULL, p_TIME_FENCE),
128: decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_DOA),
129: decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_ROLLUP_SUPERCESSION),
130: decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_FORECAST_LOWER_SUPERCESSION),
131: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
132: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
133: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
134: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
127: decode( p_TIME_FENCE, FND_API.G_MISS_NUM, NULL, p_TIME_FENCE),
128: decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_DOA),
129: decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_ROLLUP_SUPERCESSION),
130: decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_FORECAST_LOWER_SUPERCESSION),
131: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
132: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
133: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
134: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
135: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
128: decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_DOA),
129: decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_ROLLUP_SUPERCESSION),
130: decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_FORECAST_LOWER_SUPERCESSION),
131: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
132: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
133: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
134: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
135: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
136: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
129: decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_ROLLUP_SUPERCESSION),
130: decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_FORECAST_LOWER_SUPERCESSION),
131: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
132: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
133: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
134: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
135: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
136: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
137: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
130: decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_FORECAST_LOWER_SUPERCESSION),
131: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
132: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
133: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
134: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
135: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
136: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
137: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
138: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
131: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
132: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
133: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
134: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
135: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
136: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
137: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
138: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
139: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
132: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
133: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
134: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
135: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
136: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
137: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
138: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
139: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
140: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
133: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
134: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
135: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
136: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
137: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
138: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
139: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
140: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
141: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
134: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
135: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
136: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
137: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
138: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
139: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
140: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
141: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
142: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
135: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
136: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
137: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
138: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
139: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
140: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
141: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
142: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
143: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
136: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
137: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
138: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
139: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
140: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
141: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
142: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
143: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
144: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
137: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
138: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
139: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
140: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
141: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
142: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
143: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
144: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
145: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
138: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
139: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
140: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
141: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
142: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
143: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
144: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
145: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
146: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
139: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
140: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
141: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
142: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
143: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
144: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
145: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
146: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
147:
140: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
141: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
142: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
143: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
144: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
145: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
146: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
147:
148: insert into CSP_LOOP_CALC_RULES_TL (
141: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
142: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
143: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
144: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
145: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
146: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
147:
148: insert into CSP_LOOP_CALC_RULES_TL (
149: CALCULATION_RULE_ID,
142: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
143: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
144: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
145: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
146: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));
147:
148: insert into CSP_LOOP_CALC_RULES_TL (
149: CALCULATION_RULE_ID,
150: CREATED_BY,
228: IS
229: BEGIN
230: Update CSP_LOOP_CALC_RULES_B
231: SET
232: CALCULATION_RULE_ID = decode( p_CALCULATION_RULE_ID, FND_API.G_MISS_NUM, CALCULATION_RULE_ID, p_CALCULATION_RULE_ID),
233: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
234: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
235: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
236: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
229: BEGIN
230: Update CSP_LOOP_CALC_RULES_B
231: SET
232: CALCULATION_RULE_ID = decode( p_CALCULATION_RULE_ID, FND_API.G_MISS_NUM, CALCULATION_RULE_ID, p_CALCULATION_RULE_ID),
233: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
234: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
235: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
236: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
237: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
230: Update CSP_LOOP_CALC_RULES_B
231: SET
232: CALCULATION_RULE_ID = decode( p_CALCULATION_RULE_ID, FND_API.G_MISS_NUM, CALCULATION_RULE_ID, p_CALCULATION_RULE_ID),
233: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
234: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
235: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
236: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
237: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
238: CALCULATION_RULE_NAME = decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, CALCULATION_RULE_NAME, p_CALCULATION_RULE_NAME),
231: SET
232: CALCULATION_RULE_ID = decode( p_CALCULATION_RULE_ID, FND_API.G_MISS_NUM, CALCULATION_RULE_ID, p_CALCULATION_RULE_ID),
233: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
234: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
235: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
236: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
237: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
238: CALCULATION_RULE_NAME = decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, CALCULATION_RULE_NAME, p_CALCULATION_RULE_NAME),
239: INCLUDE_SALES_ORDERS = decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_SALES_ORDERS, p_INCLUDE_SALES_ORDERS),
232: CALCULATION_RULE_ID = decode( p_CALCULATION_RULE_ID, FND_API.G_MISS_NUM, CALCULATION_RULE_ID, p_CALCULATION_RULE_ID),
233: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
234: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
235: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
236: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
237: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
238: CALCULATION_RULE_NAME = decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, CALCULATION_RULE_NAME, p_CALCULATION_RULE_NAME),
239: INCLUDE_SALES_ORDERS = decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_SALES_ORDERS, p_INCLUDE_SALES_ORDERS),
240: INCLUDE_MOVE_ORDERS = decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_MOVE_ORDERS, p_INCLUDE_MOVE_ORDERS),
233: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
234: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
235: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
236: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
237: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
238: CALCULATION_RULE_NAME = decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, CALCULATION_RULE_NAME, p_CALCULATION_RULE_NAME),
239: INCLUDE_SALES_ORDERS = decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_SALES_ORDERS, p_INCLUDE_SALES_ORDERS),
240: INCLUDE_MOVE_ORDERS = decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_MOVE_ORDERS, p_INCLUDE_MOVE_ORDERS),
241: INCLUDE_REPAIR_ORDERS = decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_REPAIR_ORDERS, p_INCLUDE_REPAIR_ORDERS),
234: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
235: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
236: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
237: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
238: CALCULATION_RULE_NAME = decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, CALCULATION_RULE_NAME, p_CALCULATION_RULE_NAME),
239: INCLUDE_SALES_ORDERS = decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_SALES_ORDERS, p_INCLUDE_SALES_ORDERS),
240: INCLUDE_MOVE_ORDERS = decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_MOVE_ORDERS, p_INCLUDE_MOVE_ORDERS),
241: INCLUDE_REPAIR_ORDERS = decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_REPAIR_ORDERS, p_INCLUDE_REPAIR_ORDERS),
242: INCLUDE_WORK_ORDERS = decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_WORK_ORDERS, p_INCLUDE_WORK_ORDERS),
235: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
236: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
237: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
238: CALCULATION_RULE_NAME = decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, CALCULATION_RULE_NAME, p_CALCULATION_RULE_NAME),
239: INCLUDE_SALES_ORDERS = decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_SALES_ORDERS, p_INCLUDE_SALES_ORDERS),
240: INCLUDE_MOVE_ORDERS = decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_MOVE_ORDERS, p_INCLUDE_MOVE_ORDERS),
241: INCLUDE_REPAIR_ORDERS = decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_REPAIR_ORDERS, p_INCLUDE_REPAIR_ORDERS),
242: INCLUDE_WORK_ORDERS = decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_WORK_ORDERS, p_INCLUDE_WORK_ORDERS),
243: INCLUDE_PURCHASE_ORDERS = decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_PURCHASE_ORDERS, p_INCLUDE_PURCHASE_ORDERS),
236: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
237: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
238: CALCULATION_RULE_NAME = decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, CALCULATION_RULE_NAME, p_CALCULATION_RULE_NAME),
239: INCLUDE_SALES_ORDERS = decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_SALES_ORDERS, p_INCLUDE_SALES_ORDERS),
240: INCLUDE_MOVE_ORDERS = decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_MOVE_ORDERS, p_INCLUDE_MOVE_ORDERS),
241: INCLUDE_REPAIR_ORDERS = decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_REPAIR_ORDERS, p_INCLUDE_REPAIR_ORDERS),
242: INCLUDE_WORK_ORDERS = decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_WORK_ORDERS, p_INCLUDE_WORK_ORDERS),
243: INCLUDE_PURCHASE_ORDERS = decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_PURCHASE_ORDERS, p_INCLUDE_PURCHASE_ORDERS),
244: INCLUDE_REQUISITIONS = decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, INCLUDE_REQUISITIONS, p_INCLUDE_REQUISITIONS),
237: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
238: CALCULATION_RULE_NAME = decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, CALCULATION_RULE_NAME, p_CALCULATION_RULE_NAME),
239: INCLUDE_SALES_ORDERS = decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_SALES_ORDERS, p_INCLUDE_SALES_ORDERS),
240: INCLUDE_MOVE_ORDERS = decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_MOVE_ORDERS, p_INCLUDE_MOVE_ORDERS),
241: INCLUDE_REPAIR_ORDERS = decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_REPAIR_ORDERS, p_INCLUDE_REPAIR_ORDERS),
242: INCLUDE_WORK_ORDERS = decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_WORK_ORDERS, p_INCLUDE_WORK_ORDERS),
243: INCLUDE_PURCHASE_ORDERS = decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_PURCHASE_ORDERS, p_INCLUDE_PURCHASE_ORDERS),
244: INCLUDE_REQUISITIONS = decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, INCLUDE_REQUISITIONS, p_INCLUDE_REQUISITIONS),
245: INCLUDE_INTERORG_TRANSFERS = decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, INCLUDE_INTERORG_TRANSFERS, p_INCLUDE_INTERORG_TRANSFERS),
238: CALCULATION_RULE_NAME = decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, CALCULATION_RULE_NAME, p_CALCULATION_RULE_NAME),
239: INCLUDE_SALES_ORDERS = decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_SALES_ORDERS, p_INCLUDE_SALES_ORDERS),
240: INCLUDE_MOVE_ORDERS = decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_MOVE_ORDERS, p_INCLUDE_MOVE_ORDERS),
241: INCLUDE_REPAIR_ORDERS = decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_REPAIR_ORDERS, p_INCLUDE_REPAIR_ORDERS),
242: INCLUDE_WORK_ORDERS = decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_WORK_ORDERS, p_INCLUDE_WORK_ORDERS),
243: INCLUDE_PURCHASE_ORDERS = decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_PURCHASE_ORDERS, p_INCLUDE_PURCHASE_ORDERS),
244: INCLUDE_REQUISITIONS = decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, INCLUDE_REQUISITIONS, p_INCLUDE_REQUISITIONS),
245: INCLUDE_INTERORG_TRANSFERS = decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, INCLUDE_INTERORG_TRANSFERS, p_INCLUDE_INTERORG_TRANSFERS),
246: INCLUDE_ONHAND_GOOD = decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_GOOD, p_INCLUDE_ONHAND_GOOD),
239: INCLUDE_SALES_ORDERS = decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_SALES_ORDERS, p_INCLUDE_SALES_ORDERS),
240: INCLUDE_MOVE_ORDERS = decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_MOVE_ORDERS, p_INCLUDE_MOVE_ORDERS),
241: INCLUDE_REPAIR_ORDERS = decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_REPAIR_ORDERS, p_INCLUDE_REPAIR_ORDERS),
242: INCLUDE_WORK_ORDERS = decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_WORK_ORDERS, p_INCLUDE_WORK_ORDERS),
243: INCLUDE_PURCHASE_ORDERS = decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_PURCHASE_ORDERS, p_INCLUDE_PURCHASE_ORDERS),
244: INCLUDE_REQUISITIONS = decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, INCLUDE_REQUISITIONS, p_INCLUDE_REQUISITIONS),
245: INCLUDE_INTERORG_TRANSFERS = decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, INCLUDE_INTERORG_TRANSFERS, p_INCLUDE_INTERORG_TRANSFERS),
246: INCLUDE_ONHAND_GOOD = decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_GOOD, p_INCLUDE_ONHAND_GOOD),
247: INCLUDE_ONHAND_BAD = decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_BAD, p_INCLUDE_ONHAND_BAD),
240: INCLUDE_MOVE_ORDERS = decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_MOVE_ORDERS, p_INCLUDE_MOVE_ORDERS),
241: INCLUDE_REPAIR_ORDERS = decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_REPAIR_ORDERS, p_INCLUDE_REPAIR_ORDERS),
242: INCLUDE_WORK_ORDERS = decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_WORK_ORDERS, p_INCLUDE_WORK_ORDERS),
243: INCLUDE_PURCHASE_ORDERS = decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_PURCHASE_ORDERS, p_INCLUDE_PURCHASE_ORDERS),
244: INCLUDE_REQUISITIONS = decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, INCLUDE_REQUISITIONS, p_INCLUDE_REQUISITIONS),
245: INCLUDE_INTERORG_TRANSFERS = decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, INCLUDE_INTERORG_TRANSFERS, p_INCLUDE_INTERORG_TRANSFERS),
246: INCLUDE_ONHAND_GOOD = decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_GOOD, p_INCLUDE_ONHAND_GOOD),
247: INCLUDE_ONHAND_BAD = decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_BAD, p_INCLUDE_ONHAND_BAD),
248: INCLUDE_INTRANSIT_MOVE_ORDERS = decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, INCLUDE_INTRANSIT_MOVE_ORDERS, p_INCLUDE_INTRANSIT_MOVE_ORD),
241: INCLUDE_REPAIR_ORDERS = decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_REPAIR_ORDERS, p_INCLUDE_REPAIR_ORDERS),
242: INCLUDE_WORK_ORDERS = decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_WORK_ORDERS, p_INCLUDE_WORK_ORDERS),
243: INCLUDE_PURCHASE_ORDERS = decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_PURCHASE_ORDERS, p_INCLUDE_PURCHASE_ORDERS),
244: INCLUDE_REQUISITIONS = decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, INCLUDE_REQUISITIONS, p_INCLUDE_REQUISITIONS),
245: INCLUDE_INTERORG_TRANSFERS = decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, INCLUDE_INTERORG_TRANSFERS, p_INCLUDE_INTERORG_TRANSFERS),
246: INCLUDE_ONHAND_GOOD = decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_GOOD, p_INCLUDE_ONHAND_GOOD),
247: INCLUDE_ONHAND_BAD = decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_BAD, p_INCLUDE_ONHAND_BAD),
248: INCLUDE_INTRANSIT_MOVE_ORDERS = decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, INCLUDE_INTRANSIT_MOVE_ORDERS, p_INCLUDE_INTRANSIT_MOVE_ORD),
249: TOLERANCE_PERCENT = decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, TOLERANCE_PERCENT, p_TOLERANCE_PERCENT),
242: INCLUDE_WORK_ORDERS = decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_WORK_ORDERS, p_INCLUDE_WORK_ORDERS),
243: INCLUDE_PURCHASE_ORDERS = decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_PURCHASE_ORDERS, p_INCLUDE_PURCHASE_ORDERS),
244: INCLUDE_REQUISITIONS = decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, INCLUDE_REQUISITIONS, p_INCLUDE_REQUISITIONS),
245: INCLUDE_INTERORG_TRANSFERS = decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, INCLUDE_INTERORG_TRANSFERS, p_INCLUDE_INTERORG_TRANSFERS),
246: INCLUDE_ONHAND_GOOD = decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_GOOD, p_INCLUDE_ONHAND_GOOD),
247: INCLUDE_ONHAND_BAD = decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_BAD, p_INCLUDE_ONHAND_BAD),
248: INCLUDE_INTRANSIT_MOVE_ORDERS = decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, INCLUDE_INTRANSIT_MOVE_ORDERS, p_INCLUDE_INTRANSIT_MOVE_ORD),
249: TOLERANCE_PERCENT = decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, TOLERANCE_PERCENT, p_TOLERANCE_PERCENT),
250: TIME_FENCE = decode( p_TIME_FENCE, FND_API.G_MISS_NUM, TIME_FENCE, p_TIME_FENCE),
243: INCLUDE_PURCHASE_ORDERS = decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_PURCHASE_ORDERS, p_INCLUDE_PURCHASE_ORDERS),
244: INCLUDE_REQUISITIONS = decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, INCLUDE_REQUISITIONS, p_INCLUDE_REQUISITIONS),
245: INCLUDE_INTERORG_TRANSFERS = decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, INCLUDE_INTERORG_TRANSFERS, p_INCLUDE_INTERORG_TRANSFERS),
246: INCLUDE_ONHAND_GOOD = decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_GOOD, p_INCLUDE_ONHAND_GOOD),
247: INCLUDE_ONHAND_BAD = decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_BAD, p_INCLUDE_ONHAND_BAD),
248: INCLUDE_INTRANSIT_MOVE_ORDERS = decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, INCLUDE_INTRANSIT_MOVE_ORDERS, p_INCLUDE_INTRANSIT_MOVE_ORD),
249: TOLERANCE_PERCENT = decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, TOLERANCE_PERCENT, p_TOLERANCE_PERCENT),
250: TIME_FENCE = decode( p_TIME_FENCE, FND_API.G_MISS_NUM, TIME_FENCE, p_TIME_FENCE),
251: INCLUDE_DOA = decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, INCLUDE_DOA, p_INCLUDE_DOA),
244: INCLUDE_REQUISITIONS = decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, INCLUDE_REQUISITIONS, p_INCLUDE_REQUISITIONS),
245: INCLUDE_INTERORG_TRANSFERS = decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, INCLUDE_INTERORG_TRANSFERS, p_INCLUDE_INTERORG_TRANSFERS),
246: INCLUDE_ONHAND_GOOD = decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_GOOD, p_INCLUDE_ONHAND_GOOD),
247: INCLUDE_ONHAND_BAD = decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_BAD, p_INCLUDE_ONHAND_BAD),
248: INCLUDE_INTRANSIT_MOVE_ORDERS = decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, INCLUDE_INTRANSIT_MOVE_ORDERS, p_INCLUDE_INTRANSIT_MOVE_ORD),
249: TOLERANCE_PERCENT = decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, TOLERANCE_PERCENT, p_TOLERANCE_PERCENT),
250: TIME_FENCE = decode( p_TIME_FENCE, FND_API.G_MISS_NUM, TIME_FENCE, p_TIME_FENCE),
251: INCLUDE_DOA = decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, INCLUDE_DOA, p_INCLUDE_DOA),
252: ROLLUP_SUPERCESSION = decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, ROLLUP_SUPERCESSION, p_ROLLUP_SUPERCESSION),
245: INCLUDE_INTERORG_TRANSFERS = decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, INCLUDE_INTERORG_TRANSFERS, p_INCLUDE_INTERORG_TRANSFERS),
246: INCLUDE_ONHAND_GOOD = decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_GOOD, p_INCLUDE_ONHAND_GOOD),
247: INCLUDE_ONHAND_BAD = decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_BAD, p_INCLUDE_ONHAND_BAD),
248: INCLUDE_INTRANSIT_MOVE_ORDERS = decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, INCLUDE_INTRANSIT_MOVE_ORDERS, p_INCLUDE_INTRANSIT_MOVE_ORD),
249: TOLERANCE_PERCENT = decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, TOLERANCE_PERCENT, p_TOLERANCE_PERCENT),
250: TIME_FENCE = decode( p_TIME_FENCE, FND_API.G_MISS_NUM, TIME_FENCE, p_TIME_FENCE),
251: INCLUDE_DOA = decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, INCLUDE_DOA, p_INCLUDE_DOA),
252: ROLLUP_SUPERCESSION = decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, ROLLUP_SUPERCESSION, p_ROLLUP_SUPERCESSION),
253: FORECAST_LOWER_SUPERCESSION = decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, FORECAST_LOWER_SUPERCESSION, p_FORECAST_LOWER_SUPERCESSION),
246: INCLUDE_ONHAND_GOOD = decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_GOOD, p_INCLUDE_ONHAND_GOOD),
247: INCLUDE_ONHAND_BAD = decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_BAD, p_INCLUDE_ONHAND_BAD),
248: INCLUDE_INTRANSIT_MOVE_ORDERS = decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, INCLUDE_INTRANSIT_MOVE_ORDERS, p_INCLUDE_INTRANSIT_MOVE_ORD),
249: TOLERANCE_PERCENT = decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, TOLERANCE_PERCENT, p_TOLERANCE_PERCENT),
250: TIME_FENCE = decode( p_TIME_FENCE, FND_API.G_MISS_NUM, TIME_FENCE, p_TIME_FENCE),
251: INCLUDE_DOA = decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, INCLUDE_DOA, p_INCLUDE_DOA),
252: ROLLUP_SUPERCESSION = decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, ROLLUP_SUPERCESSION, p_ROLLUP_SUPERCESSION),
253: FORECAST_LOWER_SUPERCESSION = decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, FORECAST_LOWER_SUPERCESSION, p_FORECAST_LOWER_SUPERCESSION),
254: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
247: INCLUDE_ONHAND_BAD = decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_BAD, p_INCLUDE_ONHAND_BAD),
248: INCLUDE_INTRANSIT_MOVE_ORDERS = decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, INCLUDE_INTRANSIT_MOVE_ORDERS, p_INCLUDE_INTRANSIT_MOVE_ORD),
249: TOLERANCE_PERCENT = decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, TOLERANCE_PERCENT, p_TOLERANCE_PERCENT),
250: TIME_FENCE = decode( p_TIME_FENCE, FND_API.G_MISS_NUM, TIME_FENCE, p_TIME_FENCE),
251: INCLUDE_DOA = decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, INCLUDE_DOA, p_INCLUDE_DOA),
252: ROLLUP_SUPERCESSION = decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, ROLLUP_SUPERCESSION, p_ROLLUP_SUPERCESSION),
253: FORECAST_LOWER_SUPERCESSION = decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, FORECAST_LOWER_SUPERCESSION, p_FORECAST_LOWER_SUPERCESSION),
254: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
255: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
248: INCLUDE_INTRANSIT_MOVE_ORDERS = decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, INCLUDE_INTRANSIT_MOVE_ORDERS, p_INCLUDE_INTRANSIT_MOVE_ORD),
249: TOLERANCE_PERCENT = decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, TOLERANCE_PERCENT, p_TOLERANCE_PERCENT),
250: TIME_FENCE = decode( p_TIME_FENCE, FND_API.G_MISS_NUM, TIME_FENCE, p_TIME_FENCE),
251: INCLUDE_DOA = decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, INCLUDE_DOA, p_INCLUDE_DOA),
252: ROLLUP_SUPERCESSION = decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, ROLLUP_SUPERCESSION, p_ROLLUP_SUPERCESSION),
253: FORECAST_LOWER_SUPERCESSION = decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, FORECAST_LOWER_SUPERCESSION, p_FORECAST_LOWER_SUPERCESSION),
254: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
255: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
256: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
249: TOLERANCE_PERCENT = decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, TOLERANCE_PERCENT, p_TOLERANCE_PERCENT),
250: TIME_FENCE = decode( p_TIME_FENCE, FND_API.G_MISS_NUM, TIME_FENCE, p_TIME_FENCE),
251: INCLUDE_DOA = decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, INCLUDE_DOA, p_INCLUDE_DOA),
252: ROLLUP_SUPERCESSION = decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, ROLLUP_SUPERCESSION, p_ROLLUP_SUPERCESSION),
253: FORECAST_LOWER_SUPERCESSION = decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, FORECAST_LOWER_SUPERCESSION, p_FORECAST_LOWER_SUPERCESSION),
254: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
255: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
256: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
257: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
250: TIME_FENCE = decode( p_TIME_FENCE, FND_API.G_MISS_NUM, TIME_FENCE, p_TIME_FENCE),
251: INCLUDE_DOA = decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, INCLUDE_DOA, p_INCLUDE_DOA),
252: ROLLUP_SUPERCESSION = decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, ROLLUP_SUPERCESSION, p_ROLLUP_SUPERCESSION),
253: FORECAST_LOWER_SUPERCESSION = decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, FORECAST_LOWER_SUPERCESSION, p_FORECAST_LOWER_SUPERCESSION),
254: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
255: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
256: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
257: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
258: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
251: INCLUDE_DOA = decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, INCLUDE_DOA, p_INCLUDE_DOA),
252: ROLLUP_SUPERCESSION = decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, ROLLUP_SUPERCESSION, p_ROLLUP_SUPERCESSION),
253: FORECAST_LOWER_SUPERCESSION = decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, FORECAST_LOWER_SUPERCESSION, p_FORECAST_LOWER_SUPERCESSION),
254: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
255: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
256: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
257: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
258: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
259: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
252: ROLLUP_SUPERCESSION = decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, ROLLUP_SUPERCESSION, p_ROLLUP_SUPERCESSION),
253: FORECAST_LOWER_SUPERCESSION = decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, FORECAST_LOWER_SUPERCESSION, p_FORECAST_LOWER_SUPERCESSION),
254: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
255: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
256: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
257: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
258: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
259: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
260: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
253: FORECAST_LOWER_SUPERCESSION = decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, FORECAST_LOWER_SUPERCESSION, p_FORECAST_LOWER_SUPERCESSION),
254: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
255: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
256: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
257: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
258: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
259: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
260: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
261: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
254: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
255: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
256: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
257: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
258: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
259: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
260: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
261: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
262: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
255: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
256: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
257: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
258: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
259: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
260: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
261: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
262: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
256: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
257: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
258: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
259: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
260: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
261: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
262: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
264: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
257: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
258: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
259: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
260: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
261: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
262: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
264: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
265: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
258: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
259: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
260: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
261: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
262: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
264: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
265: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
266: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
259: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
260: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
261: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
262: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
264: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
265: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
266: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
267: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
260: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
261: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
262: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
264: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
265: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
266: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
267: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
268: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
261: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
262: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
264: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
265: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
266: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
267: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
268: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
269: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
262: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
264: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
265: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
266: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
267: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
268: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
269: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
270: where CALCULATION_RULE_ID = p_CALCULATION_RULE_ID;
263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
264: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
265: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
266: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
267: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
268: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
269: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
270: where CALCULATION_RULE_ID = p_CALCULATION_RULE_ID;
271:
264: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
265: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
266: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
267: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
268: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
269: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
270: where CALCULATION_RULE_ID = p_CALCULATION_RULE_ID;
271:
272: If (SQL%NOTFOUND) then
265: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
266: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
267: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
268: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
269: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)
270: where CALCULATION_RULE_ID = p_CALCULATION_RULE_ID;
271:
272: If (SQL%NOTFOUND) then
273: RAISE NO_DATA_FOUND;
625: BEGIN
626: -- update row if present
627: Update_Row(
628: p_CALCULATION_RULE_ID => p_calculation_rule_id,
629: p_CREATED_BY => FND_API.G_MISS_NUM,
630: p_CREATION_DATE => FND_API.G_MISS_DATE,
631: p_LAST_UPDATED_BY => l_user_id,
632: p_LAST_UPDATE_DATE => SYSDATE,
633: p_LAST_UPDATE_LOGIN => 0,
626: -- update row if present
627: Update_Row(
628: p_CALCULATION_RULE_ID => p_calculation_rule_id,
629: p_CREATED_BY => FND_API.G_MISS_NUM,
630: p_CREATION_DATE => FND_API.G_MISS_DATE,
631: p_LAST_UPDATED_BY => l_user_id,
632: p_LAST_UPDATE_DATE => SYSDATE,
633: p_LAST_UPDATE_LOGIN => 0,
634: p_CALCULATION_RULE_NAME => FND_API.G_MISS_CHAR,
630: p_CREATION_DATE => FND_API.G_MISS_DATE,
631: p_LAST_UPDATED_BY => l_user_id,
632: p_LAST_UPDATE_DATE => SYSDATE,
633: p_LAST_UPDATE_LOGIN => 0,
634: p_CALCULATION_RULE_NAME => FND_API.G_MISS_CHAR,
635: p_INCLUDE_SALES_ORDERS => FND_API.G_MISS_CHAR,
636: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
637: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
638: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
631: p_LAST_UPDATED_BY => l_user_id,
632: p_LAST_UPDATE_DATE => SYSDATE,
633: p_LAST_UPDATE_LOGIN => 0,
634: p_CALCULATION_RULE_NAME => FND_API.G_MISS_CHAR,
635: p_INCLUDE_SALES_ORDERS => FND_API.G_MISS_CHAR,
636: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
637: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
638: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
639: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
632: p_LAST_UPDATE_DATE => SYSDATE,
633: p_LAST_UPDATE_LOGIN => 0,
634: p_CALCULATION_RULE_NAME => FND_API.G_MISS_CHAR,
635: p_INCLUDE_SALES_ORDERS => FND_API.G_MISS_CHAR,
636: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
637: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
638: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
639: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
640: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
633: p_LAST_UPDATE_LOGIN => 0,
634: p_CALCULATION_RULE_NAME => FND_API.G_MISS_CHAR,
635: p_INCLUDE_SALES_ORDERS => FND_API.G_MISS_CHAR,
636: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
637: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
638: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
639: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
640: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
641: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
634: p_CALCULATION_RULE_NAME => FND_API.G_MISS_CHAR,
635: p_INCLUDE_SALES_ORDERS => FND_API.G_MISS_CHAR,
636: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
637: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
638: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
639: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
640: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
641: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
642: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
635: p_INCLUDE_SALES_ORDERS => FND_API.G_MISS_CHAR,
636: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
637: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
638: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
639: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
640: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
641: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
642: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
643: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
636: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
637: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
638: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
639: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
640: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
641: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
642: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
643: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
644: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
637: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
638: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
639: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
640: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
641: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
642: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
643: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
644: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
645: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
638: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
639: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
640: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
641: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
642: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
643: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
644: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
645: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
646: p_TIME_FENCE => FND_API.G_MISS_NUM,
639: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
640: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
641: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
642: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
643: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
644: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
645: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
646: p_TIME_FENCE => FND_API.G_MISS_NUM,
647: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
640: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
641: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
642: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
643: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
644: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
645: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
646: p_TIME_FENCE => FND_API.G_MISS_NUM,
647: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
648: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
641: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
642: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
643: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
644: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
645: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
646: p_TIME_FENCE => FND_API.G_MISS_NUM,
647: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
648: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
649: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
642: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
643: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
644: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
645: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
646: p_TIME_FENCE => FND_API.G_MISS_NUM,
647: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
648: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
649: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
643: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
644: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
645: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
646: p_TIME_FENCE => FND_API.G_MISS_NUM,
647: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
648: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
649: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
644: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
645: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
646: p_TIME_FENCE => FND_API.G_MISS_NUM,
647: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
648: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
649: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
645: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
646: p_TIME_FENCE => FND_API.G_MISS_NUM,
647: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
648: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
649: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
646: p_TIME_FENCE => FND_API.G_MISS_NUM,
647: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
648: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
649: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
647: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
648: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
649: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
648: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
649: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
649: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
650: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
658: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
651: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
658: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
659: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
652: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
658: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
659: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
660: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
653: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
658: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
659: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
660: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
654: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
658: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
659: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
660: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
655: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
658: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
659: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
660: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
656: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
658: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
659: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
660: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
657: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
658: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
659: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
660: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
658: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
659: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
660: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
666: p_DESCRIPTION => p_description);
659: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
660: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
666: p_DESCRIPTION => p_description);
667: EXCEPTION
660: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
661: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
666: p_DESCRIPTION => p_description);
667: EXCEPTION
668: WHEN NO_DATA_FOUND THEN
661: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
662: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
663: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
664: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
665: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
666: p_DESCRIPTION => p_description);
667: EXCEPTION
668: WHEN NO_DATA_FOUND THEN
669: -- insert row
668: WHEN NO_DATA_FOUND THEN
669: -- insert row
670: Insert_Row(
671: px_CALCULATION_RULE_ID => l_calculation_rule_id,
672: p_CREATED_BY => FND_API.G_MISS_NUM,
673: p_CREATION_DATE => FND_API.G_MISS_DATE,
674: p_LAST_UPDATED_BY => l_user_id,
675: p_LAST_UPDATE_DATE => SYSDATE,
676: p_LAST_UPDATE_LOGIN => 0,
669: -- insert row
670: Insert_Row(
671: px_CALCULATION_RULE_ID => l_calculation_rule_id,
672: p_CREATED_BY => FND_API.G_MISS_NUM,
673: p_CREATION_DATE => FND_API.G_MISS_DATE,
674: p_LAST_UPDATED_BY => l_user_id,
675: p_LAST_UPDATE_DATE => SYSDATE,
676: p_LAST_UPDATE_LOGIN => 0,
677: p_CALCULATION_RULE_NAME => FND_API.G_MISS_CHAR,
673: p_CREATION_DATE => FND_API.G_MISS_DATE,
674: p_LAST_UPDATED_BY => l_user_id,
675: p_LAST_UPDATE_DATE => SYSDATE,
676: p_LAST_UPDATE_LOGIN => 0,
677: p_CALCULATION_RULE_NAME => FND_API.G_MISS_CHAR,
678: p_INCLUDE_SALES_ORDERS => FND_API.G_MISS_CHAR,
679: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
680: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
681: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
674: p_LAST_UPDATED_BY => l_user_id,
675: p_LAST_UPDATE_DATE => SYSDATE,
676: p_LAST_UPDATE_LOGIN => 0,
677: p_CALCULATION_RULE_NAME => FND_API.G_MISS_CHAR,
678: p_INCLUDE_SALES_ORDERS => FND_API.G_MISS_CHAR,
679: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
680: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
681: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
682: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
675: p_LAST_UPDATE_DATE => SYSDATE,
676: p_LAST_UPDATE_LOGIN => 0,
677: p_CALCULATION_RULE_NAME => FND_API.G_MISS_CHAR,
678: p_INCLUDE_SALES_ORDERS => FND_API.G_MISS_CHAR,
679: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
680: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
681: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
682: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
683: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
676: p_LAST_UPDATE_LOGIN => 0,
677: p_CALCULATION_RULE_NAME => FND_API.G_MISS_CHAR,
678: p_INCLUDE_SALES_ORDERS => FND_API.G_MISS_CHAR,
679: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
680: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
681: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
682: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
683: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
684: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
677: p_CALCULATION_RULE_NAME => FND_API.G_MISS_CHAR,
678: p_INCLUDE_SALES_ORDERS => FND_API.G_MISS_CHAR,
679: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
680: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
681: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
682: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
683: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
684: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
685: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
678: p_INCLUDE_SALES_ORDERS => FND_API.G_MISS_CHAR,
679: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
680: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
681: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
682: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
683: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
684: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
685: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
686: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
679: p_INCLUDE_MOVE_ORDERS => FND_API.G_MISS_CHAR,
680: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
681: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
682: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
683: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
684: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
685: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
686: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
687: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
680: p_INCLUDE_REPAIR_ORDERS => FND_API.G_MISS_CHAR,
681: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
682: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
683: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
684: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
685: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
686: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
687: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
688: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
681: p_INCLUDE_WORK_ORDERS => FND_API.G_MISS_CHAR,
682: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
683: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
684: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
685: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
686: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
687: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
688: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
689: p_TIME_FENCE => FND_API.G_MISS_NUM,
682: p_INCLUDE_PURCHASE_ORDERS => FND_API.G_MISS_CHAR,
683: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
684: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
685: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
686: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
687: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
688: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
689: p_TIME_FENCE => FND_API.G_MISS_NUM,
690: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
683: p_INCLUDE_REQUISITIONS => FND_API.G_MISS_CHAR,
684: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
685: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
686: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
687: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
688: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
689: p_TIME_FENCE => FND_API.G_MISS_NUM,
690: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
691: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
684: p_INCLUDE_INTERORG_TRANSFERS => FND_API.G_MISS_CHAR,
685: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
686: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
687: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
688: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
689: p_TIME_FENCE => FND_API.G_MISS_NUM,
690: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
691: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
692: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
685: p_INCLUDE_ONHAND_GOOD => FND_API.G_MISS_CHAR,
686: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
687: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
688: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
689: p_TIME_FENCE => FND_API.G_MISS_NUM,
690: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
691: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
692: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
693: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
686: p_INCLUDE_ONHAND_BAD => FND_API.G_MISS_CHAR,
687: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
688: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
689: p_TIME_FENCE => FND_API.G_MISS_NUM,
690: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
691: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
692: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
693: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
694: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
687: p_INCLUDE_INTRANSIT_MOVE_ORD => FND_API.G_MISS_CHAR,
688: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
689: p_TIME_FENCE => FND_API.G_MISS_NUM,
690: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
691: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
692: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
693: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
694: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
695: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
688: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,
689: p_TIME_FENCE => FND_API.G_MISS_NUM,
690: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
691: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
692: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
693: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
694: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
695: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
696: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
689: p_TIME_FENCE => FND_API.G_MISS_NUM,
690: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
691: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
692: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
693: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
694: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
695: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
696: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
697: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
690: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,
691: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
692: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
693: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
694: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
695: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
696: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
697: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
698: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
691: p_ROLLUP_SUPERCESSION => FND_API.G_MISS_CHAR,
692: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
693: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
694: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
695: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
696: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
697: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
698: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
699: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
692: p_FORECAST_LOWER_SUPERCESSION => FND_API.G_MISS_CHAR,
693: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
694: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
695: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
696: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
697: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
698: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
699: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
700: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
693: p_ATTRIBUTE_CATEGORY => FND_API.G_MISS_CHAR,
694: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
695: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
696: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
697: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
698: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
699: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
700: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
701: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
694: p_ATTRIBUTE1 => FND_API.G_MISS_CHAR,
695: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
696: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
697: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
698: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
699: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
700: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
701: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
702: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
695: p_ATTRIBUTE2 => FND_API.G_MISS_CHAR,
696: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
697: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
698: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
699: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
700: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
701: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
702: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
703: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
696: p_ATTRIBUTE3 => FND_API.G_MISS_CHAR,
697: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
698: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
699: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
700: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
701: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
702: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
703: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
704: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
697: p_ATTRIBUTE4 => FND_API.G_MISS_CHAR,
698: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
699: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
700: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
701: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
702: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
703: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
704: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
705: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
698: p_ATTRIBUTE5 => FND_API.G_MISS_CHAR,
699: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
700: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
701: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
702: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
703: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
704: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
705: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
706: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
699: p_ATTRIBUTE6 => FND_API.G_MISS_CHAR,
700: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
701: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
702: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
703: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
704: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
705: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
706: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
707: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
700: p_ATTRIBUTE7 => FND_API.G_MISS_CHAR,
701: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
702: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
703: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
704: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
705: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
706: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
707: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
708: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
701: p_ATTRIBUTE8 => FND_API.G_MISS_CHAR,
702: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
703: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
704: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
705: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
706: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
707: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
708: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
709: p_DESCRIPTION => p_description);
702: p_ATTRIBUTE9 => FND_API.G_MISS_CHAR,
703: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
704: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
705: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
706: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
707: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
708: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
709: p_DESCRIPTION => p_description);
710: END;
703: p_ATTRIBUTE10 => FND_API.G_MISS_CHAR,
704: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
705: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
706: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
707: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
708: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
709: p_DESCRIPTION => p_description);
710: END;
711:
704: p_ATTRIBUTE11 => FND_API.G_MISS_CHAR,
705: p_ATTRIBUTE12 => FND_API.G_MISS_CHAR,
706: p_ATTRIBUTE13 => FND_API.G_MISS_CHAR,
707: p_ATTRIBUTE14 => FND_API.G_MISS_CHAR,
708: p_ATTRIBUTE15 => FND_API.G_MISS_CHAR,
709: p_DESCRIPTION => p_description);
710: END;
711:
712: EXCEPTION