APPS.IGI_IAC_REVAL_CRUD dependencies on IGI_IAC_REVALUATION_RATES

Line 3: l_rec igi_iac_revaluation_rates%rowtype; -- create this for quicker access via sql navigator

1: PACKAGE BODY IGI_IAC_REVAL_CRUD AS
2: -- $Header: igiiardb.pls 120.25.12020000.1 2012/06/27 10:38:45 appldev ship $
3: l_rec igi_iac_revaluation_rates%rowtype; -- create this for quicker access via sql navigator
4:
5: --===========================FND_LOG.START=====================================
6: g_state_level NUMBER;
7: g_proc_level NUMBER;

Line 1799: l_reval_rates igi_iac_revaluation_rates%ROWTYPE;

1795: function create_reval_rates
1796: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
1797: , fp_second_set in boolean )
1798: return boolean is
1799: l_reval_rates igi_iac_revaluation_rates%ROWTYPE;
1800: l_adjustment_id igi_iac_revaluation_rates.adjustment_id%TYPE;
1801: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;
1802: l_path varchar2(150);
1803: begin

Line 1800: l_adjustment_id igi_iac_revaluation_rates.adjustment_id%TYPE;

1796: ( fp_reval_params in out NOCOPY IGI_IAC_TYPES.iac_reval_params
1797: , fp_second_set in boolean )
1798: return boolean is
1799: l_reval_rates igi_iac_revaluation_rates%ROWTYPE;
1800: l_adjustment_id igi_iac_revaluation_rates.adjustment_id%TYPE;
1801: l_fp_reval_params IGI_IAC_TYPES.iac_reval_params;
1802: l_path varchar2(150);
1803: begin
1804: l_path := g_path||'create_reval_rates';

Line 1845: insert into igi_iac_revaluation_Rates

1841: end if;
1842:
1843:
1844:
1845: insert into igi_iac_revaluation_Rates
1846: (
1847: asset_id
1848: ,book_type_code
1849: ,revaluation_id

Line 1907: update igi_iac_revaluation_rates

1903: begin
1904: l_path := g_path||'update_reval_rates';
1905: for l_txns in c_txns loop
1906:
1907: update igi_iac_revaluation_rates
1908: set latest_record = 'N'
1909: where asset_id = l_txns.asset_id
1910: and book_type_code = l_txns.book_type_code
1911: and processed_flag = 'Y'

Line 1920: update igi_iac_revaluation_rates

1916: else
1917: igi_iac_debug_pkg.debug_other_string(g_error_level,l_path,'+ failed update of reval rates');
1918: end if;
1919:
1920: update igi_iac_revaluation_rates
1921: set latest_record = 'Y'
1922: where asset_id = l_txns.asset_id
1923: and book_type_code = l_txns.book_type_code
1924: and processed_flag = 'Y'