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.6 2005/07/28 00:20:51 tkawamur 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 default null) 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 39: INSERT INTO fa_bonus_rates (

35: and start_year = X_Start_Year;
36:
37: begin
38:
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'

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

Line 153: FROM fa_bonus_rates

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

Line 257: UPDATE fa_bonus_rates

253: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
254:
255: begin
256:
257: UPDATE fa_bonus_rates
258: SET bonus_rule = X_Bonus_Rule,
259: start_year = X_Start_Year,
260: end_year = X_End_Year,
261: bonus_rate = X_Bonus_Rate,

Line 290: calling_fn => 'fa_bonus_rates_pkg.update_row'

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

Line 303: DELETE FROM fa_bonus_rates

299: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
300:
301: begin
302:
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'

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

Line 361: from fa_bonus_rates

357: user_id := fnd_load_util.owner_id (X_Owner);
358:
359: select count(*)
360: into h_record_exists
361: from fa_bonus_rates
362: where bonus_rule = X_Bonus_Rule
363: and start_year = X_Start_Year;
364:
365: if (h_record_exists > 0) then

Line 369: from fa_bonus_rates

365: if (h_record_exists > 0) then
366:
367: select last_updated_by, last_update_date
368: into db_last_updated_by, db_last_update_date
369: from fa_bonus_rates
370: where bonus_rule = X_Bonus_Rule
371: and start_year = X_Start_Year;
372:
373: if (fnd_load_util.upload_test(user_id, x_last_update_date,

Line 377: fa_bonus_rates_pkg.update_row (

373: if (fnd_load_util.upload_test(user_id, x_last_update_date,
374: db_last_updated_by, db_last_update_date,
375: X_CUSTOM_MODE)) then
376:
377: fa_bonus_rates_pkg.update_row (
378: X_Bonus_Rule => X_Bonus_Rule,
379: X_Start_Year => X_Start_Year,
380: X_End_Year => X_End_Year,
381: X_Bonus_Rate => X_Bonus_Rate,

Line 405: fa_bonus_rates_pkg.insert_row (

401: ,p_log_level_rec => p_log_level_rec);
402: end if ;
403: else
404:
405: fa_bonus_rates_pkg.insert_row (
406: X_Rowid => row_id,
407: X_Bonus_Rule => X_Bonus_Rule,
408: X_Start_Year => X_Start_Year,
409: X_End_Year => X_End_Year,

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

434:
435: exception
436: when others then
437: FA_STANDARD_PKG.RAISE_ERROR(
438: CALLED_FN => 'fa_bonus_rates_pkg.load_row',
439: CALLING_FN => 'upload fa_bonus_rates'
440: ,p_log_level_rec => p_log_level_rec);
441:
442: end LOAD_ROW;

Line 439: CALLING_FN => 'upload fa_bonus_rates'

435: exception
436: when others then
437: FA_STANDARD_PKG.RAISE_ERROR(
438: CALLED_FN => 'fa_bonus_rates_pkg.load_row',
439: CALLING_FN => 'upload fa_bonus_rates'
440: ,p_log_level_rec => p_log_level_rec);
441:
442: end LOAD_ROW;
443:

Line 475: fa_bonus_rates_pkg.LOAD_ROW (

471:
472: if (x_upload_mode = 'NLS') then
473: null;
474: else
475: fa_bonus_rates_pkg.LOAD_ROW (
476: x_custom_mode => x_custom_mode,
477: x_bonus_rule => x_bonus_rule,
478: x_owner => x_owner,
479: x_last_update_date => x_last_update_date,

Line 504: END FA_BONUS_RATES_PKG;

500: end if;
501:
502: END LOAD_SEED_ROW;
503:
504: END FA_BONUS_RATES_PKG;