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 2023: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )

2019: return false;
2020: end;
2021:
2022: function reval_status_to_previewed
2023: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )
2024: return boolean is
2025: pragma autonomous_transaction;
2026: begin
2027: update igi_iac_revaluations

Line 2027: update igi_iac_revaluations

2023: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )
2024: return boolean is
2025: pragma autonomous_transaction;
2026: begin
2027: update igi_iac_revaluations
2028: set status = IGI_IAC_TYPES.gc_previewed_status
2029: where revaluation_id = fp_reval_id
2030: ;
2031: if sql%found then

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

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

Line 2045: update igi_iac_revaluations

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

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

2055: end if;
2056: end;
2057:
2058: function reval_status_to_completed
2059: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE,
2060: p_event_id in number)
2061: return boolean is
2062: pragma autonomous_transaction;
2063: begin

Line 2065: update igi_iac_revaluations

2061: return boolean is
2062: pragma autonomous_transaction;
2063: begin
2064: if p_event_id is not null then
2065: update igi_iac_revaluations
2066: set status = IGI_IAC_TYPES.gc_completed_status,
2067: event_id = p_event_id
2068: where revaluation_id = fp_reval_id
2069: and event_id is null;

Line 2071: update igi_iac_revaluations

2067: event_id = p_event_id
2068: where revaluation_id = fp_reval_id
2069: and event_id is null;
2070: else
2071: update igi_iac_revaluations
2072: set status = IGI_IAC_TYPES.gc_completed_status
2073: where revaluation_id = fp_reval_id;
2074: end if;
2075:

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

2082: end if;
2083: end;
2084:
2085: function reval_status_to_failed_run
2086: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )
2087: return boolean is
2088: pragma autonomous_transaction;
2089: begin
2090: update igi_iac_revaluations

Line 2090: update igi_iac_revaluations

2086: ( fp_reval_id in out NOCOPY IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE )
2087: return boolean is
2088: pragma autonomous_transaction;
2089: begin
2090: update igi_iac_revaluations
2091: set status = IGI_IAC_TYPES.gc_failedrun_status
2092: where revaluation_id = fp_reval_id
2093: ;
2094: if sql%found then

Line 2104: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE

2100: end if;
2101: end;
2102:
2103: function allow_transfer_to_gl
2104: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2105: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
2106: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2107: )
2108: return boolean is

Line 2105: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE

2101: end;
2102:
2103: function allow_transfer_to_gl
2104: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2105: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
2106: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2107: )
2108: return boolean is
2109: cursor c_check is

Line 2149: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE

2145: end;
2146:
2147: --Added for SLA uptake. This function will update tables with event_id.
2148: function stamp_sla_event
2149: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2150: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
2151: , fp_event_id in IGI_IAC_REVALUATIONS.EVENT_ID%TYPE
2152: )
2153: return boolean is

Line 2150: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE

2146:
2147: --Added for SLA uptake. This function will update tables with event_id.
2148: function stamp_sla_event
2149: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2150: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
2151: , fp_event_id in IGI_IAC_REVALUATIONS.EVENT_ID%TYPE
2152: )
2153: return boolean is
2154: cursor c_check is

Line 2151: , fp_event_id in IGI_IAC_REVALUATIONS.EVENT_ID%TYPE

2147: --Added for SLA uptake. This function will update tables with event_id.
2148: function stamp_sla_event
2149: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2150: , fp_book_type_code in IGI_IAC_REVALUATIONS.BOOK_TYPE_CODE%TYPE
2151: , fp_event_id in IGI_IAC_REVALUATIONS.EVENT_ID%TYPE
2152: )
2153: return boolean is
2154: cursor c_check is
2155: select 'x'

Line 2201: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE

2197: end;
2198: --Added for SLA uptake. This function will update tables with event_id.
2199:
2200: function adjustment_status_to_run
2201: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2202: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2203: )
2204: return boolean is
2205: begin

Line 2221: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE

2217: end if;
2218: end;
2219:
2220: function adjustment_status_to_obsolete
2221: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2222: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2223: )
2224: return boolean is
2225: begin

Line 2241: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE

2237: end if;
2238: end;
2239:
2240: function update_balances
2241: ( fp_reval_id in IGI_IAC_REVALUATIONS.REVALUATION_ID%TYPE
2242: , fp_asset_id in IGI_IAC_TRANSACTION_HEADERS.ASSET_ID%TYPE
2243: , fp_period_counter in IGI_IAC_TRANSACTION_HEADERS.PERIOD_COUNTER%TYPE
2244: , fp_book_type_code in IGI_IAC_TRANSACTION_HEADERS.BOOK_TYPE_CODE%TYPE
2245: )

Line 2311: from igi_iac_revaluations iar

2307:
2308: cursor c_reval_info is
2309: select iar.revaluation_id, iar.revaluation_date
2310: , iirar.revaluation_factor
2311: from igi_iac_revaluations iar
2312: , igi_iac_reval_asset_rules iirar
2313: where iar.revaluation_id = fp_reval_id
2314: and iirar.revaluation_id = fp_reval_id
2315: and iirar.asset_id = fp_asset_id