APPS.IGI_IAC_ASSET_BALANCES_PKG dependencies on IGI_IAC_ASSET_BALANCES

Line 1: PACKAGE BODY igi_iac_asset_balances_pkg AS

1: PACKAGE BODY igi_iac_asset_balances_pkg AS
2: -- $Header: igiiaabb.pls 120.6.12000000.1 2007/08/01 16:12:34 npandya ship $
3:
4: --===========================FND_LOG.START=====================================
5: g_state_level NUMBER := FND_LOG.LEVEL_STATEMENT;

Line 11: g_path VARCHAR2(100) := 'IGI.PLSQL.igiiaabb.igi_iac_asset_balances_pkg.';

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

Line 53: FROM igi_iac_asset_balances

49:
50:
51: CURSOR c IS
52: SELECT rowid
53: FROM igi_iac_asset_balances
54: WHERE asset_id = x_asset_id
55: AND book_type_code = x_book_type_code
56: AND period_counter = x_period_counter;
57:

Line 83: INSERT INTO igi_iac_asset_balances (

79: app_exception.raise_exception;
80: END IF;
81:
82:
83: INSERT INTO igi_iac_asset_balances (
84: asset_id,
85: book_type_code,
86: period_counter,
87: net_book_value,

Line 190: UPDATE igi_iac_asset_balances

186: igi_iac_debug_pkg.debug_other_msg(g_error_level,g_path||'update_row',FALSE);
187: app_exception.raise_exception;
188: END IF;
189:
190: UPDATE igi_iac_asset_balances
191: SET
192: net_book_value = x_net_book_value,
193: adjusted_cost = x_adjusted_cost,
194: operating_acct = x_operating_acct,

Line 236: DELETE FROM igi_iac_asset_balances

232:
233: BEGIN
234:
235:
236: DELETE FROM igi_iac_asset_balances
237: WHERE asset_id = x_asset_id
238: AND book_type_code = x_book_type_code
239: AND period_counter = x_period_counter;
240:

Line 251: END igi_iac_asset_balances_pkg;

247:
248: END delete_row;
249:
250:
251: END igi_iac_asset_balances_pkg;