[Home] [Help]
PACKAGE: APPS.OZF_SYS_PARAMETERS_PVT
Source
1 PACKAGE OZF_Sys_Parameters_PVT AUTHID CURRENT_USER AS
2 /* $Header: ozfvsyss.pls 120.8 2012/01/03 16:02:27 nirprasa ship $ */
3
4 TYPE sys_parameters_rec_type IS RECORD
5 (
6 set_of_books_id NUMBER,
7 object_version_number NUMBER,
8 last_update_date DATE,
9 last_updated_by NUMBER,
10 creation_date DATE,
11 created_by NUMBER,
12 last_update_login NUMBER,
13 request_id NUMBER,
14 program_application_id NUMBER,
15 program_update_date DATE,
16 program_id NUMBER,
17 created_from VARCHAR2(30),
18 post_to_gl VARCHAR2(1),
19 transfer_to_gl_in VARCHAR2(1),
20 ap_payment_term_id NUMBER,
21 rounding_level_flag VARCHAR2(1),
22 gl_id_rounding NUMBER,
23 gl_id_ded_clearing NUMBER,
24 gl_id_ded_adj NUMBER,
25 gl_id_accr_promo_liab NUMBER,
26 gl_id_ded_adj_clearing NUMBER,
27 gl_rec_ded_account NUMBER,
28 gl_rec_clearing_account NUMBER,
29 gl_cost_adjustment_acct NUMBER,
30 gl_contra_liability_acct NUMBER ,
31 gl_pp_accrual_acct NUMBER,
32 gl_date_type VARCHAR2(30),
33 days_due NUMBER,
34 claim_type_id NUMBER,
35 reason_code_id NUMBER,
36 autopay_claim_type_id NUMBER,
37 autopay_reason_code_id NUMBER,
38 autopay_flag VARCHAR2(1),
39 autopay_periodicity NUMBER,
40 autopay_periodicity_type VARCHAR2(30),
41 accounting_method_option VARCHAR2(25),
42 billback_trx_type_id NUMBER,
43 cm_trx_type_id NUMBER,
44 attribute_category VARCHAR2(150),
45 attribute1 VARCHAR2(150),
46 attribute2 VARCHAR2(150),
47 attribute3 VARCHAR2(150),
48 attribute4 VARCHAR2(150),
49 attribute5 VARCHAR2(150),
50 attribute6 VARCHAR2(150),
51 attribute7 VARCHAR2(150),
52 attribute8 VARCHAR2(150),
53 attribute9 VARCHAR2(150),
54 attribute10 VARCHAR2(150),
55 attribute11 VARCHAR2(150),
56 attribute12 VARCHAR2(150),
57 attribute13 VARCHAR2(150),
58 attribute14 VARCHAR2(150),
59 attribute15 VARCHAR2(150),
60 org_id NUMBER,
61 batch_source_id NUMBER,
62 payables_source VARCHAR2(30),
63 default_owner_id NUMBER,
64 auto_assign_flag VARCHAR2(1),
65 exchange_rate_type VARCHAR2(30),
66 order_type_id NUMBER,
67 --11.5.10 enhancements
68 gl_acct_for_offinv_flag VARCHAR2(1),
69 --short_payment_reason_code_id NUMBER,
70 cb_trx_type_id NUMBER,
71 pos_write_off_threshold NUMBER,
72 neg_write_off_threshold NUMBER,
73 adj_rec_trx_id NUMBER,
74 wo_rec_trx_id NUMBER,
75 neg_wo_rec_trx_id NUMBER,
76 un_earned_pay_allow_to VARCHAR2(30),
77 un_earned_pay_thold_type VARCHAR2(30),
78 un_earned_pay_threshold NUMBER,
79 un_earned_pay_thold_flag VARCHAR2(1),
80 header_tolerance_calc_code VARCHAR2(30),
81 header_tolerance_operand NUMBER,
82 line_tolerance_calc_code VARCHAR2(30),
83 line_tolerance_operand NUMBER,
84
85 ship_debit_accrual_flag varchar2(1),
86 ship_debit_calc_type varchar2(30),
87 inventory_tracking_flag varchar2(1),
88 end_cust_relation_flag varchar2(1),
89 auto_tp_accrual_flag varchar2(1),
90 gl_balancing_flex_value VARCHAR2(150),
91 prorate_earnings_flag VARCHAR2(1),
92 sales_credit_default_type VARCHAR2(30),
93 net_amt_for_mass_settle_flag VARCHAR2(1),
94
95 claim_tax_incl_flag VARCHAR2(1),
96 --For Rule Based Settlement
97 rule_based VARCHAR2(1),
98 approval_new_credit VARCHAR2(1),
99 approval_matched_credit VARCHAR2(1),
100 cust_name_match_type VARCHAR2(50),
101 credit_matching_thold_type VARCHAR2(50),
102 credit_tolerance_operand NUMBER,
103 -- For Price Protection Parallel Approval ER
104 automate_notification_days NUMBER,
105 -- For SSD Default Adjustment Types
106 ssd_inc_adj_type_id NUMBER,
107 ssd_dec_adj_type_id NUMBER,
108 ssd_imd_claim_flag VARCHAR2(1)
109 );
110
111
112
113 ---------------------------------------------------------------------
114 -- PROCEDURE
115 -- Create_Sys_Parameters
116 --
117 -- PURPOSE
118 -- Create a new record of system parameters.
119 --
120 -- PARAMETERS
121 -- p_sys_parameters_rec: the new record to be inserted
122 -- x_set_of_books_id: return the set_of_books_id of the new system parameters record.
123 --
124 -- NOTES
125 -- 1. object_version_number will be set to 1.
126 -- 2. If set_of_books_id is passed in, the uniqueness will be checked.
127 -- Raise exception in case of duplicates.
128 -- 3. If set_of_books_id is not passed in, get one from org definition.
129 -- 4. If a flag column is passed in, check if it is FND_API.g_true/false.
130 -- Raise exception for invalid flag.
131 -- 5. If a flag column is not passed in, default it to FND_API.g_false.
132 -- 6. Please don't pass in any FND_API.g_mess_char/num/date.
133 ---------------------------------------------------------------------
134 PROCEDURE Create_Sys_Parameters(
135 p_api_version IN NUMBER
136 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
137 ,p_commit IN VARCHAR2 := FND_API.g_false
138 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
139
140 ,x_return_status OUT NOCOPY VARCHAR2
141 ,x_msg_count OUT NOCOPY NUMBER
142 ,x_msg_data OUT NOCOPY VARCHAR2
143
144 ,p_sys_parameters_rec IN sys_parameters_rec_type
145 ,x_set_of_books_id OUT NOCOPY NUMBER
146 );
147
148
149 --------------------------------------------------------------------
150 -- PROCEDURE
151 -- Delete_Sys_Parameters
152 --
153 -- PURPOSE
154 -- Delete a record of system parameters.
155 --
156 -- PARAMETERS
157 -- p_set_of_books_id: the set_of_books_id
158 -- p_object_version: the object_version_number
159 --
160 -- NOTES
161 -- 1. Raise exception if the object_version_number doesn't match.
162 --------------------------------------------------------------------
163 PROCEDURE Delete_Sys_Parameters(
164 p_api_version IN NUMBER
165 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
166 ,p_commit IN VARCHAR2 := FND_API.g_false
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_set_of_books_id IN NUMBER
173 ,p_object_version IN NUMBER
174 );
175
176
177 -------------------------------------------------------------------
178 -- PROCEDURE
179 -- Lock_Sys_Parameters
180 --
181 -- PURPOSE
182 -- Lock a system parameters record.
183 --
184 -- PARAMETERS
185 -- p_set_of_books_id: the set_of_books_id
186 -- p_object_version : the object_version_number
187 --
188 -- NOTES
189 -- 1. Raise exception if the object_version_number doesn't match.
190 --------------------------------------------------------------------
191 PROCEDURE Lock_Sys_Parameters(
192 p_api_version IN NUMBER
193 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
194
195 ,x_return_status OUT NOCOPY VARCHAR2
196 ,x_msg_count OUT NOCOPY NUMBER
197 ,x_msg_data OUT NOCOPY VARCHAR2
198
199 ,p_set_of_books_id IN NUMBER
200 ,p_object_version IN NUMBER
201 );
202
203
204 ---------------------------------------------------------------------
205 -- PROCEDURE
206 -- Update_Sys_Parameters
207 --
208 -- PURPOSE
209 -- Update a system parameters record.
210 --
211 -- PARAMETERS
212 -- p_sys_parameters_rec: the record with new items.
213 -- p_mode : determines what sort of validation is to be performed during update.
214 --
215 -- NOTES
216 -- 1. Raise exception if the object_version_number doesn't match.
217 -- 2. If an attribute is passed in as FND_API.g_miss_char/num/date,
218 -- that column won't be updated.
219 ----------------------------------------------------------------------
220 PROCEDURE Update_Sys_Parameters(
221 p_api_version IN NUMBER
222 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
223 ,p_commit IN VARCHAR2 := FND_API.g_false
224 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
225
226 ,x_return_status OUT NOCOPY VARCHAR2
227 ,x_msg_count OUT NOCOPY NUMBER
228 ,x_msg_data OUT NOCOPY VARCHAR2
229
230 ,p_sys_parameters_rec IN sys_parameters_rec_type
231 ,p_mode IN VARCHAR2 := JTF_PLSQL_API.g_update
232 ,x_object_version_number OUT NOCOPY NUMBER
233 );
234
235
236 ---------------------------------------------------------------------
237 -- PROCEDURE
238 -- Validate_Sys_Parameters
239 --
240 -- PURPOSE
241 -- Validate a fund utilization record.
242 --
243 -- PARAMETERS
244 -- p_sys_parameters: the system parameters record to be validated
245 --
246 -- NOTES
247 -- 1. p_sys_parameters_rec should be a complete record. There
248 -- should not be any FND_API.g_miss_char/num/date in it.
249 ----------------------------------------------------------------------
250 PROCEDURE Validate_Sys_Parameters(
251 p_api_version IN NUMBER
252 ,p_init_msg_list IN VARCHAR2 := FND_API.g_false
253 ,p_validation_level IN NUMBER := FND_API.g_valid_level_full
254
255 ,x_return_status OUT NOCOPY VARCHAR2
256 ,x_msg_count OUT NOCOPY NUMBER
257 ,x_msg_data OUT NOCOPY VARCHAR2
258
259 ,p_sys_parameters_rec IN sys_parameters_rec_type
260 );
261
262
263 ---------------------------------------------------------------------
264 -- PROCEDURE
265 -- Check_Sys_Parameters_Items
266 --
267 -- PURPOSE
268 -- Perform the item level checking including unique keys,
269 -- required columns, foreign keys, domain constraints.
270 --
271 -- PARAMETERS
272 -- p_sys_parameters_rec: the record to be validated
273 -- p_validation_mode: JTF_PLSQL_API.g_create/g_update
274 ---------------------------------------------------------------------
275 PROCEDURE Check_Sys_Parameters_Items(
276 p_sys_parameters_rec IN sys_parameters_rec_type
277 ,p_validation_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
278 ,x_return_status OUT NOCOPY VARCHAR2
279
280 );
281
282
283 ---------------------------------------------------------------------
284 -- PROCEDURE
285 -- Check_Sys_Parameters_Record
286 --
287 -- PURPOSE
288 -- Check the record level business rules.
289 --
290 -- PARAMETERS
291 -- p_sys_parameters_rec: the record to be validated; may contain attributes
292 -- as FND_API.g_miss_char/num/date
293 -- p_complete_rec: the complete record after all "g_miss" items
294 -- have been replaced by current database values
295 ---------------------------------------------------------------------
296 PROCEDURE Check_Sys_Parameters_Record(
297 p_sys_parameters_rec IN sys_parameters_rec_type
298 ,p_complete_rec IN sys_parameters_rec_type := NULL
299 ,p_mode IN VARCHAR2 := JTF_PLSQL_API.g_create
300 ,x_return_status OUT NOCOPY VARCHAR2
301 );
302
303
304 ---------------------------------------------------------------------
305 -- PROCEDURE
306 -- Init_Sys_Parameters_Rec
307 --
308 -- PURPOSE
309 -- Initialize all attributes to be FND_API.g_miss_char/num/date.
310 ---------------------------------------------------------------------
311 PROCEDURE Init_Sys_Parameters_Rec(
312 x_sys_parameters_rec OUT NOCOPY sys_parameters_rec_type
313 );
314
315
316 ---------------------------------------------------------------------
317 -- PROCEDURE
318 -- Complete_Sys_Parameters_Rec
319 --
320 -- PURPOSE
321 -- For update_sys_parameters, some attributes may be passed in as
322 -- FND_API.g_miss_char/num/date if the user doesn't want to
323 -- update those attributes. This procedure will replace the
324 -- "g_miss" attributes with current database values.
325 --
326 -- PARAMETERS
327 -- p_sys_parameters_rec: the record which may contain attributes as
328 -- FND_API.g_miss_char/num/date
329 -- x_complete_rec: the complete record after all "g_miss" items
330 -- have been replaced by current database values
331 ---------------------------------------------------------------------
332 PROCEDURE Complete_Sys_Parameters_Rec(
333 p_sys_parameters_rec IN sys_parameters_rec_type
334 ,x_complete_rec OUT NOCOPY sys_parameters_rec_type
335 );
336
337
338 END OZF_Sys_Parameters_PVT;