APPS.FA_ITC_RATES_PKG dependencies on FA_ITC_RATES

Line 1: PACKAGE BODY FA_ITC_RATES_PKG as

1: PACKAGE BODY FA_ITC_RATES_PKG as
2: /* $Header: faxiitcb.pls 120.6 2005/07/28 00:20:26 tkawamur ship $ */
3:
4: procedure INSERT_ROW (
5: X_ROWID in out nocopy VARCHAR2,

Line 34: CURSOR C is SELECT rowid FROM fa_itc_rates

30: X_LAST_UPDATED_BY in NUMBER,
31: X_LAST_UPDATE_LOGIN in NUMBER,
32: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
33:
34: CURSOR C is SELECT rowid FROM fa_itc_rates
35: WHERE itc_amount_id = X_Itc_Amount_Id;
36:
37: begin
38:

Line 39: INSERT INTO fa_itc_rates (

35: WHERE itc_amount_id = X_Itc_Amount_Id;
36:
37: begin
38:
39: INSERT INTO fa_itc_rates (
40: itc_amount_id,
41: tax_year,
42: life_in_months,
43: itc_amount_rate,

Line 106: calling_fn => 'fa_itc_rates_pkg.insert_row'

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

Line 157: FROM fa_itc_rates

153: attribute13,
154: attribute14,
155: attribute15,
156: attribute_category_code
157: FROM fa_itc_rates
158: WHERE itc_amount_id = X_Itc_Amount_Id
159: FOR UPDATE of itc_amount_id NOWAIT;
160: Recinfo C%ROWTYPE;
161:

Line 262: UPDATE fa_itc_rates

258: p_log_level_rec in fa_api_types.log_level_rec_type default null) is
259:
260: begin
261:
262: UPDATE fa_itc_rates
263: SET itc_amount_id = X_Itc_Amount_Id,
264: tax_year = X_Tax_Year,
265: life_in_months = X_Life_In_Months,
266: itc_amount_rate = X_Itc_Amount_Rate,

Line 296: calling_fn => 'fa_itc_rates_pkg.update_row'

292:
293: exception
294: when others then
295: fa_srvr_msg.add_sql_error(
296: calling_fn => 'fa_itc_rates_pkg.update_row'
297: ,p_log_level_rec => p_log_level_rec);
298: raise;
299:
300: end UPDATE_ROW;

Line 308: DELETE FROM fa_itc_rates

304: ,p_log_level_rec in fa_api_types.log_level_rec_type default null) is
305:
306: begin
307:
308: DELETE FROM fa_itc_rates
309: WHERE itc_amount_id = X_Itc_Amount_Id;
310:
311: if (SQL%NOTFOUND) then
312: Raise NO_DATA_FOUND;

Line 318: calling_fn => 'fa_itc_rates_pkg.delete_row'

314:
315: exception
316: when others then
317: fa_srvr_msg.add_sql_error(
318: calling_fn => 'fa_itc_rates_pkg.delete_row'
319: ,p_log_level_rec => p_log_level_rec);
320: raise;
321:
322: end DELETE_ROW;

Line 365: from fa_itc_rates

361: user_id := fnd_load_util.owner_id (X_Owner);
362:
363: select count(*)
364: into h_record_exists
365: from fa_itc_rates
366: where itc_amount_id = X_Itc_Amount_Id;
367:
368: if (h_record_exists > 0) then
369:

Line 372: from fa_itc_rates

368: if (h_record_exists > 0) then
369:
370: select last_updated_by, last_update_date
371: into db_last_updated_by, db_last_update_date
372: from fa_itc_rates
373: where itc_amount_id = X_Itc_Amount_Id;
374:
375: if (fnd_load_util.upload_test(user_id, x_last_update_date,
376: db_last_updated_by, db_last_update_date,

Line 379: fa_itc_rates_pkg.update_row (

375: if (fnd_load_util.upload_test(user_id, x_last_update_date,
376: db_last_updated_by, db_last_update_date,
377: X_CUSTOM_MODE)) then
378:
379: fa_itc_rates_pkg.update_row (
380: X_Itc_Amount_Id => X_Itc_Amount_Id,
381: X_Tax_Year => X_Tax_Year,
382: X_Life_In_Months => X_Life_In_Months,
383: X_Itc_Amount_Rate => X_Itc_Amount_Rate,

Line 407: fa_itc_rates_pkg.insert_row (

403: X_Last_Update_Login => 0
404: ,p_log_level_rec => p_log_level_rec);
405: end if;
406: else
407: fa_itc_rates_pkg.insert_row (
408: X_Rowid => row_id,
409: X_Itc_Amount_Id => X_Itc_Amount_Id,
410: X_Tax_Year => X_Tax_Year,
411: X_Life_In_Months => X_Life_In_Months,

Line 441: CALLED_FN => 'fa_itc_rates_pkg.load_row',

437:
438: exception
439: when others then
440: FA_STANDARD_PKG.RAISE_ERROR(
441: CALLED_FN => 'fa_itc_rates_pkg.load_row',
442: CALLING_FN => 'upload fa_itc_rates'
443: ,p_log_level_rec => p_log_level_rec);
444:
445: end LOAD_ROW;

Line 442: CALLING_FN => 'upload fa_itc_rates'

438: exception
439: when others then
440: FA_STANDARD_PKG.RAISE_ERROR(
441: CALLED_FN => 'fa_itc_rates_pkg.load_row',
442: CALLING_FN => 'upload fa_itc_rates'
443: ,p_log_level_rec => p_log_level_rec);
444:
445: end LOAD_ROW;
446:

Line 480: fa_itc_rates_pkg.LOAD_ROW (

476:
477: if (x_upload_mode = 'NLS') then
478: null;
479: else
480: fa_itc_rates_pkg.LOAD_ROW (
481: x_custom_mode => x_custom_mode,
482: x_itc_amount_id => x_itc_amount_id,
483: x_owner => x_owner,
484: x_last_update_date => x_last_update_date,

Line 509: END FA_ITC_RATES_PKG;

505: end if;
506:
507: END LOAD_SEED_ROW;
508:
509: END FA_ITC_RATES_PKG;