[Home] [Help]
PACKAGE: APPS.OZF_TRADE_PROFILE_PVT
Source
1 PACKAGE OZF_Trade_Profile_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvctps.pls 115.4 2003/11/11 12:55:41 pkarthik ship $ */
3 -- ===============================================================
4 -- Start of Comments
5 -- Package name
6 -- OZF_Trade_Profile_PVT
7 -- Purpose
8 --
9 -- History
10 --
11 -- NOTE
12 --
13 -- End of Comments
14 -- ===============================================================
15
16 -- Default number of records fetch per call
17 G_DEFAULT_NUM_REC_FETCH NUMBER := 30;
18 --===================================================================
19 -- Start of Comments
20 -- -------------------------------------------------------
21 -- Record name
22 -- trade_profile_rec_type
23 -- -------------------------------------------------------
24 -- Parameters:
25 -- trade_profile_id
26 -- object_version_number
27 -- last_update_date
28 -- last_updated_by
29 -- creation_date
30 -- created_by
31 -- last_update_login
32 -- request_id
33 -- program_application_id
34 -- program_update_date
35 -- program_id
36 -- created_from
37 -- party_id
38 -- site_use_id
39 -- autopay_flag
40 -- claim_threshold
41 -- claim_currency
42 -- print_flag
43 -- internet_deal_view_flag
44 -- internet_claims_flag
45 -- autopay_periodicity
46 -- autopay_periodicity_type
47 -- payment_method
48 -- discount_type
49 -- cust_account_id
50 -- cust_acct_site_id
51 -- vendor_id
52 -- vendor_site_id
53 -- vendor_site_code
54 -- context
55 -- attribute_category
56 -- attribute1
57 -- attribute2
58 -- attribute3
59 -- attribute4
60 -- attribute5
61 -- attribute6
62 -- attribute7
63 -- attribute8
64 -- attribute9
65 -- attribute10
66 -- attribute11
67 -- attribute12
68 -- attribute13
69 -- attribute14
70 -- attribute15
71 -- org_id
72 -- days_due
73 --
74 -- Required
75 --
76 -- Defaults
77 --
78 -- Note: This is automatic generated record definition, it includes all columns
79 -- defined in the table, developer must manually add or delete some of the attributes.
80 --
81 -- End of Comments
82
83 --===================================================================
84 TYPE trade_profile_rec_type IS RECORD
85 (
86 trade_profile_id NUMBER,
87 object_version_number NUMBER,
88 last_update_date DATE,
89 last_updated_by NUMBER,
90 creation_date DATE,
91 created_by NUMBER,
92 last_update_login NUMBER,
93 request_id NUMBER,
94 program_application_id NUMBER,
95 program_update_date DATE,
96 program_id NUMBER,
97 created_from VARCHAR2(30),
98 party_id NUMBER,
99 site_use_id NUMBER,
100 autopay_flag VARCHAR2(1),
101 claim_threshold NUMBER,
102 claim_currency VARCHAR2(30),
103 print_flag VARCHAR2(1),
104 internet_deal_view_flag VARCHAR2(1),
105 internet_claims_flag VARCHAR2(1),
106 autopay_periodicity NUMBER,
107 autopay_periodicity_type VARCHAR2(30),
108 payment_method VARCHAR2(15),
109 discount_type VARCHAR2(30),
110 cust_account_id NUMBER,
111 cust_acct_site_id NUMBER,
112 vendor_id NUMBER,
113 vendor_site_id NUMBER,
114 vendor_site_code VARCHAR2(15),
115 context VARCHAR2(30),
116 attribute_category VARCHAR2(30),
117 attribute1 VARCHAR2(150),
118 attribute2 VARCHAR2(150),
119 attribute3 VARCHAR2(150),
120 attribute4 VARCHAR2(150),
121 attribute5 VARCHAR2(150),
122 attribute6 VARCHAR2(150),
123 attribute7 VARCHAR2(150),
124 attribute8 VARCHAR2(150),
125 attribute9 VARCHAR2(150),
126 attribute10 VARCHAR2(150),
127 attribute11 VARCHAR2(150),
128 attribute12 VARCHAR2(150),
129 attribute13 VARCHAR2(150),
130 attribute14 VARCHAR2(150),
131 attribute15 VARCHAR2(150),
132 org_id NUMBER ,
133 days_due NUMBER,
134 pos_write_off_threshold NUMBER,
135 neg_write_off_threshold NUMBER,
136 un_earned_pay_allow_to VARCHAR2(30),
137 un_earned_pay_thold_type VARCHAR2(30),
138 un_earned_pay_threshold NUMBER,
139 un_earned_pay_thold_flag VARCHAR2(1),
140 header_tolerance_calc_code VARCHAR2(30),
141 header_tolerance_operand NUMBER,
142 line_tolerance_calc_code VARCHAR2(30),
143 line_tolerance_operand NUMBER
144 );
145
146 g_miss_trade_profile_rec trade_profile_rec_type;
147 TYPE trade_profile_tbl_type IS TABLE OF trade_profile_rec_type INDEX BY BINARY_INTEGER;
148 g_miss_trade_profile_tbl trade_profile_tbl_type;
149
150 -- ==============================================================================
151 -- Start of Comments
152 -- ==============================================================================
153 -- API Name
154 -- Create_Trade_Profile
155 -- Type
156 -- Private
157 -- Pre-Req
158 --
159 -- Parameters
160 --
161 -- IN
162 -- p_api_version_number IN NUMBER Required
163 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
164 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
165 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
166 -- p_trade_profile_rec IN trade_profile_rec_type Required
167 --
168 -- OUT
169 -- x_return_status OUT VARCHAR2
170 -- x_msg_count OUT NUMBER
171 -- x_msg_data OUT VARCHAR2
172 -- Version : Current version 1.0
173 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
174 -- and basic operation, developer must manually add parameters and business logic as necessary.
175 --
176 -- End of Comments
177 -- ==============================================================================
178 --
179
180 PROCEDURE Create_Trade_Profile(
181 p_api_version_number IN NUMBER,
182 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
183 p_commit IN VARCHAR2 := FND_API.G_FALSE,
184 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
185
186 x_return_status OUT NOCOPY VARCHAR2,
187 x_msg_count OUT NOCOPY NUMBER,
188 x_msg_data OUT NOCOPY VARCHAR2,
189
190 p_trade_profile_rec IN trade_profile_rec_type := g_miss_trade_profile_rec,
191 x_trade_profile_id OUT NOCOPY NUMBER
192 );
193
194 -- ==============================================================================
195 -- Start of Comments
196 -- ==============================================================================
197 -- API Name
198 -- Update_Trade_Profile
199 -- Type
200 -- Private
201 -- Pre-Req
202 --
203 -- Parameters
204 --
205 -- IN
206 -- p_api_version_number IN NUMBER Required
207 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
208 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
209 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
210 -- p_trade_profile_rec IN trade_profile_rec_type Required
211 --
212 -- OUT
213 -- x_return_status OUT VARCHAR2
214 -- x_msg_count OUT NUMBER
215 -- x_msg_data OUT VARCHAR2
216 -- Version : Current version 1.0
217 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
218 -- and basic operation, developer must manually add parameters and business logic as necessary.
219 --
220 -- End of Comments
221 -- ==============================================================================
222 --
223
224 PROCEDURE Update_Trade_Profile(
225 p_api_version_number IN NUMBER,
226 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
227 p_commit IN VARCHAR2 := FND_API.G_FALSE,
228 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
229
230 x_return_status OUT NOCOPY VARCHAR2,
231 x_msg_count OUT NOCOPY NUMBER,
232 x_msg_data OUT NOCOPY VARCHAR2,
233
234 p_trade_profile_rec IN trade_profile_rec_type,
235 x_object_version_number OUT NOCOPY NUMBER
236 );
237
238 -- ==============================================================================
239 -- Start of Comments
240 -- ==============================================================================
241 -- API Name
242 -- Delete_Trade_Profile
243 -- Type
244 -- Private
245 -- Pre-Req
246 --
247 -- Parameters
248 --
249 -- IN
250 -- p_api_version_number IN NUMBER Required
251 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
252 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
253 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
254 -- p_TRADE_PROFILE_ID IN NUMBER
255 -- p_object_version_number IN NUMBER Optional Default = NULL
256 --
257 -- OUT
258 -- x_return_status OUT VARCHAR2
259 -- x_msg_count OUT NUMBER
260 -- x_msg_data OUT VARCHAR2
261 -- Version : Current version 1.0
262 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
263 -- and basic operation, developer must manually add parameters and business logic as necessary.
264 --
265 -- End of Comments
266 -- ==============================================================================
267 --
268
269 PROCEDURE Delete_Trade_Profile(
270 p_api_version_number IN NUMBER,
271 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
272 p_commit IN VARCHAR2 := FND_API.G_FALSE,
273 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
274 x_return_status OUT NOCOPY VARCHAR2,
275 x_msg_count OUT NOCOPY NUMBER,
276 x_msg_data OUT NOCOPY VARCHAR2,
277 p_trade_profile_id IN NUMBER,
278 p_object_version_number IN NUMBER
279 );
280
281 -- ==============================================================================
282 -- Start of Comments
283 -- ==============================================================================
284 -- API Name
285 -- Lock_Trade_Profile
286 -- Type
287 -- Private
288 -- Pre-Req
289 --
290 -- Parameters
291 --
292 -- IN
293 -- p_api_version_number IN NUMBER Required
294 -- p_init_msg_list IN VARCHAR2 Optional Default = FND_API_G_FALSE
295 -- p_commit IN VARCHAR2 Optional Default = FND_API.G_FALSE
296 -- p_validation_level IN NUMBER Optional Default = FND_API.G_VALID_LEVEL_FULL
297 -- p_trade_profile_rec IN trade_profile_rec_type Required
298 --
299 -- OUT
300 -- x_return_status OUT VARCHAR2
301 -- x_msg_count OUT NUMBER
302 -- x_msg_data OUT VARCHAR2
303 -- Version : Current version 1.0
304 -- Note: This automatic generated procedure definition, it includes standard IN/OUT parameters
305 -- and basic operation, developer must manually add parameters and business logic as necessary.
306 --
307 -- End of Comments
308 -- ==============================================================================
309 --
310
311 PROCEDURE Lock_Trade_Profile(
312 p_api_version_number IN NUMBER,
313 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
314
315 x_return_status OUT NOCOPY VARCHAR2,
316 x_msg_count OUT NOCOPY NUMBER,
317 x_msg_data OUT NOCOPY VARCHAR2,
318
319 p_trade_profile_id IN NUMBER,
320 p_object_version IN NUMBER
321 );
322
323
324 -- Start of Comments
325 --
326 -- validation procedures
327 --
328 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
329 -- For create: G_CREATE, for update: G_UPDATE
330 -- Note: 1. This is automated generated item level validation procedure.
331 -- The actual validation detail is needed to be added.
332 -- 2. We can also validate table instead of record. There will be an option for user to choose.
333 -- End of Comments
334
335 PROCEDURE Validate_trade_profile(
336 p_api_version_number IN NUMBER,
337 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
338 p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
339 p_trade_profile_rec IN trade_profile_rec_type,
340 x_return_status OUT NOCOPY VARCHAR2,
341 x_msg_count OUT NOCOPY NUMBER,
342 x_msg_data OUT NOCOPY VARCHAR2
343 );
344
345 -- Start of Comments
346 --
347 -- validation procedures
348 --
349 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
350 -- For create: G_CREATE, for update: G_UPDATE
351 -- Note: 1. This is automated generated item level validation procedure.
352 -- The actual validation detail is needed to be added.
353 -- 2. Validate the unique keys, lookups here
354 -- End of Comments
355
356 PROCEDURE Check_trade_profile_Items (
357 P_trade_profile_rec IN trade_profile_rec_type,
358 p_validation_mode IN VARCHAR2,
359 x_return_status OUT NOCOPY VARCHAR2
360 );
361
362 -- Start of Comments
363 --
364 -- Record level validation procedures
365 --
366 -- p_validation_mode is a constant defined in OZF_UTILITY_PVT package
367 -- For create: G_CREATE, for update: G_UPDATE
368 -- Note: 1. This is automated generated item level validation procedure.
369 -- The actual validation detail is needed to be added.
370 -- 2. Developer can manually added inter-field level validation.
371 -- End of Comments
372
373 PROCEDURE Validate_trade_profile_rec(
374 p_api_version_number IN NUMBER,
375 p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
376 x_return_status OUT NOCOPY VARCHAR2,
377 x_msg_count OUT NOCOPY NUMBER,
378 x_msg_data OUT NOCOPY VARCHAR2,
379 p_trade_profile_rec IN trade_profile_rec_type
380 );
381 END OZF_Trade_Profile_PVT;