89:
90: --===================================================================
91: TYPE model_rec_type IS RECORD
92: (
93: ROW_ID ROWID := FND_API.G_MISS_CHAR,
94: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
95: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
96: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE := FND_API.G_MISS_DATE,
90: --===================================================================
91: TYPE model_rec_type IS RECORD
92: (
93: ROW_ID ROWID := FND_API.G_MISS_CHAR,
94: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
95: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
96: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
91: TYPE model_rec_type IS RECORD
92: (
93: ROW_ID ROWID := FND_API.G_MISS_CHAR,
94: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
95: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
96: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
92: (
93: ROW_ID ROWID := FND_API.G_MISS_CHAR,
94: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
95: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
96: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
100: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
93: ROW_ID ROWID := FND_API.G_MISS_CHAR,
94: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
95: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
96: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
100: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: org_id NUMBER := FND_API.G_MISS_NUM,
94: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
95: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
96: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
100: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: org_id NUMBER := FND_API.G_MISS_NUM,
102: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
95: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
96: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
100: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: org_id NUMBER := FND_API.G_MISS_NUM,
102: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
96: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
97: CREATION_DATE DATE := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
100: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: org_id NUMBER := FND_API.G_MISS_NUM,
102: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
104: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
97: CREATION_DATE DATE := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
100: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: org_id NUMBER := FND_API.G_MISS_NUM,
102: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
104: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: STATUS_DATE DATE := FND_API.G_MISS_DATE,
98: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
99: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
100: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: org_id NUMBER := FND_API.G_MISS_NUM,
102: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
104: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: STATUS_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
99: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
100: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: org_id NUMBER := FND_API.G_MISS_NUM,
102: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
104: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: STATUS_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
107: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
100: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
101: org_id NUMBER := FND_API.G_MISS_NUM,
102: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
104: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: STATUS_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
107: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
108: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
101: org_id NUMBER := FND_API.G_MISS_NUM,
102: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
104: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: STATUS_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
107: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
108: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
109: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
102: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
104: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: STATUS_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
107: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
108: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
109: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
110: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
103: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
104: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: STATUS_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
107: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
108: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
109: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
110: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
111: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
104: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: STATUS_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
107: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
108: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
109: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
110: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
111: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
112: country_id NUMBER := FND_API.G_MISS_NUM,
105: STATUS_DATE DATE := FND_API.G_MISS_DATE,
106: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
107: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
108: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
109: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
110: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
111: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
112: country_id NUMBER := FND_API.G_MISS_NUM,
113: best_subtree NUMBER := FND_API.G_MISS_NUM,
106: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
107: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
108: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
109: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
110: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
111: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
112: country_id NUMBER := FND_API.G_MISS_NUM,
113: best_subtree NUMBER := FND_API.G_MISS_NUM,
114: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
107: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
108: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
109: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
110: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
111: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
112: country_id NUMBER := FND_API.G_MISS_NUM,
113: best_subtree NUMBER := FND_API.G_MISS_NUM,
114: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
108: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
109: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
110: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
111: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
112: country_id NUMBER := FND_API.G_MISS_NUM,
113: best_subtree NUMBER := FND_API.G_MISS_NUM,
114: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
109: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
110: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
111: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
112: country_id NUMBER := FND_API.G_MISS_NUM,
113: best_subtree NUMBER := FND_API.G_MISS_NUM,
114: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
110: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
111: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
112: country_id NUMBER := FND_API.G_MISS_NUM,
113: best_subtree NUMBER := FND_API.G_MISS_NUM,
114: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
112: country_id NUMBER := FND_API.G_MISS_NUM,
113: best_subtree NUMBER := FND_API.G_MISS_NUM,
114: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
112: country_id NUMBER := FND_API.G_MISS_NUM,
113: best_subtree NUMBER := FND_API.G_MISS_NUM,
114: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
120: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
113: best_subtree NUMBER := FND_API.G_MISS_NUM,
114: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
120: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
121: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
115: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
120: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
121: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
115: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
116: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
120: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
121: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
123: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
116: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
117: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
120: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
121: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
123: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
124: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
117: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
120: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
121: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
123: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
124: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
125: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
118: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
119: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
120: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
121: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
123: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
124: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
125: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
119: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
120: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
121: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
123: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
124: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
125: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
120: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
121: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
123: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
124: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
125: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
121: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
123: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
124: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
125: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
122: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
123: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
124: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
125: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
123: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
124: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
125: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
124: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
125: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
125: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
126: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
126: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
127: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
128: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
129: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
130: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
131: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
132: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
133: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
134: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: MODEL_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
136: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: MODEL_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
144: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR
137: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: MODEL_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
144: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR
145: );
138: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: MODEL_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
144: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR
145: );
146:
139: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: MODEL_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
144: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR
145: );
146:
147: g_miss_model_rec model_rec_type;
140: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: MODEL_NAME VARCHAR2(120) := FND_API.G_MISS_CHAR,
144: DESCRIPTION VARCHAR2(4000) := FND_API.G_MISS_CHAR
145: );
146:
147: g_miss_model_rec model_rec_type;
148: TYPE model_tbl_type IS TABLE OF model_rec_type INDEX BY BINARY_INTEGER;
166: -- Parameters
167: --
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_model_rec IN model_rec_type Required
173: --
174: -- OUT
167: --
168: -- IN
169: -- p_api_version_number IN NUMBER Required
170: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
171: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
172: -- p_model_rec IN model_rec_type Required
173: --
174: -- OUT
175: -- x_return_status OUT VARCHAR2
184: --
185:
186: PROCEDURE Create_Model(
187: p_api_version_number IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190:
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
185:
186: PROCEDURE Create_Model(
187: p_api_version_number IN NUMBER,
188: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
189: p_commit IN VARCHAR2 := FND_API.G_FALSE,
190:
191: x_return_status OUT NOCOPY VARCHAR2,
192: x_msg_count OUT NOCOPY NUMBER,
193: x_msg_data OUT NOCOPY VARCHAR2,
208: -- Parameters
209: --
210: -- IN
211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_model_rec IN model_rec_type Required
215: --
216: -- OUT
209: --
210: -- IN
211: -- p_api_version_number IN NUMBER Required
212: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
213: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
214: -- p_model_rec IN model_rec_type Required
215: --
216: -- OUT
217: -- x_return_status OUT VARCHAR2
226: --
227:
228: PROCEDURE Update_Model(
229: p_api_version_number IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232:
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
227:
228: PROCEDURE Update_Model(
229: p_api_version_number IN NUMBER,
230: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
231: p_commit IN VARCHAR2 := FND_API.G_FALSE,
232:
233: x_return_status OUT NOCOPY VARCHAR2,
234: x_msg_count OUT NOCOPY NUMBER,
235: x_msg_data OUT NOCOPY VARCHAR2,
250: -- Parameters
251: --
252: -- IN
253: -- p_api_version_number IN NUMBER Required
254: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
255: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
256: -- p_MODEL_ID IN NUMBER
257: -- p_object_version_number IN NUMBER Optional Default = NULL
258: --
251: --
252: -- IN
253: -- p_api_version_number IN NUMBER Required
254: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
255: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
256: -- p_MODEL_ID IN NUMBER
257: -- p_object_version_number IN NUMBER Optional Default = NULL
258: --
259: -- OUT
269: --
270:
271: PROCEDURE Delete_Model(
272: p_api_version_number IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
270:
271: PROCEDURE Delete_Model(
272: p_api_version_number IN NUMBER,
273: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
274: p_commit IN VARCHAR2 := FND_API.G_FALSE,
275: x_return_status OUT NOCOPY VARCHAR2,
276: x_msg_count OUT NOCOPY NUMBER,
277: x_msg_data OUT NOCOPY VARCHAR2,
278: p_model_id IN NUMBER,
291: -- Parameters
292: --
293: -- IN
294: -- p_api_version_number IN NUMBER Required
295: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
296: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
297: -- p_model_rec IN model_rec_type Required
298: --
299: -- OUT
292: --
293: -- IN
294: -- p_api_version_number IN NUMBER Required
295: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
296: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
297: -- p_model_rec IN model_rec_type Required
298: --
299: -- OUT
300: -- x_return_status OUT VARCHAR2
309: --
310:
311: PROCEDURE Lock_Model(
312: p_api_version_number IN NUMBER,
313: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
314: x_return_status OUT NOCOPY VARCHAR2,
315: x_msg_count OUT NOCOPY NUMBER,
316: x_msg_data OUT NOCOPY VARCHAR2,
317: