DBA Data[Home] [Help]

APPS.FA_DEPRN_BASIS_RULES_PKG dependencies on FA_DEPRN_BASIS_RULES_PKG

Line 1: PACKAGE BODY FA_DEPRN_BASIS_RULES_PKG as

1: PACKAGE BODY FA_DEPRN_BASIS_RULES_PKG as
2: /* $Header: faxtdbrb.pls 120.15.12020000.2 2012/07/19 12:43:29 dvjoshi ship $ */
3:
4: PROCEDURE Insert_Row( X_deprn_basis_rule_id IN OUT NOCOPY NUMBER,
5: X_rule_name VARCHAR2,

Line 75: calling_fn => 'fa_deprn_basis_rules_pkg.insert_row', p_log_level_rec => p_log_level_rec);

71: exception
72: when others then
73:
74: fa_srvr_msg.add_sql_error(
75: calling_fn => 'fa_deprn_basis_rules_pkg.insert_row', p_log_level_rec => p_log_level_rec);
76:
77: END Insert_Row;
78:
79: PROCEDURE Lock_Row ( X_deprn_basis_rule_id NUMBER,

Line 176: calling_fn => 'fa_deprn_basis_rules_pkg.update_row', p_log_level_rec => p_log_level_rec);

172: exception
173: when others then
174:
175: fa_srvr_msg.add_sql_error(
176: calling_fn => 'fa_deprn_basis_rules_pkg.update_row', p_log_level_rec => p_log_level_rec);
177:
178: END Update_Row;
179:
180: PROCEDURE Delete_Row(X_deprn_basis_rule_id NUMBER

Line 207: calling_fn => 'fa_deprn_basis_rules_pkg.delete_row', p_log_level_rec => p_log_level_rec);

