1 PACKAGE AMS_Dmlift_PUB AUTHID CURRENT_USER AS
2 /* $Header: amspdlfs.pls 115.2 2002/01/07 18:52:04 pkm ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Dmlift_PUB
7 -- Purpose
8 --
9 -- History
10 -- 21-Jan-2001 choang Added overload procedure create_lift for
11 -- ODM Accelerator integration.
12 -- 07-Jan-2002 choang removed security_group_id
13 --
14 -- NOTE
15 --
16 -- End of Comments
17 -- ===============================================================
18
19 -- Default number of records fetch per call
20 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
21 --===================================================================
22 -- Start of Comments
23 -- -------------------------------------------------------
24 -- Record name
25 -- Lift_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- LIFT_ID
29 -- LAST_UPDATE_DATE
30 -- LAST_UPDATED_BY
31 -- CREATION_DATE
32 -- CREATED_BY
33 -- LAST_UPDATE_LOGIN
34 -- OBJECT_VERSION_NUMBER
35 -- MODEL_ID
36 -- QUANTILE
37 -- LIFT
38 -- TARGETS
39 -- NON_TARGETS
40 -- TARGETS_CUMM
41 -- TARGET_DENSITY_CUMM
42 -- TARGET_DENSITY
43 -- MARGIN
44 -- ROI
45 -- TARGET_CONFIDENCE
46 -- NON_TARGET_CONFIDENCE
47 --
48 -- Required
49 --
50 -- Defaults
51 --
52 -- Note: This is automatic generated record definition, it includes all columns
53 -- defined in the table, developer must manually add or delete some of the attributes.
54 --
55 -- End of Comments
56
57 --===================================================================
58 TYPE Lift_rec_type IS RECORD
59 (
60 LIFT_ID NUMBER := FND_API.G_MISS_NUM,
61 LAST_UPDATE_DATE DATE := FND_API.G_MISS_DATE,
62 LAST_UPDATED_BY NUMBER := FND_API.G_MISS_NUM,
63 CREATION_DATE DATE := FND_API.G_MISS_DATE,
64 CREATED_BY NUMBER := FND_API.G_MISS_NUM,
65 LAST_UPDATE_LOGIN NUMBER := FND_API.G_MISS_NUM,
66 OBJECT_VERSION_NUMBER NUMBER := FND_API.G_MISS_NUM,
67 MODEL_ID NUMBER := FND_API.G_MISS_NUM,
68 QUANTILE NUMBER := FND_API.G_MISS_NUM,
69 LIFT NUMBER := FND_API.G_MISS_NUM,
70 TARGETS NUMBER := FND_API.G_MISS_NUM,
71 NON_TARGETS NUMBER := FND_API.G_MISS_NUM,
72 TARGETS_CUMM NUMBER := FND_API.G_MISS_NUM,
73 TARGET_DENSITY_CUMM NUMBER := FND_API.G_MISS_NUM,
74 TARGET_DENSITY NUMBER := FND_API.G_MISS_NUM,
75 MARGIN NUMBER := FND_API.G_MISS_NUM,
76 ROI NUMBER := FND_API.G_MISS_NUM,
77 TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM,
78 NON_TARGET_CONFIDENCE NUMBER := FND_API.G_MISS_NUM
79 );
80
81 g_miss_Lift_rec Lift_rec_type;
82 TYPE Lift_tbl_type IS TABLE OF Lift_rec_type INDEX BY BINARY_INTEGER;
83 g_miss_Lift_tbl Lift_tbl_type;
84
85 TYPE Lift_sort_rec_type IS RECORD
86 (
87 -- Please define your own sort by record here.
88 LAST_UPDATE_DATE NUMBER := NULL
89 );
90
91 -- ==============================================================================
92 -- Start of Comments
93 -- ==============================================================================
94 -- API Name
95 -- Lock_Dmlift
96 -- Type
97 -- Public
98 -- Pre-Req
99 --
100 -- Parameters
101 --
102 -- IN
103 -- p_api_version IN NUMBER Required
104 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
105 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
106 -- p_lift_rec IN lift_rec_type Required
107 --
108 -- OUT
109 -- x_return_status OUT VARCHAR2
110 -- x_msg_count OUT NUMBER
111 -- x_msg_data OUT VARCHAR2
112 -- Version : Current version 1.0
113 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
114 -- and basic operation, developer must manually add parameters and business logic as necessary.
115 --
116 -- End of Comments
117 -- ==============================================================================
118 --
119
120 PROCEDURE Lock_Dmlift(
121 p_api_version IN NUMBER,
122 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
123 x_return_status OUT VARCHAR2,
124 x_msg_count OUT NUMBER,
125 x_msg_data OUT VARCHAR2,
126
127 p_lift_id IN NUMBER,
128 p_object_version IN NUMBER
129 );
130
131 -- ==============================================================================
132 -- Start of Comments
133 -- ==============================================================================
134 -- API Name
135 -- Create_Lift
136 -- Type
137 -- Public
138 -- Pre-Req
139 --
140 -- Parameters
141 --
142 -- IN
143 -- p_api_version IN NUMBER Required
144 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
145 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
146 -- p_lift_rec IN lift_rec_type Required
147 --
148 -- OUT
149 -- x_return_status OUT VARCHAR2
150 -- x_msg_count OUT NUMBER
151 -- x_msg_data OUT VARCHAR2
152 -- Version : Current version 1.0
153 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
154 -- and basic operation, developer must manually add parameters and business logic as necessary.
155 --
156 -- End of Comments
157 -- ==============================================================================
158 --
159
160 PROCEDURE Create_Lift(
161 p_api_version IN NUMBER,
162 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
163 p_commit IN VARCHAR2 := FND_API.G_FALSE,
164
165 x_return_status OUT VARCHAR2,
166 x_msg_count OUT NUMBER,
167 x_msg_data OUT VARCHAR2,
168
169 p_lift_rec IN Lift_rec_type := g_miss_Lift_rec,
170 x_lift_id OUT NUMBER
171 );
172
173 -- ==============================================================================
174 -- Start of Comments
175 -- ==============================================================================
176 -- API Name
177 -- Update_Lift
178 -- Type
179 -- Public
180 -- Pre-Req
181 --
182 -- Parameters
183 --
184 -- IN
185 -- p_api_version IN NUMBER Required
186 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
187 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
188 -- p_lift_rec IN lift_rec_type Required
189 --
190 -- OUT
191 -- x_return_status OUT VARCHAR2
192 -- x_msg_count OUT NUMBER
193 -- x_msg_data OUT VARCHAR2
194 -- Version : Current version 1.0
195 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
196 -- and basic operation, developer must manually add parameters and business logic as necessary.
197 --
198 -- End of Comments
199 -- ==============================================================================
200 --
201
202 PROCEDURE Update_Lift(
203 p_api_version IN NUMBER,
204 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
205 p_commit IN VARCHAR2 := FND_API.G_FALSE,
206
207 x_return_status OUT VARCHAR2,
208 x_msg_count OUT NUMBER,
209 x_msg_data OUT VARCHAR2,
210
211 p_lift_rec IN lift_rec_type,
212 x_object_version_number OUT NUMBER
213 );
214
215 -- ==============================================================================
216 -- Start of Comments
217 -- ==============================================================================
218 -- API Name
219 -- Delete_Lift
220 -- Type
221 -- Public
222 -- Pre-Req
223 --
224 -- Parameters
225 --
226 -- IN
230 -- p_LIFT_ID IN NUMBER
227 -- p_api_version IN NUMBER Required
228 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
229 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
231 -- p_object_version_number IN NUMBER Optional Default = NULL
232 --
233 -- OUT
234 -- x_return_status OUT VARCHAR2
235 -- x_msg_count OUT NUMBER
236 -- x_msg_data OUT VARCHAR2
237 -- Version : Current version 1.0
238 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
239 -- and basic operation, developer must manually add parameters and business logic as necessary.
240 --
241 -- End of Comments
242 -- ==============================================================================
243 --
244
245 PROCEDURE Delete_Lift(
246 p_api_version IN NUMBER,
247 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
248 p_commit IN VARCHAR2 := FND_API.G_FALSE,
249 x_return_status OUT VARCHAR2,
250 x_msg_count OUT NUMBER,
251 x_msg_data OUT VARCHAR2,
252 p_lift_id IN NUMBER,
253 p_object_version_number IN NUMBER
254 );
255
256 -- ==============================================================================
257 -- Start of Comments
258 -- ==============================================================================
259 -- API Name
260 -- Create_Lift
261 -- Type
262 -- Public
263 -- Pre-Req
264 --
265 -- Parameters
266 --
267 -- IN
268 -- p_model_id IN NUMBER
269 -- p_quantile IN NUMBER
270 -- p_lift IN NUMBER
271 -- p_targets IN NUMBER
272 -- p_non_targets IN NUMBER
273 -- p_targets_cumm IN NUMBER
274 -- p_target_density IN NUMBER
275 -- p_target_density_cumm IN NUMBER
276 -- p_target_confidence IN NUMBER
277 -- p_non_target_confidence IN NUMBER
278 --
279 -- OUT
280 -- x_lift_id OUT NUMBER
281 -- x_return_status OUT VARCHAR2
282 --
283 -- End of Comments
284 -- ==============================================================================
285 --
286 PROCEDURE Create_Lift (
287 p_model_id IN NUMBER,
288 p_quantile IN NUMBER,
289 p_lift IN NUMBER,
290 p_targets IN NUMBER,
291 p_non_targets IN NUMBER,
292 p_targets_cumm IN NUMBER,
293 p_target_density IN NUMBER,
294 p_target_density_cumm IN NUMBER,
295 p_target_confidence IN NUMBER,
296 p_non_target_confidence IN NUMBER,
297 x_lift_id OUT NUMBER,
298 x_return_status OUT VARCHAR2
299 );
300
301 END AMS_Dmlift_PUB;