[Home] [Help]
PACKAGE: APPS.AMS_DM_MODELS_B_PKG
Source
1 PACKAGE AMS_DM_MODELS_B_PKG AUTHID CURRENT_USER as
2 /* $Header: amstdmms.pls 115.13 2002/12/09 11:07:07 choang noship $ */
3 -- Start of Comments
4 -- Package name : AMS_DM_MODELS_B_PKG
5 -- Purpose : PACKAGE SPECIFICATION FOR TABLE HANDLER
6 -- History : 11/10/00 JIE LI CREATED
7 -- 02-Feb-2001 choang Added new columns.
8 -- 08-Feb-2001 choang Changed all IN/OUT params to IN.
9 -- 16-Feb-2001 choang Added row_selection_type and removed top_down_flag.
10 -- 26-Feb-2001 choang Added custom_setup_id, country_id, best_subtree
11 -- 08-Mar-2001 choang Added wf_itemkey
12 -- 17-Mar-2001 choang Added add_language, load_row, translate_row
13 -- 01-Feb-2002 choang Removed created by in update api
14 -- 18-Mar-2002 choang Added checkfile to dbdrv
15 -- NOTE :
16 -- End of Comments
17
18 PROCEDURE Insert_Row(
19 p_model_id IN NUMBER,
20 p_last_update_date DATE,
21 p_last_updated_by NUMBER,
22 p_creation_date DATE,
23 p_created_by NUMBER,
24 p_last_update_login NUMBER,
25 p_object_version_number IN NUMBER,
26 p_model_type VARCHAR2,
27 p_user_status_id NUMBER,
28 p_status_code IN VARCHAR2,
29 p_status_date DATE,
30 p_last_build_date DATE,
31 p_owner_user_id NUMBER,
32 p_performance NUMBER,
33 p_target_group_type VARCHAR2,
34 p_darwin_model_ref VARCHAR2,
35 p_model_name VARCHAR2,
36 p_description VARCHAR2,
37 p_scheduled_date DATE,
38 p_scheduled_timezone_id NUMBER,
39 p_expiration_date DATE,
40 p_results_flag VARCHAR2,
41 p_logs_flag VARCHAR2,
42 p_target_field VARCHAR2,
43 p_target_type VARCHAR2,
44 p_target_positive_value VARCHAR2,
45 p_total_records NUMBER,
46 p_total_positives NUMBER,
47 p_min_records NUMBER,
48 p_max_records NUMBER,
49 p_row_selection_type VARCHAR2,
50 p_every_nth_row NUMBER,
51 p_pct_random NUMBER,
52 p_best_subtree NUMBER,
53 p_custom_setup_id NUMBER,
54 p_country_id NUMBER,
55 p_wf_itemkey VARCHAR2,
56 p_target_id NUMBER,
57 p_attribute_category VARCHAR2,
58 p_attribute1 VARCHAR2,
59 p_attribute2 VARCHAR2,
60 p_attribute3 VARCHAR2,
61 p_attribute4 VARCHAR2,
62 p_attribute5 VARCHAR2,
63 p_attribute6 VARCHAR2,
64 p_attribute7 VARCHAR2,
65 p_attribute8 VARCHAR2,
66 p_attribute9 VARCHAR2,
67 p_attribute10 VARCHAR2,
68 p_attribute11 VARCHAR2,
69 p_attribute12 VARCHAR2,
70 p_attribute13 VARCHAR2,
71 p_attribute14 VARCHAR2,
72 p_attribute15 VARCHAR2
73 );
74
75 PROCEDURE Update_Row(
76 p_model_id NUMBER,
77 p_last_update_date DATE,
78 p_last_updated_by NUMBER,
79 p_last_update_login NUMBER,
80 p_object_version_number NUMBER,
81 p_model_type VARCHAR2,
82 p_user_status_id NUMBER,
83 p_status_code VARCHAR2,
84 p_status_date DATE,
85 p_last_build_date DATE,
86 p_owner_user_id NUMBER,
87 p_performance NUMBER,
88 p_target_group_type VARCHAR2,
89 p_darwin_model_ref VARCHAR2,
90 p_model_name VARCHAR2,
91 p_description VARCHAR2,
92 p_scheduled_date DATE,
93 p_scheduled_timezone_id NUMBER,
94 p_expiration_date DATE,
95 p_results_flag VARCHAR2,
96 p_logs_flag VARCHAR2,
97 p_target_field VARCHAR2,
98 p_target_type VARCHAR2,
99 p_target_positive_value VARCHAR2,
100 p_total_records NUMBER,
101 p_total_positives NUMBER,
102 p_min_records NUMBER,
103 p_max_records NUMBER,
104 p_row_selection_type VARCHAR2,
105 p_every_nth_row NUMBER,
106 p_pct_random NUMBER,
107 p_best_subtree NUMBER,
108 p_custom_setup_id NUMBER,
109 p_country_id NUMBER,
110 p_wf_itemkey VARCHAR2,
111 p_target_id NUMBER,
112 p_attribute_category VARCHAR2,
113 p_attribute1 VARCHAR2,
114 p_attribute2 VARCHAR2,
115 p_attribute3 VARCHAR2,
116 p_attribute4 VARCHAR2,
117 p_attribute5 VARCHAR2,
118 p_attribute6 VARCHAR2,
119 p_attribute7 VARCHAR2,
120 p_attribute8 VARCHAR2,
121 p_attribute9 VARCHAR2,
122 p_attribute10 VARCHAR2,
123 p_attribute11 VARCHAR2,
124 p_attribute12 VARCHAR2,
125 p_attribute13 VARCHAR2,
126 p_attribute14 VARCHAR2,
127 p_attribute15 VARCHAR2
128 );
129
130 PROCEDURE Lock_Row(
131 p_MODEL_ID NUMBER,
132 p_LAST_UPDATE_DATE DATE,
133 p_LAST_UPDATED_BY NUMBER,
134 p_CREATION_DATE DATE,
135 p_CREATED_BY NUMBER,
136 p_LAST_UPDATE_LOGIN NUMBER,
137 p_OBJECT_VERSION_NUMBER NUMBER,
138 p_MODEL_TYPE VARCHAR2,
139 p_USER_STATUS_ID NUMBER,
140 p_STATUS_CODE VARCHAR2,
141 p_STATUS_DATE DATE,
142 p_LAST_BUILD_DATE DATE,
143 p_OWNER_USER_ID NUMBER,
144 p_PERFORMANCE NUMBER,
145 p_TARGET_GROUP_TYPE VARCHAR2,
146 p_DARWIN_MODEL_REF VARCHAR2,
147 p_SCHEDULED_DATE DATE,
148 p_SCHEDULED_TIMEZONE_ID NUMBER,
149 p_EXPIRATION_DATE DATE,
150 p_RESULTS_FLAG VARCHAR2,
151 p_ATTRIBUTE_CATEGORY VARCHAR2,
152 p_ATTRIBUTE1 VARCHAR2,
153 p_ATTRIBUTE2 VARCHAR2,
154 p_ATTRIBUTE3 VARCHAR2,
155 p_ATTRIBUTE4 VARCHAR2,
156 p_ATTRIBUTE5 VARCHAR2,
157 p_ATTRIBUTE6 VARCHAR2,
158 p_ATTRIBUTE7 VARCHAR2,
159 p_ATTRIBUTE8 VARCHAR2,
160 p_ATTRIBUTE9 VARCHAR2,
161 p_ATTRIBUTE10 VARCHAR2,
162 p_ATTRIBUTE11 VARCHAR2,
163 p_ATTRIBUTE12 VARCHAR2,
164 p_ATTRIBUTE13 VARCHAR2,
165 p_ATTRIBUTE14 VARCHAR2,
166 p_ATTRIBUTE15 VARCHAR2
167 );
168
169 PROCEDURE Delete_Row(
170 p_MODEL_ID NUMBER);
171
172 PROCEDURE add_language;
173
174 PROCEDURE translate_row (
175 x_model_id IN NUMBER,
176 x_model_name IN VARCHAR2,
177 x_description IN VARCHAR2,
178 x_owner IN VARCHAR2
179 );
180
181 PROCEDURE load_row (
182 x_model_id IN NUMBER,
183 x_model_type VARCHAR2,
184 x_user_status_id NUMBER,
185 x_status_code IN VARCHAR2,
186 x_status_date DATE,
187 x_last_build_date DATE,
188 x_owner_user_id NUMBER,
189 x_performance NUMBER,
190 x_target_group_type VARCHAR2,
191 x_darwin_model_ref VARCHAR2,
192 x_model_name VARCHAR2,
193 x_description VARCHAR2,
194 x_scheduled_date DATE,
195 x_scheduled_timezone_id NUMBER,
196 x_expiration_date DATE,
197 x_results_flag VARCHAR2,
198 x_logs_flag VARCHAR2,
199 x_target_field VARCHAR2,
200 x_target_type VARCHAR2,
201 x_target_positive_value VARCHAR2,
202 x_total_records NUMBER,
203 x_total_positives NUMBER,
204 x_min_records NUMBER,
205 x_max_records NUMBER,
206 x_row_selection_type VARCHAR2,
207 x_every_nth_row NUMBER,
208 x_pct_random NUMBER,
209 x_best_subtree NUMBER,
210 x_custom_setup_id NUMBER,
211 x_country_id NUMBER,
212 x_wf_itemkey VARCHAR2,
213 x_target_id NUMBER,
214 x_attribute_category VARCHAR2,
215 x_attribute1 VARCHAR2,
216 x_attribute2 VARCHAR2,
217 x_attribute3 VARCHAR2,
218 x_attribute4 VARCHAR2,
219 x_attribute5 VARCHAR2,
220 x_attribute6 VARCHAR2,
221 x_attribute7 VARCHAR2,
222 x_attribute8 VARCHAR2,
223 x_attribute9 VARCHAR2,
224 x_attribute10 VARCHAR2,
225 x_attribute11 VARCHAR2,
226 x_attribute12 VARCHAR2,
227 x_attribute13 VARCHAR2,
228 x_attribute14 VARCHAR2,
229 x_attribute15 VARCHAR2,
230 x_owner VARCHAR2
231 );
232
233
234 End AMS_DM_MODELS_B_PKG;