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_RULE_DETAILS_PKG dependencies on FA_DEPRN_RULE_DETAILS

Line 1: PACKAGE BODY FA_DEPRN_RULE_DETAILS_PKG as

1: PACKAGE BODY FA_DEPRN_RULE_DETAILS_PKG as
2: /* $Header: faxtdrdb.pls 120.7 2005/07/28 00:20:56 tkawamur noship $ */
3:
4: PROCEDURE Insert_Row(
5: p_deprn_rule_detail_id IN OUT NOCOPY NUMBER,

Line 21: CURSOR C is SELECT FA_DEPRN_RULE_DETAILS_S.nextval from sys.dual;

17: p_created_by NUMBER,
18: p_creation_date DATE,
19: p_last_update_login NUMBER,
20: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
21: CURSOR C is SELECT FA_DEPRN_RULE_DETAILS_S.nextval from sys.dual;
22:
23: CURSOR C_RULE is
24: select deprn_basis_rule_id
25: from FA_DEPRN_BASIS_RULES

Line 31: from FA_DEPRN_RULE_DETAILS;

27:
28: CURSOR C_MAX_SEQ
29: is
30: select nvl(max(deprn_rule_detail_id),0)+1
31: from FA_DEPRN_RULE_DETAILS;
32:
33: Begin
34:
35: if (p_deprn_rule_detail_id is null) then

Line 53: Insert into fa_deprn_rule_details (

49: FETCH C_RULE INTO p_deprn_basis_rule_id;
50: CLOSE C_RULE;
51: end if;
52:
53: Insert into fa_deprn_rule_details (
54: deprn_rule_detail_id,
55: deprn_basis_rule_id,
56: rule_name,
57: rate_source_rule,

Line 92: calling_fn => 'fa_deprn_rule_details_pkg.insert_row'

88: exception
89: when others then
90:
91: fa_srvr_msg.add_sql_error(
92: calling_fn => 'fa_deprn_rule_details_pkg.insert_row'
93: ,p_log_level_rec => p_log_level_rec);
94:
95: END Insert_Row;
96:

Line 126: from FA_DEPRN_RULE_DETAILS

122: use_eofy_reserve_flag,
123: last_update_date,
124: last_updated_by,
125: last_update_login
126: from FA_DEPRN_RULE_DETAILS
127: Where rule_name = p_rule_name
128: and rate_source_rule = p_rate_source_rule
129: and deprn_basis_rule = p_deprn_basis_rule
130: for update of deprn_basis_rule_id nowait;

Line 183: UPDATE FA_DEPRN_RULE_DETAILS

179: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
180:
181: BEGIN
182:
183: UPDATE FA_DEPRN_RULE_DETAILS
184: SET
185: asset_type = p_asset_type,
186: period_update_flag = p_period_update_flag,
187: subtract_ytd_flag = p_subtract_ytd_flag,

Line 202: calling_fn => 'fa_deprn_rule_details_pkg.update_row'

198: exception
199: when others then
200:
201: fa_srvr_msg.add_sql_error(
202: calling_fn => 'fa_deprn_rule_details_pkg.update_row'
203: ,p_log_level_rec => p_log_level_rec);
204:
205: END Update_Row;
206:

Line 211: DELETE FROM fa_deprn_rule_details

207: PROCEDURE Delete_Row(p_deprn_rule_detail_id NUMBER,
208: p_log_level_rec IN FA_API_TYPES.log_level_rec_type default null) IS
209: BEGIN
210:
211: DELETE FROM fa_deprn_rule_details
212: WHERE deprn_rule_detail_id = p_deprn_rule_detail_id;
213:
214: if (SQL%NOTFOUND) then
215: Raise NO_DATA_FOUND;

Line 221: calling_fn => 'fa_deprn_rule_details_pkg.delete_row'

217: exception
218: when others then
219:
220: fa_srvr_msg.add_sql_error(
221: calling_fn => 'fa_deprn_rule_details_pkg.delete_row'
222: ,p_log_level_rec => p_log_level_rec);
223:
224: END DELETE_ROW;
225:

Line 259: from fa_deprn_rule_details

255: user_id := fnd_load_util.owner_id (p_Owner);
256:
257: select count(*)
258: into h_record_exists
259: from fa_deprn_rule_details
260: where rule_name = p_rule_name
261: and rate_source_rule = p_rate_source_rule
262: and deprn_basis_rule = p_deprn_basis_rule;
263:

Line 268: from fa_deprn_rule_details

264: if (h_record_exists > 0) then
265:
266: select last_updated_by, last_update_date
267: into db_last_updated_by, db_last_update_date
268: from fa_deprn_rule_details
269: where rule_name = p_rule_name
270: and rate_source_rule = p_rate_source_rule
271: and deprn_basis_rule = p_deprn_basis_rule;
272:

Line 277: fa_deprn_rule_details_pkg.update_row (

273: if (fnd_load_util.upload_test(user_id, p_last_update_date,
274: db_last_updated_by, db_last_update_date,
275: P_CUSTOM_MODE)) then
276:
277: fa_deprn_rule_details_pkg.update_row (
278: p_deprn_rule_detail_id => p_deprn_rule_detail_id,
279: p_deprn_basis_rule_id => p_deprn_basis_rule_id,
280: p_rule_name => p_rule_name,
281: p_rate_source_rule => p_rate_source_rule,

Line 299: fa_deprn_rule_details_pkg.insert_row (

295:
296: h_deprn_rule_detail_id := p_deprn_rule_detail_id;
297: h_deprn_basis_rule_id := p_deprn_basis_rule_id;
298:
299: fa_deprn_rule_details_pkg.insert_row (
300: p_deprn_rule_detail_id => h_deprn_rule_detail_id,
301: p_deprn_basis_rule_id => h_deprn_basis_rule_id,
302: p_rule_name => p_rule_name,
303: p_rate_source_rule => p_rate_source_rule,

Line 322: calling_fn => 'fa_deprn_rule_details_pkg.load_row'

318: EXCEPTION
319: when others then
320:
321: fa_srvr_msg.add_sql_error(
322: calling_fn => 'fa_deprn_rule_details_pkg.load_row'
323: ,p_log_level_rec => p_log_level_rec);
324:
325: END LOAD_ROW;
326:

Line 350: FA_DEPRN_RULE_DETAILS_PKG.LOAD_ROW (

346:
347: if (p_upload_mode = 'NLS') then
348: null;
349: else
350: FA_DEPRN_RULE_DETAILS_PKG.LOAD_ROW (
351: p_custom_mode => p_custom_mode,
352: p_deprn_rule_detail_id => p_deprn_rule_detail_id,
353: p_owner => p_owner,
354: p_last_update_date => p_last_update_date,

Line 369: END FA_DEPRN_RULE_DETAILS_PKG;

365: end if;
366:
367: END LOAD_SEED_ROW;
368:
369: END FA_DEPRN_RULE_DETAILS_PKG;