eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FA_DEPRN_BASIS_RULES_PKG dependencies on FA_DEPRN_BASIS_RULES

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 18: CURSOR C is SELECT FA_DEPRN_BASIS_RULES_S.nextval from sys.dual;

14: X_enabled_flag VARCHAR2,
15: X_program_name VARCHAR2,
16: X_description VARCHAR2
17: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
18: CURSOR C is SELECT FA_DEPRN_BASIS_RULES_S.nextval from sys.dual;
19:
20: CURSOR C_MAX_SEQ
21: is
22: select nvl(max(deprn_basis_rule_id),0)+1

Line 23: from FA_DEPRN_BASIS_RULES;

19:
20: CURSOR C_MAX_SEQ
21: is
22: select nvl(max(deprn_basis_rule_id),0)+1
23: from FA_DEPRN_BASIS_RULES;
24:
25: Begin
26:
27: if (X_deprn_basis_rule_id is null) then

Line 40: Insert into fa_deprn_basis_rules (

36: end if;
37: end if;
38:
39:
40: Insert into fa_deprn_basis_rules (
41: deprn_basis_rule_id,
42: rule_name,
43: user_rule_name,
44: last_update_date,

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 103: from FA_DEPRN_BASIS_RULES

99: deprn_basis,
100: enabled_flag,
101: program_name,
102: description
103: from FA_DEPRN_BASIS_RULES
104: Where DEPRN_BASIS_RULE_ID = x_deprn_basis_rule_id
105: for update of deprn_basis_rule_id nowait;
106:
107: Recinfo C%ROWTYPE;

Line 155: UPDATE FA_DEPRN_BASIS_RULES

151: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) IS
152:
153: BEGIN
154:
155: UPDATE FA_DEPRN_BASIS_RULES
156: SET
157: rule_name = X_rule_name,
158: user_rule_name = X_user_rule_name,
159: last_update_date = X_last_update_date,

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 186: DELETE FROM fa_deprn_basis_rules

182:
183: h_count number;
184:
185: BEGIN
186: DELETE FROM fa_deprn_basis_rules
187: WHERE deprn_basis_rule_id = x_deprn_basis_rule_id;
188:
189: if (SQL%NOTFOUND) then
190: Raise NO_DATA_FOUND;

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 238: from fa_deprn_basis_rules

234: end if;
235:
236: select count(*)
237: into h_record_exists
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 (

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 259: -- When Seed data is insereted, deprn_basis_rule_id on FA_DEPRN_BASIS_RULES

255:
256: else
257:
258: -- Bug#2234906
259: -- When Seed data is insereted, deprn_basis_rule_id on FA_DEPRN_BASIS_RULES
260: -- doesn't match to deprn_basis_rule_id on FA_METHODS.
261:
262: -- h_deprn_basis_rule_id := null;
263:

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 319: from fa_deprn_basis_rules

315: user_id := fnd_load_util.owner_id (X_Owner);
316:
317: select count(*)
318: into h_record_exists
319: from fa_deprn_basis_rules
320: where deprn_basis_rule_id = x_deprn_basis_rule_id;
321:
322: if (h_record_exists > 0) then
323:

Line 326: from fa_deprn_basis_rules

322: if (h_record_exists > 0) then
323:
324: select last_updated_by, last_update_date
325: into db_last_updated_by, db_last_update_date
326: from fa_deprn_basis_rules
327: where deprn_basis_rule_id = x_deprn_basis_rule_id;
328:
329: if (fnd_load_util.upload_test(user_id, x_last_update_date,
330: db_last_updated_by, db_last_update_date,

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 352: -- FA_DEPRN_BASIS_RULES doesn't match to deprn_basis_rule_id on

348: else
349:
350: -- Bug#2234906
351: -- When Seed data is insereted, deprn_basis_rule_id on
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 (

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 400: update FA_DEPRN_BASIS_RULES set

396: else
397: user_id :=0;
398: end if;
399:
400: update FA_DEPRN_BASIS_RULES set
401: USER_RULE_NAME=nvl(X_USER_RULE_NAME, USER_RULE_NAME),
402: LAST_UPDATED_BY = user_id,
403: LAST_UPDATE_LOGIN =0,
404: DESCRIPTION = X_DESCRIPTION

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 420: CALLING_FN => 'upload fa_deprn_basis_rules', p_log_level_rec => p_log_level_rec);

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*/
424: procedure TRANSLATE_ROW (

Line 445: from fa_deprn_basis_rules

441: user_id := fnd_load_util.owner_id (X_Owner);
442:
443: select last_updated_by, last_update_date
444: into db_last_updated_by, db_last_update_date
445: from fa_deprn_basis_rules
446: where deprn_basis_rule_id = x_deprn_basis_rule_id;
447:
448: if (fnd_load_util.upload_test(user_id, x_last_update_date,
449: db_last_updated_by, db_last_update_date,

Line 452: update FA_DEPRN_BASIS_RULES set

448: if (fnd_load_util.upload_test(user_id, x_last_update_date,
449: db_last_updated_by, db_last_update_date,
450: X_CUSTOM_MODE)) then
451:
452: update FA_DEPRN_BASIS_RULES set
453: USER_RULE_NAME =nvl(X_USER_RULE_NAME, USER_RULE_NAME),
454: LAST_UPDATED_BY = user_id,
455: LAST_UPDATE_LOGIN = 0,
456: DESCRIPTION = X_DESCRIPTION

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 475: CALLING_FN => 'upload fa_deprn_basis_rules'

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;
479: /*bug 8355119 adding R12 specific funtion LOAD_SEED_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;