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_BONUS_RATES_PKG dependencies on FA_BONUS_RATES

Line 1: PACKAGE BODY FA_BONUS_RATES_PKG as

1: PACKAGE BODY FA_BONUS_RATES_PKG as
2: /* $Header: faxiborb.pls 120.10 2011/03/11 02:16:41 saalampa ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 33: CURSOR C is SELECT rowid FROM fa_bonus_rates

29: X_LAST_UPDATED_BY in NUMBER,
30: X_LAST_UPDATE_LOGIN in NUMBER
31: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
32:
33: CURSOR C is SELECT rowid FROM fa_bonus_rates
34: where bonus_rule = X_Bonus_Rule
35: and start_year = X_Start_Year;
36:
37: begin

Line 38: ad_zd_seed.prepare('fa_bonus_rates');

34: where bonus_rule = X_Bonus_Rule
35: and start_year = X_Start_Year;
36:
37: begin
38: ad_zd_seed.prepare('fa_bonus_rates');
39: INSERT INTO fa_bonus_rates (
40: bonus_rule,
41: start_year,
42: end_year,

Line 39: INSERT INTO fa_bonus_rates (

35: and start_year = X_Start_Year;
36:
37: begin
38: ad_zd_seed.prepare('fa_bonus_rates');
39: INSERT INTO fa_bonus_rates (
40: bonus_rule,
41: start_year,
42: end_year,
43: bonus_rate,

Line 104: calling_fn => 'fa_bonus_rates_pkg.insert_row', p_log_level_rec => p_log_level_rec);

100:
101: exception
102: when others then
103: fa_srvr_msg.add_sql_error(
104: calling_fn => 'fa_bonus_rates_pkg.insert_row', p_log_level_rec => p_log_level_rec);
105: raise;
106:
107: end INSERT_ROW;
108:

Line 152: FROM fa_bonus_rates

148: attribute13,
149: attribute14,
150: attribute15,
151: attribute_category_code
152: FROM fa_bonus_rates
153: where bonus_rule = X_Bonus_Rule
154: and start_year = X_Start_Year
155: FOR UPDATE of bonus_rule, start_year NOWAIT;
156: Recinfo C%ROWTYPE;

Line 257: ad_zd_seed.prepare('fa_bonus_rates');

253: X_LAST_UPDATE_LOGIN in NUMBER
254: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
255:
256: begin
257: ad_zd_seed.prepare('fa_bonus_rates');
258: UPDATE fa_bonus_rates
259: SET bonus_rule = X_Bonus_Rule,
260: start_year = X_Start_Year,
261: end_year = X_End_Year,

Line 258: UPDATE fa_bonus_rates

254: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
255:
256: begin
257: ad_zd_seed.prepare('fa_bonus_rates');
258: UPDATE fa_bonus_rates
259: SET bonus_rule = X_Bonus_Rule,
260: start_year = X_Start_Year,
261: end_year = X_End_Year,
262: bonus_rate = X_Bonus_Rate,

Line 291: calling_fn => 'fa_bonus_rates_pkg.update_row', p_log_level_rec => p_log_level_rec);

287:
288: exception
289: when others then
290: fa_srvr_msg.add_sql_error(
291: calling_fn => 'fa_bonus_rates_pkg.update_row', p_log_level_rec => p_log_level_rec);
292: raise;
293:
294: end UPDATE_ROW;
295:

Line 302: ad_zd_seed.prepare('fa_bonus_rates');

298: X_START_YEAR in NUMBER
299: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
300:
301: begin
302: ad_zd_seed.prepare('fa_bonus_rates');
303: DELETE FROM fa_bonus_rates
304: where bonus_rule = X_Bonus_Rule
305: and start_year = X_Start_Year;
306:

Line 303: DELETE FROM fa_bonus_rates

299: , p_log_level_rec IN FA_API_TYPES.log_level_rec_type) is
300:
301: begin
302: ad_zd_seed.prepare('fa_bonus_rates');
303: DELETE FROM fa_bonus_rates
304: where bonus_rule = X_Bonus_Rule
305: and start_year = X_Start_Year;
306:
307: if (SQL%NOTFOUND) then

Line 314: calling_fn => 'fa_bonus_rates_pkg.delete_row', p_log_level_rec => p_log_level_rec);

310:
311: exception
312: when others then
313: fa_srvr_msg.add_sql_error(
314: calling_fn => 'fa_bonus_rates_pkg.delete_row', p_log_level_rec => p_log_level_rec);
315: raise;
316:
317: end DELETE_ROW;
318:

Line 359: from fa_bonus_rates

355: end if;
356:
357: select count(*)
358: into h_record_exists
359: from fa_bonus_rates
360: where bonus_rule = X_Bonus_Rule
361: and start_year = X_Start_Year;
362:
363: if (h_record_exists > 0) then

Line 364: fa_bonus_rates_pkg.update_row (

360: where bonus_rule = X_Bonus_Rule
361: and start_year = X_Start_Year;
362:
363: if (h_record_exists > 0) then
364: fa_bonus_rates_pkg.update_row (
365: X_Bonus_Rule => X_Bonus_Rule,
366: X_Start_Year => X_Start_Year,
367: X_End_Year => X_End_Year,
368: X_Bonus_Rate => X_Bonus_Rate,

Line 390: fa_bonus_rates_pkg.insert_row (

386: X_Last_Updated_By => user_id,
387: X_Last_Update_Login => 0
388: , p_log_level_rec => p_log_level_rec);
389: else
390: fa_bonus_rates_pkg.insert_row (
391: X_Rowid => row_id,
392: X_Bonus_Rule => X_Bonus_Rule,
393: X_Start_Year => X_Start_Year,
394: X_End_Year => X_End_Year,

Line 423: CALLED_FN => 'fa_bonus_rates_pkg.load_row',

419:
420: exception
421: when others then
422: FA_STANDARD_PKG.RAISE_ERROR(
423: CALLED_FN => 'fa_bonus_rates_pkg.load_row',
424: CALLING_FN => 'upload fa_bonus_rates', p_log_level_rec => p_log_level_rec);
425:
426: end LOAD_ROW;
427:

Line 424: CALLING_FN => 'upload fa_bonus_rates', p_log_level_rec => p_log_level_rec);

420: exception
421: when others then
422: FA_STANDARD_PKG.RAISE_ERROR(
423: CALLED_FN => 'fa_bonus_rates_pkg.load_row',
424: CALLING_FN => 'upload fa_bonus_rates', p_log_level_rec => p_log_level_rec);
425:
426: end LOAD_ROW;
427:
428: /*Bug 8355119 overloading function for release specific signatures*/

