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.10 2005/08/16 21:12:27 glchen noship $ */
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 default null) 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'

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

Line 104: from FA_DEPRN_BASIS_RULES

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

Line 155: UPDATE FA_DEPRN_BASIS_RULES

151: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) 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'

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

Line 187: DELETE FROM fa_deprn_basis_rules

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

Line 208: calling_fn => 'fa_deprn_basis_rules_pkg.delete_row'

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

Line 243: from fa_deprn_basis_rules

239: user_id := fnd_load_util.owner_id (X_Owner);
240:
241: select count(*)
242: into h_record_exists
243: from fa_deprn_basis_rules
244: where deprn_basis_rule_id = x_deprn_basis_rule_id;
245:
246: if (h_record_exists > 0) then
247:

Line 250: from fa_deprn_basis_rules

246: if (h_record_exists > 0) then
247:
248: select last_updated_by, last_update_date
249: into db_last_updated_by, db_last_update_date
250: from fa_deprn_basis_rules
251: where deprn_basis_rule_id = x_deprn_basis_rule_id;
252:
253: if (fnd_load_util.upload_test(user_id, x_last_update_date,
254: db_last_updated_by, db_last_update_date,

Line 257: fa_deprn_basis_rules_pkg.update_row (

253: if (fnd_load_util.upload_test(user_id, x_last_update_date,
254: db_last_updated_by, db_last_update_date,
255: X_CUSTOM_MODE)) then
256:
257: fa_deprn_basis_rules_pkg.update_row (
258: X_deprn_basis_rule_id => h_deprn_basis_rule_id,
259: X_rule_name => X_rule_name,
260: X_user_rule_name => X_user_rule_name,
261: X_last_update_date => sysdate,

Line 276: -- FA_DEPRN_BASIS_RULES doesn't match to deprn_basis_rule_id on

272: else
273:
274: -- Bug#2234906
275: -- When Seed data is insereted, deprn_basis_rule_id on
276: -- FA_DEPRN_BASIS_RULES doesn't match to deprn_basis_rule_id on
277: -- FA_METHODS.
278: -- h_deprn_basis_rule_id := null;
279:
280: fa_deprn_basis_rules_pkg.insert_row (

Line 280: fa_deprn_basis_rules_pkg.insert_row (

276: -- FA_DEPRN_BASIS_RULES doesn't match to deprn_basis_rule_id on
277: -- FA_METHODS.
278: -- h_deprn_basis_rule_id := null;
279:
280: fa_deprn_basis_rules_pkg.insert_row (
281: X_deprn_basis_rule_id => h_deprn_basis_rule_id,
282: X_rule_name => X_rule_name,
283: X_user_rule_name => X_user_rule_name,
284: X_last_update_date => sysdate,

Line 301: calling_fn => 'fa_deprn_basis_rules_pkg.load_row'

297: exception
298: when others then
299:
300: fa_srvr_msg.add_sql_error(
301: calling_fn => 'fa_deprn_basis_rules_pkg.load_row'
302: ,p_log_level_rec => p_log_level_rec);
303:
304: end LOAD_ROW;
305:

Line 327: from fa_deprn_basis_rules

323: user_id := fnd_load_util.owner_id (X_Owner);
324:
325: select last_updated_by, last_update_date
326: into db_last_updated_by, db_last_update_date
327: from fa_deprn_basis_rules
328: where deprn_basis_rule_id = x_deprn_basis_rule_id;
329:
330: if (fnd_load_util.upload_test(user_id, x_last_update_date,
331: db_last_updated_by, db_last_update_date,

Line 334: update FA_DEPRN_BASIS_RULES set

330: if (fnd_load_util.upload_test(user_id, x_last_update_date,
331: db_last_updated_by, db_last_update_date,
332: X_CUSTOM_MODE)) then
333:
334: update FA_DEPRN_BASIS_RULES set
335: USER_RULE_NAME =nvl(X_USER_RULE_NAME, USER_RULE_NAME),
336: LAST_UPDATED_BY = user_id,
337: LAST_UPDATE_LOGIN = 0,
338: DESCRIPTION = X_DESCRIPTION

Line 352: calling_fn => 'fa_deprn_basis_rules_pkg.translate_row'

348: EXCEPTION
349: when others then
350:
351: fa_srvr_msg.add_sql_error(
352: calling_fn => 'fa_deprn_basis_rules_pkg.translate_row'
353: ,p_log_level_rec => p_log_level_rec);
354:
355: FA_STANDARD_PKG.RAISE_ERROR(
356: CALLED_FN => 'fa_deprn_basis_rules_pkg.translate_row',

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

352: calling_fn => 'fa_deprn_basis_rules_pkg.translate_row'
353: ,p_log_level_rec => p_log_level_rec);
354:
355: FA_STANDARD_PKG.RAISE_ERROR(
356: CALLED_FN => 'fa_deprn_basis_rules_pkg.translate_row',
357: CALLING_FN => 'upload fa_deprn_basis_rules'
358: ,p_log_level_rec => p_log_level_rec);
359:
360: END TRANSLATE_ROW;

Line 357: CALLING_FN => 'upload fa_deprn_basis_rules'

353: ,p_log_level_rec => p_log_level_rec);
354:
355: FA_STANDARD_PKG.RAISE_ERROR(
356: CALLED_FN => 'fa_deprn_basis_rules_pkg.translate_row',
357: CALLING_FN => 'upload fa_deprn_basis_rules'
358: ,p_log_level_rec => p_log_level_rec);
359:
360: END TRANSLATE_ROW;
361:

Line 378: fa_deprn_basis_rules_pkg.TRANSLATE_ROW (

374:
375: BEGIN
376:
377: if (X_upload_mode = 'NLS') then
378: fa_deprn_basis_rules_pkg.TRANSLATE_ROW (
379: X_custom_mode => X_custom_mode,
380: X_deprn_basis_rule_id => X_deprn_basis_rule_id,
381: X_owner => X_owner,
382: X_last_update_date => X_last_update_date,

Line 386: fa_deprn_basis_rules_pkg.LOAD_ROW (

382: X_last_update_date => X_last_update_date,
383: X_user_rule_name => X_user_rule_name,
384: X_description => X_description);
385: else
386: fa_deprn_basis_rules_pkg.LOAD_ROW (
387: X_custom_mode => X_custom_mode,
388: X_deprn_basis_rule_id => X_deprn_basis_rule_id,
389: X_owner => X_owner,
390: X_last_update_date => X_last_update_date,

Line 400: END FA_DEPRN_BASIS_RULES_PKG;

396: end if;
397:
398: END LOAD_SEED_ROW;
399:
400: END FA_DEPRN_BASIS_RULES_PKG;