DBA Data[Home] [Help]

APPS.CSP_LOOP_CALC_RULES_B_PKG dependencies on FND_API

Line 64: If (px_CALCULATION_RULE_ID IS NULL) OR (px_CALCULATION_RULE_ID = FND_API.G_MISS_NUM) then

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;

Line 110: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),

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),

Line 111: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, to_date(null), p_CREATION_DATE),

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),

Line 112: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),

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),

Line 113: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, to_date(null), p_LAST_UPDATE_DATE),

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),

Line 114: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),

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),

Line 115: decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, NULL, p_CALCULATION_RULE_NAME),

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),

Line 116: decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_SALES_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),

Line 117: decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_MOVE_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),

Line 118: decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REPAIR_ORDERS),

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),

Line 119: decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_WORK_ORDERS),

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),

Line 120: decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_PURCHASE_ORDERS),

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),

Line 121: decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_REQUISITIONS),

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),

Line 122: decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTERORG_TRANSFERS),

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),

Line 123: decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_GOOD),

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),

Line 124: decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_ONHAND_BAD),

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),

Line 125: decode( p_INCLUDE_INTRANSIT_MOVE_ORD, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_INTRANSIT_MOVE_ORD),

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),

Line 126: decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, NULL, p_TOLERANCE_PERCENT),

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),

Line 127: decode( p_TIME_FENCE, FND_API.G_MISS_NUM, NULL, p_TIME_FENCE),

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),

Line 128: decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, NULL, p_INCLUDE_DOA),

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),

Line 129: decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_ROLLUP_SUPERCESSION),

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),

Line 130: decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, NULL, p_FORECAST_LOWER_SUPERCESSION),

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),

Line 131: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),

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),

Line 132: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),

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),

Line 133: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),

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),

Line 134: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),

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),

Line 135: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),

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),

Line 136: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),

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),

Line 137: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),

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),

Line 138: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),

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),

Line 139: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),

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),

Line 140: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),

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),

Line 141: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),

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),

Line 142: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),

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));

Line 143: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),

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:

Line 144: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),

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 (

Line 145: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),

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,

Line 146: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15));

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,

Line 232: CALCULATION_RULE_ID = decode( p_CALCULATION_RULE_ID, FND_API.G_MISS_NUM, CALCULATION_RULE_ID, p_CALCULATION_RULE_ID),

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),

Line 233: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),

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),

Line 234: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),

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),

Line 235: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),

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),

Line 236: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),

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),

Line 237: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),

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),

Line 238: CALCULATION_RULE_NAME = decode( p_CALCULATION_RULE_NAME, FND_API.G_MISS_CHAR, CALCULATION_RULE_NAME, p_CALCULATION_RULE_NAME),

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),

Line 239: INCLUDE_SALES_ORDERS = decode( p_INCLUDE_SALES_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_SALES_ORDERS, p_INCLUDE_SALES_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),

Line 240: INCLUDE_MOVE_ORDERS = decode( p_INCLUDE_MOVE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_MOVE_ORDERS, p_INCLUDE_MOVE_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),

Line 241: INCLUDE_REPAIR_ORDERS = decode( p_INCLUDE_REPAIR_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_REPAIR_ORDERS, p_INCLUDE_REPAIR_ORDERS),

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),

Line 242: INCLUDE_WORK_ORDERS = decode( p_INCLUDE_WORK_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_WORK_ORDERS, p_INCLUDE_WORK_ORDERS),

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),

Line 243: INCLUDE_PURCHASE_ORDERS = decode( p_INCLUDE_PURCHASE_ORDERS, FND_API.G_MISS_CHAR, INCLUDE_PURCHASE_ORDERS, p_INCLUDE_PURCHASE_ORDERS),

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),

Line 244: INCLUDE_REQUISITIONS = decode( p_INCLUDE_REQUISITIONS, FND_API.G_MISS_CHAR, INCLUDE_REQUISITIONS, p_INCLUDE_REQUISITIONS),

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),

Line 245: INCLUDE_INTERORG_TRANSFERS = decode( p_INCLUDE_INTERORG_TRANSFERS, FND_API.G_MISS_CHAR, INCLUDE_INTERORG_TRANSFERS, p_INCLUDE_INTERORG_TRANSFERS),

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),

Line 246: INCLUDE_ONHAND_GOOD = decode( p_INCLUDE_ONHAND_GOOD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_GOOD, p_INCLUDE_ONHAND_GOOD),

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),

Line 247: INCLUDE_ONHAND_BAD = decode( p_INCLUDE_ONHAND_BAD, FND_API.G_MISS_CHAR, INCLUDE_ONHAND_BAD, p_INCLUDE_ONHAND_BAD),

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),

Line 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),

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),

Line 249: TOLERANCE_PERCENT = decode( p_TOLERANCE_PERCENT, FND_API.G_MISS_NUM, TOLERANCE_PERCENT, p_TOLERANCE_PERCENT),

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),

Line 250: TIME_FENCE = decode( p_TIME_FENCE, FND_API.G_MISS_NUM, TIME_FENCE, p_TIME_FENCE),

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),

Line 251: INCLUDE_DOA = decode( p_INCLUDE_DOA, FND_API.G_MISS_CHAR, INCLUDE_DOA, p_INCLUDE_DOA),

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),

Line 252: ROLLUP_SUPERCESSION = decode( p_ROLLUP_SUPERCESSION, FND_API.G_MISS_CHAR, ROLLUP_SUPERCESSION, p_ROLLUP_SUPERCESSION),

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),

