[Home] [Help]
1: PACKAGE BODY FA_DEPRN_RULE_DETAILS_PKG as
2: /* $Header: faxtdrdb.pls 120.11.12020000.2 2012/07/19 12:48:24 dvjoshi ship $ */
3:
4: PROCEDURE Insert_Row(
5: p_deprn_rule_detail_id IN OUT NOCOPY NUMBER,
18: p_created_by NUMBER,
19: p_creation_date DATE,
20: p_last_update_login NUMBER
21: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
22: CURSOR C is SELECT FA_DEPRN_RULE_DETAILS_S.nextval from sys.dual;
23:
24: CURSOR C_RULE is
25: select deprn_basis_rule_id
26: from FA_DEPRN_BASIS_RULES
28:
29: CURSOR C_MAX_SEQ
30: is
31: select nvl(max(deprn_rule_detail_id),0)+1
32: from FA_DEPRN_RULE_DETAILS;
33:
34: Begin
35:
36: if (p_deprn_rule_detail_id is null) then
50: FETCH C_RULE INTO p_deprn_basis_rule_id;
51: CLOSE C_RULE;
52: end if;
53:
54: Insert into fa_deprn_rule_details (
55: deprn_rule_detail_id,
56: deprn_basis_rule_id,
57: rule_name,
58: rate_source_rule,
91: exception
92: when others then
93:
94: fa_srvr_msg.add_sql_error(
95: calling_fn => 'fa_deprn_rule_details_pkg.insert_row', p_log_level_rec => p_log_level_rec);
96:
97: END Insert_Row;
98:
99: PROCEDURE Lock_Row (
127: use_rsv_after_imp_flag,
128: last_update_date,
129: last_updated_by,
130: last_update_login
131: from FA_DEPRN_RULE_DETAILS
132: Where rule_name = p_rule_name
133: and rate_source_rule = p_rate_source_rule
134: and deprn_basis_rule = p_deprn_basis_rule
135: for update of deprn_basis_rule_id nowait;
187: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
188:
189: BEGIN
190:
191: UPDATE FA_DEPRN_RULE_DETAILS
192: SET
193: asset_type = p_asset_type,
194: period_update_flag = p_period_update_flag,
195: subtract_ytd_flag = p_subtract_ytd_flag,
207: exception
208: when others then
209:
210: fa_srvr_msg.add_sql_error(
211: calling_fn => 'fa_deprn_rule_details_pkg.update_row', p_log_level_rec => p_log_level_rec);
212:
213: END Update_Row;
214:
215: PROCEDURE Delete_Row(p_deprn_rule_detail_id NUMBER
215: PROCEDURE Delete_Row(p_deprn_rule_detail_id NUMBER
216: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
217: BEGIN
218:
219: DELETE FROM fa_deprn_rule_details
220: WHERE deprn_rule_detail_id = p_deprn_rule_detail_id;
221:
222: if (SQL%NOTFOUND) then
223: Raise NO_DATA_FOUND;
225: exception
226: when others then
227:
228: fa_srvr_msg.add_sql_error(
229: calling_fn => 'fa_deprn_rule_details_pkg.delete_row', p_log_level_rec => p_log_level_rec);
230:
231: END DELETE_ROW;
232:
233: PROCEDURE LOAD_ROW (
259: end if;
260:
261: select count(*)
262: into h_record_exists
263: from fa_deprn_rule_details
264: where rule_name = p_rule_name
265: and rate_source_rule = p_rate_source_rule
266: and deprn_basis_rule = p_deprn_basis_rule;
267:
266: and deprn_basis_rule = p_deprn_basis_rule;
267:
268:
269: if (h_record_exists >0) then
270: fa_deprn_rule_details_pkg.update_row (
271: p_deprn_rule_detail_id => p_deprn_rule_detail_id,
272: p_deprn_basis_rule_id => p_deprn_basis_rule_id,
273: p_rule_name => p_rule_name,
274: p_rate_source_rule => p_rate_source_rule,
288:
289: h_deprn_rule_detail_id := p_deprn_rule_detail_id;
290: h_deprn_basis_rule_id := p_deprn_basis_rule_id;
291:
292: fa_deprn_rule_details_pkg.insert_row (
293: p_deprn_rule_detail_id => h_deprn_rule_detail_id,
294: p_deprn_basis_rule_id => h_deprn_basis_rule_id,
295: p_rule_name => p_rule_name,
296: p_rate_source_rule => p_rate_source_rule,
312: exception
313: when others then
314:
315: fa_srvr_msg.add_sql_error(
316: calling_fn => 'fa_deprn_rule_details_pkg.load_row', p_log_level_rec => p_log_level_rec);
317:
318: end LOAD_ROW;
319: /*Bug 8355119 overloading function for release specific signatures*/
320: PROCEDURE LOAD_ROW (
350: user_id := fnd_load_util.owner_id (p_Owner);
351:
352: select count(*)
353: into h_record_exists
354: from fa_deprn_rule_details
355: where rule_name = p_rule_name
356: and rate_source_rule = p_rate_source_rule
357: and deprn_basis_rule = p_deprn_basis_rule;
358:
359: if (h_record_exists > 0) then
360:
361: select last_updated_by, last_update_date
362: into db_last_updated_by, db_last_update_date
363: from fa_deprn_rule_details
364: where rule_name = p_rule_name
365: and rate_source_rule = p_rate_source_rule
366: and deprn_basis_rule = p_deprn_basis_rule;
367:
368: if (fnd_load_util.upload_test(user_id, p_last_update_date,
369: db_last_updated_by, db_last_update_date,
370: P_CUSTOM_MODE)) then
371:
372: fa_deprn_rule_details_pkg.update_row (
373: p_deprn_rule_detail_id => p_deprn_rule_detail_id,
374: p_deprn_basis_rule_id => p_deprn_basis_rule_id,
375: p_rule_name => p_rule_name,
376: p_rate_source_rule => p_rate_source_rule,
391:
392: h_deprn_rule_detail_id := p_deprn_rule_detail_id;
393: h_deprn_basis_rule_id := p_deprn_basis_rule_id;
394:
395: fa_deprn_rule_details_pkg.insert_row (
396: p_deprn_rule_detail_id => h_deprn_rule_detail_id,
397: p_deprn_basis_rule_id => h_deprn_basis_rule_id,
398: p_rule_name => p_rule_name,
399: p_rate_source_rule => p_rate_source_rule,
415: EXCEPTION
416: when others then
417:
418: fa_srvr_msg.add_sql_error(
419: calling_fn => 'fa_deprn_rule_details_pkg.load_row'
420: ,p_log_level_rec => p_log_level_rec);
421:
422: END LOAD_ROW;
423:
444:
445: if (p_upload_mode = 'NLS') then
446: null;
447: else
448: FA_DEPRN_RULE_DETAILS_PKG.LOAD_ROW (
449: p_custom_mode => p_custom_mode,
450: p_deprn_rule_detail_id => p_deprn_rule_detail_id,
451: p_owner => p_owner,
452: p_last_update_date => p_last_update_date,
464: end if;
465:
466: END LOAD_SEED_ROW;
467:
468: END FA_DEPRN_RULE_DETAILS_PKG;