74:
75: IS
76: CURSOR C2 IS SELECT AS_PROD_WORKSHEET_LINES_S.nextval FROM sys.dual;
77: BEGIN
78: If (px_PROD_WORKSHEET_LINE_ID IS NULL) OR (px_PROD_WORKSHEET_LINE_ID = FND_API.G_MISS_NUM) then
79: OPEN C2;
80: FETCH C2 INTO px_PROD_WORKSHEET_LINE_ID;
81: CLOSE C2;
82: End If;
141: PRODUCT_CATEGORY_ID,
142: PRODUCT_CAT_SET_ID
143: ) VALUES (
144: px_PROD_WORKSHEET_LINE_ID,
145: decode( p_FORECAST_WORKSHEET_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_WORKSHEET_ID),
146: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
147: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
148: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
149: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
142: PRODUCT_CAT_SET_ID
143: ) VALUES (
144: px_PROD_WORKSHEET_LINE_ID,
145: decode( p_FORECAST_WORKSHEET_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_WORKSHEET_ID),
146: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
147: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
148: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
149: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
150: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
143: ) VALUES (
144: px_PROD_WORKSHEET_LINE_ID,
145: decode( p_FORECAST_WORKSHEET_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_WORKSHEET_ID),
146: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
147: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
148: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
149: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
150: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
151: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
144: px_PROD_WORKSHEET_LINE_ID,
145: decode( p_FORECAST_WORKSHEET_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_WORKSHEET_ID),
146: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
147: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
148: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
149: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
150: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
151: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
152: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
145: decode( p_FORECAST_WORKSHEET_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_WORKSHEET_ID),
146: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
147: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
148: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
149: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
150: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
151: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
152: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
153: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
146: decode( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
147: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
148: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
149: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
150: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
151: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
152: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
153: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
154: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
147: decode( p_CREATION_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_CREATION_DATE),
148: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
149: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
150: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
151: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
152: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
153: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
154: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
155: decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, NULL, p_SALES_QUOTA_ID),
148: decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
149: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
150: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
151: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
152: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
153: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
154: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
155: decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, NULL, p_SALES_QUOTA_ID),
156: decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WORST_FORECAST_AMOUNT),
149: decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_LAST_UPDATE_DATE),
150: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
151: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
152: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
153: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
154: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
155: decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, NULL, p_SALES_QUOTA_ID),
156: decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WORST_FORECAST_AMOUNT),
157: decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
150: decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
151: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
152: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
153: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
154: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
155: decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, NULL, p_SALES_QUOTA_ID),
156: decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WORST_FORECAST_AMOUNT),
157: decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
158: decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
151: decode( p_REQUEST_ID, FND_API.G_MISS_NUM, NULL, p_REQUEST_ID),
152: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
153: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
154: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
155: decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, NULL, p_SALES_QUOTA_ID),
156: decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WORST_FORECAST_AMOUNT),
157: decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
158: decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
159: decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WEIGHTED_PIPELINE_AMOUNT),
152: decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_APPLICATION_ID),
153: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
154: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
155: decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, NULL, p_SALES_QUOTA_ID),
156: decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WORST_FORECAST_AMOUNT),
157: decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
158: decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
159: decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WEIGHTED_PIPELINE_AMOUNT),
160: decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PIPELINE_AMOUNT),
153: decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
154: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
155: decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, NULL, p_SALES_QUOTA_ID),
156: decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WORST_FORECAST_AMOUNT),
157: decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
158: decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
159: decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WEIGHTED_PIPELINE_AMOUNT),
160: decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PIPELINE_AMOUNT),
161: decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
154: decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_PROGRAM_UPDATE_DATE),
155: decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, NULL, p_SALES_QUOTA_ID),
156: decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WORST_FORECAST_AMOUNT),
157: decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
158: decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
159: decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WEIGHTED_PIPELINE_AMOUNT),
160: decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PIPELINE_AMOUNT),
161: decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
162: decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
155: decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, NULL, p_SALES_QUOTA_ID),
156: decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WORST_FORECAST_AMOUNT),
157: decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
158: decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
159: decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WEIGHTED_PIPELINE_AMOUNT),
160: decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PIPELINE_AMOUNT),
161: decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
162: decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
163: decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_GROUP_FORECAST_AMOUNT),
156: decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WORST_FORECAST_AMOUNT),
157: decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
158: decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
159: decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WEIGHTED_PIPELINE_AMOUNT),
160: decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PIPELINE_AMOUNT),
161: decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
162: decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
163: decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_GROUP_FORECAST_AMOUNT),
164: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
157: decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
158: decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
159: decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WEIGHTED_PIPELINE_AMOUNT),
160: decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PIPELINE_AMOUNT),
161: decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
162: decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
163: decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_GROUP_FORECAST_AMOUNT),
164: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
165: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
158: decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
159: decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WEIGHTED_PIPELINE_AMOUNT),
160: decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PIPELINE_AMOUNT),
161: decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
162: decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
163: decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_GROUP_FORECAST_AMOUNT),
164: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
165: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
166: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
159: decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WEIGHTED_PIPELINE_AMOUNT),
160: decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PIPELINE_AMOUNT),
161: decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
162: decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
163: decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_GROUP_FORECAST_AMOUNT),
164: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
165: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
166: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
167: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
160: decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_PIPELINE_AMOUNT),
161: decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
162: decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
163: decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_GROUP_FORECAST_AMOUNT),
164: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
165: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
166: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
167: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
168: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
161: decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
162: decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
163: decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_GROUP_FORECAST_AMOUNT),
164: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
165: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
166: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
167: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
168: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
169: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
162: decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
163: decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_GROUP_FORECAST_AMOUNT),
164: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
165: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
166: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
167: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
168: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
169: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
170: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
163: decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_GROUP_FORECAST_AMOUNT),
164: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
165: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
166: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
167: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
168: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
169: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
170: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
171: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
164: decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
165: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
166: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
167: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
168: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
169: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
170: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
171: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
172: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
165: decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
166: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
167: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
168: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
169: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
170: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
171: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
172: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
173: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
166: decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
167: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
168: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
169: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
170: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
171: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
172: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
173: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
174: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
167: decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
168: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
169: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
170: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
171: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
172: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
173: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
174: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
175: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
168: decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
169: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
170: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
171: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
172: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
173: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
174: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
175: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
176: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
169: decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
170: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
171: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
172: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
173: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
174: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
175: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
176: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
177: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
170: decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
171: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
172: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
173: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
174: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
175: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
176: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
177: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
178: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
171: decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
172: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
173: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
174: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
175: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
176: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
177: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
178: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
179: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
172: decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
173: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
174: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
175: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
176: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
177: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
178: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
179: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
180: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
173: decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
174: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
175: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
176: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
177: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
178: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
179: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
180: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
181: decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALES_GROUP_ID),
174: decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
175: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
176: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
177: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
178: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
179: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
180: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
181: decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALES_GROUP_ID),
182: decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
175: decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
176: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
177: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
178: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
179: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
180: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
181: decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALES_GROUP_ID),
182: decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
183: decode( p_FORECAST_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_ID),
176: decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
177: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
178: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
179: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
180: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
181: decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALES_GROUP_ID),
182: decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
183: decode( p_FORECAST_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_ID),
184: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
177: decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
178: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
179: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
180: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
181: decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALES_GROUP_ID),
182: decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
183: decode( p_FORECAST_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_ID),
184: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
185: decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, NULL, p_PERIOD_NAME),
178: decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
179: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
180: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
181: decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALES_GROUP_ID),
182: decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
183: decode( p_FORECAST_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_ID),
184: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
185: decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, NULL, p_PERIOD_NAME),
186: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
179: decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15),
180: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
181: decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALES_GROUP_ID),
182: decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
183: decode( p_FORECAST_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_ID),
184: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
185: decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, NULL, p_PERIOD_NAME),
186: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
187: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
180: decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, NULL, p_SALESFORCE_ID),
181: decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALES_GROUP_ID),
182: decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
183: decode( p_FORECAST_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_ID),
184: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
185: decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, NULL, p_PERIOD_NAME),
186: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
187: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
188: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
181: decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, NULL, p_SALES_GROUP_ID),
182: decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
183: decode( p_FORECAST_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_ID),
184: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
185: decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, NULL, p_PERIOD_NAME),
186: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
187: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
188: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
189: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
182: decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
183: decode( p_FORECAST_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_ID),
184: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
185: decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, NULL, p_PERIOD_NAME),
186: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
187: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
188: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
189: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
190: decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUOTA_AMOUNT_FLAG),
183: decode( p_FORECAST_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_ID),
184: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
185: decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, NULL, p_PERIOD_NAME),
186: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
187: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
188: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
189: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
190: decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUOTA_AMOUNT_FLAG),
191: decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
184: decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, NULL, p_CURRENCY_CODE),
185: decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, NULL, p_PERIOD_NAME),
186: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
187: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
188: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
189: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
190: decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUOTA_AMOUNT_FLAG),
191: decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
192: decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WTD_PIPE_AMOUNT_FLAG),
185: decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, NULL, p_PERIOD_NAME),
186: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
187: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
188: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
189: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
190: decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUOTA_AMOUNT_FLAG),
191: decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
192: decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WTD_PIPE_AMOUNT_FLAG),
193: decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_PIPELINE_AMOUNT_FLAG),
186: decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_START_DATE_ACTIVE),
187: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
188: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
189: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
190: decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUOTA_AMOUNT_FLAG),
191: decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
192: decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WTD_PIPE_AMOUNT_FLAG),
193: decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_PIPELINE_AMOUNT_FLAG),
194: decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WON_PIPELINE_AMOUNT_FLAG),
187: decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, TO_DATE(NULL), p_END_DATE_ACTIVE),
188: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
189: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
190: decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUOTA_AMOUNT_FLAG),
191: decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
192: decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WTD_PIPE_AMOUNT_FLAG),
193: decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_PIPELINE_AMOUNT_FLAG),
194: decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WON_PIPELINE_AMOUNT_FLAG),
195: decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
188: decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
189: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
190: decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUOTA_AMOUNT_FLAG),
191: decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
192: decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WTD_PIPE_AMOUNT_FLAG),
193: decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_PIPELINE_AMOUNT_FLAG),
194: decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WON_PIPELINE_AMOUNT_FLAG),
195: decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
196: decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORECAST_AMOUNT_FLAG),
189: decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
190: decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUOTA_AMOUNT_FLAG),
191: decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
192: decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WTD_PIPE_AMOUNT_FLAG),
193: decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_PIPELINE_AMOUNT_FLAG),
194: decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WON_PIPELINE_AMOUNT_FLAG),
195: decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
196: decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORECAST_AMOUNT_FLAG),
197: decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_BEST_FORECAST_AMOUNT_FLAG),
190: decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_QUOTA_AMOUNT_FLAG),
191: decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
192: decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WTD_PIPE_AMOUNT_FLAG),
193: decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_PIPELINE_AMOUNT_FLAG),
194: decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WON_PIPELINE_AMOUNT_FLAG),
195: decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
196: decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORECAST_AMOUNT_FLAG),
197: decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_BEST_FORECAST_AMOUNT_FLAG),
198: decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
191: decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
192: decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WTD_PIPE_AMOUNT_FLAG),
193: decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_PIPELINE_AMOUNT_FLAG),
194: decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WON_PIPELINE_AMOUNT_FLAG),
195: decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
196: decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORECAST_AMOUNT_FLAG),
197: decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_BEST_FORECAST_AMOUNT_FLAG),
198: decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
199: decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_INTEREST_TYPE_ID),
192: decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WTD_PIPE_AMOUNT_FLAG),
193: decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_PIPELINE_AMOUNT_FLAG),
194: decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WON_PIPELINE_AMOUNT_FLAG),
195: decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
196: decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORECAST_AMOUNT_FLAG),
197: decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_BEST_FORECAST_AMOUNT_FLAG),
198: decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
199: decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_INTEREST_TYPE_ID),
200: decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_CATEGORY_ID),
193: decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_PIPELINE_AMOUNT_FLAG),
194: decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WON_PIPELINE_AMOUNT_FLAG),
195: decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
196: decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORECAST_AMOUNT_FLAG),
197: decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_BEST_FORECAST_AMOUNT_FLAG),
198: decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
199: decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_INTEREST_TYPE_ID),
200: decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_CATEGORY_ID),
201: decode( P_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, P_PRODUCT_CATEGORY_ID),
194: decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WON_PIPELINE_AMOUNT_FLAG),
195: decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
196: decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORECAST_AMOUNT_FLAG),
197: decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_BEST_FORECAST_AMOUNT_FLAG),
198: decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
199: decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_INTEREST_TYPE_ID),
200: decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_CATEGORY_ID),
201: decode( P_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, P_PRODUCT_CATEGORY_ID),
202: decode( P_PRODUCT_CAT_SET_ID, FND_API.G_MISS_NUM, NULL, P_PRODUCT_CAT_SET_ID));
195: decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
196: decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORECAST_AMOUNT_FLAG),
197: decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_BEST_FORECAST_AMOUNT_FLAG),
198: decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
199: decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_INTEREST_TYPE_ID),
200: decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_CATEGORY_ID),
201: decode( P_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, P_PRODUCT_CATEGORY_ID),
202: decode( P_PRODUCT_CAT_SET_ID, FND_API.G_MISS_NUM, NULL, P_PRODUCT_CAT_SET_ID));
203: End Insert_Row;
196: decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_FORECAST_AMOUNT_FLAG),
197: decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_BEST_FORECAST_AMOUNT_FLAG),
198: decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
199: decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_INTEREST_TYPE_ID),
200: decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_CATEGORY_ID),
201: decode( P_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, P_PRODUCT_CATEGORY_ID),
202: decode( P_PRODUCT_CAT_SET_ID, FND_API.G_MISS_NUM, NULL, P_PRODUCT_CAT_SET_ID));
203: End Insert_Row;
204:
197: decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_BEST_FORECAST_AMOUNT_FLAG),
198: decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
199: decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_INTEREST_TYPE_ID),
200: decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_CATEGORY_ID),
201: decode( P_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, P_PRODUCT_CATEGORY_ID),
202: decode( P_PRODUCT_CAT_SET_ID, FND_API.G_MISS_NUM, NULL, P_PRODUCT_CAT_SET_ID));
203: End Insert_Row;
204:
205: PROCEDURE Update_Row(
198: decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
199: decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL, p_INTEREST_TYPE_ID),
200: decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_CATEGORY_ID),
201: decode( P_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, P_PRODUCT_CATEGORY_ID),
202: decode( P_PRODUCT_CAT_SET_ID, FND_API.G_MISS_NUM, NULL, P_PRODUCT_CAT_SET_ID));
203: End Insert_Row;
204:
205: PROCEDURE Update_Row(
206: p_PROD_WORKSHEET_LINE_ID NUMBER,
266: IS
267: BEGIN
268: Update AS_PROD_WORKSHEET_LINES
269: SET object_version_number = nvl(object_version_number,0) + 1,
270: FORECAST_WORKSHEET_ID = decode( p_FORECAST_WORKSHEET_ID, FND_API.G_MISS_NUM, FORECAST_WORKSHEET_ID, p_FORECAST_WORKSHEET_ID),
271: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
272: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
273: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
274: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
267: BEGIN
268: Update AS_PROD_WORKSHEET_LINES
269: SET object_version_number = nvl(object_version_number,0) + 1,
270: FORECAST_WORKSHEET_ID = decode( p_FORECAST_WORKSHEET_ID, FND_API.G_MISS_NUM, FORECAST_WORKSHEET_ID, p_FORECAST_WORKSHEET_ID),
271: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
272: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
273: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
274: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
275: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
268: Update AS_PROD_WORKSHEET_LINES
269: SET object_version_number = nvl(object_version_number,0) + 1,
270: FORECAST_WORKSHEET_ID = decode( p_FORECAST_WORKSHEET_ID, FND_API.G_MISS_NUM, FORECAST_WORKSHEET_ID, p_FORECAST_WORKSHEET_ID),
271: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
272: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
273: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
274: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
275: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
276: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
269: SET object_version_number = nvl(object_version_number,0) + 1,
270: FORECAST_WORKSHEET_ID = decode( p_FORECAST_WORKSHEET_ID, FND_API.G_MISS_NUM, FORECAST_WORKSHEET_ID, p_FORECAST_WORKSHEET_ID),
271: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
272: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
273: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
274: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
275: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
276: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
277: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
270: FORECAST_WORKSHEET_ID = decode( p_FORECAST_WORKSHEET_ID, FND_API.G_MISS_NUM, FORECAST_WORKSHEET_ID, p_FORECAST_WORKSHEET_ID),
271: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
272: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
273: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
274: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
275: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
276: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
277: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
278: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
271: CREATED_BY = decode( p_CREATED_BY, FND_API.G_MISS_NUM, CREATED_BY, p_CREATED_BY),
272: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
273: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
274: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
275: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
276: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
277: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
278: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
279: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
272: CREATION_DATE = decode( p_CREATION_DATE, FND_API.G_MISS_DATE, CREATION_DATE, p_CREATION_DATE),
273: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
274: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
275: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
276: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
277: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
278: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
279: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
280:
273: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
274: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
275: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
276: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
277: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
278: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
279: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
280:
281: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, SALES_QUOTA_ID, p_SALES_QUOTA_ID),
274: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
275: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
276: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
277: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
278: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
279: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
280:
281: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, SALES_QUOTA_ID, p_SALES_QUOTA_ID),
282: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, WORST_FORECAST_AMOUNT, p_WORST_FORECAST_AMOUNT),
275: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
276: REQUEST_ID = decode( p_REQUEST_ID, FND_API.G_MISS_NUM, REQUEST_ID, p_REQUEST_ID),
277: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
278: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
279: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
280:
281: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, SALES_QUOTA_ID, p_SALES_QUOTA_ID),
282: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, WORST_FORECAST_AMOUNT, p_WORST_FORECAST_AMOUNT),
283: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, FORECAST_AMOUNT, p_FORECAST_AMOUNT),
277: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM, PROGRAM_APPLICATION_ID, p_PROGRAM_APPLICATION_ID),
278: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
279: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
280:
281: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, SALES_QUOTA_ID, p_SALES_QUOTA_ID),
282: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, WORST_FORECAST_AMOUNT, p_WORST_FORECAST_AMOUNT),
283: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, FORECAST_AMOUNT, p_FORECAST_AMOUNT),
284: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, BEST_FORECAST_AMOUNT, p_BEST_FORECAST_AMOUNT),
285: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WEIGHTED_PIPELINE_AMOUNT, p_WEIGHTED_PIPELINE_AMOUNT),
278: PROGRAM_ID = decode( p_PROGRAM_ID, FND_API.G_MISS_NUM, PROGRAM_ID, p_PROGRAM_ID),
279: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
280:
281: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, SALES_QUOTA_ID, p_SALES_QUOTA_ID),
282: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, WORST_FORECAST_AMOUNT, p_WORST_FORECAST_AMOUNT),
283: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, FORECAST_AMOUNT, p_FORECAST_AMOUNT),
284: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, BEST_FORECAST_AMOUNT, p_BEST_FORECAST_AMOUNT),
285: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WEIGHTED_PIPELINE_AMOUNT, p_WEIGHTED_PIPELINE_AMOUNT),
286: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, PIPELINE_AMOUNT, p_PIPELINE_AMOUNT),
279: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE, PROGRAM_UPDATE_DATE, p_PROGRAM_UPDATE_DATE),
280:
281: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, SALES_QUOTA_ID, p_SALES_QUOTA_ID),
282: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, WORST_FORECAST_AMOUNT, p_WORST_FORECAST_AMOUNT),
283: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, FORECAST_AMOUNT, p_FORECAST_AMOUNT),
284: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, BEST_FORECAST_AMOUNT, p_BEST_FORECAST_AMOUNT),
285: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WEIGHTED_PIPELINE_AMOUNT, p_WEIGHTED_PIPELINE_AMOUNT),
286: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, PIPELINE_AMOUNT, p_PIPELINE_AMOUNT),
287: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WON_PIPELINE_AMOUNT, p_WON_PIPELINE_AMOUNT),
280:
281: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, SALES_QUOTA_ID, p_SALES_QUOTA_ID),
282: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, WORST_FORECAST_AMOUNT, p_WORST_FORECAST_AMOUNT),
283: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, FORECAST_AMOUNT, p_FORECAST_AMOUNT),
284: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, BEST_FORECAST_AMOUNT, p_BEST_FORECAST_AMOUNT),
285: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WEIGHTED_PIPELINE_AMOUNT, p_WEIGHTED_PIPELINE_AMOUNT),
286: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, PIPELINE_AMOUNT, p_PIPELINE_AMOUNT),
287: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WON_PIPELINE_AMOUNT, p_WON_PIPELINE_AMOUNT),
288: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, QUOTA_AMOUNT, p_QUOTA_AMOUNT),
281: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, FND_API.G_MISS_NUM, SALES_QUOTA_ID, p_SALES_QUOTA_ID),
282: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, WORST_FORECAST_AMOUNT, p_WORST_FORECAST_AMOUNT),
283: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, FORECAST_AMOUNT, p_FORECAST_AMOUNT),
284: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, BEST_FORECAST_AMOUNT, p_BEST_FORECAST_AMOUNT),
285: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WEIGHTED_PIPELINE_AMOUNT, p_WEIGHTED_PIPELINE_AMOUNT),
286: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, PIPELINE_AMOUNT, p_PIPELINE_AMOUNT),
287: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WON_PIPELINE_AMOUNT, p_WON_PIPELINE_AMOUNT),
288: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, QUOTA_AMOUNT, p_QUOTA_AMOUNT),
289: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, GROUP_FORECAST_AMOUNT, p_GROUP_FORECAST_AMOUNT),
282: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, WORST_FORECAST_AMOUNT, p_WORST_FORECAST_AMOUNT),
283: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, FORECAST_AMOUNT, p_FORECAST_AMOUNT),
284: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, BEST_FORECAST_AMOUNT, p_BEST_FORECAST_AMOUNT),
285: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WEIGHTED_PIPELINE_AMOUNT, p_WEIGHTED_PIPELINE_AMOUNT),
286: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, PIPELINE_AMOUNT, p_PIPELINE_AMOUNT),
287: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WON_PIPELINE_AMOUNT, p_WON_PIPELINE_AMOUNT),
288: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, QUOTA_AMOUNT, p_QUOTA_AMOUNT),
289: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, GROUP_FORECAST_AMOUNT, p_GROUP_FORECAST_AMOUNT),
290: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
283: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, FND_API.G_MISS_NUM, FORECAST_AMOUNT, p_FORECAST_AMOUNT),
284: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, BEST_FORECAST_AMOUNT, p_BEST_FORECAST_AMOUNT),
285: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WEIGHTED_PIPELINE_AMOUNT, p_WEIGHTED_PIPELINE_AMOUNT),
286: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, PIPELINE_AMOUNT, p_PIPELINE_AMOUNT),
287: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WON_PIPELINE_AMOUNT, p_WON_PIPELINE_AMOUNT),
288: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, QUOTA_AMOUNT, p_QUOTA_AMOUNT),
289: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, GROUP_FORECAST_AMOUNT, p_GROUP_FORECAST_AMOUNT),
290: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
291: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
284: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, FND_API.G_MISS_NUM, BEST_FORECAST_AMOUNT, p_BEST_FORECAST_AMOUNT),
285: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WEIGHTED_PIPELINE_AMOUNT, p_WEIGHTED_PIPELINE_AMOUNT),
286: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, PIPELINE_AMOUNT, p_PIPELINE_AMOUNT),
287: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WON_PIPELINE_AMOUNT, p_WON_PIPELINE_AMOUNT),
288: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, QUOTA_AMOUNT, p_QUOTA_AMOUNT),
289: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, GROUP_FORECAST_AMOUNT, p_GROUP_FORECAST_AMOUNT),
290: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
291: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
292: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
285: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WEIGHTED_PIPELINE_AMOUNT, p_WEIGHTED_PIPELINE_AMOUNT),
286: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, PIPELINE_AMOUNT, p_PIPELINE_AMOUNT),
287: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WON_PIPELINE_AMOUNT, p_WON_PIPELINE_AMOUNT),
288: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, QUOTA_AMOUNT, p_QUOTA_AMOUNT),
289: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, GROUP_FORECAST_AMOUNT, p_GROUP_FORECAST_AMOUNT),
290: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
291: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
292: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
293: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
286: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, PIPELINE_AMOUNT, p_PIPELINE_AMOUNT),
287: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WON_PIPELINE_AMOUNT, p_WON_PIPELINE_AMOUNT),
288: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, QUOTA_AMOUNT, p_QUOTA_AMOUNT),
289: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, GROUP_FORECAST_AMOUNT, p_GROUP_FORECAST_AMOUNT),
290: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
291: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
292: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
293: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
294: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
287: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, FND_API.G_MISS_NUM, WON_PIPELINE_AMOUNT, p_WON_PIPELINE_AMOUNT),
288: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, QUOTA_AMOUNT, p_QUOTA_AMOUNT),
289: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, GROUP_FORECAST_AMOUNT, p_GROUP_FORECAST_AMOUNT),
290: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
291: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
292: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
293: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
294: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
295: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
288: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, FND_API.G_MISS_NUM, QUOTA_AMOUNT, p_QUOTA_AMOUNT),
289: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, GROUP_FORECAST_AMOUNT, p_GROUP_FORECAST_AMOUNT),
290: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
291: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
292: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
293: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
294: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
295: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
296: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
289: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM, GROUP_FORECAST_AMOUNT, p_GROUP_FORECAST_AMOUNT),
290: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
291: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
292: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
293: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
294: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
295: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
296: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
297: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
290: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
291: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
292: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
293: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
294: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
295: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
296: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
297: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
298: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
291: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, ATTRIBUTE1, p_ATTRIBUTE1),
292: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
293: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
294: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
295: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
296: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
297: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
298: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
299: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
292: ATTRIBUTE2 = decode( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, ATTRIBUTE2, p_ATTRIBUTE2),
293: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
294: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
295: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
296: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
297: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
298: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
299: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
300: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
293: ATTRIBUTE3 = decode( p_ATTRIBUTE3, FND_API.G_MISS_CHAR, ATTRIBUTE3, p_ATTRIBUTE3),
294: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
295: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
296: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
297: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
298: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
299: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
300: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
301: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
294: ATTRIBUTE4 = decode( p_ATTRIBUTE4, FND_API.G_MISS_CHAR, ATTRIBUTE4, p_ATTRIBUTE4),
295: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
296: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
297: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
298: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
299: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
300: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
301: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
302: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
295: ATTRIBUTE5 = decode( p_ATTRIBUTE5, FND_API.G_MISS_CHAR, ATTRIBUTE5, p_ATTRIBUTE5),
296: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
297: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
298: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
299: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
300: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
301: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
302: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
303: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
296: ATTRIBUTE6 = decode( p_ATTRIBUTE6, FND_API.G_MISS_CHAR, ATTRIBUTE6, p_ATTRIBUTE6),
297: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
298: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
299: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
300: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
301: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
302: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
303: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
304: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
297: ATTRIBUTE7 = decode( p_ATTRIBUTE7, FND_API.G_MISS_CHAR, ATTRIBUTE7, p_ATTRIBUTE7),
298: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
299: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
300: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
301: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
302: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
303: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
304: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
305: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
298: ATTRIBUTE8 = decode( p_ATTRIBUTE8, FND_API.G_MISS_CHAR, ATTRIBUTE8, p_ATTRIBUTE8),
299: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
300: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
301: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
302: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
303: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
304: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
305: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
306: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
299: ATTRIBUTE9 = decode( p_ATTRIBUTE9, FND_API.G_MISS_CHAR, ATTRIBUTE9, p_ATTRIBUTE9),
300: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
301: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
302: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
303: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
304: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
305: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
306: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
307: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, SALES_GROUP_ID, p_SALES_GROUP_ID),
300: ATTRIBUTE10 = decode( p_ATTRIBUTE10, FND_API.G_MISS_CHAR, ATTRIBUTE10, p_ATTRIBUTE10),
301: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
302: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
303: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
304: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
305: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
306: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
307: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, SALES_GROUP_ID, p_SALES_GROUP_ID),
308: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, EMPLOYEE_PERSON_ID, p_EMPLOYEE_PERSON_ID),
301: ATTRIBUTE11 = decode( p_ATTRIBUTE11, FND_API.G_MISS_CHAR, ATTRIBUTE11, p_ATTRIBUTE11),
302: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
303: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
304: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
305: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
306: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
307: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, SALES_GROUP_ID, p_SALES_GROUP_ID),
308: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, EMPLOYEE_PERSON_ID, p_EMPLOYEE_PERSON_ID),
309: FORECAST_ID = decode( p_FORECAST_ID, FND_API.G_MISS_NUM, FORECAST_ID, p_FORECAST_ID),
302: ATTRIBUTE12 = decode( p_ATTRIBUTE12, FND_API.G_MISS_CHAR, ATTRIBUTE12, p_ATTRIBUTE12),
303: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
304: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
305: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
306: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
307: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, SALES_GROUP_ID, p_SALES_GROUP_ID),
308: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, EMPLOYEE_PERSON_ID, p_EMPLOYEE_PERSON_ID),
309: FORECAST_ID = decode( p_FORECAST_ID, FND_API.G_MISS_NUM, FORECAST_ID, p_FORECAST_ID),
310: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
303: ATTRIBUTE13 = decode( p_ATTRIBUTE13, FND_API.G_MISS_CHAR, ATTRIBUTE13, p_ATTRIBUTE13),
304: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
305: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
306: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
307: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, SALES_GROUP_ID, p_SALES_GROUP_ID),
308: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, EMPLOYEE_PERSON_ID, p_EMPLOYEE_PERSON_ID),
309: FORECAST_ID = decode( p_FORECAST_ID, FND_API.G_MISS_NUM, FORECAST_ID, p_FORECAST_ID),
310: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
311: PERIOD_NAME = decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, PERIOD_NAME, p_PERIOD_NAME),
304: ATTRIBUTE14 = decode( p_ATTRIBUTE14, FND_API.G_MISS_CHAR, ATTRIBUTE14, p_ATTRIBUTE14),
305: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
306: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
307: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, SALES_GROUP_ID, p_SALES_GROUP_ID),
308: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, EMPLOYEE_PERSON_ID, p_EMPLOYEE_PERSON_ID),
309: FORECAST_ID = decode( p_FORECAST_ID, FND_API.G_MISS_NUM, FORECAST_ID, p_FORECAST_ID),
310: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
311: PERIOD_NAME = decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, PERIOD_NAME, p_PERIOD_NAME),
312: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
305: ATTRIBUTE15 = decode( p_ATTRIBUTE15, FND_API.G_MISS_CHAR, ATTRIBUTE15, p_ATTRIBUTE15),
306: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
307: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, SALES_GROUP_ID, p_SALES_GROUP_ID),
308: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, EMPLOYEE_PERSON_ID, p_EMPLOYEE_PERSON_ID),
309: FORECAST_ID = decode( p_FORECAST_ID, FND_API.G_MISS_NUM, FORECAST_ID, p_FORECAST_ID),
310: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
311: PERIOD_NAME = decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, PERIOD_NAME, p_PERIOD_NAME),
312: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
313: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
306: SALESFORCE_ID = decode( p_SALESFORCE_ID, FND_API.G_MISS_NUM, SALESFORCE_ID, p_SALESFORCE_ID),
307: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, SALES_GROUP_ID, p_SALES_GROUP_ID),
308: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, EMPLOYEE_PERSON_ID, p_EMPLOYEE_PERSON_ID),
309: FORECAST_ID = decode( p_FORECAST_ID, FND_API.G_MISS_NUM, FORECAST_ID, p_FORECAST_ID),
310: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
311: PERIOD_NAME = decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, PERIOD_NAME, p_PERIOD_NAME),
312: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
313: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
314: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
307: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, FND_API.G_MISS_NUM, SALES_GROUP_ID, p_SALES_GROUP_ID),
308: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, EMPLOYEE_PERSON_ID, p_EMPLOYEE_PERSON_ID),
309: FORECAST_ID = decode( p_FORECAST_ID, FND_API.G_MISS_NUM, FORECAST_ID, p_FORECAST_ID),
310: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
311: PERIOD_NAME = decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, PERIOD_NAME, p_PERIOD_NAME),
312: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
313: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
314: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
315: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
308: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, FND_API.G_MISS_NUM, EMPLOYEE_PERSON_ID, p_EMPLOYEE_PERSON_ID),
309: FORECAST_ID = decode( p_FORECAST_ID, FND_API.G_MISS_NUM, FORECAST_ID, p_FORECAST_ID),
310: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
311: PERIOD_NAME = decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, PERIOD_NAME, p_PERIOD_NAME),
312: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
313: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
314: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
315: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
316: QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
309: FORECAST_ID = decode( p_FORECAST_ID, FND_API.G_MISS_NUM, FORECAST_ID, p_FORECAST_ID),
310: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
311: PERIOD_NAME = decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, PERIOD_NAME, p_PERIOD_NAME),
312: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
313: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
314: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
315: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
316: QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
317: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, GROUP_FORECAST_AMOUNT_FLAG, p_GROUP_FORECAST_AMOUNT_FLAG),
310: CURRENCY_CODE = decode( p_CURRENCY_CODE, FND_API.G_MISS_CHAR, CURRENCY_CODE, p_CURRENCY_CODE),
311: PERIOD_NAME = decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, PERIOD_NAME, p_PERIOD_NAME),
312: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
313: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
314: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
315: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
316: QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
317: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, GROUP_FORECAST_AMOUNT_FLAG, p_GROUP_FORECAST_AMOUNT_FLAG),
318: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WEIGHTED_PIPELINE_AMOUNT_FLAG, p_WTD_PIPE_AMOUNT_FLAG),
311: PERIOD_NAME = decode( p_PERIOD_NAME, FND_API.G_MISS_CHAR, PERIOD_NAME, p_PERIOD_NAME),
312: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
313: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
314: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
315: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
316: QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
317: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, GROUP_FORECAST_AMOUNT_FLAG, p_GROUP_FORECAST_AMOUNT_FLAG),
318: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WEIGHTED_PIPELINE_AMOUNT_FLAG, p_WTD_PIPE_AMOUNT_FLAG),
319: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, PIPELINE_AMOUNT_FLAG, p_PIPELINE_AMOUNT_FLAG),
312: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, FND_API.G_MISS_DATE, START_DATE_ACTIVE, p_START_DATE_ACTIVE),
313: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
314: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
315: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
316: QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
317: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, GROUP_FORECAST_AMOUNT_FLAG, p_GROUP_FORECAST_AMOUNT_FLAG),
318: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WEIGHTED_PIPELINE_AMOUNT_FLAG, p_WTD_PIPE_AMOUNT_FLAG),
319: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, PIPELINE_AMOUNT_FLAG, p_PIPELINE_AMOUNT_FLAG),
320: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WON_PIPELINE_AMOUNT_FLAG, p_WON_PIPELINE_AMOUNT_FLAG),
313: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, FND_API.G_MISS_DATE, END_DATE_ACTIVE, p_END_DATE_ACTIVE),
314: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
315: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
316: QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
317: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, GROUP_FORECAST_AMOUNT_FLAG, p_GROUP_FORECAST_AMOUNT_FLAG),
318: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WEIGHTED_PIPELINE_AMOUNT_FLAG, p_WTD_PIPE_AMOUNT_FLAG),
319: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, PIPELINE_AMOUNT_FLAG, p_PIPELINE_AMOUNT_FLAG),
320: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WON_PIPELINE_AMOUNT_FLAG, p_WON_PIPELINE_AMOUNT_FLAG),
321: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WORST_FORECAST_AMOUNT_FLAG, p_WORST_FORECAST_AMOUNT_FLAG),
314: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
315: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
316: QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
317: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, GROUP_FORECAST_AMOUNT_FLAG, p_GROUP_FORECAST_AMOUNT_FLAG),
318: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WEIGHTED_PIPELINE_AMOUNT_FLAG, p_WTD_PIPE_AMOUNT_FLAG),
319: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, PIPELINE_AMOUNT_FLAG, p_PIPELINE_AMOUNT_FLAG),
320: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WON_PIPELINE_AMOUNT_FLAG, p_WON_PIPELINE_AMOUNT_FLAG),
321: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WORST_FORECAST_AMOUNT_FLAG, p_WORST_FORECAST_AMOUNT_FLAG),
322: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
315: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, FND_API.G_MISS_NUM, CREDIT_TYPE_ID, p_CREDIT_TYPE_ID),
316: QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
317: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, GROUP_FORECAST_AMOUNT_FLAG, p_GROUP_FORECAST_AMOUNT_FLAG),
318: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WEIGHTED_PIPELINE_AMOUNT_FLAG, p_WTD_PIPE_AMOUNT_FLAG),
319: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, PIPELINE_AMOUNT_FLAG, p_PIPELINE_AMOUNT_FLAG),
320: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WON_PIPELINE_AMOUNT_FLAG, p_WON_PIPELINE_AMOUNT_FLAG),
321: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WORST_FORECAST_AMOUNT_FLAG, p_WORST_FORECAST_AMOUNT_FLAG),
322: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
323: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, BEST_FORECAST_AMOUNT_FLAG, p_BEST_FORECAST_AMOUNT_FLAG),
316: QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
317: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, GROUP_FORECAST_AMOUNT_FLAG, p_GROUP_FORECAST_AMOUNT_FLAG),
318: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WEIGHTED_PIPELINE_AMOUNT_FLAG, p_WTD_PIPE_AMOUNT_FLAG),
319: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, PIPELINE_AMOUNT_FLAG, p_PIPELINE_AMOUNT_FLAG),
320: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WON_PIPELINE_AMOUNT_FLAG, p_WON_PIPELINE_AMOUNT_FLAG),
321: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WORST_FORECAST_AMOUNT_FLAG, p_WORST_FORECAST_AMOUNT_FLAG),
322: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
323: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, BEST_FORECAST_AMOUNT_FLAG, p_BEST_FORECAST_AMOUNT_FLAG),
324: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, FST_SALES_CATEGORY_ID, p_FST_SALES_CATEGORY_ID),
317: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, GROUP_FORECAST_AMOUNT_FLAG, p_GROUP_FORECAST_AMOUNT_FLAG),
318: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WEIGHTED_PIPELINE_AMOUNT_FLAG, p_WTD_PIPE_AMOUNT_FLAG),
319: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, PIPELINE_AMOUNT_FLAG, p_PIPELINE_AMOUNT_FLAG),
320: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WON_PIPELINE_AMOUNT_FLAG, p_WON_PIPELINE_AMOUNT_FLAG),
321: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WORST_FORECAST_AMOUNT_FLAG, p_WORST_FORECAST_AMOUNT_FLAG),
322: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
323: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, BEST_FORECAST_AMOUNT_FLAG, p_BEST_FORECAST_AMOUNT_FLAG),
324: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, FST_SALES_CATEGORY_ID, p_FST_SALES_CATEGORY_ID),
325: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, INTEREST_TYPE_ID, p_INTEREST_TYPE_ID),
318: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WEIGHTED_PIPELINE_AMOUNT_FLAG, p_WTD_PIPE_AMOUNT_FLAG),
319: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, PIPELINE_AMOUNT_FLAG, p_PIPELINE_AMOUNT_FLAG),
320: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WON_PIPELINE_AMOUNT_FLAG, p_WON_PIPELINE_AMOUNT_FLAG),
321: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WORST_FORECAST_AMOUNT_FLAG, p_WORST_FORECAST_AMOUNT_FLAG),
322: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
323: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, BEST_FORECAST_AMOUNT_FLAG, p_BEST_FORECAST_AMOUNT_FLAG),
324: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, FST_SALES_CATEGORY_ID, p_FST_SALES_CATEGORY_ID),
325: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, INTEREST_TYPE_ID, p_INTEREST_TYPE_ID),
326: FORECAST_CATEGORY_ID = decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, FORECAST_CATEGORY_ID, p_FORECAST_CATEGORY_ID),
319: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, PIPELINE_AMOUNT_FLAG, p_PIPELINE_AMOUNT_FLAG),
320: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WON_PIPELINE_AMOUNT_FLAG, p_WON_PIPELINE_AMOUNT_FLAG),
321: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WORST_FORECAST_AMOUNT_FLAG, p_WORST_FORECAST_AMOUNT_FLAG),
322: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
323: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, BEST_FORECAST_AMOUNT_FLAG, p_BEST_FORECAST_AMOUNT_FLAG),
324: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, FST_SALES_CATEGORY_ID, p_FST_SALES_CATEGORY_ID),
325: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, INTEREST_TYPE_ID, p_INTEREST_TYPE_ID),
326: FORECAST_CATEGORY_ID = decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, FORECAST_CATEGORY_ID, p_FORECAST_CATEGORY_ID),
327: PRODUCT_CATEGORY_ID = decode( P_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, PRODUCT_CATEGORY_ID, P_PRODUCT_CATEGORY_ID),
320: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WON_PIPELINE_AMOUNT_FLAG, p_WON_PIPELINE_AMOUNT_FLAG),
321: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WORST_FORECAST_AMOUNT_FLAG, p_WORST_FORECAST_AMOUNT_FLAG),
322: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
323: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, BEST_FORECAST_AMOUNT_FLAG, p_BEST_FORECAST_AMOUNT_FLAG),
324: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, FST_SALES_CATEGORY_ID, p_FST_SALES_CATEGORY_ID),
325: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, INTEREST_TYPE_ID, p_INTEREST_TYPE_ID),
326: FORECAST_CATEGORY_ID = decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, FORECAST_CATEGORY_ID, p_FORECAST_CATEGORY_ID),
327: PRODUCT_CATEGORY_ID = decode( P_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, PRODUCT_CATEGORY_ID, P_PRODUCT_CATEGORY_ID),
328: PRODUCT_CAT_SET_ID = decode( P_PRODUCT_CAT_SET_ID, FND_API.G_MISS_NUM, PRODUCT_CAT_SET_ID, P_PRODUCT_CAT_SET_ID)
321: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, WORST_FORECAST_AMOUNT_FLAG, p_WORST_FORECAST_AMOUNT_FLAG),
322: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
323: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, BEST_FORECAST_AMOUNT_FLAG, p_BEST_FORECAST_AMOUNT_FLAG),
324: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, FST_SALES_CATEGORY_ID, p_FST_SALES_CATEGORY_ID),
325: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, INTEREST_TYPE_ID, p_INTEREST_TYPE_ID),
326: FORECAST_CATEGORY_ID = decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, FORECAST_CATEGORY_ID, p_FORECAST_CATEGORY_ID),
327: PRODUCT_CATEGORY_ID = decode( P_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, PRODUCT_CATEGORY_ID, P_PRODUCT_CATEGORY_ID),
328: PRODUCT_CAT_SET_ID = decode( P_PRODUCT_CAT_SET_ID, FND_API.G_MISS_NUM, PRODUCT_CAT_SET_ID, P_PRODUCT_CAT_SET_ID)
329: /*
322: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
323: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, BEST_FORECAST_AMOUNT_FLAG, p_BEST_FORECAST_AMOUNT_FLAG),
324: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, FST_SALES_CATEGORY_ID, p_FST_SALES_CATEGORY_ID),
325: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, INTEREST_TYPE_ID, p_INTEREST_TYPE_ID),
326: FORECAST_CATEGORY_ID = decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, FORECAST_CATEGORY_ID, p_FORECAST_CATEGORY_ID),
327: PRODUCT_CATEGORY_ID = decode( P_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, PRODUCT_CATEGORY_ID, P_PRODUCT_CATEGORY_ID),
328: PRODUCT_CAT_SET_ID = decode( P_PRODUCT_CAT_SET_ID, FND_API.G_MISS_NUM, PRODUCT_CAT_SET_ID, P_PRODUCT_CAT_SET_ID)
329: /*
330:
323: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, BEST_FORECAST_AMOUNT_FLAG, p_BEST_FORECAST_AMOUNT_FLAG),
324: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, FST_SALES_CATEGORY_ID, p_FST_SALES_CATEGORY_ID),
325: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, INTEREST_TYPE_ID, p_INTEREST_TYPE_ID),
326: FORECAST_CATEGORY_ID = decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, FORECAST_CATEGORY_ID, p_FORECAST_CATEGORY_ID),
327: PRODUCT_CATEGORY_ID = decode( P_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, PRODUCT_CATEGORY_ID, P_PRODUCT_CATEGORY_ID),
328: PRODUCT_CAT_SET_ID = decode( P_PRODUCT_CAT_SET_ID, FND_API.G_MISS_NUM, PRODUCT_CAT_SET_ID, P_PRODUCT_CAT_SET_ID)
329: /*
330:
331: FORECAST_WORKSHEET_ID = decode( p_FORECAST_WORKSHEET_ID, NULL, FORECAST_WORKSHEET_ID,FND_API.G_MISS_NUM,NULL,p_FORECAST_WORKSHEET_ID),
324: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, FND_API.G_MISS_NUM, FST_SALES_CATEGORY_ID, p_FST_SALES_CATEGORY_ID),
325: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, FND_API.G_MISS_NUM, INTEREST_TYPE_ID, p_INTEREST_TYPE_ID),
326: FORECAST_CATEGORY_ID = decode( p_FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, FORECAST_CATEGORY_ID, p_FORECAST_CATEGORY_ID),
327: PRODUCT_CATEGORY_ID = decode( P_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, PRODUCT_CATEGORY_ID, P_PRODUCT_CATEGORY_ID),
328: PRODUCT_CAT_SET_ID = decode( P_PRODUCT_CAT_SET_ID, FND_API.G_MISS_NUM, PRODUCT_CAT_SET_ID, P_PRODUCT_CAT_SET_ID)
329: /*
330:
331: FORECAST_WORKSHEET_ID = decode( p_FORECAST_WORKSHEET_ID, NULL, FORECAST_WORKSHEET_ID,FND_API.G_MISS_NUM,NULL,p_FORECAST_WORKSHEET_ID),
332: CREATED_BY = decode( p_CREATED_BY, NULL,CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
327: PRODUCT_CATEGORY_ID = decode( P_PRODUCT_CATEGORY_ID, FND_API.G_MISS_NUM, PRODUCT_CATEGORY_ID, P_PRODUCT_CATEGORY_ID),
328: PRODUCT_CAT_SET_ID = decode( P_PRODUCT_CAT_SET_ID, FND_API.G_MISS_NUM, PRODUCT_CAT_SET_ID, P_PRODUCT_CAT_SET_ID)
329: /*
330:
331: FORECAST_WORKSHEET_ID = decode( p_FORECAST_WORKSHEET_ID, NULL, FORECAST_WORKSHEET_ID,FND_API.G_MISS_NUM,NULL,p_FORECAST_WORKSHEET_ID),
332: CREATED_BY = decode( p_CREATED_BY, NULL,CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
333: CREATION_DATE = decode( p_CREATION_DATE, NULL, CREATION_DATE,FND_API.G_MISS_DATE,NULL, p_CREATION_DATE),
334: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
335: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL, p_LAST_UPDATE_DATE),
328: PRODUCT_CAT_SET_ID = decode( P_PRODUCT_CAT_SET_ID, FND_API.G_MISS_NUM, PRODUCT_CAT_SET_ID, P_PRODUCT_CAT_SET_ID)
329: /*
330:
331: FORECAST_WORKSHEET_ID = decode( p_FORECAST_WORKSHEET_ID, NULL, FORECAST_WORKSHEET_ID,FND_API.G_MISS_NUM,NULL,p_FORECAST_WORKSHEET_ID),
332: CREATED_BY = decode( p_CREATED_BY, NULL,CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
333: CREATION_DATE = decode( p_CREATION_DATE, NULL, CREATION_DATE,FND_API.G_MISS_DATE,NULL, p_CREATION_DATE),
334: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
335: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL, p_LAST_UPDATE_DATE),
336: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL, p_LAST_UPDATE_LOGIN),
329: /*
330:
331: FORECAST_WORKSHEET_ID = decode( p_FORECAST_WORKSHEET_ID, NULL, FORECAST_WORKSHEET_ID,FND_API.G_MISS_NUM,NULL,p_FORECAST_WORKSHEET_ID),
332: CREATED_BY = decode( p_CREATED_BY, NULL,CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
333: CREATION_DATE = decode( p_CREATION_DATE, NULL, CREATION_DATE,FND_API.G_MISS_DATE,NULL, p_CREATION_DATE),
334: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
335: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL, p_LAST_UPDATE_DATE),
336: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL, p_LAST_UPDATE_LOGIN),
337: REQUEST_ID = decode( p_REQUEST_ID, NULL,REQUEST_ID, FND_API.G_MISS_NUM,NULL, p_REQUEST_ID),
330:
331: FORECAST_WORKSHEET_ID = decode( p_FORECAST_WORKSHEET_ID, NULL, FORECAST_WORKSHEET_ID,FND_API.G_MISS_NUM,NULL,p_FORECAST_WORKSHEET_ID),
332: CREATED_BY = decode( p_CREATED_BY, NULL,CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
333: CREATION_DATE = decode( p_CREATION_DATE, NULL, CREATION_DATE,FND_API.G_MISS_DATE,NULL, p_CREATION_DATE),
334: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
335: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL, p_LAST_UPDATE_DATE),
336: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL, p_LAST_UPDATE_LOGIN),
337: REQUEST_ID = decode( p_REQUEST_ID, NULL,REQUEST_ID, FND_API.G_MISS_NUM,NULL, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, NULL,PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
331: FORECAST_WORKSHEET_ID = decode( p_FORECAST_WORKSHEET_ID, NULL, FORECAST_WORKSHEET_ID,FND_API.G_MISS_NUM,NULL,p_FORECAST_WORKSHEET_ID),
332: CREATED_BY = decode( p_CREATED_BY, NULL,CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
333: CREATION_DATE = decode( p_CREATION_DATE, NULL, CREATION_DATE,FND_API.G_MISS_DATE,NULL, p_CREATION_DATE),
334: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
335: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL, p_LAST_UPDATE_DATE),
336: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL, p_LAST_UPDATE_LOGIN),
337: REQUEST_ID = decode( p_REQUEST_ID, NULL,REQUEST_ID, FND_API.G_MISS_NUM,NULL, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, NULL,PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, NULL, PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
332: CREATED_BY = decode( p_CREATED_BY, NULL,CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
333: CREATION_DATE = decode( p_CREATION_DATE, NULL, CREATION_DATE,FND_API.G_MISS_DATE,NULL, p_CREATION_DATE),
334: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
335: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL, p_LAST_UPDATE_DATE),
336: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL, p_LAST_UPDATE_LOGIN),
337: REQUEST_ID = decode( p_REQUEST_ID, NULL,REQUEST_ID, FND_API.G_MISS_NUM,NULL, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, NULL,PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, NULL, PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, NULL, PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL, p_PROGRAM_UPDATE_DATE),
333: CREATION_DATE = decode( p_CREATION_DATE, NULL, CREATION_DATE,FND_API.G_MISS_DATE,NULL, p_CREATION_DATE),
334: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
335: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL, p_LAST_UPDATE_DATE),
336: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL, p_LAST_UPDATE_LOGIN),
337: REQUEST_ID = decode( p_REQUEST_ID, NULL,REQUEST_ID, FND_API.G_MISS_NUM,NULL, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, NULL,PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, NULL, PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, NULL, PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL, p_PROGRAM_UPDATE_DATE),
341:
334: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, NULL, LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL,p_LAST_UPDATED_BY),
335: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL, p_LAST_UPDATE_DATE),
336: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL, p_LAST_UPDATE_LOGIN),
337: REQUEST_ID = decode( p_REQUEST_ID, NULL,REQUEST_ID, FND_API.G_MISS_NUM,NULL, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, NULL,PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, NULL, PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, NULL, PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL, p_PROGRAM_UPDATE_DATE),
341:
342: CURRENCY_CODE = decode( p_CURRENCY_CODE, NULL, CURRENCY_CODE,FND_API.G_MISS_CHAR,NULL, p_CURRENCY_CODE),
335: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, NULL, LAST_UPDATE_DATE,FND_API.G_MISS_DATE,NULL, p_LAST_UPDATE_DATE),
336: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL, p_LAST_UPDATE_LOGIN),
337: REQUEST_ID = decode( p_REQUEST_ID, NULL,REQUEST_ID, FND_API.G_MISS_NUM,NULL, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, NULL,PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, NULL, PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, NULL, PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL, p_PROGRAM_UPDATE_DATE),
341:
342: CURRENCY_CODE = decode( p_CURRENCY_CODE, NULL, CURRENCY_CODE,FND_API.G_MISS_CHAR,NULL, p_CURRENCY_CODE),
343: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, NULL,START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE),
336: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, NULL, LAST_UPDATE_LOGIN,FND_API.G_MISS_NUM,NULL, p_LAST_UPDATE_LOGIN),
337: REQUEST_ID = decode( p_REQUEST_ID, NULL,REQUEST_ID, FND_API.G_MISS_NUM,NULL, p_REQUEST_ID),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, NULL,PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, NULL, PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, NULL, PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL, p_PROGRAM_UPDATE_DATE),
341:
342: CURRENCY_CODE = decode( p_CURRENCY_CODE, NULL, CURRENCY_CODE,FND_API.G_MISS_CHAR,NULL, p_CURRENCY_CODE),
343: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, NULL,START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE),
344: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE),
338: PROGRAM_APPLICATION_ID = decode( p_PROGRAM_APPLICATION_ID, NULL,PROGRAM_APPLICATION_ID, FND_API.G_MISS_NUM,NULL,p_PROGRAM_APPLICATION_ID),
339: PROGRAM_ID = decode( p_PROGRAM_ID, NULL, PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, NULL, PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL, p_PROGRAM_UPDATE_DATE),
341:
342: CURRENCY_CODE = decode( p_CURRENCY_CODE, NULL, CURRENCY_CODE,FND_API.G_MISS_CHAR,NULL, p_CURRENCY_CODE),
343: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, NULL,START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE),
344: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE),
345: STATUS_CODE = decode( p_STATUS_CODE, NULL, STATUS_CODE, FND_API.G_MISS_CHAR,NULL, p_STATUS_CODE),
346: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, NULL, WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_WEIGHTED_PIPELINE_AMOUNT),
339: PROGRAM_ID = decode( p_PROGRAM_ID, NULL, PROGRAM_ID, FND_API.G_MISS_NUM, NULL, p_PROGRAM_ID),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, NULL, PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL, p_PROGRAM_UPDATE_DATE),
341:
342: CURRENCY_CODE = decode( p_CURRENCY_CODE, NULL, CURRENCY_CODE,FND_API.G_MISS_CHAR,NULL, p_CURRENCY_CODE),
343: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, NULL,START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE),
344: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE),
345: STATUS_CODE = decode( p_STATUS_CODE, NULL, STATUS_CODE, FND_API.G_MISS_CHAR,NULL, p_STATUS_CODE),
346: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, NULL, WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_WEIGHTED_PIPELINE_AMOUNT),
347: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, NULL, PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_PIPELINE_AMOUNT),
340: PROGRAM_UPDATE_DATE = decode( p_PROGRAM_UPDATE_DATE, NULL, PROGRAM_UPDATE_DATE, FND_API.G_MISS_DATE,NULL, p_PROGRAM_UPDATE_DATE),
341:
342: CURRENCY_CODE = decode( p_CURRENCY_CODE, NULL, CURRENCY_CODE,FND_API.G_MISS_CHAR,NULL, p_CURRENCY_CODE),
343: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, NULL,START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE),
344: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE),
345: STATUS_CODE = decode( p_STATUS_CODE, NULL, STATUS_CODE, FND_API.G_MISS_CHAR,NULL, p_STATUS_CODE),
346: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, NULL, WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_WEIGHTED_PIPELINE_AMOUNT),
347: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, NULL, PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_PIPELINE_AMOUNT),
348: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, NULL, WON_PIPELINE_AMOUNT,FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
341:
342: CURRENCY_CODE = decode( p_CURRENCY_CODE, NULL, CURRENCY_CODE,FND_API.G_MISS_CHAR,NULL, p_CURRENCY_CODE),
343: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, NULL,START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE),
344: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE),
345: STATUS_CODE = decode( p_STATUS_CODE, NULL, STATUS_CODE, FND_API.G_MISS_CHAR,NULL, p_STATUS_CODE),
346: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, NULL, WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_WEIGHTED_PIPELINE_AMOUNT),
347: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, NULL, PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_PIPELINE_AMOUNT),
348: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, NULL, WON_PIPELINE_AMOUNT,FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
349: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, NULL, QUOTA_AMOUNT,FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
342: CURRENCY_CODE = decode( p_CURRENCY_CODE, NULL, CURRENCY_CODE,FND_API.G_MISS_CHAR,NULL, p_CURRENCY_CODE),
343: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, NULL,START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE),
344: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE),
345: STATUS_CODE = decode( p_STATUS_CODE, NULL, STATUS_CODE, FND_API.G_MISS_CHAR,NULL, p_STATUS_CODE),
346: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, NULL, WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_WEIGHTED_PIPELINE_AMOUNT),
347: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, NULL, PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_PIPELINE_AMOUNT),
348: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, NULL, WON_PIPELINE_AMOUNT,FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
349: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, NULL, QUOTA_AMOUNT,FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
350: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, NULL, WEIGHTED_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WTD_PIPE_AMOUNT_FLAG),
343: START_DATE_ACTIVE = decode( p_START_DATE_ACTIVE, NULL,START_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_START_DATE_ACTIVE),
344: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE),
345: STATUS_CODE = decode( p_STATUS_CODE, NULL, STATUS_CODE, FND_API.G_MISS_CHAR,NULL, p_STATUS_CODE),
346: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, NULL, WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_WEIGHTED_PIPELINE_AMOUNT),
347: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, NULL, PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_PIPELINE_AMOUNT),
348: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, NULL, WON_PIPELINE_AMOUNT,FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
349: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, NULL, QUOTA_AMOUNT,FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
350: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, NULL, WEIGHTED_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WTD_PIPE_AMOUNT_FLAG),
351: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, NULL, PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_PIPELINE_AMOUNT_FLAG),
344: END_DATE_ACTIVE = decode( p_END_DATE_ACTIVE, NULL, END_DATE_ACTIVE, FND_API.G_MISS_DATE, NULL, p_END_DATE_ACTIVE),
345: STATUS_CODE = decode( p_STATUS_CODE, NULL, STATUS_CODE, FND_API.G_MISS_CHAR,NULL, p_STATUS_CODE),
346: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, NULL, WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_WEIGHTED_PIPELINE_AMOUNT),
347: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, NULL, PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_PIPELINE_AMOUNT),
348: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, NULL, WON_PIPELINE_AMOUNT,FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
349: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, NULL, QUOTA_AMOUNT,FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
350: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, NULL, WEIGHTED_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WTD_PIPE_AMOUNT_FLAG),
351: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, NULL, PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_PIPELINE_AMOUNT_FLAG),
352: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, NULL, WON_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WON_PIPELINE_AMOUNT_FLAG),
345: STATUS_CODE = decode( p_STATUS_CODE, NULL, STATUS_CODE, FND_API.G_MISS_CHAR,NULL, p_STATUS_CODE),
346: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, NULL, WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_WEIGHTED_PIPELINE_AMOUNT),
347: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, NULL, PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_PIPELINE_AMOUNT),
348: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, NULL, WON_PIPELINE_AMOUNT,FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
349: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, NULL, QUOTA_AMOUNT,FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
350: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, NULL, WEIGHTED_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WTD_PIPE_AMOUNT_FLAG),
351: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, NULL, PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_PIPELINE_AMOUNT_FLAG),
352: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, NULL, WON_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WON_PIPELINE_AMOUNT_FLAG),
353: --QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
346: WEIGHTED_PIPELINE_AMOUNT = decode( p_WEIGHTED_PIPELINE_AMOUNT, NULL, WEIGHTED_PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_WEIGHTED_PIPELINE_AMOUNT),
347: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, NULL, PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_PIPELINE_AMOUNT),
348: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, NULL, WON_PIPELINE_AMOUNT,FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
349: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, NULL, QUOTA_AMOUNT,FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
350: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, NULL, WEIGHTED_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WTD_PIPE_AMOUNT_FLAG),
351: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, NULL, PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_PIPELINE_AMOUNT_FLAG),
352: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, NULL, WON_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WON_PIPELINE_AMOUNT_FLAG),
353: --QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
354: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, NULL,GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM,NULL, p_GROUP_FORECAST_AMOUNT),
347: PIPELINE_AMOUNT = decode( p_PIPELINE_AMOUNT, NULL, PIPELINE_AMOUNT, FND_API.G_MISS_NUM,NULL, p_PIPELINE_AMOUNT),
348: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, NULL, WON_PIPELINE_AMOUNT,FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
349: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, NULL, QUOTA_AMOUNT,FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
350: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, NULL, WEIGHTED_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WTD_PIPE_AMOUNT_FLAG),
351: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, NULL, PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_PIPELINE_AMOUNT_FLAG),
352: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, NULL, WON_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WON_PIPELINE_AMOUNT_FLAG),
353: --QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
354: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, NULL,GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM,NULL, p_GROUP_FORECAST_AMOUNT),
355: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, NULL, GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR,NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
348: WON_PIPELINE_AMOUNT = decode( p_WON_PIPELINE_AMOUNT, NULL, WON_PIPELINE_AMOUNT,FND_API.G_MISS_NUM, NULL, p_WON_PIPELINE_AMOUNT),
349: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, NULL, QUOTA_AMOUNT,FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
350: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, NULL, WEIGHTED_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WTD_PIPE_AMOUNT_FLAG),
351: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, NULL, PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_PIPELINE_AMOUNT_FLAG),
352: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, NULL, WON_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WON_PIPELINE_AMOUNT_FLAG),
353: --QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
354: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, NULL,GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM,NULL, p_GROUP_FORECAST_AMOUNT),
355: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, NULL, GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR,NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
356:
349: QUOTA_AMOUNT = decode( p_QUOTA_AMOUNT, NULL, QUOTA_AMOUNT,FND_API.G_MISS_NUM, NULL, p_QUOTA_AMOUNT),
350: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, NULL, WEIGHTED_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WTD_PIPE_AMOUNT_FLAG),
351: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, NULL, PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_PIPELINE_AMOUNT_FLAG),
352: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, NULL, WON_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WON_PIPELINE_AMOUNT_FLAG),
353: --QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
354: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, NULL,GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM,NULL, p_GROUP_FORECAST_AMOUNT),
355: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, NULL, GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR,NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
356:
357: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, NULL, FST_SALES_CATEGORY_ID,FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
350: WEIGHTED_PIPELINE_AMOUNT_FLAG = decode( p_WTD_PIPE_AMOUNT_FLAG, NULL, WEIGHTED_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WTD_PIPE_AMOUNT_FLAG),
351: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, NULL, PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_PIPELINE_AMOUNT_FLAG),
352: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, NULL, WON_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WON_PIPELINE_AMOUNT_FLAG),
353: --QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
354: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, NULL,GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM,NULL, p_GROUP_FORECAST_AMOUNT),
355: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, NULL, GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR,NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
356:
357: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, NULL, FST_SALES_CATEGORY_ID,FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
358: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, NULL,INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_INTEREST_TYPE_ID),
351: PIPELINE_AMOUNT_FLAG = decode( p_PIPELINE_AMOUNT_FLAG, NULL, PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_PIPELINE_AMOUNT_FLAG),
352: WON_PIPELINE_AMOUNT_FLAG = decode( p_WON_PIPELINE_AMOUNT_FLAG, NULL, WON_PIPELINE_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_WON_PIPELINE_AMOUNT_FLAG),
353: --QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
354: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, NULL,GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM,NULL, p_GROUP_FORECAST_AMOUNT),
355: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, NULL, GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR,NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
356:
357: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, NULL, FST_SALES_CATEGORY_ID,FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
358: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, NULL,INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_INTEREST_TYPE_ID),
359: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, NULL,SALES_QUOTA_ID, FND_API.G_MISS_NUM,NULL, p_SALES_QUOTA_ID),
353: --QUOTA_AMOUNT_FLAG = decode( p_QUOTA_AMOUNT_FLAG, FND_API.G_MISS_CHAR, QUOTA_AMOUNT_FLAG, p_QUOTA_AMOUNT_FLAG),
354: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, NULL,GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM,NULL, p_GROUP_FORECAST_AMOUNT),
355: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, NULL, GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR,NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
356:
357: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, NULL, FST_SALES_CATEGORY_ID,FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
358: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, NULL,INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_INTEREST_TYPE_ID),
359: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, NULL,SALES_QUOTA_ID, FND_API.G_MISS_NUM,NULL, p_SALES_QUOTA_ID),
360:
361: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
354: GROUP_FORECAST_AMOUNT = decode( p_GROUP_FORECAST_AMOUNT, NULL,GROUP_FORECAST_AMOUNT, FND_API.G_MISS_NUM,NULL, p_GROUP_FORECAST_AMOUNT),
355: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, NULL, GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR,NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
356:
357: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, NULL, FST_SALES_CATEGORY_ID,FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
358: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, NULL,INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_INTEREST_TYPE_ID),
359: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, NULL,SALES_QUOTA_ID, FND_API.G_MISS_NUM,NULL, p_SALES_QUOTA_ID),
360:
361: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
362: ATTRIBUTE1 = decode( p_ATTRIBUTE1, NULL, ATTRIBUTE1,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE1),
355: GROUP_FORECAST_AMOUNT_FLAG = decode( p_GROUP_FORECAST_AMOUNT_FLAG, NULL, GROUP_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR,NULL, p_GROUP_FORECAST_AMOUNT_FLAG),
356:
357: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, NULL, FST_SALES_CATEGORY_ID,FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
358: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, NULL,INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_INTEREST_TYPE_ID),
359: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, NULL,SALES_QUOTA_ID, FND_API.G_MISS_NUM,NULL, p_SALES_QUOTA_ID),
360:
361: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
362: ATTRIBUTE1 = decode( p_ATTRIBUTE1, NULL, ATTRIBUTE1,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE1),
363: ATTRIBUTE2 = decode( p_ATTRIBUTE2, NULL, ATTRIBUTE2,FND_API.G_MISS_CHAR,nULL, p_ATTRIBUTE2),
357: FST_SALES_CATEGORY_ID = decode( p_FST_SALES_CATEGORY_ID, NULL, FST_SALES_CATEGORY_ID,FND_API.G_MISS_NUM, NULL, p_FST_SALES_CATEGORY_ID),
358: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, NULL,INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_INTEREST_TYPE_ID),
359: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, NULL,SALES_QUOTA_ID, FND_API.G_MISS_NUM,NULL, p_SALES_QUOTA_ID),
360:
361: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
362: ATTRIBUTE1 = decode( p_ATTRIBUTE1, NULL, ATTRIBUTE1,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE1),
363: ATTRIBUTE2 = decode( p_ATTRIBUTE2, NULL, ATTRIBUTE2,FND_API.G_MISS_CHAR,nULL, p_ATTRIBUTE2),
364: ATTRIBUTE3 = decode( p_ATTRIBUTE3, NULL, ATTRIBUTE3,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE3),
365: ATTRIBUTE4 = decode( p_ATTRIBUTE4, NULL, ATTRIBUTE4,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE4),
358: INTEREST_TYPE_ID = decode( p_INTEREST_TYPE_ID, NULL,INTEREST_TYPE_ID, FND_API.G_MISS_NUM, NULL,p_INTEREST_TYPE_ID),
359: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, NULL,SALES_QUOTA_ID, FND_API.G_MISS_NUM,NULL, p_SALES_QUOTA_ID),
360:
361: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
362: ATTRIBUTE1 = decode( p_ATTRIBUTE1, NULL, ATTRIBUTE1,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE1),
363: ATTRIBUTE2 = decode( p_ATTRIBUTE2, NULL, ATTRIBUTE2,FND_API.G_MISS_CHAR,nULL, p_ATTRIBUTE2),
364: ATTRIBUTE3 = decode( p_ATTRIBUTE3, NULL, ATTRIBUTE3,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE3),
365: ATTRIBUTE4 = decode( p_ATTRIBUTE4, NULL, ATTRIBUTE4,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE4),
366: ATTRIBUTE5 = decode( p_ATTRIBUTE5, NULL, ATTRIBUTE5,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE5),
359: SALES_QUOTA_ID = decode( p_SALES_QUOTA_ID, NULL,SALES_QUOTA_ID, FND_API.G_MISS_NUM,NULL, p_SALES_QUOTA_ID),
360:
361: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
362: ATTRIBUTE1 = decode( p_ATTRIBUTE1, NULL, ATTRIBUTE1,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE1),
363: ATTRIBUTE2 = decode( p_ATTRIBUTE2, NULL, ATTRIBUTE2,FND_API.G_MISS_CHAR,nULL, p_ATTRIBUTE2),
364: ATTRIBUTE3 = decode( p_ATTRIBUTE3, NULL, ATTRIBUTE3,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE3),
365: ATTRIBUTE4 = decode( p_ATTRIBUTE4, NULL, ATTRIBUTE4,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE4),
366: ATTRIBUTE5 = decode( p_ATTRIBUTE5, NULL, ATTRIBUTE5,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE5),
367: ATTRIBUTE6 = decode( p_ATTRIBUTE6, NULL, ATTRIBUTE6,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE6),
360:
361: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
362: ATTRIBUTE1 = decode( p_ATTRIBUTE1, NULL, ATTRIBUTE1,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE1),
363: ATTRIBUTE2 = decode( p_ATTRIBUTE2, NULL, ATTRIBUTE2,FND_API.G_MISS_CHAR,nULL, p_ATTRIBUTE2),
364: ATTRIBUTE3 = decode( p_ATTRIBUTE3, NULL, ATTRIBUTE3,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE3),
365: ATTRIBUTE4 = decode( p_ATTRIBUTE4, NULL, ATTRIBUTE4,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE4),
366: ATTRIBUTE5 = decode( p_ATTRIBUTE5, NULL, ATTRIBUTE5,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE5),
367: ATTRIBUTE6 = decode( p_ATTRIBUTE6, NULL, ATTRIBUTE6,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE6),
368: ATTRIBUTE7 = decode( p_ATTRIBUTE7, NULL, ATTRIBUTE7,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE7),
361: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, NULL,ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
362: ATTRIBUTE1 = decode( p_ATTRIBUTE1, NULL, ATTRIBUTE1,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE1),
363: ATTRIBUTE2 = decode( p_ATTRIBUTE2, NULL, ATTRIBUTE2,FND_API.G_MISS_CHAR,nULL, p_ATTRIBUTE2),
364: ATTRIBUTE3 = decode( p_ATTRIBUTE3, NULL, ATTRIBUTE3,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE3),
365: ATTRIBUTE4 = decode( p_ATTRIBUTE4, NULL, ATTRIBUTE4,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE4),
366: ATTRIBUTE5 = decode( p_ATTRIBUTE5, NULL, ATTRIBUTE5,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE5),
367: ATTRIBUTE6 = decode( p_ATTRIBUTE6, NULL, ATTRIBUTE6,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE6),
368: ATTRIBUTE7 = decode( p_ATTRIBUTE7, NULL, ATTRIBUTE7,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE7),
369: ATTRIBUTE8 = decode( p_ATTRIBUTE8, NULL, ATTRIBUTE8,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE8),
362: ATTRIBUTE1 = decode( p_ATTRIBUTE1, NULL, ATTRIBUTE1,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE1),
363: ATTRIBUTE2 = decode( p_ATTRIBUTE2, NULL, ATTRIBUTE2,FND_API.G_MISS_CHAR,nULL, p_ATTRIBUTE2),
364: ATTRIBUTE3 = decode( p_ATTRIBUTE3, NULL, ATTRIBUTE3,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE3),
365: ATTRIBUTE4 = decode( p_ATTRIBUTE4, NULL, ATTRIBUTE4,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE4),
366: ATTRIBUTE5 = decode( p_ATTRIBUTE5, NULL, ATTRIBUTE5,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE5),
367: ATTRIBUTE6 = decode( p_ATTRIBUTE6, NULL, ATTRIBUTE6,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE6),
368: ATTRIBUTE7 = decode( p_ATTRIBUTE7, NULL, ATTRIBUTE7,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE7),
369: ATTRIBUTE8 = decode( p_ATTRIBUTE8, NULL, ATTRIBUTE8,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE8),
370: ATTRIBUTE9 = decode( p_ATTRIBUTE9, NULL, ATTRIBUTE9,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE9),
363: ATTRIBUTE2 = decode( p_ATTRIBUTE2, NULL, ATTRIBUTE2,FND_API.G_MISS_CHAR,nULL, p_ATTRIBUTE2),
364: ATTRIBUTE3 = decode( p_ATTRIBUTE3, NULL, ATTRIBUTE3,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE3),
365: ATTRIBUTE4 = decode( p_ATTRIBUTE4, NULL, ATTRIBUTE4,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE4),
366: ATTRIBUTE5 = decode( p_ATTRIBUTE5, NULL, ATTRIBUTE5,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE5),
367: ATTRIBUTE6 = decode( p_ATTRIBUTE6, NULL, ATTRIBUTE6,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE6),
368: ATTRIBUTE7 = decode( p_ATTRIBUTE7, NULL, ATTRIBUTE7,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE7),
369: ATTRIBUTE8 = decode( p_ATTRIBUTE8, NULL, ATTRIBUTE8,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE8),
370: ATTRIBUTE9 = decode( p_ATTRIBUTE9, NULL, ATTRIBUTE9,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE9),
371: ATTRIBUTE10 = decode( p_ATTRIBUTE10, NULL, ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
364: ATTRIBUTE3 = decode( p_ATTRIBUTE3, NULL, ATTRIBUTE3,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE3),
365: ATTRIBUTE4 = decode( p_ATTRIBUTE4, NULL, ATTRIBUTE4,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE4),
366: ATTRIBUTE5 = decode( p_ATTRIBUTE5, NULL, ATTRIBUTE5,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE5),
367: ATTRIBUTE6 = decode( p_ATTRIBUTE6, NULL, ATTRIBUTE6,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE6),
368: ATTRIBUTE7 = decode( p_ATTRIBUTE7, NULL, ATTRIBUTE7,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE7),
369: ATTRIBUTE8 = decode( p_ATTRIBUTE8, NULL, ATTRIBUTE8,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE8),
370: ATTRIBUTE9 = decode( p_ATTRIBUTE9, NULL, ATTRIBUTE9,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE9),
371: ATTRIBUTE10 = decode( p_ATTRIBUTE10, NULL, ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
372: ATTRIBUTE11 = decode( p_ATTRIBUTE11, NULL, ATTRIBUTE11,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE11),
365: ATTRIBUTE4 = decode( p_ATTRIBUTE4, NULL, ATTRIBUTE4,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE4),
366: ATTRIBUTE5 = decode( p_ATTRIBUTE5, NULL, ATTRIBUTE5,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE5),
367: ATTRIBUTE6 = decode( p_ATTRIBUTE6, NULL, ATTRIBUTE6,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE6),
368: ATTRIBUTE7 = decode( p_ATTRIBUTE7, NULL, ATTRIBUTE7,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE7),
369: ATTRIBUTE8 = decode( p_ATTRIBUTE8, NULL, ATTRIBUTE8,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE8),
370: ATTRIBUTE9 = decode( p_ATTRIBUTE9, NULL, ATTRIBUTE9,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE9),
371: ATTRIBUTE10 = decode( p_ATTRIBUTE10, NULL, ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
372: ATTRIBUTE11 = decode( p_ATTRIBUTE11, NULL, ATTRIBUTE11,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE11),
373: ATTRIBUTE12 = decode( p_ATTRIBUTE12, NULL, ATTRIBUTE12,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE12),
366: ATTRIBUTE5 = decode( p_ATTRIBUTE5, NULL, ATTRIBUTE5,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE5),
367: ATTRIBUTE6 = decode( p_ATTRIBUTE6, NULL, ATTRIBUTE6,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE6),
368: ATTRIBUTE7 = decode( p_ATTRIBUTE7, NULL, ATTRIBUTE7,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE7),
369: ATTRIBUTE8 = decode( p_ATTRIBUTE8, NULL, ATTRIBUTE8,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE8),
370: ATTRIBUTE9 = decode( p_ATTRIBUTE9, NULL, ATTRIBUTE9,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE9),
371: ATTRIBUTE10 = decode( p_ATTRIBUTE10, NULL, ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
372: ATTRIBUTE11 = decode( p_ATTRIBUTE11, NULL, ATTRIBUTE11,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE11),
373: ATTRIBUTE12 = decode( p_ATTRIBUTE12, NULL, ATTRIBUTE12,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE12),
374: ATTRIBUTE13 = decode( p_ATTRIBUTE13, NULL, ATTRIBUTE13,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE13),
367: ATTRIBUTE6 = decode( p_ATTRIBUTE6, NULL, ATTRIBUTE6,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE6),
368: ATTRIBUTE7 = decode( p_ATTRIBUTE7, NULL, ATTRIBUTE7,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE7),
369: ATTRIBUTE8 = decode( p_ATTRIBUTE8, NULL, ATTRIBUTE8,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE8),
370: ATTRIBUTE9 = decode( p_ATTRIBUTE9, NULL, ATTRIBUTE9,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE9),
371: ATTRIBUTE10 = decode( p_ATTRIBUTE10, NULL, ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
372: ATTRIBUTE11 = decode( p_ATTRIBUTE11, NULL, ATTRIBUTE11,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE11),
373: ATTRIBUTE12 = decode( p_ATTRIBUTE12, NULL, ATTRIBUTE12,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE12),
374: ATTRIBUTE13 = decode( p_ATTRIBUTE13, NULL, ATTRIBUTE13,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE13),
375: ATTRIBUTE14 = decode( p_ATTRIBUTE14, NULL, ATTRIBUTE14,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE14),
368: ATTRIBUTE7 = decode( p_ATTRIBUTE7, NULL, ATTRIBUTE7,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE7),
369: ATTRIBUTE8 = decode( p_ATTRIBUTE8, NULL, ATTRIBUTE8,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE8),
370: ATTRIBUTE9 = decode( p_ATTRIBUTE9, NULL, ATTRIBUTE9,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE9),
371: ATTRIBUTE10 = decode( p_ATTRIBUTE10, NULL, ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
372: ATTRIBUTE11 = decode( p_ATTRIBUTE11, NULL, ATTRIBUTE11,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE11),
373: ATTRIBUTE12 = decode( p_ATTRIBUTE12, NULL, ATTRIBUTE12,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE12),
374: ATTRIBUTE13 = decode( p_ATTRIBUTE13, NULL, ATTRIBUTE13,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE13),
375: ATTRIBUTE14 = decode( p_ATTRIBUTE14, NULL, ATTRIBUTE14,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE14),
376: ATTRIBUTE15 = decode( p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE15),
369: ATTRIBUTE8 = decode( p_ATTRIBUTE8, NULL, ATTRIBUTE8,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE8),
370: ATTRIBUTE9 = decode( p_ATTRIBUTE9, NULL, ATTRIBUTE9,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE9),
371: ATTRIBUTE10 = decode( p_ATTRIBUTE10, NULL, ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
372: ATTRIBUTE11 = decode( p_ATTRIBUTE11, NULL, ATTRIBUTE11,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE11),
373: ATTRIBUTE12 = decode( p_ATTRIBUTE12, NULL, ATTRIBUTE12,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE12),
374: ATTRIBUTE13 = decode( p_ATTRIBUTE13, NULL, ATTRIBUTE13,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE13),
375: ATTRIBUTE14 = decode( p_ATTRIBUTE14, NULL, ATTRIBUTE14,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE14),
376: ATTRIBUTE15 = decode( p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE15),
377:
370: ATTRIBUTE9 = decode( p_ATTRIBUTE9, NULL, ATTRIBUTE9,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE9),
371: ATTRIBUTE10 = decode( p_ATTRIBUTE10, NULL, ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
372: ATTRIBUTE11 = decode( p_ATTRIBUTE11, NULL, ATTRIBUTE11,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE11),
373: ATTRIBUTE12 = decode( p_ATTRIBUTE12, NULL, ATTRIBUTE12,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE12),
374: ATTRIBUTE13 = decode( p_ATTRIBUTE13, NULL, ATTRIBUTE13,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE13),
375: ATTRIBUTE14 = decode( p_ATTRIBUTE14, NULL, ATTRIBUTE14,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE14),
376: ATTRIBUTE15 = decode( p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE15),
377:
378: SALESFORCE_ID = decode( p_SALESFORCE_ID, NULL, SALESFORCE_ID,FND_API.G_MISS_NUM,NULL, p_SALESFORCE_ID),
371: ATTRIBUTE10 = decode( p_ATTRIBUTE10, NULL, ATTRIBUTE10,FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
372: ATTRIBUTE11 = decode( p_ATTRIBUTE11, NULL, ATTRIBUTE11,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE11),
373: ATTRIBUTE12 = decode( p_ATTRIBUTE12, NULL, ATTRIBUTE12,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE12),
374: ATTRIBUTE13 = decode( p_ATTRIBUTE13, NULL, ATTRIBUTE13,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE13),
375: ATTRIBUTE14 = decode( p_ATTRIBUTE14, NULL, ATTRIBUTE14,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE14),
376: ATTRIBUTE15 = decode( p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE15),
377:
378: SALESFORCE_ID = decode( p_SALESFORCE_ID, NULL, SALESFORCE_ID,FND_API.G_MISS_NUM,NULL, p_SALESFORCE_ID),
379: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, NULL, SALES_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SALES_GROUP_ID),
372: ATTRIBUTE11 = decode( p_ATTRIBUTE11, NULL, ATTRIBUTE11,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE11),
373: ATTRIBUTE12 = decode( p_ATTRIBUTE12, NULL, ATTRIBUTE12,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE12),
374: ATTRIBUTE13 = decode( p_ATTRIBUTE13, NULL, ATTRIBUTE13,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE13),
375: ATTRIBUTE14 = decode( p_ATTRIBUTE14, NULL, ATTRIBUTE14,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE14),
376: ATTRIBUTE15 = decode( p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE15),
377:
378: SALESFORCE_ID = decode( p_SALESFORCE_ID, NULL, SALESFORCE_ID,FND_API.G_MISS_NUM,NULL, p_SALESFORCE_ID),
379: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, NULL, SALES_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SALES_GROUP_ID),
380: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, NULL, EMPLOYEE_PERSON_ID,FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
374: ATTRIBUTE13 = decode( p_ATTRIBUTE13, NULL, ATTRIBUTE13,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE13),
375: ATTRIBUTE14 = decode( p_ATTRIBUTE14, NULL, ATTRIBUTE14,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE14),
376: ATTRIBUTE15 = decode( p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE15),
377:
378: SALESFORCE_ID = decode( p_SALESFORCE_ID, NULL, SALESFORCE_ID,FND_API.G_MISS_NUM,NULL, p_SALESFORCE_ID),
379: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, NULL, SALES_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SALES_GROUP_ID),
380: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, NULL, EMPLOYEE_PERSON_ID,FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
381: PERIOD_NAME = decode( p_PERIOD_NAME, NULL, PERIOD_NAME,FND_API.G_MISS_CHAR,NULL, p_PERIOD_NAME),
382: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, NULL, CREDIT_TYPE_ID,FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
375: ATTRIBUTE14 = decode( p_ATTRIBUTE14, NULL, ATTRIBUTE14,FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE14),
376: ATTRIBUTE15 = decode( p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE15),
377:
378: SALESFORCE_ID = decode( p_SALESFORCE_ID, NULL, SALESFORCE_ID,FND_API.G_MISS_NUM,NULL, p_SALESFORCE_ID),
379: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, NULL, SALES_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SALES_GROUP_ID),
380: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, NULL, EMPLOYEE_PERSON_ID,FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
381: PERIOD_NAME = decode( p_PERIOD_NAME, NULL, PERIOD_NAME,FND_API.G_MISS_CHAR,NULL, p_PERIOD_NAME),
382: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, NULL, CREDIT_TYPE_ID,FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
383: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, NULL,WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
376: ATTRIBUTE15 = decode( p_ATTRIBUTE15, NULL, ATTRIBUTE15, FND_API.G_MISS_CHAR,NULL, p_ATTRIBUTE15),
377:
378: SALESFORCE_ID = decode( p_SALESFORCE_ID, NULL, SALESFORCE_ID,FND_API.G_MISS_NUM,NULL, p_SALESFORCE_ID),
379: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, NULL, SALES_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SALES_GROUP_ID),
380: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, NULL, EMPLOYEE_PERSON_ID,FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
381: PERIOD_NAME = decode( p_PERIOD_NAME, NULL, PERIOD_NAME,FND_API.G_MISS_CHAR,NULL, p_PERIOD_NAME),
382: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, NULL, CREDIT_TYPE_ID,FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
383: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, NULL,WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
384: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, NULL, WORST_FORECAST_AMOUNT,FND_API.G_MISS_NUM,NULL, p_WORST_FORECAST_AMOUNT),
377:
378: SALESFORCE_ID = decode( p_SALESFORCE_ID, NULL, SALESFORCE_ID,FND_API.G_MISS_NUM,NULL, p_SALESFORCE_ID),
379: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, NULL, SALES_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SALES_GROUP_ID),
380: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, NULL, EMPLOYEE_PERSON_ID,FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
381: PERIOD_NAME = decode( p_PERIOD_NAME, NULL, PERIOD_NAME,FND_API.G_MISS_CHAR,NULL, p_PERIOD_NAME),
382: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, NULL, CREDIT_TYPE_ID,FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
383: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, NULL,WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
384: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, NULL, WORST_FORECAST_AMOUNT,FND_API.G_MISS_NUM,NULL, p_WORST_FORECAST_AMOUNT),
385: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
378: SALESFORCE_ID = decode( p_SALESFORCE_ID, NULL, SALESFORCE_ID,FND_API.G_MISS_NUM,NULL, p_SALESFORCE_ID),
379: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, NULL, SALES_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SALES_GROUP_ID),
380: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, NULL, EMPLOYEE_PERSON_ID,FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
381: PERIOD_NAME = decode( p_PERIOD_NAME, NULL, PERIOD_NAME,FND_API.G_MISS_CHAR,NULL, p_PERIOD_NAME),
382: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, NULL, CREDIT_TYPE_ID,FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
383: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, NULL,WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
384: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, NULL, WORST_FORECAST_AMOUNT,FND_API.G_MISS_NUM,NULL, p_WORST_FORECAST_AMOUNT),
385: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
386: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, NULL,FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
379: SALES_GROUP_ID = decode( p_SALES_GROUP_ID, NULL, SALES_GROUP_ID,FND_API.G_MISS_NUM,NULL, p_SALES_GROUP_ID),
380: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, NULL, EMPLOYEE_PERSON_ID,FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
381: PERIOD_NAME = decode( p_PERIOD_NAME, NULL, PERIOD_NAME,FND_API.G_MISS_CHAR,NULL, p_PERIOD_NAME),
382: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, NULL, CREDIT_TYPE_ID,FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
383: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, NULL,WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
384: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, NULL, WORST_FORECAST_AMOUNT,FND_API.G_MISS_NUM,NULL, p_WORST_FORECAST_AMOUNT),
385: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
386: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, NULL,FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
387: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, NULL, BEST_FORECAST_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_BEST_FORECAST_AMOUNT_FLAG),
380: EMPLOYEE_PERSON_ID = decode( p_EMPLOYEE_PERSON_ID, NULL, EMPLOYEE_PERSON_ID,FND_API.G_MISS_NUM, NULL, p_EMPLOYEE_PERSON_ID),
381: PERIOD_NAME = decode( p_PERIOD_NAME, NULL, PERIOD_NAME,FND_API.G_MISS_CHAR,NULL, p_PERIOD_NAME),
382: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, NULL, CREDIT_TYPE_ID,FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
383: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, NULL,WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
384: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, NULL, WORST_FORECAST_AMOUNT,FND_API.G_MISS_NUM,NULL, p_WORST_FORECAST_AMOUNT),
385: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
386: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, NULL,FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
387: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, NULL, BEST_FORECAST_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_BEST_FORECAST_AMOUNT_FLAG),
388: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, NULL, BEST_FORECAST_AMOUNT,FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
381: PERIOD_NAME = decode( p_PERIOD_NAME, NULL, PERIOD_NAME,FND_API.G_MISS_CHAR,NULL, p_PERIOD_NAME),
382: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, NULL, CREDIT_TYPE_ID,FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
383: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, NULL,WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
384: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, NULL, WORST_FORECAST_AMOUNT,FND_API.G_MISS_NUM,NULL, p_WORST_FORECAST_AMOUNT),
385: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
386: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, NULL,FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
387: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, NULL, BEST_FORECAST_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_BEST_FORECAST_AMOUNT_FLAG),
388: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, NULL, BEST_FORECAST_AMOUNT,FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
389: FORECAST_ID = decode( p_FORECAST_ID, NULL, FORECAST_ID,FND_API.G_MISS_NUM,NULL, p_FORECAST_ID),
382: CREDIT_TYPE_ID = decode( p_CREDIT_TYPE_ID, NULL, CREDIT_TYPE_ID,FND_API.G_MISS_NUM, NULL, p_CREDIT_TYPE_ID),
383: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, NULL,WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
384: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, NULL, WORST_FORECAST_AMOUNT,FND_API.G_MISS_NUM,NULL, p_WORST_FORECAST_AMOUNT),
385: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
386: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, NULL,FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
387: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, NULL, BEST_FORECAST_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_BEST_FORECAST_AMOUNT_FLAG),
388: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, NULL, BEST_FORECAST_AMOUNT,FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
389: FORECAST_ID = decode( p_FORECAST_ID, NULL, FORECAST_ID,FND_API.G_MISS_NUM,NULL, p_FORECAST_ID),
390: FORECAST_CATEGORY_ID = decode( p_FORECAST_CATEGORY_ID, NULL,FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_CATEGORY_ID)
383: WORST_FORECAST_AMOUNT_FLAG = decode( p_WORST_FORECAST_AMOUNT_FLAG, NULL,WORST_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, NULL, p_WORST_FORECAST_AMOUNT_FLAG),
384: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, NULL, WORST_FORECAST_AMOUNT,FND_API.G_MISS_NUM,NULL, p_WORST_FORECAST_AMOUNT),
385: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
386: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, NULL,FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
387: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, NULL, BEST_FORECAST_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_BEST_FORECAST_AMOUNT_FLAG),
388: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, NULL, BEST_FORECAST_AMOUNT,FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
389: FORECAST_ID = decode( p_FORECAST_ID, NULL, FORECAST_ID,FND_API.G_MISS_NUM,NULL, p_FORECAST_ID),
390: FORECAST_CATEGORY_ID = decode( p_FORECAST_CATEGORY_ID, NULL,FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_CATEGORY_ID)
391: */
384: WORST_FORECAST_AMOUNT = decode( p_WORST_FORECAST_AMOUNT, NULL, WORST_FORECAST_AMOUNT,FND_API.G_MISS_NUM,NULL, p_WORST_FORECAST_AMOUNT),
385: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
386: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, NULL,FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
387: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, NULL, BEST_FORECAST_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_BEST_FORECAST_AMOUNT_FLAG),
388: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, NULL, BEST_FORECAST_AMOUNT,FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
389: FORECAST_ID = decode( p_FORECAST_ID, NULL, FORECAST_ID,FND_API.G_MISS_NUM,NULL, p_FORECAST_ID),
390: FORECAST_CATEGORY_ID = decode( p_FORECAST_CATEGORY_ID, NULL,FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_CATEGORY_ID)
391: */
392: where PROD_WORKSHEET_LINE_ID = p_PROD_WORKSHEET_LINE_ID;
385: FORECAST_AMOUNT_FLAG = decode( p_FORECAST_AMOUNT_FLAG, FND_API.G_MISS_CHAR, FORECAST_AMOUNT_FLAG, p_FORECAST_AMOUNT_FLAG),
386: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, NULL,FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
387: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, NULL, BEST_FORECAST_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_BEST_FORECAST_AMOUNT_FLAG),
388: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, NULL, BEST_FORECAST_AMOUNT,FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
389: FORECAST_ID = decode( p_FORECAST_ID, NULL, FORECAST_ID,FND_API.G_MISS_NUM,NULL, p_FORECAST_ID),
390: FORECAST_CATEGORY_ID = decode( p_FORECAST_CATEGORY_ID, NULL,FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_CATEGORY_ID)
391: */
392: where PROD_WORKSHEET_LINE_ID = p_PROD_WORKSHEET_LINE_ID;
393:
386: FORECAST_AMOUNT = decode( p_FORECAST_AMOUNT, NULL,FORECAST_AMOUNT, FND_API.G_MISS_NUM, NULL, p_FORECAST_AMOUNT),
387: BEST_FORECAST_AMOUNT_FLAG = decode( p_BEST_FORECAST_AMOUNT_FLAG, NULL, BEST_FORECAST_AMOUNT_FLAG,FND_API.G_MISS_CHAR,NULL, p_BEST_FORECAST_AMOUNT_FLAG),
388: BEST_FORECAST_AMOUNT = decode( p_BEST_FORECAST_AMOUNT, NULL, BEST_FORECAST_AMOUNT,FND_API.G_MISS_NUM, NULL, p_BEST_FORECAST_AMOUNT),
389: FORECAST_ID = decode( p_FORECAST_ID, NULL, FORECAST_ID,FND_API.G_MISS_NUM,NULL, p_FORECAST_ID),
390: FORECAST_CATEGORY_ID = decode( p_FORECAST_CATEGORY_ID, NULL,FORECAST_CATEGORY_ID, FND_API.G_MISS_NUM, NULL, p_FORECAST_CATEGORY_ID)
391: */
392: where PROD_WORKSHEET_LINE_ID = p_PROD_WORKSHEET_LINE_ID;
393:
394: If (SQL%NOTFOUND) then