APPS.IGI_IAC_FA_DEPRN_PKG dependencies on IGI_IAC_FA_DEPRN

Line 1: PACKAGE BODY igi_iac_fa_deprn_pkg AS

1: PACKAGE BODY igi_iac_fa_deprn_pkg AS
2: -- $Header: igiiafdb.pls 120.4.12000000.1 2007/08/01 16:15:29 npandya noship $
3:
4: --===========================FND_LOG.START=====================================
5:

Line 12: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiafdb.igi_iac_fa_deprn_pkg.';

8: g_event_level NUMBER := FND_LOG.LEVEL_EVENT;
9: g_excep_level NUMBER := FND_LOG.LEVEL_EXCEPTION;
10: g_error_level NUMBER := FND_LOG.LEVEL_ERROR;
11: g_unexp_level NUMBER := FND_LOG.LEVEL_UNEXPECTED;
12: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiafdb.igi_iac_fa_deprn_pkg.';
13:
14: --===========================FND_LOG.END=======================================
15:
16:

Line 51: FROM igi_iac_fa_deprn

47:
48:
49: CURSOR c IS
50: SELECT rowid
51: FROM igi_iac_fa_deprn
52: WHERE adjustment_id = x_adjustment_id
53: AND asset_id = x_asset_id
54: AND distribution_id = x_distribution_id
55: AND book_type_code = x_book_type_code

Line 85: INSERT INTO igi_iac_fa_deprn (

81: app_exception.raise_exception;
82: END IF;
83:
84:
85: INSERT INTO igi_iac_fa_deprn (
86: book_type_code,
87: asset_id,
88: period_counter,
89: adjustment_id,

Line 176: UPDATE igi_iac_fa_deprn SET

172: igi_iac_debug_pkg.debug_other_msg(g_error_level,l_path,FALSE);
173: app_exception.raise_exception;
174: END IF;
175:
176: UPDATE igi_iac_fa_deprn SET
177: deprn_period = x_deprn_period,
178: deprn_ytd = x_deprn_ytd,
179: deprn_reserve = x_deprn_reserve,
180: active_flag = x_active_flag,

Line 212: DELETE FROM igi_iac_fa_deprn

208: || (reverse chronological order - newest change first)
209: */
210: BEGIN
211:
212: DELETE FROM igi_iac_fa_deprn
213: WHERE adjustment_id = x_adjustment_id
214: AND asset_id = x_asset_id
215: AND distribution_id = x_distribution_id
216: AND book_type_code = x_book_type_code

Line 229: END igi_iac_fa_deprn_pkg;

225:
226: END delete_row;
227:
228:
229: END igi_iac_fa_deprn_pkg;