Line 253: FORECAST_LOWER_SUPERCESSION = decode( p_FORECAST_LOWER_SUPERCESSION, FND_API.G_MISS_CHAR, FORECAST_LOWER_SUPERCESSION, p_FORECAST_LOWER_SUPERCESSION),

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),

Line 254: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),

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),

Line 255: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),

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),

Line 256: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),

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),

Line 257: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),

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),

Line 258: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),

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),

Line 259: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),

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),

Line 260: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),

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),

Line 261: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),

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),

Line 262: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),

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),

Line 263: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),

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),

Line 264: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),

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),

Line 265: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),

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)

Line 266: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),

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;

Line 267: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),

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:

Line 268: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),

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

Line 269: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15)

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;

Line 629: p_CREATED_BY => FND_API.G_MISS_NUM,

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,

Line 630: p_CREATION_DATE => FND_API.G_MISS_DATE,

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,

Line 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,

Line 635: p_INCLUDE_SALES_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,

Line 636: p_INCLUDE_MOVE_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,

Line 637: p_INCLUDE_REPAIR_ORDERS => 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,

Line 638: p_INCLUDE_WORK_ORDERS => 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,

Line 639: p_INCLUDE_PURCHASE_ORDERS => 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,

Line 640: p_INCLUDE_REQUISITIONS => 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,

Line 641: p_INCLUDE_INTERORG_TRANSFERS => 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,

Line 642: p_INCLUDE_ONHAND_GOOD => 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,
646: p_TIME_FENCE => FND_API.G_MISS_NUM,

Line 643: p_INCLUDE_ONHAND_BAD => 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,
647: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,

Line 644: p_INCLUDE_INTRANSIT_MOVE_ORD => 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,

Line 645: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,

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,

Line 646: p_TIME_FENCE => FND_API.G_MISS_NUM,

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,

Line 647: p_INCLUDE_DOA => 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,

Line 648: p_ROLLUP_SUPERCESSION => 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,

Line 649: p_FORECAST_LOWER_SUPERCESSION => 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,

Line 650: p_ATTRIBUTE_CATEGORY => 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,

Line 651: p_ATTRIBUTE1 => 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,

Line 652: p_ATTRIBUTE2 => 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,

Line 653: p_ATTRIBUTE3 => 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,

Line 654: p_ATTRIBUTE4 => 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,

Line 655: p_ATTRIBUTE5 => 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,

Line 656: p_ATTRIBUTE6 => 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,

Line 657: p_ATTRIBUTE7 => 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,

Line 658: p_ATTRIBUTE8 => 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,

Line 659: p_ATTRIBUTE9 => 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,

Line 660: p_ATTRIBUTE10 => 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,

Line 661: p_ATTRIBUTE11 => 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,

Line 662: p_ATTRIBUTE12 => 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);

Line 663: p_ATTRIBUTE13 => 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);
667: EXCEPTION

Line 664: p_ATTRIBUTE14 => 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
668: WHEN NO_DATA_FOUND THEN

Line 665: p_ATTRIBUTE15 => 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
669: -- insert row

Line 672: p_CREATED_BY => FND_API.G_MISS_NUM,

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,

Line 673: p_CREATION_DATE => FND_API.G_MISS_DATE,

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,

Line 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,

Line 678: p_INCLUDE_SALES_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,

Line 679: p_INCLUDE_MOVE_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,

Line 680: p_INCLUDE_REPAIR_ORDERS => 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,

Line 681: p_INCLUDE_WORK_ORDERS => 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,

Line 682: p_INCLUDE_PURCHASE_ORDERS => 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,

Line 683: p_INCLUDE_REQUISITIONS => 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,

Line 684: p_INCLUDE_INTERORG_TRANSFERS => 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,

Line 685: p_INCLUDE_ONHAND_GOOD => 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,
689: p_TIME_FENCE => FND_API.G_MISS_NUM,

Line 686: p_INCLUDE_ONHAND_BAD => 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,
690: p_INCLUDE_DOA => FND_API.G_MISS_CHAR,

Line 687: p_INCLUDE_INTRANSIT_MOVE_ORD => 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,

Line 688: p_TOLERANCE_PERCENT => FND_API.G_MISS_NUM,

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,

Line 689: p_TIME_FENCE => FND_API.G_MISS_NUM,

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,

Line 690: p_INCLUDE_DOA => 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,

Line 691: p_ROLLUP_SUPERCESSION => 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,

Line 692: p_FORECAST_LOWER_SUPERCESSION => 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,

Line 693: p_ATTRIBUTE_CATEGORY => 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,

Line 694: p_ATTRIBUTE1 => 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,

Line 695: p_ATTRIBUTE2 => 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,

Line 696: p_ATTRIBUTE3 => 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,

Line 697: p_ATTRIBUTE4 => 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,

Line 698: p_ATTRIBUTE5 => 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,

Line 699: p_ATTRIBUTE6 => 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,

Line 700: p_ATTRIBUTE7 => 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,

Line 701: p_ATTRIBUTE8 => 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,

Line 702: p_ATTRIBUTE9 => 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,

Line 703: p_ATTRIBUTE10 => 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,

Line 704: p_ATTRIBUTE11 => 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,

Line 705: p_ATTRIBUTE12 => 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);

Line 706: p_ATTRIBUTE13 => 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);
710: END;

Line 707: p_ATTRIBUTE14 => 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;
711:

Line 708: p_ATTRIBUTE15 => 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:
712: EXCEPTION