1 PACKAGE AMS_Appr_Hist_PVT AUTHID CURRENT_USER AS
2 /* $Header: amsvaphs.pls 115.1 2002/12/03 11:15:51 vmodur noship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- AMS_Appr_Hist_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- This Api is generated with Latest version of
14 -- Rosetta, where g_miss indicates NULL and
15 -- NULL indicates missing value. Rosetta Version 1.55
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 -- appr_hist_rec_type
26 -- -------------------------------------------------------
27 -- Parameters:
28 -- object_id
29 -- object_type_code
30 -- sequence_num
31 -- object_version_num
32 -- last_update_date
33 -- last_updated_by
34 -- creation_date
35 -- created_by
36 -- action_code
37 -- action_date
38 -- approver_id
39 -- approval_detail_id
40 -- note
41 -- last_update_login
42 -- approval_type
43 -- approver_type
44 -- custom_setup_id
45 -- log_message
46 --
47 -- Required
48 --
49 -- Defaults
50 --
51 -- Note: This is automatic generated record definition, it includes all columns
52 -- defined in the table, developer must manually add or delete some of the attributes.
53 --
54 -- End of Comments
55
56 --===================================================================
57 TYPE appr_hist_rec_type IS RECORD
58 (
59 object_id NUMBER,
60 object_type_code VARCHAR2(25),
61 sequence_num NUMBER,
62 object_version_num NUMBER,
63 last_update_date DATE,
64 last_updated_by NUMBER,
65 creation_date DATE,
66 created_by NUMBER,
67 action_code VARCHAR2(25),
68 action_date DATE,
69 approver_id NUMBER,
70 approval_detail_id NUMBER,
71 note VARCHAR2(4000),
72 last_update_login NUMBER,
73 approval_type VARCHAR2(30),
74 approver_type VARCHAR2(30),
75 custom_setup_id NUMBER,
76 log_message VARCHAR2(2000)
77 );
78
79 g_miss_appr_hist_rec appr_hist_rec_type := NULL;
80 TYPE appr_hist_tbl_type IS TABLE OF appr_hist_rec_type INDEX BY BINARY_INTEGER;
81 g_miss_appr_hist_tbl appr_hist_tbl_type;
82
83 -- ==============================================================================
84 -- Start of Comments
85 -- ==============================================================================
86 -- API Name
87 -- Create_Appr_Hist
88 -- Type
89 -- Private
90 -- Pre-Req
91 --
92 -- Parameters
93 --
94 -- IN
95 -- p_api_version_number IN NUMBER Required
96 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
97 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
98 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
99 -- p_appr_hist_rec IN appr_hist_rec_type Required
100 --
101 -- OUT
102 -- x_return_status OUT VARCHAR2
103 -- x_msg_count OUT NUMBER
104 -- x_msg_data OUT VARCHAR2
105 -- Version : Current version 1.0
106 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
107 -- and basic operation, developer must manually add parameters and business logic as necessary.
108 --
109 -- History
110 --
111 -- NOTE
112 --
113 -- End of Comments
114 -- ==============================================================================
115
116 PROCEDURE Create_Appr_Hist(
117 p_api_version_number IN NUMBER,
118 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
119 p_commit IN VARCHAR2 := FND_API.G_FALSE,
120 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
121
122 x_return_status OUT NOCOPY VARCHAR2,
123 x_msg_count OUT NOCOPY NUMBER,
124 x_msg_data OUT NOCOPY VARCHAR2,
125
126 p_appr_hist_rec IN appr_hist_rec_type := g_miss_appr_hist_rec
127 );
128
129 -- ==============================================================================
130 -- Start of Comments
131 -- ==============================================================================
132 -- API Name
133 -- Update_Appr_Hist
134 -- Type
135 -- Private
136 -- Pre-Req
137 --
138 -- Parameters
139 --
140 -- IN
141 -- p_api_version_number IN NUMBER Required
142 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
143 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
144 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
145 -- p_appr_hist_rec IN appr_hist_rec_type Required
146 --
147 -- OUT
148 -- x_return_status OUT VARCHAR2
149 -- x_msg_count OUT NUMBER
150 -- x_msg_data OUT VARCHAR2
151 -- Version : Current version 1.0
152 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
153 -- and basic operation, developer must manually add parameters and business logic as necessary.
154 --
155 -- History
156 --
157 -- NOTE
158 --
159 -- End of Comments
160 -- ==============================================================================
161
162 PROCEDURE Update_Appr_Hist(
163 p_api_version_number IN NUMBER,
164 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
165 p_commit IN VARCHAR2 := FND_API.G_FALSE,
166 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
167
168 x_return_status OUT NOCOPY VARCHAR2,
169 x_msg_count OUT NOCOPY NUMBER,
170 x_msg_data OUT NOCOPY VARCHAR2,
171
172 p_appr_hist_rec IN appr_hist_rec_type
173 );
174
175 -- ==============================================================================
176 -- Start of Comments
177 -- ==============================================================================
178 -- API Name
179 -- Delete_Appr_Hist
180 -- Type
181 -- Private
182 -- Pre-Req
183 --
184 -- Parameters
185 --
186 -- IN
187 -- p_api_version_number IN NUMBER Required
188 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
189 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
190 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
191 -- p_object_id IN NUMBER
192 -- p_object_version_num IN NUMBER Optional Default = NULL
193 --
194 -- OUT
195 -- x_return_status OUT VARCHAR2
196 -- x_msg_count OUT NUMBER
197 -- x_msg_data OUT VARCHAR2
198 -- Version : Current version 1.0
199 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
200 -- and basic operation, developer must manually add parameters and business logic as necessary.
201 --
202 -- History
203 --
204 -- NOTE
205 --
206 -- End of Comments
207 -- ==============================================================================
208
209 PROCEDURE Delete_Appr_Hist(
210 p_api_version_number IN NUMBER,
211 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
212 p_commit IN VARCHAR2 := FND_API.G_FALSE,
213 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
214 x_return_status OUT NOCOPY VARCHAR2,
215 x_msg_count OUT NOCOPY NUMBER,
216 x_msg_data OUT NOCOPY VARCHAR2,
217 p_object_id IN NUMBER,
218 p_object_type_code IN VARCHAR2,
219 p_sequence_num IN NUMBER,
220 p_action_code IN VARCHAR2,
221 p_object_version_num IN NUMBER,
222 p_approval_type IN VARCHAR2
223 );
224
225
226 -- ==============================================================================
227 -- Start of Comments
228 -- ==============================================================================
229 -- API Name
230 -- Validate_Appr_Hist
231 --
232 -- Version : Current version 1.0
233 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
234 -- For create: G_CREATE, for update: G_UPDATE
235 -- Note: 1. This is automated generated item level validation procedure.
236 -- The actual validation detail is needed to be added.
237 -- 2. We can also validate table instead of record. There will be an option for user to choose.
238 --
239 -- History
240 --
241 -- NOTE
242 --
243 -- End of Comments
244 -- ==============================================================================
245
246
247 PROCEDURE Validate_Appr_Hist(
248 p_api_version_number IN NUMBER,
249 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
250 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
251 p_appr_hist_rec IN appr_hist_rec_type,
252 p_validation_mode IN VARCHAR2,
253 x_return_status OUT NOCOPY VARCHAR2,
254 x_msg_count OUT NOCOPY NUMBER,
255 x_msg_data OUT NOCOPY VARCHAR2
256 );
257
258 -- ==============================================================================
259 -- Start of Comments
260 -- ==============================================================================
261 -- API Name
262 -- Appr_Hist_Items
263 --
264 -- Version : Current version 1.0
265 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
266 -- For create: G_CREATE, for update: G_UPDATE
267 -- Note: 1. This is automated generated item level validation procedure.
268 -- The actual validation detail is needed to be added.
269 -- 2. Validate the unique keys, lookups here
270 --
271 -- History
272 --
273 -- NOTE
274 --
275 -- End of Comments
276 -- ==============================================================================
277
278
279 PROCEDURE Check_Appr_Hist_Items (
280 P_appr_hist_rec IN appr_hist_rec_type,
281 p_validation_mode IN VARCHAR2,
282 x_return_status OUT NOCOPY VARCHAR2
283 );
284
285 -- ==============================================================================
286 -- Start of Comments
287 -- ==============================================================================
288 -- API Name
289 -- Validate_Appr_Hist_Rec
290 --
291 -- Version : Current version 1.0
292 -- p_validation_mode is a constant defined in AMS_UTILITY_PVT package
293 -- For create: G_CREATE, for update: G_UPDATE
294 -- Note: 1. This is automated generated item level validation procedure.
295 -- The actual validation detail is needed to be added.
296 -- 2. Developer can manually added inter-field level validation.
297 --
298 -- History
299 --
300 -- NOTE
301 --
302 -- End of Comments
303 -- ==============================================================================
304
305
306 PROCEDURE Validate_Appr_Hist_Rec (
307 p_api_version_number IN NUMBER,
308 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
309 x_return_status OUT NOCOPY VARCHAR2,
310 x_msg_count OUT NOCOPY NUMBER,
311 x_msg_data OUT NOCOPY VARCHAR2,
312 p_appr_hist_rec IN appr_hist_rec_type
313 );
314 END AMS_Appr_Hist_PVT;