98: -- End of Comments
99:
100: TYPE DM_MODEL_Rec_Type IS RECORD
101: (
102: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
103: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
99:
100: TYPE DM_MODEL_Rec_Type IS RECORD
101: (
102: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
103: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
100: TYPE DM_MODEL_Rec_Type IS RECORD
101: (
102: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
103: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
108: ORG_ID NUMBER := FND_API.G_MISS_NUM,
101: (
102: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
103: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
108: ORG_ID NUMBER := FND_API.G_MISS_NUM,
109: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
102: MODEL_ID NUMBER := FND_API.G_MISS_NUM,
103: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
108: ORG_ID NUMBER := FND_API.G_MISS_NUM,
109: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
110: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
103: LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
104: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
108: ORG_ID NUMBER := FND_API.G_MISS_NUM,
109: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
110: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
104: LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
108: ORG_ID NUMBER := FND_API.G_MISS_NUM,
109: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
110: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
105: CREATION_DATE DATE := FND_API.G_MISS_DATE,
106: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
108: ORG_ID NUMBER := FND_API.G_MISS_NUM,
109: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
110: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: STATUS_DATE DATE := FND_API.G_MISS_DATE,
106: CREATED_BY NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
108: ORG_ID NUMBER := FND_API.G_MISS_NUM,
109: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
110: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: STATUS_DATE DATE := FND_API.G_MISS_DATE,
114: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
107: LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
108: ORG_ID NUMBER := FND_API.G_MISS_NUM,
109: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
110: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: STATUS_DATE DATE := FND_API.G_MISS_DATE,
114: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
115: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
108: ORG_ID NUMBER := FND_API.G_MISS_NUM,
109: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
110: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: STATUS_DATE DATE := FND_API.G_MISS_DATE,
114: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
115: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
116: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
109: OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
110: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: STATUS_DATE DATE := FND_API.G_MISS_DATE,
114: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
115: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
116: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
117: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
110: MODEL_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
111: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: STATUS_DATE DATE := FND_API.G_MISS_DATE,
114: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
115: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
116: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
117: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
118: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
111: USER_STATUS_ID NUMBER := FND_API.G_MISS_NUM,
112: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: STATUS_DATE DATE := FND_API.G_MISS_DATE,
114: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
115: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
116: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
117: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
118: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
119: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
112: STATUS_CODE VARCHAR2(30) := FND_API.G_MISS_CHAR,
113: STATUS_DATE DATE := FND_API.G_MISS_DATE,
114: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
115: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
116: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
117: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
118: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
119: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
120: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
113: STATUS_DATE DATE := FND_API.G_MISS_DATE,
114: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
115: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
116: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
117: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
118: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
119: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
120: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
121: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
114: OWNER_USER_ID NUMBER := FND_API.G_MISS_NUM,
115: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
116: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
117: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
118: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
119: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
120: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
121: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
115: LAST_BUILD_DATE DATE := FND_API.G_MISS_DATE,
116: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
117: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
118: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
119: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
120: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
121: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
116: SCHEDULED_DATE DATE := FND_API.G_MISS_DATE,
117: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
118: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
119: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
120: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
121: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
124: TOTAL_RECORDS NUMBER := FND_API.G_MISS_NUM,
117: SCHEDULED_TIMEZONE_ID NUMBER := FND_API.G_MISS_NUM,
118: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
119: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
120: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
121: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
124: TOTAL_RECORDS NUMBER := FND_API.G_MISS_NUM,
125: TOTAL_POSITIVES NUMBER := FND_API.G_MISS_NUM,
118: EXPIRATION_DATE DATE := FND_API.G_MISS_DATE,
119: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
120: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
121: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
124: TOTAL_RECORDS NUMBER := FND_API.G_MISS_NUM,
125: TOTAL_POSITIVES NUMBER := FND_API.G_MISS_NUM,
126: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
119: RESULTS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
120: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
121: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
124: TOTAL_RECORDS NUMBER := FND_API.G_MISS_NUM,
125: TOTAL_POSITIVES NUMBER := FND_API.G_MISS_NUM,
126: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
127: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
120: LOGS_FLAG VARCHAR2(1) := FND_API.G_MISS_CHAR,
121: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
124: TOTAL_RECORDS NUMBER := FND_API.G_MISS_NUM,
125: TOTAL_POSITIVES NUMBER := FND_API.G_MISS_NUM,
126: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
127: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
128: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
121: TARGET_FIELD VARCHAR2(30) := FND_API.G_MISS_CHAR,
122: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
124: TOTAL_RECORDS NUMBER := FND_API.G_MISS_NUM,
125: TOTAL_POSITIVES NUMBER := FND_API.G_MISS_NUM,
126: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
127: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
128: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
122: TARGET_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
123: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
124: TOTAL_RECORDS NUMBER := FND_API.G_MISS_NUM,
125: TOTAL_POSITIVES NUMBER := FND_API.G_MISS_NUM,
126: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
127: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
128: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
130: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
123: TARGET_POSITIVE_VALUE VARCHAR2(30) := FND_API.G_MISS_CHAR,
124: TOTAL_RECORDS NUMBER := FND_API.G_MISS_NUM,
125: TOTAL_POSITIVES NUMBER := FND_API.G_MISS_NUM,
126: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
127: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
128: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
130: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
131: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
124: TOTAL_RECORDS NUMBER := FND_API.G_MISS_NUM,
125: TOTAL_POSITIVES NUMBER := FND_API.G_MISS_NUM,
126: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
127: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
128: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
130: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
131: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
132: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
125: TOTAL_POSITIVES NUMBER := FND_API.G_MISS_NUM,
126: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
127: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
128: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
130: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
131: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
132: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
126: MIN_RECORDS NUMBER := FND_API.G_MISS_NUM,
127: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
128: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
130: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
131: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
132: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: model_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
127: MAX_RECORDS NUMBER := FND_API.G_MISS_NUM,
128: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
130: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
131: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
132: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: model_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
135: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
128: row_selection_type VARCHAR2(30) := FND_API.G_MISS_CHAR,
129: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
130: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
131: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
132: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: model_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
135: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
136: best_subtree NUMBER := FND_API.G_MISS_NUM,
129: EVERY_NTH_ROW NUMBER := FND_API.G_MISS_NUM,
130: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
131: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
132: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: model_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
135: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
136: best_subtree NUMBER := FND_API.G_MISS_NUM,
137: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
130: PCT_RANDOM NUMBER := FND_API.G_MISS_NUM,
131: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
132: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: model_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
135: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
136: best_subtree NUMBER := FND_API.G_MISS_NUM,
137: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
138: country_id NUMBER := FND_API.G_MISS_NUM,
131: PERFORMANCE NUMBER := FND_API.G_MISS_NUM,
132: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: model_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
135: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
136: best_subtree NUMBER := FND_API.G_MISS_NUM,
137: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
138: country_id NUMBER := FND_API.G_MISS_NUM,
139: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
132: TARGET_GROUP_TYPE VARCHAR2(30) := FND_API.G_MISS_CHAR,
133: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: model_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
135: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
136: best_subtree NUMBER := FND_API.G_MISS_NUM,
137: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
138: country_id NUMBER := FND_API.G_MISS_NUM,
139: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
140: target_id NUMBER := FND_API.G_MISS_NUM,
133: DARWIN_MODEL_REF VARCHAR2(4000) := FND_API.G_MISS_CHAR,
134: model_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
135: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
136: best_subtree NUMBER := FND_API.G_MISS_NUM,
137: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
138: country_id NUMBER := FND_API.G_MISS_NUM,
139: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
140: target_id NUMBER := FND_API.G_MISS_NUM,
141: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
134: model_name VARCHAR2(120) := FND_API.G_MISS_CHAR,
135: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
136: best_subtree NUMBER := FND_API.G_MISS_NUM,
137: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
138: country_id NUMBER := FND_API.G_MISS_NUM,
139: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
140: target_id NUMBER := FND_API.G_MISS_NUM,
141: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
135: description VARCHAR2(4000) := FND_API.G_MISS_CHAR,
136: best_subtree NUMBER := FND_API.G_MISS_NUM,
137: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
138: country_id NUMBER := FND_API.G_MISS_NUM,
139: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
140: target_id NUMBER := FND_API.G_MISS_NUM,
141: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
136: best_subtree NUMBER := FND_API.G_MISS_NUM,
137: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
138: country_id NUMBER := FND_API.G_MISS_NUM,
139: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
140: target_id NUMBER := FND_API.G_MISS_NUM,
141: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
137: custom_setup_id NUMBER := FND_API.G_MISS_NUM,
138: country_id NUMBER := FND_API.G_MISS_NUM,
139: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
140: target_id NUMBER := FND_API.G_MISS_NUM,
141: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
138: country_id NUMBER := FND_API.G_MISS_NUM,
139: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
140: target_id NUMBER := FND_API.G_MISS_NUM,
141: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
139: wf_itemkey VARCHAR2(240) := FND_API.G_MISS_CHAR,
140: target_id NUMBER := FND_API.G_MISS_NUM,
141: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
140: target_id NUMBER := FND_API.G_MISS_NUM,
141: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
141: ATTRIBUTE_CATEGORY VARCHAR2(30) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
142: ATTRIBUTE1 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
143: ATTRIBUTE2 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
144: ATTRIBUTE3 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
145: ATTRIBUTE4 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
146: ATTRIBUTE5 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
147: ATTRIBUTE6 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
148: ATTRIBUTE7 VARCHAR2(150) := FND_API.G_MISS_CHAR,
149: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
149: ATTRIBUTE8 VARCHAR2(150) := FND_API.G_MISS_CHAR,
150: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
157: );
150: ATTRIBUTE9 VARCHAR2(150) := FND_API.G_MISS_CHAR,
151: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
157: );
158:
151: ATTRIBUTE10 VARCHAR2(150) := FND_API.G_MISS_CHAR,
152: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
157: );
158:
159: G_MISS_DM_MODEL_REC DM_MODEL_Rec_Type;
152: ATTRIBUTE11 VARCHAR2(150) := FND_API.G_MISS_CHAR,
153: ATTRIBUTE12 VARCHAR2(150) := FND_API.G_MISS_CHAR,
154: ATTRIBUTE13 VARCHAR2(150) := FND_API.G_MISS_CHAR,
155: ATTRIBUTE14 VARCHAR2(150) := FND_API.G_MISS_CHAR,
156: ATTRIBUTE15 VARCHAR2(150) := FND_API.G_MISS_CHAR
157: );
158:
159: G_MISS_DM_MODEL_REC DM_MODEL_Rec_Type;
160: TYPE DM_MODEL_Tbl_Type IS TABLE OF DM_MODEL_Rec_Type INDEX BY BINARY_INTEGER;
185: -- Pre-Req :
186: -- Parameters:
187: -- IN
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192: -- P_DM_MODEL_Rec IN DM_MODEL_Rec_Type Required
193: --
186: -- Parameters:
187: -- IN
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192: -- P_DM_MODEL_Rec IN DM_MODEL_Rec_Type Required
193: --
194: -- OUT:
187: -- IN
188: -- p_api_version_number IN NUMBER Required
189: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
190: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
191: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
192: -- P_DM_MODEL_Rec IN DM_MODEL_Rec_Type Required
193: --
194: -- OUT:
195: -- x_return_status OUT VARCHAR2
202: -- End of Comments
203: --
204: PROCEDURE Lock_dm_model(
205: P_Api_Version_Number IN NUMBER,
206: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
207:
208: X_Return_Status OUT NOCOPY VARCHAR2,
209: X_Msg_Count OUT NOCOPY NUMBER,
210: X_Msg_Data OUT NOCOPY VARCHAR2,
221: -- Pre-Req :
222: -- Parameters:
223: -- IN
224: -- p_api_version_number IN NUMBER Required
225: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
226: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
228: -- P_DM_MODEL_Rec IN DM_MODEL_Rec_Type Required
229: --
222: -- Parameters:
223: -- IN
224: -- p_api_version_number IN NUMBER Required
225: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
226: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
228: -- P_DM_MODEL_Rec IN DM_MODEL_Rec_Type Required
229: --
230: -- OUT:
223: -- IN
224: -- p_api_version_number IN NUMBER Required
225: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
226: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
227: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
228: -- P_DM_MODEL_Rec IN DM_MODEL_Rec_Type Required
229: --
230: -- OUT:
231: -- x_return_status OUT VARCHAR2
238: -- End of Comments
239: --
240: PROCEDURE Create_dm_model(
241: P_Api_Version_Number IN NUMBER,
242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245:
246: X_Return_Status OUT NOCOPY VARCHAR2,
239: --
240: PROCEDURE Create_dm_model(
241: P_Api_Version_Number IN NUMBER,
242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245:
246: X_Return_Status OUT NOCOPY VARCHAR2,
247: X_Msg_Count OUT NOCOPY NUMBER,
240: PROCEDURE Create_dm_model(
241: P_Api_Version_Number IN NUMBER,
242: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
243: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
244: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
245:
246: X_Return_Status OUT NOCOPY VARCHAR2,
247: X_Msg_Count OUT NOCOPY NUMBER,
248: X_Msg_Data OUT NOCOPY VARCHAR2,
260: -- Pre-Req :
261: -- Parameters:
262: -- IN
263: -- p_api_version_number IN NUMBER Required
264: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
265: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
266: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
267: -- P_DM_MODEL_Rec IN DM_MODEL_Rec_Type Required
268: --
261: -- Parameters:
262: -- IN
263: -- p_api_version_number IN NUMBER Required
264: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
265: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
266: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
267: -- P_DM_MODEL_Rec IN DM_MODEL_Rec_Type Required
268: --
269: -- OUT:
262: -- IN
263: -- p_api_version_number IN NUMBER Required
264: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
265: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
266: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
267: -- P_DM_MODEL_Rec IN DM_MODEL_Rec_Type Required
268: --
269: -- OUT:
270: -- x_return_status OUT VARCHAR2
277: -- End of Comments
278: --
279: PROCEDURE Update_dm_model(
280: P_Api_Version_Number IN NUMBER,
281: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
282: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
284:
285: X_Return_Status OUT NOCOPY VARCHAR2,
278: --
279: PROCEDURE Update_dm_model(
280: P_Api_Version_Number IN NUMBER,
281: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
282: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
284:
285: X_Return_Status OUT NOCOPY VARCHAR2,
286: X_Msg_Count OUT NOCOPY NUMBER,
279: PROCEDURE Update_dm_model(
280: P_Api_Version_Number IN NUMBER,
281: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
282: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
283: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
284:
285: X_Return_Status OUT NOCOPY VARCHAR2,
286: X_Msg_Count OUT NOCOPY NUMBER,
287: X_Msg_Data OUT NOCOPY VARCHAR2,
298: -- Pre-Req :
299: -- Parameters:
300: -- IN
301: -- p_api_version_number IN NUMBER Required
302: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
303: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
304: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
305: -- p_MODEL_ID IN NUMBER
306: -- p_object_version_number IN NUMBER Optional Default = NULL
299: -- Parameters:
300: -- IN
301: -- p_api_version_number IN NUMBER Required
302: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
303: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
304: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
305: -- p_MODEL_ID IN NUMBER
306: -- p_object_version_number IN NUMBER Optional Default = NULL
307: --
300: -- IN
301: -- p_api_version_number IN NUMBER Required
302: -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
303: -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
304: -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
305: -- p_MODEL_ID IN NUMBER
306: -- p_object_version_number IN NUMBER Optional Default = NULL
307: --
308: -- OUT:
316: -- End of Comments
317: --
318: PROCEDURE Delete_dm_model(
319: P_Api_Version_Number IN NUMBER,
320: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
321: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: X_Return_Status OUT NOCOPY VARCHAR2,
324: X_Msg_Count OUT NOCOPY NUMBER,
317: --
318: PROCEDURE Delete_dm_model(
319: P_Api_Version_Number IN NUMBER,
320: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
321: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: X_Return_Status OUT NOCOPY VARCHAR2,
324: X_Msg_Count OUT NOCOPY NUMBER,
325: X_Msg_Data OUT NOCOPY VARCHAR2,
318: PROCEDURE Delete_dm_model(
319: P_Api_Version_Number IN NUMBER,
320: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
321: P_Commit IN VARCHAR2 := FND_API.G_FALSE,
322: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
323: X_Return_Status OUT NOCOPY VARCHAR2,
324: X_Msg_Count OUT NOCOPY NUMBER,
325: X_Msg_Data OUT NOCOPY VARCHAR2,
326: P_MODEL_ID IN NUMBER,
340: -- End of Comments
341:
342: PROCEDURE Validate_DM_MODEL_rec(
343: P_Api_Version_Number IN NUMBER,
344: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
345: p_validation_mode IN VARCHAR2 := FND_API.G_FALSE,
346: X_Return_Status OUT NOCOPY VARCHAR2,
347: X_Msg_Count OUT NOCOPY NUMBER,
348: X_Msg_Data OUT NOCOPY VARCHAR2,
341:
342: PROCEDURE Validate_DM_MODEL_rec(
343: P_Api_Version_Number IN NUMBER,
344: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
345: p_validation_mode IN VARCHAR2 := FND_API.G_FALSE,
346: X_Return_Status OUT NOCOPY VARCHAR2,
347: X_Msg_Count OUT NOCOPY NUMBER,
348: X_Msg_Data OUT NOCOPY VARCHAR2,
349: P_DM_MODEL_Rec IN DM_MODEL_Rec_Type
361: -- End of Comments
362:
363: PROCEDURE Validate_dm_model(
364: P_Api_Version_Number IN NUMBER,
365: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
366: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
367: P_Validation_mode IN VARCHAR2,
368: P_DM_MODEL_Rec IN DM_MODEL_Rec_Type,
369: X_Return_Status OUT NOCOPY VARCHAR2,
362:
363: PROCEDURE Validate_dm_model(
364: P_Api_Version_Number IN NUMBER,
365: P_Init_Msg_List IN VARCHAR2 := FND_API.G_FALSE,
366: P_Validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
367: P_Validation_mode IN VARCHAR2,
368: P_DM_MODEL_Rec IN DM_MODEL_Rec_Type,
369: X_Return_Status OUT NOCOPY VARCHAR2,
370: X_Msg_Count OUT NOCOPY NUMBER,
374: PROCEDURE Validate_next_status(
375: p_curr_status IN VARCHAR2,
376: p_next_status IN VARCHAR2,
377: p_system_status_type IN VARCHAR2,
378: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
379: x_return_status OUT NOCOPY VARCHAR2,
380: x_msg_count OUT NOCOPY NUMBER,
381: x_msg_data OUT NOCOPY VARCHAR2);
382:
454:
455:
456: PROCEDURE copy_model (
457: p_api_version IN NUMBER,
458: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
459: p_commit IN VARCHAR2 := FND_API.G_FALSE,
460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461: x_return_status OUT NOCOPY VARCHAR2,
462: x_msg_count OUT NOCOPY NUMBER,
455:
456: PROCEDURE copy_model (
457: p_api_version IN NUMBER,
458: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
459: p_commit IN VARCHAR2 := FND_API.G_FALSE,
460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461: x_return_status OUT NOCOPY VARCHAR2,
462: x_msg_count OUT NOCOPY NUMBER,
463: x_msg_data OUT NOCOPY VARCHAR2,
456: PROCEDURE copy_model (
457: p_api_version IN NUMBER,
458: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
459: p_commit IN VARCHAR2 := FND_API.G_FALSE,
460: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
461: x_return_status OUT NOCOPY VARCHAR2,
462: x_msg_count OUT NOCOPY NUMBER,
463: x_msg_data OUT NOCOPY VARCHAR2,
464: p_source_object_id IN NUMBER,