APPS.IGI_IAC_ADJ_PKG dependencies on IGI_IAC_ADJUSTMENTS_HISTORY

Line 82: FROM igi_iac_adjustments_history

78: CURSOR c_get_asset_adj (p_book_type_code fa_transaction_headers.book_type_code%TYPE,
79: p_asset_id fa_transaction_headers.asset_id%TYPE,
80: p_period_counter number) IS
81: SELECT *
82: FROM igi_iac_adjustments_history
83: WHERE book_type_code = p_book_type_code
84: AND period_counter = p_period_counter
85: AND asset_id = p_asset_id
86: AND NVL(active_flag,'N') = 'N' ;

Line 96: l_iac_adjustment_history igi_iac_adjustments_history%ROWTYPE;

92: l_precision number:=0;
93: l_category_id number;
94: l_amort_period_info igi_iac_types.prd_rec;
95: l_open_period igi_iac_types.prd_rec;
96: l_iac_adjustment_history igi_iac_adjustments_history%ROWTYPE;
97: l_get_fa_book_info fa_books%ROWTYPE;
98: l_last_update_date date;
99: l_last_updated_by number;
100: l_last_update_login number;

Line 708: UPDATE igi_iac_adjustments_history

704: -- set the cost adjustment
705: l_iac_adjustment_history.adjustment_reval_type := 'C';
706: END IF;
707:
708: UPDATE igi_iac_adjustments_history
709: SET active_flag = 'Y'
710: WHERE asset_id = l_iac_adjustment_history.asset_id
711: AND book_type_code =l_iac_adjustment_history.book_type_code
712: AND period_counter = l_iac_adjustment_history.period_counter;

Line 732: INSERT INTO igi_iac_adjustments_history

728: IF (l_last_update_login IS NULL) THEN
729: l_last_update_login := -1;
730: END IF;
731:
732: INSERT INTO igi_iac_adjustments_history
733: (book_type_code,
734: asset_id ,
735: category_id ,
736: date_placed_in_service,

Line 868: p_adjustment_type igi_iac_adjustments_history.transaction_subtype%TYPE

864:
865: FUNCTION Prepare_Adjustment(p_book_type_code igi_iac_det_balances.book_type_code%TYPE,
866: p_period_counter igi_iac_det_balances.period_counter%TYPE,
867: p_asset_id igi_iac_det_balances.asset_id%TYPE,
868: p_adjustment_type igi_iac_adjustments_history.transaction_subtype%TYPE
869: ,p_asset_iac_adj_info IN OUT NOCOPY igi_iac_types.iac_adj_hist_asset_info
870: ,p_asset_dist_iac_adj_info IN OUT NOCOPY igi_iac_types.iac_adj_dist_info_tab
871: ,p_asset_adj_hist_info igi_iac_adjustments_history%ROWTYPE)
872:

Line 871: ,p_asset_adj_hist_info igi_iac_adjustments_history%ROWTYPE)

867: p_asset_id igi_iac_det_balances.asset_id%TYPE,
868: p_adjustment_type igi_iac_adjustments_history.transaction_subtype%TYPE
869: ,p_asset_iac_adj_info IN OUT NOCOPY igi_iac_types.iac_adj_hist_asset_info
870: ,p_asset_dist_iac_adj_info IN OUT NOCOPY igi_iac_types.iac_adj_dist_info_tab
871: ,p_asset_adj_hist_info igi_iac_adjustments_history%ROWTYPE)
872:
873: RETURN boolean IS
874:
875: CURSOR c_get_fa_book_info(p_book_type_code fa_transaction_headers.book_type_code%TYPE,

Line 1247: FROM igi_iac_adjustments_history

1243: ) RETURN boolean IS
1244:
1245: CURSOR c_get_asset_adj IS
1246: SELECT *
1247: FROM igi_iac_adjustments_history
1248: WHERE book_type_code = p_book_type_code
1249: AND period_counter = p_period_counter
1250: AND NVL(active_flag,'N') = 'N' ;
1251:

Line 1369: UPDATE igi_iac_adjustments_history

1365: IF (l_last_update_login IS NULL) THEN
1366: l_last_update_login := -1;
1367: END IF;
1368:
1369: UPDATE igi_iac_adjustments_history
1370: SET active_flag = 'Y',
1371: last_updated_by = l_last_updated_by,
1372: last_update_date =l_last_update_date,
1373: last_update_login =l_last_update_login