203: exception
204: when others then
205:
206: fa_srvr_msg.add_sql_error(
207: calling_fn => 'fa_deprn_basis_rules_pkg.delete_row', p_log_level_rec => p_log_level_rec);
208:
209: END DELETE_ROW;
210:
211: PROCEDURE LOAD_ROW ( X_deprn_basis_rule_id NUMBER,

Line 242: fa_deprn_basis_rules_pkg.update_row (

238: from fa_deprn_basis_rules
239: where deprn_basis_rule_id = x_deprn_basis_rule_id;
240:
241: if (h_record_exists >0) then
242: fa_deprn_basis_rules_pkg.update_row (
243: X_deprn_basis_rule_id => h_deprn_basis_rule_id,
244: X_rule_name => X_rule_name,
245: X_user_rule_name => X_user_rule_name,
246: X_last_update_date => sysdate,

Line 264: fa_deprn_basis_rules_pkg.insert_row (

260: -- doesn't match to deprn_basis_rule_id on FA_METHODS.
261:
262: -- h_deprn_basis_rule_id := null;
263:
264: fa_deprn_basis_rules_pkg.insert_row (
265: X_deprn_basis_rule_id => h_deprn_basis_rule_id,
266: X_rule_name => X_rule_name,
267: X_user_rule_name => X_user_rule_name,
268: X_last_update_date => sysdate,

Line 285: calling_fn => 'fa_deprn_basis_rules_pkg.load_row', p_log_level_rec => p_log_level_rec);

281: exception
282: when others then
283:
284: fa_srvr_msg.add_sql_error(
285: calling_fn => 'fa_deprn_basis_rules_pkg.load_row', p_log_level_rec => p_log_level_rec);
286:
287: end LOAD_ROW;
288: /*Bug 8355119 overloading function for release specific signatures*/
289: PROCEDURE LOAD_ROW (X_custom_mode IN VARCHAR2,

Line 333: fa_deprn_basis_rules_pkg.update_row (

329: if (fnd_load_util.upload_test(user_id, x_last_update_date,
330: db_last_updated_by, db_last_update_date,
331: X_CUSTOM_MODE)) then
332:
333: fa_deprn_basis_rules_pkg.update_row (
334: X_deprn_basis_rule_id => h_deprn_basis_rule_id,
335: X_rule_name => X_rule_name,
336: X_user_rule_name => X_user_rule_name,
337: X_last_update_date => sysdate,

Line 356: fa_deprn_basis_rules_pkg.insert_row (

352: -- FA_DEPRN_BASIS_RULES doesn't match to deprn_basis_rule_id on
353: -- FA_METHODS.
354: -- h_deprn_basis_rule_id := null;
355:
356: fa_deprn_basis_rules_pkg.insert_row (
357: X_deprn_basis_rule_id => h_deprn_basis_rule_id,
358: X_rule_name => X_rule_name,
359: X_user_rule_name => X_user_rule_name,
360: X_last_update_date => sysdate,

Line 377: calling_fn => 'fa_deprn_basis_rules_pkg.load_row'

373: exception
374: when others then
375:
376: fa_srvr_msg.add_sql_error(
377: calling_fn => 'fa_deprn_basis_rules_pkg.load_row'
378: ,p_log_level_rec => p_log_level_rec);
379:
380: end LOAD_ROW;
381:

Line 416: calling_fn => 'fa_deprn_basis_rules_pkg.translate_row', p_log_level_rec => p_log_level_rec);

412: exception
413: when others then
414:
415: fa_srvr_msg.add_sql_error(
416: calling_fn => 'fa_deprn_basis_rules_pkg.translate_row', p_log_level_rec => p_log_level_rec);
417:
418: FA_STANDARD_PKG.RAISE_ERROR(
419: CALLED_FN => 'fa_deprn_basis_rules_pkg.translate_row',
420: CALLING_FN => 'upload fa_deprn_basis_rules', p_log_level_rec => p_log_level_rec);

Line 419: CALLED_FN => 'fa_deprn_basis_rules_pkg.translate_row',

415: fa_srvr_msg.add_sql_error(
416: calling_fn => 'fa_deprn_basis_rules_pkg.translate_row', p_log_level_rec => p_log_level_rec);
417:
418: FA_STANDARD_PKG.RAISE_ERROR(
419: CALLED_FN => 'fa_deprn_basis_rules_pkg.translate_row',
420: CALLING_FN => 'upload fa_deprn_basis_rules', p_log_level_rec => p_log_level_rec);
421:
422: end TRANSLATE_ROW;
423: /*Bug 8355119 overloading function for release specific signatures*/

Line 470: calling_fn => 'fa_deprn_basis_rules_pkg.translate_row'

466: EXCEPTION
467: when others then
468:
469: fa_srvr_msg.add_sql_error(
470: calling_fn => 'fa_deprn_basis_rules_pkg.translate_row'
471: ,p_log_level_rec => p_log_level_rec);
472:
473: FA_STANDARD_PKG.RAISE_ERROR(
474: CALLED_FN => 'fa_deprn_basis_rules_pkg.translate_row',

Line 474: CALLED_FN => 'fa_deprn_basis_rules_pkg.translate_row',

470: calling_fn => 'fa_deprn_basis_rules_pkg.translate_row'
471: ,p_log_level_rec => p_log_level_rec);
472:
473: FA_STANDARD_PKG.RAISE_ERROR(
474: CALLED_FN => 'fa_deprn_basis_rules_pkg.translate_row',
475: CALLING_FN => 'upload fa_deprn_basis_rules'
476: ,p_log_level_rec => p_log_level_rec);
477:
478: END TRANSLATE_ROW;

Line 496: fa_deprn_basis_rules_pkg.TRANSLATE_ROW (

492:
493: BEGIN
494:
495: if (X_upload_mode = 'NLS') then
496: fa_deprn_basis_rules_pkg.TRANSLATE_ROW (
497: X_custom_mode => X_custom_mode,
498: X_deprn_basis_rule_id => X_deprn_basis_rule_id,
499: X_owner => X_owner,
500: X_last_update_date => X_last_update_date,

Line 504: fa_deprn_basis_rules_pkg.LOAD_ROW (

500: X_last_update_date => X_last_update_date,
501: X_user_rule_name => X_user_rule_name,
502: X_description => X_description);
503: else
504: fa_deprn_basis_rules_pkg.LOAD_ROW (
505: X_custom_mode => X_custom_mode,
506: X_deprn_basis_rule_id => X_deprn_basis_rule_id,
507: X_owner => X_owner,
508: X_last_update_date => X_last_update_date,

Line 518: END FA_DEPRN_BASIS_RULES_PKG;

514: end if;
515:
516: END LOAD_SEED_ROW;
517:
518: END FA_DEPRN_BASIS_RULES_PKG;