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

Line 23: g_book_type_code igi_iac_transaction_headers.book_type_code%TYPE;

19: g_message VARCHAR2(200);
20: g_calling_fn VARCHAR2(200);
21: g_calling_fn1 VARCHAR2(200);
22:
23: g_book_type_code igi_iac_transaction_headers.book_type_code%TYPE;
24: g_asset_id igi_iac_transaction_headers.asset_id%TYPE;
25: g_retirement_id NUMBER;
26: g_adj_prior_ret igi_iac_transaction_headers.adjustment_id%TYPE;
27:

Line 24: g_asset_id igi_iac_transaction_headers.asset_id%TYPE;

20: g_calling_fn VARCHAR2(200);
21: g_calling_fn1 VARCHAR2(200);
22:
23: g_book_type_code igi_iac_transaction_headers.book_type_code%TYPE;
24: g_asset_id igi_iac_transaction_headers.asset_id%TYPE;
25: g_retirement_id NUMBER;
26: g_adj_prior_ret igi_iac_transaction_headers.adjustment_id%TYPE;
27:
28: -- define asset rec type

Line 26: g_adj_prior_ret igi_iac_transaction_headers.adjustment_id%TYPE;

22:
23: g_book_type_code igi_iac_transaction_headers.book_type_code%TYPE;
24: g_asset_id igi_iac_transaction_headers.asset_id%TYPE;
25: g_retirement_id NUMBER;
26: g_adj_prior_ret igi_iac_transaction_headers.adjustment_id%TYPE;
27:
28: -- define asset rec type
29: TYPE fa_reins_rec_info IS RECORD (asset_id NUMBER,
30: book_type_code VARCHAR2(15),

Line 67: CURSOR c_trx_prev_ret(cp_book_type_code igi_iac_transaction_headers.book_type_code%TYPE,

63:
64:
65: -- retrieve the transaction just prior to the
66: -- retirement
67: CURSOR c_trx_prev_ret(cp_book_type_code igi_iac_transaction_headers.book_type_code%TYPE,
68: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
69: cp_trxhdr_id_retire igi_iac_transaction_headers.transaction_header_id%TYPE)
70: IS
71: SELECT adjustment_id

Line 68: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,

64:
65: -- retrieve the transaction just prior to the
66: -- retirement
67: CURSOR c_trx_prev_ret(cp_book_type_code igi_iac_transaction_headers.book_type_code%TYPE,
68: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
69: cp_trxhdr_id_retire igi_iac_transaction_headers.transaction_header_id%TYPE)
70: IS
71: SELECT adjustment_id
72: FROM igi_iac_transaction_headers

Line 69: cp_trxhdr_id_retire igi_iac_transaction_headers.transaction_header_id%TYPE)

65: -- retrieve the transaction just prior to the
66: -- retirement
67: CURSOR c_trx_prev_ret(cp_book_type_code igi_iac_transaction_headers.book_type_code%TYPE,
68: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
69: cp_trxhdr_id_retire igi_iac_transaction_headers.transaction_header_id%TYPE)
70: IS
71: SELECT adjustment_id
72: FROM igi_iac_transaction_headers
73: WHERE book_type_code = cp_book_type_code

Line 72: FROM igi_iac_transaction_headers

68: cp_asset_id igi_iac_transaction_headers.asset_id%TYPE,
69: cp_trxhdr_id_retire igi_iac_transaction_headers.transaction_header_id%TYPE)
70: IS
71: SELECT adjustment_id
72: FROM igi_iac_transaction_headers
73: WHERE book_type_code = cp_book_type_code
74: AND asset_id = cp_asset_id
75: AND adjustment_id_out = (select min(adjustment_id)
76: from igi_iac_transaction_headers

Line 76: from igi_iac_transaction_headers

72: FROM igi_iac_transaction_headers
73: WHERE book_type_code = cp_book_type_code
74: AND asset_id = cp_asset_id
75: AND adjustment_id_out = (select min(adjustment_id)
76: from igi_iac_transaction_headers
77: where transaction_header_id = cp_trxhdr_id_retire);
78: /*CURSOR c_trx_prev_ret(n_trx_id NUMBER)
79: IS
80: SELECT adjustment_id,

Line 82: FROM igi_iac_transaction_headers

78: /*CURSOR c_trx_prev_ret(n_trx_id NUMBER)
79: IS
80: SELECT adjustment_id,
81: period_counter
82: FROM igi_iac_transaction_headers
83: WHERE adjustment_id_out = (SELECT adjustment_id
84: FROM igi_iac_transaction_headers
85: WHERE transaction_header_id = n_trx_id); */
86:

Line 84: FROM igi_iac_transaction_headers

80: SELECT adjustment_id,
81: period_counter
82: FROM igi_iac_transaction_headers
83: WHERE adjustment_id_out = (SELECT adjustment_id
84: FROM igi_iac_transaction_headers
85: WHERE transaction_header_id = n_trx_id); */
86:
87: -- cursor to get the asset balances for the period
88: CURSOR c_ret_ass_bal(n_asset_id NUMBER,

Line 331: FROM igi_iac_transaction_headers a1

327: l_cnt NUMBER;
328: BEGIN
329: SELECT count(*)
330: INTO l_cnt
331: FROM igi_iac_transaction_headers a1
332: WHERE a1.asset_id = x_asset_id
333: AND a1.book_type_code = x_book_type_code
334: AND a1.transaction_type_code = 'REVALUATION'
335: AND a1.adjustment_status NOT IN ('PREVIEW', 'OBSOLETE')

Line 338: FROM igi_iac_transaction_headers a2

334: AND a1.transaction_type_code = 'REVALUATION'
335: AND a1.adjustment_status NOT IN ('PREVIEW', 'OBSOLETE')
336: AND a1.period_counter BETWEEN x_eff_ret_period_cnt AND x_curr_period_cnt;
337: /* AND a1.adjustment_id > (SELECT a2.adjustment_id
338: FROM igi_iac_transaction_headers a2
339: WHERE a2.transaction_header_id = x_ret_trx_hdr_id
340: AND a2.transaction_type_code = 'PARTIAL RETIRE'
341: AND a2.period_counter <= a1.period_counter
342: AND a2.asset_id = x_asset_id

Line 376: FROM igi_iac_transaction_headers

372: BEGIN
373: -- get the retirement period counter
374: SELECT period_counter
375: INTO l_ret_prd_counter
376: FROM igi_iac_transaction_headers
377: WHERE adjustment_id = x_ret_adj_id;
378:
379: -- get the reinstatement period counter
380: SELECT period_counter

Line 382: FROM igi_iac_transaction_headers

378:
379: -- get the reinstatement period counter
380: SELECT period_counter
381: INTO l_ren_prd_counter
382: FROM igi_iac_transaction_headers
383: WHERE adjustment_id = x_ren_adj_id;
384:
385: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reinstate period counter: '||l_ren_prd_counter);
386: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Retire period counter: '||l_ret_prd_counter);

Line 484: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

480:
481: -- local variables
482: l_rowid ROWID;
483:
484: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
485: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;
486: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;
487:
488: l_ren_dist_id igi_iac_transaction_headers.adjustment_id%TYPE;

Line 488: l_ren_dist_id igi_iac_transaction_headers.adjustment_id%TYPE;

484: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
485: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;
486: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;
487:
488: l_ren_dist_id igi_iac_transaction_headers.adjustment_id%TYPE;
489: l_prorate_factor NUMBER;
490: l_elapsed_periods NUMBER;
491:
492: l_adjustment_cost NUMBER := 0;

Line 1931: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

1927: l_path VARCHAR2(150);
1928:
1929: l_units_ren fa_distribution_history.units_assigned%TYPE;
1930: l_units_ret fa_distribution_history.units_assigned%TYPE;
1931: l_prev_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
1932: l_prev_dist_id igi_iac_det_balances.distribution_id%TYPE;
1933:
1934: l_retire_effect NUMBER := 0;
1935: l_prorate_factor NUMBER;

Line 2905: igi_iac_transaction_headers iath

2901: iaa.period_counter,
2902: iaa.adjustment_offset_type,
2903: iaa.report_ccid
2904: FROM igi_iac_adjustments iaa,
2905: igi_iac_transaction_headers iath
2906: WHERE iaa.adjustment_id = iath.adjustment_id
2907: AND iath.transaction_header_id = p_trx_header_id;
2908:
2909: -- local variables

Line 2911: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;

2907: AND iath.transaction_header_id = p_trx_header_id;
2908:
2909: -- local variables
2910: l_rowid ROWID;
2911: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
2912: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
2913: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
2914: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
2915: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;

Line 2912: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;

2908:
2909: -- local variables
2910: l_rowid ROWID;
2911: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
2912: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
2913: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
2914: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
2915: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
2916: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

Line 2913: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;

2909: -- local variables
2910: l_rowid ROWID;
2911: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
2912: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
2913: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
2914: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
2915: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
2916: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
2917: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;

Line 2914: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

2910: l_rowid ROWID;
2911: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
2912: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
2913: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
2914: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
2915: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
2916: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
2917: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;
2918: l_dr_cr_flag igi_iac_adjustments.dr_cr_flag%TYPE;

Line 2915: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;

2911: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
2912: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
2913: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
2914: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
2915: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
2916: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
2917: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;
2918: l_dr_cr_flag igi_iac_adjustments.dr_cr_flag%TYPE;
2919: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;

Line 2916: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

2912: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
2913: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
2914: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
2915: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
2916: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
2917: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;
2918: l_dr_cr_flag igi_iac_adjustments.dr_cr_flag%TYPE;
2919: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;
2920: l_units_assigned fa_distribution_history.units_assigned%TYPE;

Line 2917: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;

2913: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
2914: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
2915: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
2916: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
2917: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;
2918: l_dr_cr_flag igi_iac_adjustments.dr_cr_flag%TYPE;
2919: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;
2920: l_units_assigned fa_distribution_history.units_assigned%TYPE;
2921:

Line 2946: -- into igi_iac_transaction_headers

2942: RAISE e_latest_trx_not_avail;
2943: END IF;
2944:
2945: -- insert a new row for the asset with transaction type REINSTATEMENT
2946: -- into igi_iac_transaction_headers
2947: l_adjust_id_reinstate := null;
2948: IGI_IAC_TRANS_HEADERS_PKG.Insert_Row(
2949: x_rowid => l_rowid,
2950: x_adjustment_id => l_adjust_id_reinstate, -- out parameter

Line 2967: -- update the previous active row for the asset in igi_iac_transaction_headers

2963: x_period_counter => p_fa_reins_rec_info.curr_period_counter,
2964: x_event_id => p_event_id );
2965: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted into headers table');
2966:
2967: -- update the previous active row for the asset in igi_iac_transaction_headers
2968: -- in order to make it inactive by setting adjustment_id_out= adjustment_id of
2969: -- the active row in igi_iac_transaction_headers
2970: IGI_IAC_TRANS_HEADERS_PKG.Update_Row(
2971: x_prev_adjustment_id => l_latest_adj_id,

Line 2969: -- the active row in igi_iac_transaction_headers

2965: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted into headers table');
2966:
2967: -- update the previous active row for the asset in igi_iac_transaction_headers
2968: -- in order to make it inactive by setting adjustment_id_out= adjustment_id of
2969: -- the active row in igi_iac_transaction_headers
2970: IGI_IAC_TRANS_HEADERS_PKG.Update_Row(
2971: x_prev_adjustment_id => l_latest_adj_id,
2972: x_adjustment_id => l_adjust_id_reinstate
2973: );

Line 3156: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;

3152: IS
3153:
3154: -- local variables
3155: l_rowid ROWID;
3156: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
3157: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
3158: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
3159: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
3160: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;

Line 3157: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;

3153:
3154: -- local variables
3155: l_rowid ROWID;
3156: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
3157: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
3158: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
3159: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
3160: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
3161: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

Line 3158: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;

3154: -- local variables
3155: l_rowid ROWID;
3156: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
3157: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
3158: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
3159: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
3160: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
3161: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
3162: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;

Line 3159: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;

3155: l_rowid ROWID;
3156: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
3157: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
3158: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
3159: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
3160: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
3161: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
3162: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;
3163:

Line 3160: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;

3156: l_latest_trx_type igi_iac_transaction_headers.transaction_type_code%TYPE;
3157: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
3158: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
3159: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
3160: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
3161: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
3162: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;
3163:
3164: l_path VARCHAR2(150);

Line 3161: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;

3157: l_latest_trx_id igi_iac_transaction_headers.transaction_header_id%TYPE;
3158: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
3159: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
3160: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
3161: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
3162: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;
3163:
3164: l_path VARCHAR2(150);
3165:

Line 3162: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;

3158: l_latest_mref_id igi_iac_transaction_headers.mass_reference_id%TYPE;
3159: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
3160: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
3161: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
3162: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;
3163:
3164: l_path VARCHAR2(150);
3165:
3166: -- exceptions

Line 3185: -- into igi_iac_transaction_headers

3181: RAISE e_latest_trx_not_avail;
3182: END IF;
3183:
3184: -- insert a new row for the asset with transaction type REINSTATEMENT
3185: -- into igi_iac_transaction_headers
3186: l_adjust_id_reinstate := null;
3187: IGI_IAC_TRANS_HEADERS_PKG.Insert_Row(
3188: x_rowid => l_rowid,
3189: x_adjustment_id => l_adjust_id_reinstate, -- out parameter

Line 3207: -- update the previous active row for the asset in igi_iac_transaction_headers

3203: x_event_id => p_event_id
3204: );
3205: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted into headers table');
3206:
3207: -- update the previous active row for the asset in igi_iac_transaction_headers
3208: -- in order to make it inactive by setting adjustment_id_out= adjustment_id of
3209: -- the active row in igi_iac_transaction_headers
3210: IGI_IAC_TRANS_HEADERS_PKG.Update_Row(
3211: x_prev_adjustment_id => l_latest_adj_id,

Line 3209: -- the active row in igi_iac_transaction_headers

3205: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Inserted into headers table');
3206:
3207: -- update the previous active row for the asset in igi_iac_transaction_headers
3208: -- in order to make it inactive by setting adjustment_id_out= adjustment_id of
3209: -- the active row in igi_iac_transaction_headers
3210: IGI_IAC_TRANS_HEADERS_PKG.Update_Row(
3211: x_prev_adjustment_id => l_latest_adj_id,
3212: x_adjustment_id => l_adjust_id_reinstate
3213: );

Line 3378: FROM IGI_IAC_TRANSACTION_HEADERS

3374: p_asset_id fa_transaction_headers.asset_id%TYPE,
3375: P_period_counter number)
3376: IS
3377: SELECT *
3378: FROM IGI_IAC_TRANSACTION_HEADERS
3379: WHERE book_type_code = p_book_type_code
3380: AND period_counter >= p_period_counter
3381: AND asset_id = p_asset_id
3382: AND transaction_type_code='REVALUATION' and transaction_sub_type in ('OCCASSIONAL','PRFOESSIONAL');

Line 3467: -- from igi_iac_transaction_headers

3463: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Obtained GL information');
3464:
3465: -- from the p_retirement_id parameter passed in, retrieve the active
3466: -- transaction_header_id and the associated adjustment_id of the asset
3467: -- from igi_iac_transaction_headers
3468: l_ret_rec.retirement_id := p_retirement_id;
3469: l_mrc_sob_type := null;
3470: IF NOT fa_util_pvt.get_asset_retire_rec(l_ret_rec,
3471: l_mrc_sob_type)