APPS.IGI_IAC_REVAL_HIST_PKG dependencies on IGI_IAC_REVAL_HISTORY

Line 17: -- asset cost and inserts into table igi_iac_reval_history.

13:
14: --===========================FND_LOG.END=====================================
15: -- ==========================================================================
16: -- FUNCTION Insert_Rows: Function calculates the revaluation history of the
17: -- asset cost and inserts into table igi_iac_reval_history.
18: -- ==========================================================================
19:
20: FUNCTION Insert_rows ( P_Asset_id Number,
21: P_Book_type_code Varchar2)

Line 74: FROM IGI_IAC_REVAL_HISTORY

70:
71: --
72: CURSOR c_get_iac_history IS
73: SELECT *
74: FROM IGI_IAC_REVAL_HISTORY
75: WHERE asset_id = p_asset_id
76: AND book_type_code = p_book_type_code;
77:
78: --- fecthing the Fa_cost if transaction is Addition or Revaluation;

Line 185: l_iac_asset_history igi_iac_reval_history%ROWTYPE;

181: l_get_transactions c_get_iac_transactions%ROWTYPE;
182: l_get_iac_history c_get_iac_history%ROWTYPE;
183: l_get_iac_Prev_transactions c_get_iac_Prev_transactions%ROWTYPE;
184:
185: l_iac_asset_history igi_iac_reval_history%ROWTYPE;
186: l_get_fa_cost c_get_fa_cost%ROWTYPE;
187: -- bug 3394103 start 2
188: l_get_fa_cost_prev c_get_fa_cost_prev%ROWTYPE;
189: l_get_fa_cost_curr c_get_fa_cost_curr%ROWTYPE;

Line 538: INSERT INTO igi_iac_reval_history

534: l_lac_reval_history(l_idx2).transaction_sub_type := 'INDEXED';
535: END IF;
536: END IF;
537:
538: INSERT INTO igi_iac_reval_history
539: ( ASSET_ID ,
540: BOOK_TYPE_CODE ,
541: ADJUSTMENT_ID ,
542: PERIOD_COUNTER ,

Line 576: -- FUNCTION Delete_Rows: Function deletes rows from igi_iac_reval_history

572: END insert_rows;
573:
574:
575: -- ==========================================================================
576: -- FUNCTION Delete_Rows: Function deletes rows from igi_iac_reval_history
577: -- ==========================================================================
578: FUNCTION Delete_rows( P_Asset_id Number,
579: P_Book_type_code Varchar2)
580: RETURN boolean IS

Line 584: FROM IGI_IAC_REVAL_HISTORY

580: RETURN boolean IS
581:
582: CURSOR c_get_iac_history IS
583: SELECT *
584: FROM IGI_IAC_REVAL_HISTORY
585: WHERE asset_id = p_asset_id
586: AND book_type_code = p_book_type_code;
587:
588: l_get_iac_history c_get_iac_history%ROWTYPE;

Line 604: DELETE FROM igi_iac_reval_history

600: RETURN TRUE;
601: END IF;
602: CLOSE c_get_iac_history;
603:
604: DELETE FROM igi_iac_reval_history
605: WHERE asset_id = p_asset_id
606: AND book_type_code = p_book_type_code;
607:
608: RETURN TRUE;