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_RETIREMENT dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 13: g_latest_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;

9: g_excep_level NUMBER;
10: g_error_level NUMBER;
11: g_unexp_level NUMBER;
12: g_path VARCHAR2(100);
13: g_latest_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
14: g_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE DEFAULT NULL;
15: g_mass_reference_id igi_iac_transaction_headers.mass_reference_id%TYPE ;
16: g_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE ;
17: g_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE ;

Line 14: g_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE DEFAULT NULL;

10: g_error_level NUMBER;
11: g_unexp_level NUMBER;
12: g_path VARCHAR2(100);
13: g_latest_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
14: g_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE DEFAULT NULL;
15: g_mass_reference_id igi_iac_transaction_headers.mass_reference_id%TYPE ;
16: g_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE ;
17: g_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE ;
18: g_prd_rec igi_iac_types.prd_rec ;

Line 15: g_mass_reference_id igi_iac_transaction_headers.mass_reference_id%TYPE ;

11: g_unexp_level NUMBER;
12: g_path VARCHAR2(100);
13: g_latest_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
14: g_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE DEFAULT NULL;
15: g_mass_reference_id igi_iac_transaction_headers.mass_reference_id%TYPE ;
16: g_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE ;
17: g_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE ;
18: g_prd_rec igi_iac_types.prd_rec ;
19: g_retire_prd_rec igi_iac_types.prd_rec ;

Line 16: g_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE ;

12: g_path VARCHAR2(100);
13: g_latest_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
14: g_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE DEFAULT NULL;
15: g_mass_reference_id igi_iac_transaction_headers.mass_reference_id%TYPE ;
16: g_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE ;
17: g_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE ;
18: g_prd_rec igi_iac_types.prd_rec ;
19: g_retire_prd_rec igi_iac_types.prd_rec ;
20: g_retire_rec fa_api_types.asset_retire_rec_type ;

Line 17: g_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE ;

13: g_latest_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
14: g_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE DEFAULT NULL;
15: g_mass_reference_id igi_iac_transaction_headers.mass_reference_id%TYPE ;
16: g_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE ;
17: g_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE ;
18: g_prd_rec igi_iac_types.prd_rec ;
19: g_retire_prd_rec igi_iac_types.prd_rec ;
20: g_retire_rec fa_api_types.asset_retire_rec_type ;
21: g_retirement_type VARCHAR2(4) ;

Line 26: g_retirement_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;

22: g_retirement_period_type VARCHAR2(10) ;
23: g_ret_type_long VARCHAR2(20) ;
24: g_retirement_factor NUMBER ;
25: g_err_msg VARCHAR2(250) ;
26: g_retirement_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
27: g_asset_category_id fa_additions_b.asset_category_id%TYPE ;
28: g_rowid ROWID ;
29: g_sob_id NUMBER ;
30: g_coa_id NUMBER ;

Line 93: FROM igi_iac_transaction_headers

89: AND transaction_header_id_out IS NULL ;
90:
91: CURSOR c_previous_per (p_adjustment_id NUMBER) IS
92: SELECT period_counter
93: FROM igi_iac_transaction_headers
94: WHERE adjustment_id = p_adjustment_id ;
95:
96:
97: CURSOR c_fa_deprn(n_adjust_id NUMBER, n_dist_id NUMBER,n_prd_cnt NUMBER)

Line 138: FROM igi_iac_transaction_headers

134: p_book_type_code fa_books.book_type_code%TYPE,
135: p_retire_period Number,
136: p_current_period NUmber) IS
137: SELECT *
138: FROM igi_iac_transaction_headers
139: WHERE book_type_code = p_book_type_code
140: AND asset_id = p_asset_id
141: AND period_counter >= p_retire_period
142: AND period_counter <= p_current_period

Line 159: FROM igi_iac_transaction_headers

155: WHERE book_type_code = p_book_type_code
156: AND asset_id = p_asset_id
157: AND distribution_id = p_distribution_id
158: AND adjustment_id IN (SELECT adjustment_id
159: FROM igi_iac_transaction_headers
160: WHERE book_type_code = p_book_type_code
161: AND asset_id = p_asset_id
162: AND period_counter >= p_retire_period
163: AND period_counter <= p_current_period

Line 173: FROM igi_iac_transaction_headers

169: p_book_type_code fa_books.book_type_code%TYPE,
170: p_retire_period Number,
171: p_current_period NUmber) IS
172: SELECT *
173: FROM igi_iac_transaction_headers
174: WHERE book_type_code = p_book_type_code
175: AND asset_id = p_asset_id
176: AND period_counter >= p_retire_period
177: AND period_counter <= p_current_period

