140: attribute13 ,
141: attribute14 ,
142: attribute15
143: ) VALUES (
144: DECODE( p_MODEL_ID, FND_API.G_MISS_NUM, NULL, p_MODEL_ID),
145: DECODE( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
146: DECODE( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
147: DECODE( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
148: DECODE( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
141: attribute14 ,
142: attribute15
143: ) VALUES (
144: DECODE( p_MODEL_ID, FND_API.G_MISS_NUM, NULL, p_MODEL_ID),
145: DECODE( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
146: DECODE( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
147: DECODE( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
148: DECODE( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
149: DECODE( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
142: attribute15
143: ) VALUES (
144: DECODE( p_MODEL_ID, FND_API.G_MISS_NUM, NULL, p_MODEL_ID),
145: DECODE( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
146: DECODE( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
147: DECODE( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
148: DECODE( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
149: DECODE( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
150: DECODE( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
143: ) VALUES (
144: DECODE( p_MODEL_ID, FND_API.G_MISS_NUM, NULL, p_MODEL_ID),
145: DECODE( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
146: DECODE( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
147: DECODE( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
148: DECODE( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
149: DECODE( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
150: DECODE( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
151: DECODE( p_MODEL_TYPE, FND_API.G_MISS_CHAR, NULL, p_MODEL_TYPE),
144: DECODE( p_MODEL_ID, FND_API.G_MISS_NUM, NULL, p_MODEL_ID),
145: DECODE( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
146: DECODE( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
147: DECODE( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
148: DECODE( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
149: DECODE( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
150: DECODE( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
151: DECODE( p_MODEL_TYPE, FND_API.G_MISS_CHAR, NULL, p_MODEL_TYPE),
152: DECODE( p_USER_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_USER_STATUS_ID),
145: DECODE( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_UPDATE_DATE),
146: DECODE( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
147: DECODE( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
148: DECODE( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
149: DECODE( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
150: DECODE( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
151: DECODE( p_MODEL_TYPE, FND_API.G_MISS_CHAR, NULL, p_MODEL_TYPE),
152: DECODE( p_USER_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_USER_STATUS_ID),
153: DECODE( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
146: DECODE( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATED_BY),
147: DECODE( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
148: DECODE( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
149: DECODE( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
150: DECODE( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
151: DECODE( p_MODEL_TYPE, FND_API.G_MISS_CHAR, NULL, p_MODEL_TYPE),
152: DECODE( p_USER_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_USER_STATUS_ID),
153: DECODE( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
154: DECODE( p_STATUS_DATE, FND_API.G_MISS_CHAR, NULL, p_STATUS_DATE),
147: DECODE( p_CREATION_DATE, FND_API.G_MISS_DATE, NULL, p_CREATION_DATE),
148: DECODE( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
149: DECODE( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
150: DECODE( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
151: DECODE( p_MODEL_TYPE, FND_API.G_MISS_CHAR, NULL, p_MODEL_TYPE),
152: DECODE( p_USER_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_USER_STATUS_ID),
153: DECODE( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
154: DECODE( p_STATUS_DATE, FND_API.G_MISS_CHAR, NULL, p_STATUS_DATE),
155: DECODE( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_BUILD_DATE),
148: DECODE( p_CREATED_BY, FND_API.G_MISS_NUM, NULL, p_CREATED_BY),
149: DECODE( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
150: DECODE( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
151: DECODE( p_MODEL_TYPE, FND_API.G_MISS_CHAR, NULL, p_MODEL_TYPE),
152: DECODE( p_USER_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_USER_STATUS_ID),
153: DECODE( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
154: DECODE( p_STATUS_DATE, FND_API.G_MISS_CHAR, NULL, p_STATUS_DATE),
155: DECODE( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_BUILD_DATE),
156: DECODE( p_OWNER_USER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_USER_ID),
149: DECODE( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, NULL, p_LAST_UPDATE_LOGIN),
150: DECODE( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
151: DECODE( p_MODEL_TYPE, FND_API.G_MISS_CHAR, NULL, p_MODEL_TYPE),
152: DECODE( p_USER_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_USER_STATUS_ID),
153: DECODE( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
154: DECODE( p_STATUS_DATE, FND_API.G_MISS_CHAR, NULL, p_STATUS_DATE),
155: DECODE( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_BUILD_DATE),
156: DECODE( p_OWNER_USER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_USER_ID),
157: DECODE( p_PERFORMANCE, FND_API.G_MISS_NUM, NULL, p_PERFORMANCE),
150: DECODE( p_OBJECT_VERSION_NUMBER, FND_API.G_MISS_NUM, 1, p_OBJECT_VERSION_NUMBER),
151: DECODE( p_MODEL_TYPE, FND_API.G_MISS_CHAR, NULL, p_MODEL_TYPE),
152: DECODE( p_USER_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_USER_STATUS_ID),
153: DECODE( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
154: DECODE( p_STATUS_DATE, FND_API.G_MISS_CHAR, NULL, p_STATUS_DATE),
155: DECODE( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_BUILD_DATE),
156: DECODE( p_OWNER_USER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_USER_ID),
157: DECODE( p_PERFORMANCE, FND_API.G_MISS_NUM, NULL, p_PERFORMANCE),
158: DECODE( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, p_TARGET_GROUP_TYPE),
151: DECODE( p_MODEL_TYPE, FND_API.G_MISS_CHAR, NULL, p_MODEL_TYPE),
152: DECODE( p_USER_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_USER_STATUS_ID),
153: DECODE( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
154: DECODE( p_STATUS_DATE, FND_API.G_MISS_CHAR, NULL, p_STATUS_DATE),
155: DECODE( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_BUILD_DATE),
156: DECODE( p_OWNER_USER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_USER_ID),
157: DECODE( p_PERFORMANCE, FND_API.G_MISS_NUM, NULL, p_PERFORMANCE),
158: DECODE( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, p_TARGET_GROUP_TYPE),
159: DECODE( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, NULL, p_DARWIN_MODEL_REF),
152: DECODE( p_USER_STATUS_ID, FND_API.G_MISS_NUM, NULL, p_USER_STATUS_ID),
153: DECODE( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
154: DECODE( p_STATUS_DATE, FND_API.G_MISS_CHAR, NULL, p_STATUS_DATE),
155: DECODE( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_BUILD_DATE),
156: DECODE( p_OWNER_USER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_USER_ID),
157: DECODE( p_PERFORMANCE, FND_API.G_MISS_NUM, NULL, p_PERFORMANCE),
158: DECODE( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, p_TARGET_GROUP_TYPE),
159: DECODE( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, NULL, p_DARWIN_MODEL_REF),
160: DECODE( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,NULL, p_SCHEDULED_DATE),
153: DECODE( p_STATUS_CODE, FND_API.G_MISS_CHAR, NULL, p_STATUS_CODE),
154: DECODE( p_STATUS_DATE, FND_API.G_MISS_CHAR, NULL, p_STATUS_DATE),
155: DECODE( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_BUILD_DATE),
156: DECODE( p_OWNER_USER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_USER_ID),
157: DECODE( p_PERFORMANCE, FND_API.G_MISS_NUM, NULL, p_PERFORMANCE),
158: DECODE( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, p_TARGET_GROUP_TYPE),
159: DECODE( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, NULL, p_DARWIN_MODEL_REF),
160: DECODE( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,NULL, p_SCHEDULED_DATE),
161: DECODE( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_SCHEDULED_TIMEZONE_ID),
154: DECODE( p_STATUS_DATE, FND_API.G_MISS_CHAR, NULL, p_STATUS_DATE),
155: DECODE( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_BUILD_DATE),
156: DECODE( p_OWNER_USER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_USER_ID),
157: DECODE( p_PERFORMANCE, FND_API.G_MISS_NUM, NULL, p_PERFORMANCE),
158: DECODE( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, p_TARGET_GROUP_TYPE),
159: DECODE( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, NULL, p_DARWIN_MODEL_REF),
160: DECODE( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,NULL, p_SCHEDULED_DATE),
161: DECODE( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_SCHEDULED_TIMEZONE_ID),
162: DECODE( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,NULL, p_EXPIRATION_DATE),
155: DECODE( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, NULL, p_LAST_BUILD_DATE),
156: DECODE( p_OWNER_USER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_USER_ID),
157: DECODE( p_PERFORMANCE, FND_API.G_MISS_NUM, NULL, p_PERFORMANCE),
158: DECODE( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, p_TARGET_GROUP_TYPE),
159: DECODE( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, NULL, p_DARWIN_MODEL_REF),
160: DECODE( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,NULL, p_SCHEDULED_DATE),
161: DECODE( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_SCHEDULED_TIMEZONE_ID),
162: DECODE( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,NULL, p_EXPIRATION_DATE),
163: DECODE( p_RESULTS_FLAG, FND_API.G_MISS_CHAR, 'N', p_RESULTS_FLAG),
156: DECODE( p_OWNER_USER_ID, FND_API.G_MISS_NUM, NULL, p_OWNER_USER_ID),
157: DECODE( p_PERFORMANCE, FND_API.G_MISS_NUM, NULL, p_PERFORMANCE),
158: DECODE( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, p_TARGET_GROUP_TYPE),
159: DECODE( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, NULL, p_DARWIN_MODEL_REF),
160: DECODE( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,NULL, p_SCHEDULED_DATE),
161: DECODE( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_SCHEDULED_TIMEZONE_ID),
162: DECODE( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,NULL, p_EXPIRATION_DATE),
163: DECODE( p_RESULTS_FLAG, FND_API.G_MISS_CHAR, 'N', p_RESULTS_FLAG),
164: DECODE( p_LOGS_FLAG, FND_API.g_miss_char, 'N', p_LOGS_FLAG),
157: DECODE( p_PERFORMANCE, FND_API.G_MISS_NUM, NULL, p_PERFORMANCE),
158: DECODE( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, p_TARGET_GROUP_TYPE),
159: DECODE( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, NULL, p_DARWIN_MODEL_REF),
160: DECODE( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,NULL, p_SCHEDULED_DATE),
161: DECODE( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_SCHEDULED_TIMEZONE_ID),
162: DECODE( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,NULL, p_EXPIRATION_DATE),
163: DECODE( p_RESULTS_FLAG, FND_API.G_MISS_CHAR, 'N', p_RESULTS_FLAG),
164: DECODE( p_LOGS_FLAG, FND_API.g_miss_char, 'N', p_LOGS_FLAG),
165: DECODE( p_TARGET_FIELD, FND_API.g_miss_char, NULL, p_TARGET_FIELD),
158: DECODE( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, NULL, p_TARGET_GROUP_TYPE),
159: DECODE( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, NULL, p_DARWIN_MODEL_REF),
160: DECODE( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,NULL, p_SCHEDULED_DATE),
161: DECODE( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_SCHEDULED_TIMEZONE_ID),
162: DECODE( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,NULL, p_EXPIRATION_DATE),
163: DECODE( p_RESULTS_FLAG, FND_API.G_MISS_CHAR, 'N', p_RESULTS_FLAG),
164: DECODE( p_LOGS_FLAG, FND_API.g_miss_char, 'N', p_LOGS_FLAG),
165: DECODE( p_TARGET_FIELD, FND_API.g_miss_char, NULL, p_TARGET_FIELD),
166: DECODE( p_TARGET_TYPE, FND_API.g_miss_char, NULL, p_TARGET_TYPE),
159: DECODE( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, NULL, p_DARWIN_MODEL_REF),
160: DECODE( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,NULL, p_SCHEDULED_DATE),
161: DECODE( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_SCHEDULED_TIMEZONE_ID),
162: DECODE( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,NULL, p_EXPIRATION_DATE),
163: DECODE( p_RESULTS_FLAG, FND_API.G_MISS_CHAR, 'N', p_RESULTS_FLAG),
164: DECODE( p_LOGS_FLAG, FND_API.g_miss_char, 'N', p_LOGS_FLAG),
165: DECODE( p_TARGET_FIELD, FND_API.g_miss_char, NULL, p_TARGET_FIELD),
166: DECODE( p_TARGET_TYPE, FND_API.g_miss_char, NULL, p_TARGET_TYPE),
167: DECODE( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, NULL, p_TARGET_POSITIVE_VALUE),
160: DECODE( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,NULL, p_SCHEDULED_DATE),
161: DECODE( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_SCHEDULED_TIMEZONE_ID),
162: DECODE( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,NULL, p_EXPIRATION_DATE),
163: DECODE( p_RESULTS_FLAG, FND_API.G_MISS_CHAR, 'N', p_RESULTS_FLAG),
164: DECODE( p_LOGS_FLAG, FND_API.g_miss_char, 'N', p_LOGS_FLAG),
165: DECODE( p_TARGET_FIELD, FND_API.g_miss_char, NULL, p_TARGET_FIELD),
166: DECODE( p_TARGET_TYPE, FND_API.g_miss_char, NULL, p_TARGET_TYPE),
167: DECODE( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, NULL, p_TARGET_POSITIVE_VALUE),
168: DECODE( p_TOTAL_RECORDS, FND_API.g_miss_num, NULL, p_TOTAL_RECORDS),
161: DECODE( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, NULL, p_SCHEDULED_TIMEZONE_ID),
162: DECODE( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,NULL, p_EXPIRATION_DATE),
163: DECODE( p_RESULTS_FLAG, FND_API.G_MISS_CHAR, 'N', p_RESULTS_FLAG),
164: DECODE( p_LOGS_FLAG, FND_API.g_miss_char, 'N', p_LOGS_FLAG),
165: DECODE( p_TARGET_FIELD, FND_API.g_miss_char, NULL, p_TARGET_FIELD),
166: DECODE( p_TARGET_TYPE, FND_API.g_miss_char, NULL, p_TARGET_TYPE),
167: DECODE( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, NULL, p_TARGET_POSITIVE_VALUE),
168: DECODE( p_TOTAL_RECORDS, FND_API.g_miss_num, NULL, p_TOTAL_RECORDS),
169: DECODE( p_TOTAL_POSITIVES, FND_API.g_miss_num, NULL, p_TOTAL_POSITIVES),
162: DECODE( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,NULL, p_EXPIRATION_DATE),
163: DECODE( p_RESULTS_FLAG, FND_API.G_MISS_CHAR, 'N', p_RESULTS_FLAG),
164: DECODE( p_LOGS_FLAG, FND_API.g_miss_char, 'N', p_LOGS_FLAG),
165: DECODE( p_TARGET_FIELD, FND_API.g_miss_char, NULL, p_TARGET_FIELD),
166: DECODE( p_TARGET_TYPE, FND_API.g_miss_char, NULL, p_TARGET_TYPE),
167: DECODE( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, NULL, p_TARGET_POSITIVE_VALUE),
168: DECODE( p_TOTAL_RECORDS, FND_API.g_miss_num, NULL, p_TOTAL_RECORDS),
169: DECODE( p_TOTAL_POSITIVES, FND_API.g_miss_num, NULL, p_TOTAL_POSITIVES),
170: DECODE( p_MIN_RECORDS, FND_API.g_miss_num, NULL, p_MIN_RECORDS),
163: DECODE( p_RESULTS_FLAG, FND_API.G_MISS_CHAR, 'N', p_RESULTS_FLAG),
164: DECODE( p_LOGS_FLAG, FND_API.g_miss_char, 'N', p_LOGS_FLAG),
165: DECODE( p_TARGET_FIELD, FND_API.g_miss_char, NULL, p_TARGET_FIELD),
166: DECODE( p_TARGET_TYPE, FND_API.g_miss_char, NULL, p_TARGET_TYPE),
167: DECODE( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, NULL, p_TARGET_POSITIVE_VALUE),
168: DECODE( p_TOTAL_RECORDS, FND_API.g_miss_num, NULL, p_TOTAL_RECORDS),
169: DECODE( p_TOTAL_POSITIVES, FND_API.g_miss_num, NULL, p_TOTAL_POSITIVES),
170: DECODE( p_MIN_RECORDS, FND_API.g_miss_num, NULL, p_MIN_RECORDS),
171: DECODE( p_MAX_RECORDS, FND_API.g_miss_num, NULL, p_MAX_RECORDS),
164: DECODE( p_LOGS_FLAG, FND_API.g_miss_char, 'N', p_LOGS_FLAG),
165: DECODE( p_TARGET_FIELD, FND_API.g_miss_char, NULL, p_TARGET_FIELD),
166: DECODE( p_TARGET_TYPE, FND_API.g_miss_char, NULL, p_TARGET_TYPE),
167: DECODE( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, NULL, p_TARGET_POSITIVE_VALUE),
168: DECODE( p_TOTAL_RECORDS, FND_API.g_miss_num, NULL, p_TOTAL_RECORDS),
169: DECODE( p_TOTAL_POSITIVES, FND_API.g_miss_num, NULL, p_TOTAL_POSITIVES),
170: DECODE( p_MIN_RECORDS, FND_API.g_miss_num, NULL, p_MIN_RECORDS),
171: DECODE( p_MAX_RECORDS, FND_API.g_miss_num, NULL, p_MAX_RECORDS),
172: DECODE( p_row_selection_type, FND_API.g_miss_char, L_DEFAULT_SELECTION_TYPE, p_row_selection_type),
165: DECODE( p_TARGET_FIELD, FND_API.g_miss_char, NULL, p_TARGET_FIELD),
166: DECODE( p_TARGET_TYPE, FND_API.g_miss_char, NULL, p_TARGET_TYPE),
167: DECODE( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, NULL, p_TARGET_POSITIVE_VALUE),
168: DECODE( p_TOTAL_RECORDS, FND_API.g_miss_num, NULL, p_TOTAL_RECORDS),
169: DECODE( p_TOTAL_POSITIVES, FND_API.g_miss_num, NULL, p_TOTAL_POSITIVES),
170: DECODE( p_MIN_RECORDS, FND_API.g_miss_num, NULL, p_MIN_RECORDS),
171: DECODE( p_MAX_RECORDS, FND_API.g_miss_num, NULL, p_MAX_RECORDS),
172: DECODE( p_row_selection_type, FND_API.g_miss_char, L_DEFAULT_SELECTION_TYPE, p_row_selection_type),
173: DECODE( p_EVERY_NTH_ROW, FND_API.g_miss_num, NULL, p_EVERY_NTH_ROW),
166: DECODE( p_TARGET_TYPE, FND_API.g_miss_char, NULL, p_TARGET_TYPE),
167: DECODE( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, NULL, p_TARGET_POSITIVE_VALUE),
168: DECODE( p_TOTAL_RECORDS, FND_API.g_miss_num, NULL, p_TOTAL_RECORDS),
169: DECODE( p_TOTAL_POSITIVES, FND_API.g_miss_num, NULL, p_TOTAL_POSITIVES),
170: DECODE( p_MIN_RECORDS, FND_API.g_miss_num, NULL, p_MIN_RECORDS),
171: DECODE( p_MAX_RECORDS, FND_API.g_miss_num, NULL, p_MAX_RECORDS),
172: DECODE( p_row_selection_type, FND_API.g_miss_char, L_DEFAULT_SELECTION_TYPE, p_row_selection_type),
173: DECODE( p_EVERY_NTH_ROW, FND_API.g_miss_num, NULL, p_EVERY_NTH_ROW),
174: DECODE( p_PCT_RANDOM, FND_API.g_miss_num, NULL, p_PCT_RANDOM),
167: DECODE( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, NULL, p_TARGET_POSITIVE_VALUE),
168: DECODE( p_TOTAL_RECORDS, FND_API.g_miss_num, NULL, p_TOTAL_RECORDS),
169: DECODE( p_TOTAL_POSITIVES, FND_API.g_miss_num, NULL, p_TOTAL_POSITIVES),
170: DECODE( p_MIN_RECORDS, FND_API.g_miss_num, NULL, p_MIN_RECORDS),
171: DECODE( p_MAX_RECORDS, FND_API.g_miss_num, NULL, p_MAX_RECORDS),
172: DECODE( p_row_selection_type, FND_API.g_miss_char, L_DEFAULT_SELECTION_TYPE, p_row_selection_type),
173: DECODE( p_EVERY_NTH_ROW, FND_API.g_miss_num, NULL, p_EVERY_NTH_ROW),
174: DECODE( p_PCT_RANDOM, FND_API.g_miss_num, NULL, p_PCT_RANDOM),
175: DECODE( p_best_subtree, FND_API.g_miss_num, NULL, p_best_subtree),
168: DECODE( p_TOTAL_RECORDS, FND_API.g_miss_num, NULL, p_TOTAL_RECORDS),
169: DECODE( p_TOTAL_POSITIVES, FND_API.g_miss_num, NULL, p_TOTAL_POSITIVES),
170: DECODE( p_MIN_RECORDS, FND_API.g_miss_num, NULL, p_MIN_RECORDS),
171: DECODE( p_MAX_RECORDS, FND_API.g_miss_num, NULL, p_MAX_RECORDS),
172: DECODE( p_row_selection_type, FND_API.g_miss_char, L_DEFAULT_SELECTION_TYPE, p_row_selection_type),
173: DECODE( p_EVERY_NTH_ROW, FND_API.g_miss_num, NULL, p_EVERY_NTH_ROW),
174: DECODE( p_PCT_RANDOM, FND_API.g_miss_num, NULL, p_PCT_RANDOM),
175: DECODE( p_best_subtree, FND_API.g_miss_num, NULL, p_best_subtree),
176: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
169: DECODE( p_TOTAL_POSITIVES, FND_API.g_miss_num, NULL, p_TOTAL_POSITIVES),
170: DECODE( p_MIN_RECORDS, FND_API.g_miss_num, NULL, p_MIN_RECORDS),
171: DECODE( p_MAX_RECORDS, FND_API.g_miss_num, NULL, p_MAX_RECORDS),
172: DECODE( p_row_selection_type, FND_API.g_miss_char, L_DEFAULT_SELECTION_TYPE, p_row_selection_type),
173: DECODE( p_EVERY_NTH_ROW, FND_API.g_miss_num, NULL, p_EVERY_NTH_ROW),
174: DECODE( p_PCT_RANDOM, FND_API.g_miss_num, NULL, p_PCT_RANDOM),
175: DECODE( p_best_subtree, FND_API.g_miss_num, NULL, p_best_subtree),
176: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
177: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
170: DECODE( p_MIN_RECORDS, FND_API.g_miss_num, NULL, p_MIN_RECORDS),
171: DECODE( p_MAX_RECORDS, FND_API.g_miss_num, NULL, p_MAX_RECORDS),
172: DECODE( p_row_selection_type, FND_API.g_miss_char, L_DEFAULT_SELECTION_TYPE, p_row_selection_type),
173: DECODE( p_EVERY_NTH_ROW, FND_API.g_miss_num, NULL, p_EVERY_NTH_ROW),
174: DECODE( p_PCT_RANDOM, FND_API.g_miss_num, NULL, p_PCT_RANDOM),
175: DECODE( p_best_subtree, FND_API.g_miss_num, NULL, p_best_subtree),
176: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
177: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
178: DECODE( p_wf_itemkey, FND_API.G_MISS_CHAR, NULL, p_wf_itemkey),
171: DECODE( p_MAX_RECORDS, FND_API.g_miss_num, NULL, p_MAX_RECORDS),
172: DECODE( p_row_selection_type, FND_API.g_miss_char, L_DEFAULT_SELECTION_TYPE, p_row_selection_type),
173: DECODE( p_EVERY_NTH_ROW, FND_API.g_miss_num, NULL, p_EVERY_NTH_ROW),
174: DECODE( p_PCT_RANDOM, FND_API.g_miss_num, NULL, p_PCT_RANDOM),
175: DECODE( p_best_subtree, FND_API.g_miss_num, NULL, p_best_subtree),
176: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
177: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
178: DECODE( p_wf_itemkey, FND_API.G_MISS_CHAR, NULL, p_wf_itemkey),
179: DECODE( p_target_id, FND_API.G_MISS_CHAR, NULL, p_target_id),
172: DECODE( p_row_selection_type, FND_API.g_miss_char, L_DEFAULT_SELECTION_TYPE, p_row_selection_type),
173: DECODE( p_EVERY_NTH_ROW, FND_API.g_miss_num, NULL, p_EVERY_NTH_ROW),
174: DECODE( p_PCT_RANDOM, FND_API.g_miss_num, NULL, p_PCT_RANDOM),
175: DECODE( p_best_subtree, FND_API.g_miss_num, NULL, p_best_subtree),
176: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
177: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
178: DECODE( p_wf_itemkey, FND_API.G_MISS_CHAR, NULL, p_wf_itemkey),
179: DECODE( p_target_id, FND_API.G_MISS_CHAR, NULL, p_target_id),
180: DECODE( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
173: DECODE( p_EVERY_NTH_ROW, FND_API.g_miss_num, NULL, p_EVERY_NTH_ROW),
174: DECODE( p_PCT_RANDOM, FND_API.g_miss_num, NULL, p_PCT_RANDOM),
175: DECODE( p_best_subtree, FND_API.g_miss_num, NULL, p_best_subtree),
176: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
177: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
178: DECODE( p_wf_itemkey, FND_API.G_MISS_CHAR, NULL, p_wf_itemkey),
179: DECODE( p_target_id, FND_API.G_MISS_CHAR, NULL, p_target_id),
180: DECODE( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
181: DECODE( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
174: DECODE( p_PCT_RANDOM, FND_API.g_miss_num, NULL, p_PCT_RANDOM),
175: DECODE( p_best_subtree, FND_API.g_miss_num, NULL, p_best_subtree),
176: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
177: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
178: DECODE( p_wf_itemkey, FND_API.G_MISS_CHAR, NULL, p_wf_itemkey),
179: DECODE( p_target_id, FND_API.G_MISS_CHAR, NULL, p_target_id),
180: DECODE( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
181: DECODE( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
182: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
175: DECODE( p_best_subtree, FND_API.g_miss_num, NULL, p_best_subtree),
176: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
177: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
178: DECODE( p_wf_itemkey, FND_API.G_MISS_CHAR, NULL, p_wf_itemkey),
179: DECODE( p_target_id, FND_API.G_MISS_CHAR, NULL, p_target_id),
180: DECODE( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
181: DECODE( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
182: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
183: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
176: DECODE( p_custom_setup_id, FND_API.g_miss_num, NULL, p_custom_setup_id),
177: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
178: DECODE( p_wf_itemkey, FND_API.G_MISS_CHAR, NULL, p_wf_itemkey),
179: DECODE( p_target_id, FND_API.G_MISS_CHAR, NULL, p_target_id),
180: DECODE( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
181: DECODE( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
182: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
183: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
184: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
177: DECODE( p_country_id, FND_API.g_miss_num, NULL, p_country_id),
178: DECODE( p_wf_itemkey, FND_API.G_MISS_CHAR, NULL, p_wf_itemkey),
179: DECODE( p_target_id, FND_API.G_MISS_CHAR, NULL, p_target_id),
180: DECODE( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
181: DECODE( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
182: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
183: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
184: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
185: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
178: DECODE( p_wf_itemkey, FND_API.G_MISS_CHAR, NULL, p_wf_itemkey),
179: DECODE( p_target_id, FND_API.G_MISS_CHAR, NULL, p_target_id),
180: DECODE( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
181: DECODE( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
182: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
183: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
184: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
185: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
186: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
179: DECODE( p_target_id, FND_API.G_MISS_CHAR, NULL, p_target_id),
180: DECODE( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
181: DECODE( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
182: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
183: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
184: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
185: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
186: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
187: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
180: DECODE( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE_CATEGORY),
181: DECODE( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
182: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
183: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
184: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
185: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
186: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
187: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
188: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
181: DECODE( p_ATTRIBUTE1, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE1),
182: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
183: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
184: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
185: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
186: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
187: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
188: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
189: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
182: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE2),
183: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
184: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
185: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
186: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
187: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
188: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
189: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
190: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
183: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE3),
184: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
185: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
186: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
187: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
188: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
189: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
190: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
191: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
184: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE4),
185: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
186: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
187: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
188: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
189: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
190: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
191: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
192: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
185: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE5),
186: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
187: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
188: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
189: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
190: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
191: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
192: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
193: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
186: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE6),
187: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
188: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
189: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
190: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
191: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
192: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
193: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
194: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
187: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE7),
188: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
189: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
190: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
191: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
192: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
193: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
194: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
195: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
188: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE8),
189: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
190: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
191: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
192: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
193: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
194: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
195: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
196: );
189: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE9),
190: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
191: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
192: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
193: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
194: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
195: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
196: );
197:
190: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE10),
191: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
192: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
193: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
194: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
195: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
196: );
197:
198: INSERT INTO ams_dm_models_all_tl(
191: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE11),
192: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE12),
193: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE13),
194: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE14),
195: DECODE( p_ATTRIBUTE2, FND_API.G_MISS_CHAR, NULL, p_ATTRIBUTE15)
196: );
197:
198: INSERT INTO ams_dm_models_all_tl(
199: model_id,
207: model_name,
208: description
209: )
210: SELECT
211: decode( p_MODEL_ID, FND_API.G_MISS_NUM, NULL, p_MODEL_ID),
212: l.language_code,
213: SYSDATE,
214: FND_GLOBAL.user_id,
215: SYSDATE,
215: SYSDATE,
216: FND_GLOBAL.user_id,
217: FND_GLOBAL.conc_login_id,
218: USERENV('LANG'),
219: decode( p_MODEL_NAME, FND_API.G_MISS_CHAR, NULL, p_MODEL_NAME),
220: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
221: FROM fnd_languages l
222: WHERE l.installed_flag in ('I', 'B')
223: AND NOT EXISTS(
216: FND_GLOBAL.user_id,
217: FND_GLOBAL.conc_login_id,
218: USERENV('LANG'),
219: decode( p_MODEL_NAME, FND_API.G_MISS_CHAR, NULL, p_MODEL_NAME),
220: decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, NULL, p_DESCRIPTION)
221: FROM fnd_languages l
222: WHERE l.installed_flag in ('I', 'B')
223: AND NOT EXISTS(
224: SELECT NULL
222: WHERE l.installed_flag in ('I', 'B')
223: AND NOT EXISTS(
224: SELECT NULL
225: FROM ams_dm_models_all_tl t
226: WHERE t.model_id = decode( p_MODEL_ID, FND_API.G_MISS_NUM, NULL, p_MODEL_ID)
227: AND t.language = l.language_code );
228:
229: End Insert_Row;
230:
285: IS
286: BEGIN
287: Update ams_dm_models_all_b
288: SET
289: MODEL_ID = decode( p_MODEL_ID, FND_API.G_MISS_NUM, MODEL_ID, p_MODEL_ID),
290: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
291: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
292: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
293: object_version_number = object_version_number + 1,
286: BEGIN
287: Update ams_dm_models_all_b
288: SET
289: MODEL_ID = decode( p_MODEL_ID, FND_API.G_MISS_NUM, MODEL_ID, p_MODEL_ID),
290: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
291: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
292: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
293: object_version_number = object_version_number + 1,
294: MODEL_TYPE = decode( p_MODEL_TYPE, FND_API.G_MISS_CHAR, MODEL_TYPE, p_MODEL_TYPE),
287: Update ams_dm_models_all_b
288: SET
289: MODEL_ID = decode( p_MODEL_ID, FND_API.G_MISS_NUM, MODEL_ID, p_MODEL_ID),
290: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
291: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
292: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
293: object_version_number = object_version_number + 1,
294: MODEL_TYPE = decode( p_MODEL_TYPE, FND_API.G_MISS_CHAR, MODEL_TYPE, p_MODEL_TYPE),
295: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.G_MISS_NUM, USER_STATUS_ID, p_USER_STATUS_ID),
288: SET
289: MODEL_ID = decode( p_MODEL_ID, FND_API.G_MISS_NUM, MODEL_ID, p_MODEL_ID),
290: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
291: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
292: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
293: object_version_number = object_version_number + 1,
294: MODEL_TYPE = decode( p_MODEL_TYPE, FND_API.G_MISS_CHAR, MODEL_TYPE, p_MODEL_TYPE),
295: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.G_MISS_NUM, USER_STATUS_ID, p_USER_STATUS_ID),
296: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
290: LAST_UPDATE_DATE = decode( p_LAST_UPDATE_DATE, FND_API.G_MISS_DATE, LAST_UPDATE_DATE, p_LAST_UPDATE_DATE),
291: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
292: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
293: object_version_number = object_version_number + 1,
294: MODEL_TYPE = decode( p_MODEL_TYPE, FND_API.G_MISS_CHAR, MODEL_TYPE, p_MODEL_TYPE),
295: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.G_MISS_NUM, USER_STATUS_ID, p_USER_STATUS_ID),
296: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
297: STATUS_DATE = decode( p_STATUS_DATE, FND_API.G_MISS_CHAR, STATUS_DATE, p_STATUS_DATE),
298: LAST_BUILD_DATE = decode( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, LAST_BUILD_DATE, p_LAST_BUILD_DATE),
291: LAST_UPDATED_BY = decode( p_LAST_UPDATED_BY, FND_API.G_MISS_NUM, LAST_UPDATED_BY, p_LAST_UPDATED_BY),
292: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
293: object_version_number = object_version_number + 1,
294: MODEL_TYPE = decode( p_MODEL_TYPE, FND_API.G_MISS_CHAR, MODEL_TYPE, p_MODEL_TYPE),
295: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.G_MISS_NUM, USER_STATUS_ID, p_USER_STATUS_ID),
296: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
297: STATUS_DATE = decode( p_STATUS_DATE, FND_API.G_MISS_CHAR, STATUS_DATE, p_STATUS_DATE),
298: LAST_BUILD_DATE = decode( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, LAST_BUILD_DATE, p_LAST_BUILD_DATE),
299: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.G_MISS_NUM, OWNER_USER_ID, p_OWNER_USER_ID),
292: LAST_UPDATE_LOGIN = decode( p_LAST_UPDATE_LOGIN, FND_API.G_MISS_NUM, LAST_UPDATE_LOGIN, p_LAST_UPDATE_LOGIN),
293: object_version_number = object_version_number + 1,
294: MODEL_TYPE = decode( p_MODEL_TYPE, FND_API.G_MISS_CHAR, MODEL_TYPE, p_MODEL_TYPE),
295: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.G_MISS_NUM, USER_STATUS_ID, p_USER_STATUS_ID),
296: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
297: STATUS_DATE = decode( p_STATUS_DATE, FND_API.G_MISS_CHAR, STATUS_DATE, p_STATUS_DATE),
298: LAST_BUILD_DATE = decode( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, LAST_BUILD_DATE, p_LAST_BUILD_DATE),
299: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.G_MISS_NUM, OWNER_USER_ID, p_OWNER_USER_ID),
300: PERFORMANCE = decode( p_PERFORMANCE, FND_API.G_MISS_NUM, PERFORMANCE, p_PERFORMANCE),
293: object_version_number = object_version_number + 1,
294: MODEL_TYPE = decode( p_MODEL_TYPE, FND_API.G_MISS_CHAR, MODEL_TYPE, p_MODEL_TYPE),
295: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.G_MISS_NUM, USER_STATUS_ID, p_USER_STATUS_ID),
296: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
297: STATUS_DATE = decode( p_STATUS_DATE, FND_API.G_MISS_CHAR, STATUS_DATE, p_STATUS_DATE),
298: LAST_BUILD_DATE = decode( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, LAST_BUILD_DATE, p_LAST_BUILD_DATE),
299: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.G_MISS_NUM, OWNER_USER_ID, p_OWNER_USER_ID),
300: PERFORMANCE = decode( p_PERFORMANCE, FND_API.G_MISS_NUM, PERFORMANCE, p_PERFORMANCE),
301: TARGET_GROUP_TYPE = decode( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, TARGET_GROUP_TYPE, p_TARGET_GROUP_TYPE),
294: MODEL_TYPE = decode( p_MODEL_TYPE, FND_API.G_MISS_CHAR, MODEL_TYPE, p_MODEL_TYPE),
295: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.G_MISS_NUM, USER_STATUS_ID, p_USER_STATUS_ID),
296: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
297: STATUS_DATE = decode( p_STATUS_DATE, FND_API.G_MISS_CHAR, STATUS_DATE, p_STATUS_DATE),
298: LAST_BUILD_DATE = decode( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, LAST_BUILD_DATE, p_LAST_BUILD_DATE),
299: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.G_MISS_NUM, OWNER_USER_ID, p_OWNER_USER_ID),
300: PERFORMANCE = decode( p_PERFORMANCE, FND_API.G_MISS_NUM, PERFORMANCE, p_PERFORMANCE),
301: TARGET_GROUP_TYPE = decode( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, TARGET_GROUP_TYPE, p_TARGET_GROUP_TYPE),
302: DARWIN_MODEL_REF = decode( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, DARWIN_MODEL_REF, p_DARWIN_MODEL_REF),
295: USER_STATUS_ID = decode( p_USER_STATUS_ID, FND_API.G_MISS_NUM, USER_STATUS_ID, p_USER_STATUS_ID),
296: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
297: STATUS_DATE = decode( p_STATUS_DATE, FND_API.G_MISS_CHAR, STATUS_DATE, p_STATUS_DATE),
298: LAST_BUILD_DATE = decode( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, LAST_BUILD_DATE, p_LAST_BUILD_DATE),
299: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.G_MISS_NUM, OWNER_USER_ID, p_OWNER_USER_ID),
300: PERFORMANCE = decode( p_PERFORMANCE, FND_API.G_MISS_NUM, PERFORMANCE, p_PERFORMANCE),
301: TARGET_GROUP_TYPE = decode( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, TARGET_GROUP_TYPE, p_TARGET_GROUP_TYPE),
302: DARWIN_MODEL_REF = decode( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, DARWIN_MODEL_REF, p_DARWIN_MODEL_REF),
303: SCHEDULED_DATE = decode( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,SCHEDULED_DATE, p_SCHEDULED_DATE),
296: STATUS_CODE = decode( p_STATUS_CODE, FND_API.G_MISS_CHAR, STATUS_CODE, p_STATUS_CODE),
297: STATUS_DATE = decode( p_STATUS_DATE, FND_API.G_MISS_CHAR, STATUS_DATE, p_STATUS_DATE),
298: LAST_BUILD_DATE = decode( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, LAST_BUILD_DATE, p_LAST_BUILD_DATE),
299: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.G_MISS_NUM, OWNER_USER_ID, p_OWNER_USER_ID),
300: PERFORMANCE = decode( p_PERFORMANCE, FND_API.G_MISS_NUM, PERFORMANCE, p_PERFORMANCE),
301: TARGET_GROUP_TYPE = decode( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, TARGET_GROUP_TYPE, p_TARGET_GROUP_TYPE),
302: DARWIN_MODEL_REF = decode( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, DARWIN_MODEL_REF, p_DARWIN_MODEL_REF),
303: SCHEDULED_DATE = decode( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,SCHEDULED_DATE, p_SCHEDULED_DATE),
304: SCHEDULED_TIMEZONE_ID = decode( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, SCHEDULED_TIMEZONE_ID, p_SCHEDULED_TIMEZONE_ID),
297: STATUS_DATE = decode( p_STATUS_DATE, FND_API.G_MISS_CHAR, STATUS_DATE, p_STATUS_DATE),
298: LAST_BUILD_DATE = decode( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, LAST_BUILD_DATE, p_LAST_BUILD_DATE),
299: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.G_MISS_NUM, OWNER_USER_ID, p_OWNER_USER_ID),
300: PERFORMANCE = decode( p_PERFORMANCE, FND_API.G_MISS_NUM, PERFORMANCE, p_PERFORMANCE),
301: TARGET_GROUP_TYPE = decode( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, TARGET_GROUP_TYPE, p_TARGET_GROUP_TYPE),
302: DARWIN_MODEL_REF = decode( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, DARWIN_MODEL_REF, p_DARWIN_MODEL_REF),
303: SCHEDULED_DATE = decode( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,SCHEDULED_DATE, p_SCHEDULED_DATE),
304: SCHEDULED_TIMEZONE_ID = decode( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, SCHEDULED_TIMEZONE_ID, p_SCHEDULED_TIMEZONE_ID),
305: EXPIRATION_DATE = decode( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,EXPIRATION_DATE, p_EXPIRATION_DATE),
298: LAST_BUILD_DATE = decode( p_LAST_BUILD_DATE, FND_API.G_MISS_DATE, LAST_BUILD_DATE, p_LAST_BUILD_DATE),
299: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.G_MISS_NUM, OWNER_USER_ID, p_OWNER_USER_ID),
300: PERFORMANCE = decode( p_PERFORMANCE, FND_API.G_MISS_NUM, PERFORMANCE, p_PERFORMANCE),
301: TARGET_GROUP_TYPE = decode( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, TARGET_GROUP_TYPE, p_TARGET_GROUP_TYPE),
302: DARWIN_MODEL_REF = decode( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, DARWIN_MODEL_REF, p_DARWIN_MODEL_REF),
303: SCHEDULED_DATE = decode( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,SCHEDULED_DATE, p_SCHEDULED_DATE),
304: SCHEDULED_TIMEZONE_ID = decode( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, SCHEDULED_TIMEZONE_ID, p_SCHEDULED_TIMEZONE_ID),
305: EXPIRATION_DATE = decode( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,EXPIRATION_DATE, p_EXPIRATION_DATE),
306: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.G_MISS_CHAR,RESULTS_FLAG, p_RESULTS_FLAG),
299: OWNER_USER_ID = decode( p_OWNER_USER_ID, FND_API.G_MISS_NUM, OWNER_USER_ID, p_OWNER_USER_ID),
300: PERFORMANCE = decode( p_PERFORMANCE, FND_API.G_MISS_NUM, PERFORMANCE, p_PERFORMANCE),
301: TARGET_GROUP_TYPE = decode( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, TARGET_GROUP_TYPE, p_TARGET_GROUP_TYPE),
302: DARWIN_MODEL_REF = decode( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, DARWIN_MODEL_REF, p_DARWIN_MODEL_REF),
303: SCHEDULED_DATE = decode( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,SCHEDULED_DATE, p_SCHEDULED_DATE),
304: SCHEDULED_TIMEZONE_ID = decode( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, SCHEDULED_TIMEZONE_ID, p_SCHEDULED_TIMEZONE_ID),
305: EXPIRATION_DATE = decode( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,EXPIRATION_DATE, p_EXPIRATION_DATE),
306: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.G_MISS_CHAR,RESULTS_FLAG, p_RESULTS_FLAG),
307: LOGS_FLAG = decode( p_LOGS_FLAG, FND_API.g_miss_char, LOGS_FLAG, p_LOGS_FLAG),
300: PERFORMANCE = decode( p_PERFORMANCE, FND_API.G_MISS_NUM, PERFORMANCE, p_PERFORMANCE),
301: TARGET_GROUP_TYPE = decode( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, TARGET_GROUP_TYPE, p_TARGET_GROUP_TYPE),
302: DARWIN_MODEL_REF = decode( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, DARWIN_MODEL_REF, p_DARWIN_MODEL_REF),
303: SCHEDULED_DATE = decode( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,SCHEDULED_DATE, p_SCHEDULED_DATE),
304: SCHEDULED_TIMEZONE_ID = decode( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, SCHEDULED_TIMEZONE_ID, p_SCHEDULED_TIMEZONE_ID),
305: EXPIRATION_DATE = decode( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,EXPIRATION_DATE, p_EXPIRATION_DATE),
306: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.G_MISS_CHAR,RESULTS_FLAG, p_RESULTS_FLAG),
307: LOGS_FLAG = decode( p_LOGS_FLAG, FND_API.g_miss_char, LOGS_FLAG, p_LOGS_FLAG),
308: TARGET_FIELD = decode( p_TARGET_FIELD, FND_API.g_miss_char, TARGET_FIELD, p_TARGET_FIELD),
301: TARGET_GROUP_TYPE = decode( p_TARGET_GROUP_TYPE, FND_API.G_MISS_CHAR, TARGET_GROUP_TYPE, p_TARGET_GROUP_TYPE),
302: DARWIN_MODEL_REF = decode( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, DARWIN_MODEL_REF, p_DARWIN_MODEL_REF),
303: SCHEDULED_DATE = decode( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,SCHEDULED_DATE, p_SCHEDULED_DATE),
304: SCHEDULED_TIMEZONE_ID = decode( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, SCHEDULED_TIMEZONE_ID, p_SCHEDULED_TIMEZONE_ID),
305: EXPIRATION_DATE = decode( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,EXPIRATION_DATE, p_EXPIRATION_DATE),
306: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.G_MISS_CHAR,RESULTS_FLAG, p_RESULTS_FLAG),
307: LOGS_FLAG = decode( p_LOGS_FLAG, FND_API.g_miss_char, LOGS_FLAG, p_LOGS_FLAG),
308: TARGET_FIELD = decode( p_TARGET_FIELD, FND_API.g_miss_char, TARGET_FIELD, p_TARGET_FIELD),
309: TARGET_TYPE = decode( p_TARGET_TYPE, FND_API.g_miss_char, TARGET_TYPE, p_TARGET_TYPE),
302: DARWIN_MODEL_REF = decode( p_DARWIN_MODEL_REF, FND_API.G_MISS_CHAR, DARWIN_MODEL_REF, p_DARWIN_MODEL_REF),
303: SCHEDULED_DATE = decode( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,SCHEDULED_DATE, p_SCHEDULED_DATE),
304: SCHEDULED_TIMEZONE_ID = decode( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, SCHEDULED_TIMEZONE_ID, p_SCHEDULED_TIMEZONE_ID),
305: EXPIRATION_DATE = decode( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,EXPIRATION_DATE, p_EXPIRATION_DATE),
306: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.G_MISS_CHAR,RESULTS_FLAG, p_RESULTS_FLAG),
307: LOGS_FLAG = decode( p_LOGS_FLAG, FND_API.g_miss_char, LOGS_FLAG, p_LOGS_FLAG),
308: TARGET_FIELD = decode( p_TARGET_FIELD, FND_API.g_miss_char, TARGET_FIELD, p_TARGET_FIELD),
309: TARGET_TYPE = decode( p_TARGET_TYPE, FND_API.g_miss_char, TARGET_TYPE, p_TARGET_TYPE),
310: TARGET_POSITIVE_VALUE = decode( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, TARGET_POSITIVE_VALUE, p_TARGET_POSITIVE_VALUE),
303: SCHEDULED_DATE = decode( p_SCHEDULED_DATE, FND_API.G_MISS_DATE,SCHEDULED_DATE, p_SCHEDULED_DATE),
304: SCHEDULED_TIMEZONE_ID = decode( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, SCHEDULED_TIMEZONE_ID, p_SCHEDULED_TIMEZONE_ID),
305: EXPIRATION_DATE = decode( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,EXPIRATION_DATE, p_EXPIRATION_DATE),
306: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.G_MISS_CHAR,RESULTS_FLAG, p_RESULTS_FLAG),
307: LOGS_FLAG = decode( p_LOGS_FLAG, FND_API.g_miss_char, LOGS_FLAG, p_LOGS_FLAG),
308: TARGET_FIELD = decode( p_TARGET_FIELD, FND_API.g_miss_char, TARGET_FIELD, p_TARGET_FIELD),
309: TARGET_TYPE = decode( p_TARGET_TYPE, FND_API.g_miss_char, TARGET_TYPE, p_TARGET_TYPE),
310: TARGET_POSITIVE_VALUE = decode( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, TARGET_POSITIVE_VALUE, p_TARGET_POSITIVE_VALUE),
311: TOTAL_RECORDS = decode( p_TOTAL_RECORDS, FND_API.g_miss_num, TOTAL_RECORDS, p_TOTAL_RECORDS),
304: SCHEDULED_TIMEZONE_ID = decode( p_SCHEDULED_TIMEZONE_ID, FND_API.G_MISS_NUM, SCHEDULED_TIMEZONE_ID, p_SCHEDULED_TIMEZONE_ID),
305: EXPIRATION_DATE = decode( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,EXPIRATION_DATE, p_EXPIRATION_DATE),
306: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.G_MISS_CHAR,RESULTS_FLAG, p_RESULTS_FLAG),
307: LOGS_FLAG = decode( p_LOGS_FLAG, FND_API.g_miss_char, LOGS_FLAG, p_LOGS_FLAG),
308: TARGET_FIELD = decode( p_TARGET_FIELD, FND_API.g_miss_char, TARGET_FIELD, p_TARGET_FIELD),
309: TARGET_TYPE = decode( p_TARGET_TYPE, FND_API.g_miss_char, TARGET_TYPE, p_TARGET_TYPE),
310: TARGET_POSITIVE_VALUE = decode( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, TARGET_POSITIVE_VALUE, p_TARGET_POSITIVE_VALUE),
311: TOTAL_RECORDS = decode( p_TOTAL_RECORDS, FND_API.g_miss_num, TOTAL_RECORDS, p_TOTAL_RECORDS),
312: TOTAL_POSITIVES = decode( p_TOTAL_POSITIVES, FND_API.g_miss_num, TOTAL_POSITIVES, p_TOTAL_POSITIVES),
305: EXPIRATION_DATE = decode( p_EXPIRATION_DATE, FND_API.G_MISS_DATE,EXPIRATION_DATE, p_EXPIRATION_DATE),
306: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.G_MISS_CHAR,RESULTS_FLAG, p_RESULTS_FLAG),
307: LOGS_FLAG = decode( p_LOGS_FLAG, FND_API.g_miss_char, LOGS_FLAG, p_LOGS_FLAG),
308: TARGET_FIELD = decode( p_TARGET_FIELD, FND_API.g_miss_char, TARGET_FIELD, p_TARGET_FIELD),
309: TARGET_TYPE = decode( p_TARGET_TYPE, FND_API.g_miss_char, TARGET_TYPE, p_TARGET_TYPE),
310: TARGET_POSITIVE_VALUE = decode( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, TARGET_POSITIVE_VALUE, p_TARGET_POSITIVE_VALUE),
311: TOTAL_RECORDS = decode( p_TOTAL_RECORDS, FND_API.g_miss_num, TOTAL_RECORDS, p_TOTAL_RECORDS),
312: TOTAL_POSITIVES = decode( p_TOTAL_POSITIVES, FND_API.g_miss_num, TOTAL_POSITIVES, p_TOTAL_POSITIVES),
313: MIN_RECORDS = decode( p_MIN_RECORDS, FND_API.g_miss_num, MIN_RECORDS, p_MIN_RECORDS),
306: RESULTS_FLAG = decode( p_RESULTS_FLAG, FND_API.G_MISS_CHAR,RESULTS_FLAG, p_RESULTS_FLAG),
307: LOGS_FLAG = decode( p_LOGS_FLAG, FND_API.g_miss_char, LOGS_FLAG, p_LOGS_FLAG),
308: TARGET_FIELD = decode( p_TARGET_FIELD, FND_API.g_miss_char, TARGET_FIELD, p_TARGET_FIELD),
309: TARGET_TYPE = decode( p_TARGET_TYPE, FND_API.g_miss_char, TARGET_TYPE, p_TARGET_TYPE),
310: TARGET_POSITIVE_VALUE = decode( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, TARGET_POSITIVE_VALUE, p_TARGET_POSITIVE_VALUE),
311: TOTAL_RECORDS = decode( p_TOTAL_RECORDS, FND_API.g_miss_num, TOTAL_RECORDS, p_TOTAL_RECORDS),
312: TOTAL_POSITIVES = decode( p_TOTAL_POSITIVES, FND_API.g_miss_num, TOTAL_POSITIVES, p_TOTAL_POSITIVES),
313: MIN_RECORDS = decode( p_MIN_RECORDS, FND_API.g_miss_num, MIN_RECORDS, p_MIN_RECORDS),
314: MAX_RECORDS = decode( p_MAX_RECORDS, FND_API.g_miss_num, MAX_RECORDS, p_MAX_RECORDS),
307: LOGS_FLAG = decode( p_LOGS_FLAG, FND_API.g_miss_char, LOGS_FLAG, p_LOGS_FLAG),
308: TARGET_FIELD = decode( p_TARGET_FIELD, FND_API.g_miss_char, TARGET_FIELD, p_TARGET_FIELD),
309: TARGET_TYPE = decode( p_TARGET_TYPE, FND_API.g_miss_char, TARGET_TYPE, p_TARGET_TYPE),
310: TARGET_POSITIVE_VALUE = decode( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, TARGET_POSITIVE_VALUE, p_TARGET_POSITIVE_VALUE),
311: TOTAL_RECORDS = decode( p_TOTAL_RECORDS, FND_API.g_miss_num, TOTAL_RECORDS, p_TOTAL_RECORDS),
312: TOTAL_POSITIVES = decode( p_TOTAL_POSITIVES, FND_API.g_miss_num, TOTAL_POSITIVES, p_TOTAL_POSITIVES),
313: MIN_RECORDS = decode( p_MIN_RECORDS, FND_API.g_miss_num, MIN_RECORDS, p_MIN_RECORDS),
314: MAX_RECORDS = decode( p_MAX_RECORDS, FND_API.g_miss_num, MAX_RECORDS, p_MAX_RECORDS),
315: row_selection_type = decode( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
308: TARGET_FIELD = decode( p_TARGET_FIELD, FND_API.g_miss_char, TARGET_FIELD, p_TARGET_FIELD),
309: TARGET_TYPE = decode( p_TARGET_TYPE, FND_API.g_miss_char, TARGET_TYPE, p_TARGET_TYPE),
310: TARGET_POSITIVE_VALUE = decode( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, TARGET_POSITIVE_VALUE, p_TARGET_POSITIVE_VALUE),
311: TOTAL_RECORDS = decode( p_TOTAL_RECORDS, FND_API.g_miss_num, TOTAL_RECORDS, p_TOTAL_RECORDS),
312: TOTAL_POSITIVES = decode( p_TOTAL_POSITIVES, FND_API.g_miss_num, TOTAL_POSITIVES, p_TOTAL_POSITIVES),
313: MIN_RECORDS = decode( p_MIN_RECORDS, FND_API.g_miss_num, MIN_RECORDS, p_MIN_RECORDS),
314: MAX_RECORDS = decode( p_MAX_RECORDS, FND_API.g_miss_num, MAX_RECORDS, p_MAX_RECORDS),
315: row_selection_type = decode( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
316: EVERY_NTH_ROW = decode( p_EVERY_NTH_ROW, FND_API.g_miss_num, EVERY_NTH_ROW, p_EVERY_NTH_ROW),
309: TARGET_TYPE = decode( p_TARGET_TYPE, FND_API.g_miss_char, TARGET_TYPE, p_TARGET_TYPE),
310: TARGET_POSITIVE_VALUE = decode( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, TARGET_POSITIVE_VALUE, p_TARGET_POSITIVE_VALUE),
311: TOTAL_RECORDS = decode( p_TOTAL_RECORDS, FND_API.g_miss_num, TOTAL_RECORDS, p_TOTAL_RECORDS),
312: TOTAL_POSITIVES = decode( p_TOTAL_POSITIVES, FND_API.g_miss_num, TOTAL_POSITIVES, p_TOTAL_POSITIVES),
313: MIN_RECORDS = decode( p_MIN_RECORDS, FND_API.g_miss_num, MIN_RECORDS, p_MIN_RECORDS),
314: MAX_RECORDS = decode( p_MAX_RECORDS, FND_API.g_miss_num, MAX_RECORDS, p_MAX_RECORDS),
315: row_selection_type = decode( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
316: EVERY_NTH_ROW = decode( p_EVERY_NTH_ROW, FND_API.g_miss_num, EVERY_NTH_ROW, p_EVERY_NTH_ROW),
317: PCT_RANDOM = decode( p_PCT_RANDOM, FND_API.g_miss_num, PCT_RANDOM, p_PCT_RANDOM),
310: TARGET_POSITIVE_VALUE = decode( p_TARGET_POSITIVE_VALUE, FND_API.g_miss_char, TARGET_POSITIVE_VALUE, p_TARGET_POSITIVE_VALUE),
311: TOTAL_RECORDS = decode( p_TOTAL_RECORDS, FND_API.g_miss_num, TOTAL_RECORDS, p_TOTAL_RECORDS),
312: TOTAL_POSITIVES = decode( p_TOTAL_POSITIVES, FND_API.g_miss_num, TOTAL_POSITIVES, p_TOTAL_POSITIVES),
313: MIN_RECORDS = decode( p_MIN_RECORDS, FND_API.g_miss_num, MIN_RECORDS, p_MIN_RECORDS),
314: MAX_RECORDS = decode( p_MAX_RECORDS, FND_API.g_miss_num, MAX_RECORDS, p_MAX_RECORDS),
315: row_selection_type = decode( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
316: EVERY_NTH_ROW = decode( p_EVERY_NTH_ROW, FND_API.g_miss_num, EVERY_NTH_ROW, p_EVERY_NTH_ROW),
317: PCT_RANDOM = decode( p_PCT_RANDOM, FND_API.g_miss_num, PCT_RANDOM, p_PCT_RANDOM),
318: best_subtree = DECODE( p_best_subtree, FND_API.g_miss_num, best_subtree, p_best_subtree),
311: TOTAL_RECORDS = decode( p_TOTAL_RECORDS, FND_API.g_miss_num, TOTAL_RECORDS, p_TOTAL_RECORDS),
312: TOTAL_POSITIVES = decode( p_TOTAL_POSITIVES, FND_API.g_miss_num, TOTAL_POSITIVES, p_TOTAL_POSITIVES),
313: MIN_RECORDS = decode( p_MIN_RECORDS, FND_API.g_miss_num, MIN_RECORDS, p_MIN_RECORDS),
314: MAX_RECORDS = decode( p_MAX_RECORDS, FND_API.g_miss_num, MAX_RECORDS, p_MAX_RECORDS),
315: row_selection_type = decode( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
316: EVERY_NTH_ROW = decode( p_EVERY_NTH_ROW, FND_API.g_miss_num, EVERY_NTH_ROW, p_EVERY_NTH_ROW),
317: PCT_RANDOM = decode( p_PCT_RANDOM, FND_API.g_miss_num, PCT_RANDOM, p_PCT_RANDOM),
318: best_subtree = DECODE( p_best_subtree, FND_API.g_miss_num, best_subtree, p_best_subtree),
319: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
312: TOTAL_POSITIVES = decode( p_TOTAL_POSITIVES, FND_API.g_miss_num, TOTAL_POSITIVES, p_TOTAL_POSITIVES),
313: MIN_RECORDS = decode( p_MIN_RECORDS, FND_API.g_miss_num, MIN_RECORDS, p_MIN_RECORDS),
314: MAX_RECORDS = decode( p_MAX_RECORDS, FND_API.g_miss_num, MAX_RECORDS, p_MAX_RECORDS),
315: row_selection_type = decode( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
316: EVERY_NTH_ROW = decode( p_EVERY_NTH_ROW, FND_API.g_miss_num, EVERY_NTH_ROW, p_EVERY_NTH_ROW),
317: PCT_RANDOM = decode( p_PCT_RANDOM, FND_API.g_miss_num, PCT_RANDOM, p_PCT_RANDOM),
318: best_subtree = DECODE( p_best_subtree, FND_API.g_miss_num, best_subtree, p_best_subtree),
319: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
320: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
313: MIN_RECORDS = decode( p_MIN_RECORDS, FND_API.g_miss_num, MIN_RECORDS, p_MIN_RECORDS),
314: MAX_RECORDS = decode( p_MAX_RECORDS, FND_API.g_miss_num, MAX_RECORDS, p_MAX_RECORDS),
315: row_selection_type = decode( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
316: EVERY_NTH_ROW = decode( p_EVERY_NTH_ROW, FND_API.g_miss_num, EVERY_NTH_ROW, p_EVERY_NTH_ROW),
317: PCT_RANDOM = decode( p_PCT_RANDOM, FND_API.g_miss_num, PCT_RANDOM, p_PCT_RANDOM),
318: best_subtree = DECODE( p_best_subtree, FND_API.g_miss_num, best_subtree, p_best_subtree),
319: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
320: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
321: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
314: MAX_RECORDS = decode( p_MAX_RECORDS, FND_API.g_miss_num, MAX_RECORDS, p_MAX_RECORDS),
315: row_selection_type = decode( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
316: EVERY_NTH_ROW = decode( p_EVERY_NTH_ROW, FND_API.g_miss_num, EVERY_NTH_ROW, p_EVERY_NTH_ROW),
317: PCT_RANDOM = decode( p_PCT_RANDOM, FND_API.g_miss_num, PCT_RANDOM, p_PCT_RANDOM),
318: best_subtree = DECODE( p_best_subtree, FND_API.g_miss_num, best_subtree, p_best_subtree),
319: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
320: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
321: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
322: target_id = decode( p_target_id, FND_API.g_miss_char, target_id, p_target_id),
315: row_selection_type = decode( p_row_selection_type, FND_API.g_miss_char, row_selection_type, p_row_selection_type),
316: EVERY_NTH_ROW = decode( p_EVERY_NTH_ROW, FND_API.g_miss_num, EVERY_NTH_ROW, p_EVERY_NTH_ROW),
317: PCT_RANDOM = decode( p_PCT_RANDOM, FND_API.g_miss_num, PCT_RANDOM, p_PCT_RANDOM),
318: best_subtree = DECODE( p_best_subtree, FND_API.g_miss_num, best_subtree, p_best_subtree),
319: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
320: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
321: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
322: target_id = decode( p_target_id, FND_API.g_miss_char, target_id, p_target_id),
323: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
316: EVERY_NTH_ROW = decode( p_EVERY_NTH_ROW, FND_API.g_miss_num, EVERY_NTH_ROW, p_EVERY_NTH_ROW),
317: PCT_RANDOM = decode( p_PCT_RANDOM, FND_API.g_miss_num, PCT_RANDOM, p_PCT_RANDOM),
318: best_subtree = DECODE( p_best_subtree, FND_API.g_miss_num, best_subtree, p_best_subtree),
319: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
320: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
321: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
322: target_id = decode( p_target_id, FND_API.g_miss_char, target_id, p_target_id),
323: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
324: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE1, p_ATTRIBUTE1),
317: PCT_RANDOM = decode( p_PCT_RANDOM, FND_API.g_miss_num, PCT_RANDOM, p_PCT_RANDOM),
318: best_subtree = DECODE( p_best_subtree, FND_API.g_miss_num, best_subtree, p_best_subtree),
319: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
320: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
321: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
322: target_id = decode( p_target_id, FND_API.g_miss_char, target_id, p_target_id),
323: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
324: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE1, p_ATTRIBUTE1),
325: ATTRIBUTE2 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE2, p_ATTRIBUTE2),
318: best_subtree = DECODE( p_best_subtree, FND_API.g_miss_num, best_subtree, p_best_subtree),
319: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
320: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
321: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
322: target_id = decode( p_target_id, FND_API.g_miss_char, target_id, p_target_id),
323: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
324: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE1, p_ATTRIBUTE1),
325: ATTRIBUTE2 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE2, p_ATTRIBUTE2),
326: ATTRIBUTE3 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE3, p_ATTRIBUTE3),
319: custom_setup_id = DECODE( p_custom_setup_id, FND_API.g_miss_num, custom_setup_id, p_custom_setup_id),
320: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
321: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
322: target_id = decode( p_target_id, FND_API.g_miss_char, target_id, p_target_id),
323: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
324: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE1, p_ATTRIBUTE1),
325: ATTRIBUTE2 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE2, p_ATTRIBUTE2),
326: ATTRIBUTE3 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE3, p_ATTRIBUTE3),
327: ATTRIBUTE4 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE4, p_ATTRIBUTE4),
320: country_id = DECODE( p_country_id, FND_API.g_miss_num, country_id, p_country_id),
321: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
322: target_id = decode( p_target_id, FND_API.g_miss_char, target_id, p_target_id),
323: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
324: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE1, p_ATTRIBUTE1),
325: ATTRIBUTE2 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE2, p_ATTRIBUTE2),
326: ATTRIBUTE3 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE3, p_ATTRIBUTE3),
327: ATTRIBUTE4 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE4, p_ATTRIBUTE4),
328: ATTRIBUTE5 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE5, p_ATTRIBUTE5),
321: wf_itemkey = decode( p_wf_itemkey, FND_API.g_miss_char, wf_itemkey, p_wf_itemkey),
322: target_id = decode( p_target_id, FND_API.g_miss_char, target_id, p_target_id),
323: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
324: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE1, p_ATTRIBUTE1),
325: ATTRIBUTE2 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE2, p_ATTRIBUTE2),
326: ATTRIBUTE3 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE3, p_ATTRIBUTE3),
327: ATTRIBUTE4 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE4, p_ATTRIBUTE4),
328: ATTRIBUTE5 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE5, p_ATTRIBUTE5),
329: ATTRIBUTE6 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE6, p_ATTRIBUTE6),
322: target_id = decode( p_target_id, FND_API.g_miss_char, target_id, p_target_id),
323: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
324: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE1, p_ATTRIBUTE1),
325: ATTRIBUTE2 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE2, p_ATTRIBUTE2),
326: ATTRIBUTE3 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE3, p_ATTRIBUTE3),
327: ATTRIBUTE4 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE4, p_ATTRIBUTE4),
328: ATTRIBUTE5 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE5, p_ATTRIBUTE5),
329: ATTRIBUTE6 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE6, p_ATTRIBUTE6),
330: ATTRIBUTE7 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE7, p_ATTRIBUTE7),
323: ATTRIBUTE_CATEGORY = decode( p_ATTRIBUTE_CATEGORY, FND_API.G_MISS_CHAR,ATTRIBUTE_CATEGORY, p_ATTRIBUTE_CATEGORY),
324: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE1, p_ATTRIBUTE1),
325: ATTRIBUTE2 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE2, p_ATTRIBUTE2),
326: ATTRIBUTE3 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE3, p_ATTRIBUTE3),
327: ATTRIBUTE4 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE4, p_ATTRIBUTE4),
328: ATTRIBUTE5 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE5, p_ATTRIBUTE5),
329: ATTRIBUTE6 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE6, p_ATTRIBUTE6),
330: ATTRIBUTE7 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE7, p_ATTRIBUTE7),
331: ATTRIBUTE8 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE8, p_ATTRIBUTE8),
324: ATTRIBUTE1 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE1, p_ATTRIBUTE1),
325: ATTRIBUTE2 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE2, p_ATTRIBUTE2),
326: ATTRIBUTE3 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE3, p_ATTRIBUTE3),
327: ATTRIBUTE4 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE4, p_ATTRIBUTE4),
328: ATTRIBUTE5 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE5, p_ATTRIBUTE5),
329: ATTRIBUTE6 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE6, p_ATTRIBUTE6),
330: ATTRIBUTE7 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE7, p_ATTRIBUTE7),
331: ATTRIBUTE8 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE8, p_ATTRIBUTE8),
332: ATTRIBUTE9 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE9, p_ATTRIBUTE9),
325: ATTRIBUTE2 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE2, p_ATTRIBUTE2),
326: ATTRIBUTE3 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE3, p_ATTRIBUTE3),
327: ATTRIBUTE4 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE4, p_ATTRIBUTE4),
328: ATTRIBUTE5 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE5, p_ATTRIBUTE5),
329: ATTRIBUTE6 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE6, p_ATTRIBUTE6),
330: ATTRIBUTE7 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE7, p_ATTRIBUTE7),
331: ATTRIBUTE8 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE8, p_ATTRIBUTE8),
332: ATTRIBUTE9 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE9, p_ATTRIBUTE9),
333: ATTRIBUTE10 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE10, p_ATTRIBUTE10),
326: ATTRIBUTE3 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE3, p_ATTRIBUTE3),
327: ATTRIBUTE4 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE4, p_ATTRIBUTE4),
328: ATTRIBUTE5 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE5, p_ATTRIBUTE5),
329: ATTRIBUTE6 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE6, p_ATTRIBUTE6),
330: ATTRIBUTE7 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE7, p_ATTRIBUTE7),
331: ATTRIBUTE8 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE8, p_ATTRIBUTE8),
332: ATTRIBUTE9 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE9, p_ATTRIBUTE9),
333: ATTRIBUTE10 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE10, p_ATTRIBUTE10),
334: ATTRIBUTE11 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE11, p_ATTRIBUTE11),
327: ATTRIBUTE4 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE4, p_ATTRIBUTE4),
328: ATTRIBUTE5 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE5, p_ATTRIBUTE5),
329: ATTRIBUTE6 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE6, p_ATTRIBUTE6),
330: ATTRIBUTE7 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE7, p_ATTRIBUTE7),
331: ATTRIBUTE8 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE8, p_ATTRIBUTE8),
332: ATTRIBUTE9 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE9, p_ATTRIBUTE9),
333: ATTRIBUTE10 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE10, p_ATTRIBUTE10),
334: ATTRIBUTE11 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE11, p_ATTRIBUTE11),
335: ATTRIBUTE12 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE12, p_ATTRIBUTE12),
328: ATTRIBUTE5 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE5, p_ATTRIBUTE5),
329: ATTRIBUTE6 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE6, p_ATTRIBUTE6),
330: ATTRIBUTE7 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE7, p_ATTRIBUTE7),
331: ATTRIBUTE8 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE8, p_ATTRIBUTE8),
332: ATTRIBUTE9 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE9, p_ATTRIBUTE9),
333: ATTRIBUTE10 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE10, p_ATTRIBUTE10),
334: ATTRIBUTE11 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE11, p_ATTRIBUTE11),
335: ATTRIBUTE12 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE12, p_ATTRIBUTE12),
336: ATTRIBUTE13 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE13, p_ATTRIBUTE13),
329: ATTRIBUTE6 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE6, p_ATTRIBUTE6),
330: ATTRIBUTE7 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE7, p_ATTRIBUTE7),
331: ATTRIBUTE8 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE8, p_ATTRIBUTE8),
332: ATTRIBUTE9 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE9, p_ATTRIBUTE9),
333: ATTRIBUTE10 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE10, p_ATTRIBUTE10),
334: ATTRIBUTE11 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE11, p_ATTRIBUTE11),
335: ATTRIBUTE12 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE12, p_ATTRIBUTE12),
336: ATTRIBUTE13 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE13, p_ATTRIBUTE13),
337: ATTRIBUTE14 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE14, p_ATTRIBUTE14),
330: ATTRIBUTE7 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE7, p_ATTRIBUTE7),
331: ATTRIBUTE8 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE8, p_ATTRIBUTE8),
332: ATTRIBUTE9 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE9, p_ATTRIBUTE9),
333: ATTRIBUTE10 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE10, p_ATTRIBUTE10),
334: ATTRIBUTE11 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE11, p_ATTRIBUTE11),
335: ATTRIBUTE12 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE12, p_ATTRIBUTE12),
336: ATTRIBUTE13 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE13, p_ATTRIBUTE13),
337: ATTRIBUTE14 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE14, p_ATTRIBUTE14),
338: ATTRIBUTE15 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE15, p_ATTRIBUTE15)
331: ATTRIBUTE8 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE8, p_ATTRIBUTE8),
332: ATTRIBUTE9 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE9, p_ATTRIBUTE9),
333: ATTRIBUTE10 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE10, p_ATTRIBUTE10),
334: ATTRIBUTE11 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE11, p_ATTRIBUTE11),
335: ATTRIBUTE12 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE12, p_ATTRIBUTE12),
336: ATTRIBUTE13 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE13, p_ATTRIBUTE13),
337: ATTRIBUTE14 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE14, p_ATTRIBUTE14),
338: ATTRIBUTE15 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE15, p_ATTRIBUTE15)
339: WHERE MODEL_ID = p_MODEL_ID
332: ATTRIBUTE9 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE9, p_ATTRIBUTE9),
333: ATTRIBUTE10 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE10, p_ATTRIBUTE10),
334: ATTRIBUTE11 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE11, p_ATTRIBUTE11),
335: ATTRIBUTE12 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE12, p_ATTRIBUTE12),
336: ATTRIBUTE13 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE13, p_ATTRIBUTE13),
337: ATTRIBUTE14 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE14, p_ATTRIBUTE14),
338: ATTRIBUTE15 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE15, p_ATTRIBUTE15)
339: WHERE MODEL_ID = p_MODEL_ID
340: AND object_version_number = p_object_version_number;
333: ATTRIBUTE10 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE10, p_ATTRIBUTE10),
334: ATTRIBUTE11 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE11, p_ATTRIBUTE11),
335: ATTRIBUTE12 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE12, p_ATTRIBUTE12),
336: ATTRIBUTE13 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE13, p_ATTRIBUTE13),
337: ATTRIBUTE14 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE14, p_ATTRIBUTE14),
338: ATTRIBUTE15 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE15, p_ATTRIBUTE15)
339: WHERE MODEL_ID = p_MODEL_ID
340: AND object_version_number = p_object_version_number;
341: IF SQL%NOTFOUND THEN
334: ATTRIBUTE11 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE11, p_ATTRIBUTE11),
335: ATTRIBUTE12 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE12, p_ATTRIBUTE12),
336: ATTRIBUTE13 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE13, p_ATTRIBUTE13),
337: ATTRIBUTE14 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE14, p_ATTRIBUTE14),
338: ATTRIBUTE15 = decode( p_ATTRIBUTE1, FND_API.G_MISS_CHAR,ATTRIBUTE15, p_ATTRIBUTE15)
339: WHERE MODEL_ID = p_MODEL_ID
340: AND object_version_number = p_object_version_number;
341: IF SQL%NOTFOUND THEN
342: -- the calling program should catch no_data_found
345: RAISE NO_DATA_FOUND;
346: END IF;
347:
348: update ams_dm_models_all_tl set
349: model_name = decode( p_MODEL_NAME, FND_API.G_MISS_CHAR, MODEL_NAME, p_MODEL_NAME),
350: description = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
351: last_update_date = SYSDATE,
352: last_updated_by = FND_GLOBAL.user_id,
353: last_update_login = FND_GLOBAL.conc_login_id,
346: END IF;
347:
348: update ams_dm_models_all_tl set
349: model_name = decode( p_MODEL_NAME, FND_API.G_MISS_CHAR, MODEL_NAME, p_MODEL_NAME),
350: description = decode( p_DESCRIPTION, FND_API.G_MISS_CHAR, DESCRIPTION, p_DESCRIPTION),
351: last_update_date = SYSDATE,
352: last_updated_by = FND_GLOBAL.user_id,
353: last_update_login = FND_GLOBAL.conc_login_id,
354: source_lang = USERENV('LANG')