1 PACKAGE AMS_Scoreresult_PUB AUTHID CURRENT_USER AS
2 /* $Header: amspdrss.pls 115.3 2002/01/07 18:52:12 pkm ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Scoreresult_PUB
7 -- Purpose
8 --
9 -- History
10 -- 24-Jan-2001 choang Created.
11 -- 12-Feb-2001 choang Changed model_score_id to score_id.
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 -- scoreresult_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- score_result_id
29 -- last_update_date
30 -- last_updated_by
31 -- creation_date
32 -- created_by
33 -- last_update_login
34 -- object_version_number
35 -- score_id
36 -- tree_node
37 -- num_records
38 -- response
39 -- confidence
40 --
41 -- Required
42 --
43 -- Defaults
44 --
45 -- Note: This is automatic generated record definition, it includes all columns
46 -- defined in the table, developer must manually add or delete some of the attributes.
47 --
48 -- End of Comments
49
50 --===================================================================
51 TYPE scoreresult_rec_type IS RECORD
52 (
53 score_result_id NUMBER := FND_API.G_MISS_NUM,
54 last_update_date DATE := FND_API.G_MISS_DATE,
55 last_updated_by NUMBER := FND_API.G_MISS_NUM,
56 creation_date DATE := FND_API.G_MISS_DATE,
57 created_by NUMBER := FND_API.G_MISS_NUM,
58 last_update_login NUMBER := FND_API.G_MISS_NUM,
59 object_version_number NUMBER := FND_API.G_MISS_NUM,
60 score_id NUMBER := FND_API.G_MISS_NUM,
61 tree_node VARCHAR2(30) := FND_API.G_MISS_CHAR,
62 num_records NUMBER := FND_API.G_MISS_NUM,
63 response VARCHAR2(30) := FND_API.G_MISS_CHAR,
64 confidence NUMBER := FND_API.G_MISS_NUM
65 );
66
67 g_miss_scoreresult_rec scoreresult_rec_type;
68 TYPE scoreresult_tbl_type IS TABLE OF scoreresult_rec_type INDEX BY BINARY_INTEGER;
69 g_miss_scoreresult_tbl scoreresult_tbl_type;
70
71 TYPE scoreresult_sort_rec_type IS RECORD
72 (
73 -- Please define your own sort by record here.
74 last_update_date NUMBER := NULL
75 );
76
77 -- ==============================================================================
78 -- Start of Comments
79 -- ==============================================================================
80 -- API Name
81 -- Create_Scoreresult
82 -- Type
83 -- Public
84 -- Pre-Req
85 --
86 -- Parameters
87 --
88 -- IN
89 -- p_api_version IN NUMBER Required
90 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
91 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
92 -- p_scoreresult_rec IN scoreresult_rec_type Required
93 --
94 -- OUT
95 -- x_return_status OUT VARCHAR2
96 -- x_msg_count OUT NUMBER
97 -- x_msg_data OUT VARCHAR2
98 -- Version : Current version 1.0
99 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
100 -- and basic operation, developer must manually add parameters and business logic as necessary.
101 --
102 -- End of Comments
103 -- ==============================================================================
104 --
105
106 PROCEDURE Create_Scoreresult(
107 p_api_version IN NUMBER,
108 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
109 p_commit IN VARCHAR2 := FND_API.G_FALSE,
110
111 x_return_status OUT VARCHAR2,
112 x_msg_count OUT NUMBER,
113 x_msg_data OUT VARCHAR2,
114
115 p_scoreresult_rec IN scoreresult_rec_type := g_miss_scoreresult_rec,
116 x_score_result_id OUT NUMBER
117 );
118
119 -- ==============================================================================
120 -- Start of Comments
121 -- ==============================================================================
122 -- API Name
123 -- Update_Scoreresult
124 -- Type
125 -- Public
126 -- Pre-Req
127 --
128 -- Parameters
129 --
130 -- IN
131 -- p_api_version IN NUMBER Required
132 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
133 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
134 -- p_scoreresult_rec IN scoreresult_rec_type Required
135 --
136 -- OUT
137 -- x_return_status OUT VARCHAR2
138 -- x_msg_count OUT NUMBER
139 -- x_msg_data OUT VARCHAR2
140 -- Version : Current version 1.0
141 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
142 -- and basic operation, developer must manually add parameters and business logic as necessary.
143 --
144 -- End of Comments
145 -- ==============================================================================
146 --
147
148 PROCEDURE Update_Scoreresult(
149 p_api_version IN NUMBER,
150 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
151 p_commit IN VARCHAR2 := FND_API.G_FALSE,
152
153 x_return_status OUT VARCHAR2,
154 x_msg_count OUT NUMBER,
155 x_msg_data OUT VARCHAR2,
156
157 p_scoreresult_rec IN scoreresult_rec_type,
158 x_object_version_number OUT NUMBER
159 );
160
161 -- ==============================================================================
162 -- Start of Comments
163 -- ==============================================================================
164 -- API Name
165 -- Delete_Scoreresult
166 -- Type
167 -- Public
168 -- Pre-Req
169 --
170 -- Parameters
171 --
172 -- IN
173 -- p_api_version IN NUMBER Required
174 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
175 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
176 -- p_SCORE_RESULT_ID IN NUMBER
177 -- p_object_version_number IN NUMBER Optional Default = NULL
178 --
179 -- OUT
180 -- x_return_status OUT VARCHAR2
181 -- x_msg_count OUT NUMBER
182 -- x_msg_data OUT VARCHAR2
183 -- Version : Current version 1.0
184 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
185 -- and basic operation, developer must manually add parameters and business logic as necessary.
186 --
187 -- End of Comments
188 -- ==============================================================================
189 --
190
191 PROCEDURE Delete_Scoreresult(
192 p_api_version IN NUMBER,
193 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
194 p_commit IN VARCHAR2 := FND_API.G_FALSE,
195 x_return_status OUT VARCHAR2,
196 x_msg_count OUT NUMBER,
197 x_msg_data OUT VARCHAR2,
198 p_score_result_id IN NUMBER,
199 p_object_version_number IN NUMBER
200 );
201
202 -- ==============================================================================
203 -- Start of Comments
204 -- ==============================================================================
205 -- API Name
206 -- Lock_Scoreresult
207 -- Type
208 -- Public
209 -- Pre-Req
210 --
211 -- Parameters
212 --
213 -- IN
214 -- p_api_version IN NUMBER Required
215 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
216 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
217 -- p_scoreresult_rec IN scoreresult_rec_type Required
218 --
219 -- OUT
220 -- x_return_status OUT VARCHAR2
221 -- x_msg_count OUT NUMBER
222 -- x_msg_data OUT VARCHAR2
223 -- Version : Current version 1.0
224 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
225 -- and basic operation, developer must manually add parameters and business logic as necessary.
226 --
227 -- End of Comments
228 -- ==============================================================================
229 --
230
231 PROCEDURE Lock_Scoreresult(
232 p_api_version IN NUMBER,
233 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
234 x_return_status OUT VARCHAR2,
235 x_msg_count OUT NUMBER,
236 x_msg_data OUT VARCHAR2,
237
238 p_score_result_id IN NUMBER,
239 p_object_version IN NUMBER
240 );
241
242
243 -- ==============================================================================
244 -- Start of Comments
245 -- ==============================================================================
246 -- API Name
247 -- Create_Scoreresult
248 -- Type
249 -- Public
250 -- Pre-Req
251 --
252 -- Parameters
253 --
254 -- IN
255 -- p_score_id NUMBER
256 -- p_tree_node NUMBER
257 -- p_num_records NUMBER
258 -- p_score VARCHAR2
259 -- p_confidence NUMBER
260 -- p_positive_score_prob NUMBER
261 --
262 -- OUT
263 -- x_score_result_id NUMBER
264 -- x_return_status VARCHAR2
265 --
266 -- End of Comments
267 -- ==============================================================================
268 PROCEDURE Create_ScoreResult (
269 p_score_id IN NUMBER,
270 p_tree_node IN NUMBER,
271 p_num_records IN NUMBER,
272 p_score IN VARCHAR2,
273 p_confidence IN NUMBER,
274 p_positive_score_prob IN NUMBER,
275 x_score_result_id OUT NUMBER,
276 x_return_status OUT VARCHAR2
277 );
278
279
280 END AMS_Scoreresult_PUB;
[Home] [Help]