Line 469: from fa_bonus_rates

465: user_id := fnd_load_util.owner_id (X_Owner);
466:
467: select count(*)
468: into h_record_exists
469: from fa_bonus_rates
470: where bonus_rule = X_Bonus_Rule
471: and start_year = X_Start_Year;
472:
473: if (h_record_exists > 0) then

Line 477: from fa_bonus_rates

473: if (h_record_exists > 0) then
474:
475: select last_updated_by, last_update_date
476: into db_last_updated_by, db_last_update_date
477: from fa_bonus_rates
478: where bonus_rule = X_Bonus_Rule
479: and start_year = X_Start_Year;
480:
481: if (fnd_load_util.upload_test(user_id, x_last_update_date,

Line 485: fa_bonus_rates_pkg.update_row (

481: if (fnd_load_util.upload_test(user_id, x_last_update_date,
482: db_last_updated_by, db_last_update_date,
483: X_CUSTOM_MODE)) then
484:
485: fa_bonus_rates_pkg.update_row (
486: X_Bonus_Rule => X_Bonus_Rule,
487: X_Start_Year => X_Start_Year,
488: X_End_Year => X_End_Year,
489: X_Bonus_Rate => X_Bonus_Rate,

Line 513: fa_bonus_rates_pkg.insert_row (

509: ,p_log_level_rec => p_log_level_rec);
510: end if ;
511: else
512:
513: fa_bonus_rates_pkg.insert_row (
514: X_Rowid => row_id,
515: X_Bonus_Rule => X_Bonus_Rule,
516: X_Start_Year => X_Start_Year,
517: X_End_Year => X_End_Year,

Line 546: CALLED_FN => 'fa_bonus_rates_pkg.load_row',

542:
543: exception
544: when others then
545: FA_STANDARD_PKG.RAISE_ERROR(
546: CALLED_FN => 'fa_bonus_rates_pkg.load_row',
547: CALLING_FN => 'upload fa_bonus_rates'
548: ,p_log_level_rec => p_log_level_rec);
549:
550: end LOAD_ROW;

Line 547: CALLING_FN => 'upload fa_bonus_rates'

543: exception
544: when others then
545: FA_STANDARD_PKG.RAISE_ERROR(
546: CALLED_FN => 'fa_bonus_rates_pkg.load_row',
547: CALLING_FN => 'upload fa_bonus_rates'
548: ,p_log_level_rec => p_log_level_rec);
549:
550: end LOAD_ROW;
551:

Line 584: fa_bonus_rates_pkg.LOAD_ROW (

580:
581: if (x_upload_mode = 'NLS') then
582: null;
583: else
584: fa_bonus_rates_pkg.LOAD_ROW (
585: x_custom_mode => x_custom_mode,
586: x_bonus_rule => x_bonus_rule,
587: x_owner => x_owner,
588: x_last_update_date => x_last_update_date,

Line 613: END FA_BONUS_RATES_PKG;

609: end if;
610:
611: END LOAD_SEED_ROW;
612:
613: END FA_BONUS_RATES_PKG;