Line 194: FROM igi_iac_transaction_headers

190: WHERE book_type_code = p_book_type_code
191: AND asset_id = p_asset_id
192: AND distribution_id = p_distribution_id
193: AND adjustment_id IN (SELECT adjustment_id
194: FROM igi_iac_transaction_headers
195: WHERE book_type_code = p_book_type_code
196: AND asset_id = p_asset_id
197: AND period_counter >= p_retire_period
198: AND period_counter <= p_current_period

Line 214: FROM igi_iac_transaction_headers

210: WHERE book_type_code = p_book_type_code
211: AND asset_id = p_asset_id
212: AND distribution_id = p_distribution_id
213: AND adjustment_id = (SELECT MAX(adjustment_id)
214: FROM igi_iac_transaction_headers
215: WHERE asset_id = p_asset_id
216: AND book_type_code = p_book_type_code
217: AND period_counter = ( SELECT max(period_counter)
218: FROM igi_iac_det_balances

Line 323: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;

319: l_ret BOOLEAN ;
320: l_total_asset_units NUMBER ;
321: l_asset_units_count NUMBER ;
322: l_previous_per NUMBER ;
323: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
324: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
325: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
326: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
327: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 324: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;

320: l_total_asset_units NUMBER ;
321: l_asset_units_count NUMBER ;
322: l_previous_per NUMBER ;
323: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
324: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
325: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
326: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
327: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
328: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 345: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

341: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
342: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
343: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
344: l_op_exp_ccid NUMBER;
345: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
346: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
347: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
348: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
349: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;

Line 346: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;

342: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
343: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
344: l_op_exp_ccid NUMBER;
345: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
346: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
347: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
348: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
349: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
350: l_retirement_adjustment_id NUmber;

Line 347: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;

343: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
344: l_op_exp_ccid NUMBER;
345: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
346: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
347: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
348: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
349: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
350: l_retirement_adjustment_id NUmber;
351: l_path_name varchar2(200);

Line 348: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;

344: l_op_exp_ccid NUMBER;
345: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
346: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
347: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
348: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
349: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
350: l_retirement_adjustment_id NUmber;
351: l_path_name varchar2(200);
352: l_detail_balances_prior C_get_prior_dist%ROWTYPE;

Line 1327: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;

1323: l_ret BOOLEAN ;
1324: l_total_asset_units NUMBER ;
1325: l_asset_units_count NUMBER ;
1326: l_previous_per NUMBER ;
1327: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1328: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1329: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1330: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1331: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 1328: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;

1324: l_total_asset_units NUMBER ;
1325: l_asset_units_count NUMBER ;
1326: l_previous_per NUMBER ;
1327: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1328: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
1329: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
1330: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
1331: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
1332: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 1349: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

1345: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1346: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1347: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1348: l_op_exp_ccid NUMBER;
1349: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
1350: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
1351: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
1352: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
1353: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;

Line 1350: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;

1346: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
1347: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1348: l_op_exp_ccid NUMBER;
1349: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
1350: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
1351: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
1352: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
1353: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
1354: l_retirement_adjustment_id NUmber;

Line 1351: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;

1347: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
1348: l_op_exp_ccid NUMBER;
1349: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
1350: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
1351: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
1352: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
1353: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
1354: l_retirement_adjustment_id NUmber;
1355: l_path_name varchar2(200);

Line 1352: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;

1348: l_op_exp_ccid NUMBER;
1349: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
1350: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
1351: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
1352: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
1353: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
1354: l_retirement_adjustment_id NUmber;
1355: l_path_name varchar2(200);
1356: l_check_revaluations c_check_revaluations%ROWTYPE;

Line 2050: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;

2046: l_ret BOOLEAN ;
2047: l_total_asset_units NUMBER ;
2048: l_asset_units_count NUMBER ;
2049: l_previous_per NUMBER ;
2050: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
2051: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
2052: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
2053: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
2054: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 2051: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;

2047: l_total_asset_units NUMBER ;
2048: l_asset_units_count NUMBER ;
2049: l_previous_per NUMBER ;
2050: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
2051: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
2052: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
2053: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
2054: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
2055: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 2075: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

2071: l_impact_fa_dist c_get_impacted_dist%ROWTYPE;
2072: l_new_fa_dist c_get_new_dist%ROWTYPE;
2073: l_retirement_factor Number;
2074: l_op_exp_ccid Number;
2075: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
2076: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
2077: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
2078: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
2079: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;

Line 2076: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;

2072: l_new_fa_dist c_get_new_dist%ROWTYPE;
2073: l_retirement_factor Number;
2074: l_op_exp_ccid Number;
2075: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
2076: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
2077: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
2078: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
2079: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
2080: l_retirement_adjustment_id Number;

Line 2077: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;

2073: l_retirement_factor Number;
2074: l_op_exp_ccid Number;
2075: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
2076: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
2077: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
2078: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
2079: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
2080: l_retirement_adjustment_id Number;
2081: l_path_name varchar2(200);

Line 2078: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;

2074: l_op_exp_ccid Number;
2075: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
2076: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
2077: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
2078: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
2079: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
2080: l_retirement_adjustment_id Number;
2081: l_path_name varchar2(200);
2082: l_detail_balances_prior C_get_prior_dist%rowtype;

Line 3394: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;

3390: l_ret BOOLEAN ;
3391: l_total_asset_units NUMBER ;
3392: l_asset_units_count NUMBER ;
3393: l_previous_per NUMBER ;
3394: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3395: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3396: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
3397: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3398: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 3395: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;

3391: l_total_asset_units NUMBER ;
3392: l_asset_units_count NUMBER ;
3393: l_previous_per NUMBER ;
3394: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3395: l_last_active_adj_id igi_iac_transaction_headers.adjustment_id%TYPE ;
3396: l_db_op_acct_ytd igi_iac_det_balances.operating_acct_ytd%TYPE;
3397: l_db_deprn_ytd igi_iac_det_balances.deprn_ytd%TYPE;
3398: l_fa_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;
3399: l_fa_tot_round_deprn_prd igi_iac_fa_deprn.deprn_period%TYPE;

Line 3416: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;

3412: l_fa_total_old_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3413: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3414: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3415: l_op_exp_ccid NUMBER;
3416: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
3417: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
3418: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
3419: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
3420: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;

Line 3417: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;

3413: l_fa_retire_deprn_prd igi_iac_fa_deprn.deprn_ytd%TYPE;
3414: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3415: l_op_exp_ccid NUMBER;
3416: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
3417: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
3418: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
3419: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
3420: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
3421: l_retirement_adjustment_id NUMBER;

Line 3418: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;

3414: l_fa_retire_deprn_ytd igi_iac_fa_deprn.deprn_ytd%TYPE;
3415: l_op_exp_ccid NUMBER;
3416: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
3417: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
3418: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
3419: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
3420: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
3421: l_retirement_adjustment_id NUMBER;
3422: l_path_name varchar2(200);

Line 3419: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;

3415: l_op_exp_ccid NUMBER;
3416: l_Transaction_Type_Code igi_iac_transaction_headers.transaction_type_code%TYPE;
3417: l_Transaction_Id igi_iac_transaction_headers.transaction_header_id%TYPE;
3418: l_Mass_Reference_ID igi_iac_transaction_headers.mass_reference_id%TYPE;
3419: l_Adjustment_Status igi_iac_transaction_headers.adjustment_status%TYPE;
3420: l_adjustment_id_out igi_iac_adjustments.adjustment_id%TYPE;
3421: l_retirement_adjustment_id NUMBER;
3422: l_path_name varchar2(200);
3423: l_check_revaluations c_check_revaluations%ROWTYPE;

Line 4306: from igi_iac_transaction_headers

4302: RETURN BOOLEAN IS
4303:
4304: Cursor c_get_prior_transactions(p_book_type_code varchar2, p_asset_id number,p_period_counter number)
4305: is select MAX(period_counter) period_counter
4306: from igi_iac_transaction_headers
4307: where asset_id = p_asset_id
4308: and book_type_code = p_book_type_code
4309: and period_counter >= p_period_counter
4310: and not (transaction_type_code='DEPRECIATION' and transaction_sub_type is null)