eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IAC_REVAL_CRUD dependencies on IGI_IAC_REVALUATIONS

Line 1976: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )

1972: return false;
1973: end;
1974:
1975: function reval_status_to_previewed
1976: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )
1977: return boolean is
1978: pragma autonomous_transaction;
1979: begin
1980: update igi_iac_revaluations

Line 1980: update igi_iac_revaluations

1976: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )
1977: return boolean is
1978: pragma autonomous_transaction;
1979: begin
1980: update igi_iac_revaluations
1981: set status = IGI_IAC_TYPES.gc_previewed_status
1982: where revaluation_id = fp_reval_id
1983: ;
1984: if sql%found then

Line 1994: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )

1990: end if;
1991: end;
1992:
1993: function reval_status_to_failed_pre
1994: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )
1995: return boolean is
1996: pragma autonomous_transaction;
1997: begin
1998: update igi_iac_revaluations

Line 1998: update igi_iac_revaluations

1994: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )
1995: return boolean is
1996: pragma autonomous_transaction;
1997: begin
1998: update igi_iac_revaluations
1999: set status = IGI_IAC_TYPES.gc_failedpre_status
2000: where revaluation_id = fp_reval_id
2001: ;
2002: if sql%found then

Line 2012: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE,

2008: end if;
2009: end;
2010:
2011: function reval_status_to_completed
2012: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE,
2013: p_event_id in number)
2014: return boolean is
2015: pragma autonomous_transaction;
2016: begin

Line 2018: update igi_iac_revaluations

2014: return boolean is
2015: pragma autonomous_transaction;
2016: begin
2017: if p_event_id is not null then
2018: update igi_iac_revaluations
2019: set status = IGI_IAC_TYPES.gc_completed_status,
2020: event_id = p_event_id
2021: where revaluation_id = fp_reval_id
2022: and event_id is null;

Line 2024: update igi_iac_revaluations

2020: event_id = p_event_id
2021: where revaluation_id = fp_reval_id
2022: and event_id is null;
2023: else
2024: update igi_iac_revaluations
2025: set status = IGI_IAC_TYPES.gc_completed_status
2026: where revaluation_id = fp_reval_id;
2027: end if;
2028:

Line 2039: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )

2035: end if;
2036: end;
2037:
2038: function reval_status_to_failed_run
2039: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )
2040: return boolean is
2041: pragma autonomous_transaction;
2042: begin
2043: update igi_iac_revaluations

Line 2043: update igi_iac_revaluations

2039: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )
2040: return boolean is
2041: pragma autonomous_transaction;
2042: begin
2043: update igi_iac_revaluations
2044: set status = IGI_IAC_TYPES.gc_failedrun_status
2045: where revaluation_id = fp_reval_id
2046: ;
2047: if sql%found then

Line 2057: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE

2053: end if;
2054: end;
2055:
2056: function allow_transfer_to_gl
2057: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2058: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
2059: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2060: )
2061: return boolean is

Line 2058: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE

2054: end;
2055:
2056: function allow_transfer_to_gl
2057: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2058: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
2059: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2060: )
2061: return boolean is
2062: cursor c_check is

Line 2102: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE

2098: end;
2099:
2100: --Added for SLA uptake. This function will update tables with event_id.
2101: function stamp_sla_event
2102: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2103: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
2104: , fp_event_id in IGI_IAC_REVALUATIONS.EVENT_ID%TYPE
2105: )
2106: return boolean is

Line 2103: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE

2099:
2100: --Added for SLA uptake. This function will update tables with event_id.
2101: function stamp_sla_event
2102: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2103: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
2104: , fp_event_id in IGI_IAC_REVALUATIONS.EVENT_ID%TYPE
2105: )
2106: return boolean is
2107: cursor c_check is

Line 2104: , fp_event_id in IGI_IAC_REVALUATIONS.EVENT_ID%TYPE

2100: --Added for SLA uptake. This function will update tables with event_id.
2101: function stamp_sla_event
2102: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2103: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
2104: , fp_event_id in IGI_IAC_REVALUATIONS.EVENT_ID%TYPE
2105: )
2106: return boolean is
2107: cursor c_check is
2108: select 'x'

Line 2154: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE

2150: end;
2151: --Added for SLA uptake. This function will update tables with event_id.
2152:
2153: function adjustment_status_to_run
2154: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2155: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2156: )
2157: return boolean is
2158: begin

Line 2174: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE

2170: end if;
2171: end;
2172:
2173: function adjustment_status_to_obsolete
2174: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2175: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2176: )
2177: return boolean is
2178: begin

Line 2194: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE

2190: end if;
2191: end;
2192:
2193: function update_balances
2194: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2195: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2196: , fp_period_counter in IGI_IAC_TRANSACTION_HEADERS.PERIOD_COUNTER%TYPE
2197: , fp_book_type_code in IGI_IAC_TRANSACTION_HEADERS.BOOK_TYPE_CODE%TYPE
2198: )

Line 2264: from igi_iac_revaluations iar

2260:
2261: cursor c_reval_info is
2262: select iar.revaluation_id, iar.revaluation_date
2263: , iirar.revaluation_factor
2264: from igi_iac_revaluations iar
2265: , igi_iac_reval_asset_rules iirar
2266: where iar.revaluation_id = fp_reval_id
2267: and iirar.revaluation_id = fp_reval_id
2268: and iirar.asset_id = fp_asset_id