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_ADJUSTMENTS

Line 557: l_ccid igi_iac_adjustments.code_combination_id%TYPE;

553: l_ab_deprn_reserve NUMBER := 0;
554: l_ab_backlog_deprn_reserve NUMBER := 0;
555: l_ab_general_fund NUMBER := 0;
556:
557: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
558: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
559: l_exists NUMBER;
560: l_fully_reserved NUMBER;
561:

Line 558: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;

554: l_ab_backlog_deprn_reserve NUMBER := 0;
555: l_ab_general_fund NUMBER := 0;
556:
557: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
558: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
559: l_exists NUMBER;
560: l_fully_reserved NUMBER;
561:
562: l_ret_ass_bal c_ret_ass_bal%ROWTYPE;

Line 810: -- insert into igi_iac_adjustments

806: --RETURN false;
807: g_message := 'No account code combination found for Depreciation Expense';
808: RAISE e_no_ccid_found;
809: END IF;
810: -- insert into igi_iac_adjustments
811: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
812: x_rowid => l_rowid,
813: x_adjustment_id => p_adjust_id_reinstate,
814: x_book_type_code => g_book_type_code,

Line 811: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

807: g_message := 'No account code combination found for Depreciation Expense';
808: RAISE e_no_ccid_found;
809: END IF;
810: -- insert into igi_iac_adjustments
811: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
812: x_rowid => l_rowid,
813: x_adjustment_id => p_adjust_id_reinstate,
814: x_book_type_code => g_book_type_code,
815: x_code_combination_id => l_ccid,

Line 830: -- insert RESERVE journal into igi_iac_adjustments with the reserve catchup amount

826: x_period_counter => p_period_counter,
827: x_mode => 'R',
828: x_event_id => p_event_id );
829: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Done Expense: '||l_rsv_catchup_amt);
830: -- insert RESERVE journal into igi_iac_adjustments with the reserve catchup amount
831: -- get the ccid for the account type
832: IF NOT igi_iac_common_utils.get_account_ccid(g_book_type_code,
833: g_asset_id,
834: l_ren_dist_id,

Line 844: -- insert into igi_iac_adjustments

840: --RETURN false;
841: g_message := 'No account code combination found for Accumulated Depreciation';
842: RAISE e_no_ccid_found;
843: END IF;
844: -- insert into igi_iac_adjustments
845: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
846: x_rowid => l_rowid,
847: x_adjustment_id => p_adjust_id_reinstate,
848: x_book_type_code => g_book_type_code,

Line 845: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

841: g_message := 'No account code combination found for Accumulated Depreciation';
842: RAISE e_no_ccid_found;
843: END IF;
844: -- insert into igi_iac_adjustments
845: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
846: x_rowid => l_rowid,
847: x_adjustment_id => p_adjust_id_reinstate,
848: x_book_type_code => g_book_type_code,
849: x_code_combination_id => l_ccid,

Line 864: -- insert GENERAL FUND journal into igi_iac_adjustments with the catchup amount

860: x_period_counter => p_period_counter,
861: x_mode => 'R',
862: x_event_id => p_event_id );
863: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Done Deprn Reserve: '||l_rsv_catchup_amt);
864: -- insert GENERAL FUND journal into igi_iac_adjustments with the catchup amount
865: -- only if adjustment amount is greater than zero
866: IF (l_det_bal.adjustment_cost > 0) THEN
867: -- get the ccid for the account type Reval Reserve
868: IF NOT igi_iac_common_utils.get_account_ccid(g_book_type_code,

Line 883: -- insert into igi_iac_adjustments

879: END IF;
880:
881: l_reval_rsv_ccid := l_ccid;
882:
883: -- insert into igi_iac_adjustments
884: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
885: x_rowid => l_rowid,
886: x_adjustment_id => p_adjust_id_reinstate,
887: x_book_type_code => g_book_type_code,

Line 884: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

880:
881: l_reval_rsv_ccid := l_ccid;
882:
883: -- insert into igi_iac_adjustments
884: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
885: x_rowid => l_rowid,
886: x_adjustment_id => p_adjust_id_reinstate,
887: x_book_type_code => g_book_type_code,
888: x_code_combination_id => l_ccid,

Line 916: -- insert into igi_iac_adjustments

912: --RETURN false;
913: g_message := 'No account code combination found for General Fund';
914: RAISE e_no_ccid_found;
915: END IF;
916: -- insert into igi_iac_adjustments
917: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
918: x_rowid => l_rowid,
919: x_adjustment_id => p_adjust_id_reinstate,
920: x_book_type_code => g_book_type_code,

Line 917: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

913: g_message := 'No account code combination found for General Fund';
914: RAISE e_no_ccid_found;
915: END IF;
916: -- insert into igi_iac_adjustments
917: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
918: x_rowid => l_rowid,
919: x_adjustment_id => p_adjust_id_reinstate,
920: x_book_type_code => g_book_type_code,
921: x_code_combination_id => l_ccid,

Line 1205: l_ccid igi_iac_adjustments.code_combination_id%TYPE;

1201: l_latest_dep_rsv NUMBER;
1202: l_latest_gen_fund NUMBER;
1203: l_latest_rev_rsv NUMBER;
1204:
1205: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
1206: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
1207: l_elapsed_periods NUMBER;
1208:
1209: l_exists NUMBER;

Line 1206: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;

1202: l_latest_gen_fund NUMBER;
1203: l_latest_rev_rsv NUMBER;
1204:
1205: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
1206: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
1207: l_elapsed_periods NUMBER;
1208:
1209: l_exists NUMBER;
1210: l_ret_ass_bal c_ret_ass_bal%ROWTYPE;

Line 1531: -- insert into igi_iac_adjustments

1527: -- depreciation expense catchup
1528: l_rsv_catchup := (l_deprn_period - l_latest_dep_exp)*l_elapsed_periods;
1529: do_round(l_rsv_catchup,g_book_type_code);
1530:
1531: -- insert into igi_iac_adjustments
1532: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
1533: x_rowid => l_rowid,
1534: x_adjustment_id => p_adjust_id_reinstate,
1535: x_book_type_code => g_book_type_code,

Line 1532: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

1528: l_rsv_catchup := (l_deprn_period - l_latest_dep_exp)*l_elapsed_periods;
1529: do_round(l_rsv_catchup,g_book_type_code);
1530:
1531: -- insert into igi_iac_adjustments
1532: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
1533: x_rowid => l_rowid,
1534: x_adjustment_id => p_adjust_id_reinstate,
1535: x_book_type_code => g_book_type_code,
1536: x_code_combination_id => l_ccid,

Line 1553: -- insert RESERVE journal into igi_iac_adjustments with the reserve catchup amount

1549: x_event_id => p_event_id
1550: );
1551: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Done Expense: '||l_rsv_catchup);
1552:
1553: -- insert RESERVE journal into igi_iac_adjustments with the reserve catchup amount
1554: -- calculate the catchup amount
1555: --l_de_catchup := l_deprn_reserve - l_latest_dep_rsv;
1556: -- get the ccid for the account type
1557: IF NOT igi_iac_common_utils.get_account_ccid(g_book_type_code,

Line 1570: -- insert into igi_iac_adjustments

1566: g_message := 'No account code combination found for Accumulated Depreciation';
1567: RAISE e_no_ccid_found;
1568: END IF;
1569:
1570: -- insert into igi_iac_adjustments
1571: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
1572: x_rowid => l_rowid,
1573: x_adjustment_id => p_adjust_id_reinstate,
1574: x_book_type_code => g_book_type_code,

Line 1571: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

1567: RAISE e_no_ccid_found;
1568: END IF;
1569:
1570: -- insert into igi_iac_adjustments
1571: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
1572: x_rowid => l_rowid,
1573: x_adjustment_id => p_adjust_id_reinstate,
1574: x_book_type_code => g_book_type_code,
1575: x_code_combination_id => l_ccid,

Line 1592: -- insert GENERAL FUND a REVAL RESERVE journal into igi_iac_adjustments with the catchup amount

1588: x_event_id => p_event_id
1589: );
1590: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Done Reserve: '|| l_rsv_catchup);
1591:
1592: -- insert GENERAL FUND a REVAL RESERVE journal into igi_iac_adjustments with the catchup amount
1593: -- only if adjustment amount is greater than zero
1594: IF (l_det_bal.adjustment_cost > 0) THEN
1595: -- get the ccid for the account type REVAL RESERVE
1596: IF NOT igi_iac_common_utils.get_account_ccid(g_book_type_code,

Line 1611: -- insert into igi_iac_adjustments

1607: END IF;
1608:
1609: l_reval_rsv_ccid := l_ccid;
1610:
1611: -- insert into igi_iac_adjustments
1612: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
1613: x_rowid => l_rowid,
1614: x_adjustment_id => p_adjust_id_reinstate,
1615: x_book_type_code => g_book_type_code,

Line 1612: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

1608:
1609: l_reval_rsv_ccid := l_ccid;
1610:
1611: -- insert into igi_iac_adjustments
1612: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
1613: x_rowid => l_rowid,
1614: x_adjustment_id => p_adjust_id_reinstate,
1615: x_book_type_code => g_book_type_code,
1616: x_code_combination_id => l_ccid,

Line 1646: -- insert into igi_iac_adjustments

1642: --RETURN false;
1643: g_message := 'No account code combination found for General Fund';
1644: RAISE e_no_ccid_found;
1645: END IF;
1646: -- insert into igi_iac_adjustments
1647: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
1648: x_rowid => l_rowid,
1649: x_adjustment_id => p_adjust_id_reinstate,
1650: x_book_type_code => g_book_type_code,

Line 1647: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

1643: g_message := 'No account code combination found for General Fund';
1644: RAISE e_no_ccid_found;
1645: END IF;
1646: -- insert into igi_iac_adjustments
1647: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
1648: x_rowid => l_rowid,
1649: x_adjustment_id => p_adjust_id_reinstate,
1650: x_book_type_code => g_book_type_code,
1651: x_code_combination_id => l_ccid,

Line 1981: l_ccid igi_iac_adjustments.code_combination_id%TYPE;

1977: l_units_after NUMBER;
1978: l_elapsed_periods NUMBER := 0;
1979: l_ret_type VARCHAR2(4);
1980:
1981: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
1982: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
1983:
1984: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;
1985: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;

Line 1982: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;

1978: l_elapsed_periods NUMBER := 0;
1979: l_ret_type VARCHAR2(4);
1980:
1981: l_ccid igi_iac_adjustments.code_combination_id%TYPE;
1982: l_reval_rsv_ccid igi_iac_adjustments.code_combination_id%TYPE;
1983:
1984: l_rsv_catchup_amt igi_iac_det_balances.deprn_period%TYPE;
1985: l_gf_catchup_amt igi_iac_det_balances.general_fund_acc%TYPE;
1986: l_adjustment_cost NUMBER;

Line 2305: -- insert into igi_iac_adjustments

2301: --RETURN false;
2302: g_message := 'No account code combination found for Depreciation Expense';
2303: RAISE e_no_ccid_found;
2304: END IF;
2305: -- insert into igi_iac_adjustments
2306: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2307: x_rowid => l_rowid,
2308: x_adjustment_id => p_adjust_id_reinstate,
2309: x_book_type_code => g_book_type_code,

Line 2306: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

2302: g_message := 'No account code combination found for Depreciation Expense';
2303: RAISE e_no_ccid_found;
2304: END IF;
2305: -- insert into igi_iac_adjustments
2306: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2307: x_rowid => l_rowid,
2308: x_adjustment_id => p_adjust_id_reinstate,
2309: x_book_type_code => g_book_type_code,
2310: x_code_combination_id => l_ccid,

Line 2326: -- insert RESERVE journal into igi_iac_adjustments with the reserve catchup amount

2322: x_mode => 'R',
2323: x_event_id => p_event_id
2324: );
2325: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'FULL:Done Expense: '||l_rsv_catchup_amt);
2326: -- insert RESERVE journal into igi_iac_adjustments with the reserve catchup amount
2327: -- get the ccid for the account type
2328: IF NOT igi_iac_common_utils.get_account_ccid(g_book_type_code,
2329: g_asset_id,
2330: l_ren_dist_id,

Line 2340: -- insert into igi_iac_adjustments

2336: --RETURN false;
2337: g_message := 'No account code combination found for Accumulated Depreciation';
2338: RAISE e_no_ccid_found;
2339: END IF;
2340: -- insert into igi_iac_adjustments
2341: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2342: x_rowid => l_rowid,
2343: x_adjustment_id => p_adjust_id_reinstate,
2344: x_book_type_code => g_book_type_code,

Line 2341: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

2337: g_message := 'No account code combination found for Accumulated Depreciation';
2338: RAISE e_no_ccid_found;
2339: END IF;
2340: -- insert into igi_iac_adjustments
2341: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2342: x_rowid => l_rowid,
2343: x_adjustment_id => p_adjust_id_reinstate,
2344: x_book_type_code => g_book_type_code,
2345: x_code_combination_id => l_ccid,

Line 2361: -- insert GENERAL FUND journal into igi_iac_adjustments with the catchup amount

2357: x_mode => 'R',
2358: x_event_id => p_event_id
2359: );
2360: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'FULL:Done Deprn Reserve: '||l_rsv_catchup_amt);
2361: -- insert GENERAL FUND journal into igi_iac_adjustments with the catchup amount
2362: -- only if adjustment amount is greater than zero
2363: IF (l_det_bal.adjustment_cost > 0) THEN
2364: -- get the ccid for the account type Reval Reserve
2365: IF NOT igi_iac_common_utils.get_account_ccid(g_book_type_code,

Line 2380: -- insert into igi_iac_adjustments

2376: END IF;
2377:
2378: l_reval_rsv_ccid := l_ccid;
2379:
2380: -- insert into igi_iac_adjustments
2381: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2382: x_rowid => l_rowid,
2383: x_adjustment_id => p_adjust_id_reinstate,
2384: x_book_type_code => g_book_type_code,

Line 2381: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

2377:
2378: l_reval_rsv_ccid := l_ccid;
2379:
2380: -- insert into igi_iac_adjustments
2381: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2382: x_rowid => l_rowid,
2383: x_adjustment_id => p_adjust_id_reinstate,
2384: x_book_type_code => g_book_type_code,
2385: x_code_combination_id => l_ccid,

Line 2414: -- insert into igi_iac_adjustments

2410: --RETURN false;
2411: g_message := 'No account code combination found for General Fund';
2412: RAISE e_no_ccid_found;
2413: END IF;
2414: -- insert into igi_iac_adjustments
2415: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2416: x_rowid => l_rowid,
2417: x_adjustment_id => p_adjust_id_reinstate,
2418: x_book_type_code => g_book_type_code,

Line 2415: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

2411: g_message := 'No account code combination found for General Fund';
2412: RAISE e_no_ccid_found;
2413: END IF;
2414: -- insert into igi_iac_adjustments
2415: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2416: x_rowid => l_rowid,
2417: x_adjustment_id => p_adjust_id_reinstate,
2418: x_book_type_code => g_book_type_code,
2419: x_code_combination_id => l_ccid,

Line 2555: -- insert into igi_iac_adjustments

2551: -- depreciation expense catchup
2552: l_rsv_catchup := (l_deprn_period - l_latest_dep_exp)*l_elapsed_periods;
2553: do_round(l_rsv_catchup,g_book_type_code);
2554:
2555: -- insert into igi_iac_adjustments
2556: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2557: x_rowid => l_rowid,
2558: x_adjustment_id => p_adjust_id_reinstate,
2559: x_book_type_code => g_book_type_code,

Line 2556: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

2552: l_rsv_catchup := (l_deprn_period - l_latest_dep_exp)*l_elapsed_periods;
2553: do_round(l_rsv_catchup,g_book_type_code);
2554:
2555: -- insert into igi_iac_adjustments
2556: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2557: x_rowid => l_rowid,
2558: x_adjustment_id => p_adjust_id_reinstate,
2559: x_book_type_code => g_book_type_code,
2560: x_code_combination_id => l_ccid,

Line 2575: -- insert RESERVE journal into igi_iac_adjustments with the reserve catchup amount

2571: x_period_counter => p_period_counter,
2572: x_mode => 'R',
2573: x_event_id => p_event_id );
2574: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'PARTIAL:Done Expense: '||l_rsv_catchup);
2575: -- insert RESERVE journal into igi_iac_adjustments with the reserve catchup amount
2576: -- get the ccid for the account type
2577: IF NOT igi_iac_common_utils.get_account_ccid(g_book_type_code,
2578: g_asset_id,
2579: l_ren_dist_id,

Line 2589: -- insert into igi_iac_adjustments

2585: --RETURN false;
2586: g_message := 'No account code combination found for Accumulated Depreciation';
2587: RAISE e_no_ccid_found;
2588: END IF;
2589: -- insert into igi_iac_adjustments
2590: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2591: x_rowid => l_rowid,
2592: x_adjustment_id => p_adjust_id_reinstate,
2593: x_book_type_code => g_book_type_code,

Line 2590: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

2586: g_message := 'No account code combination found for Accumulated Depreciation';
2587: RAISE e_no_ccid_found;
2588: END IF;
2589: -- insert into igi_iac_adjustments
2590: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2591: x_rowid => l_rowid,
2592: x_adjustment_id => p_adjust_id_reinstate,
2593: x_book_type_code => g_book_type_code,
2594: x_code_combination_id => l_ccid,

Line 2609: -- insert GENERAL FUND journal into igi_iac_adjustments with the catchup amount

2605: x_period_counter => p_period_counter,
2606: x_mode => 'R',
2607: x_event_id => p_event_id );
2608: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'PARTIAL:Done Dep Reserve: '||l_rsv_catchup);
2609: -- insert GENERAL FUND journal into igi_iac_adjustments with the catchup amount
2610: -- only if adjustment amount is greater than zero
2611: IF (l_det_bal.adjustment_cost > 0) THEN
2612: -- get the ccid for the account type Revaluaion Reserve
2613: IF NOT igi_iac_common_utils.get_account_ccid(g_book_type_code,

Line 2628: -- insert into igi_iac_adjustments

2624: END IF;
2625:
2626: l_reval_rsv_ccid := l_ccid;
2627:
2628: -- insert into igi_iac_adjustments
2629: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2630: x_rowid => l_rowid,
2631: x_adjustment_id => p_adjust_id_reinstate,
2632: x_book_type_code => g_book_type_code,

Line 2629: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

2625:
2626: l_reval_rsv_ccid := l_ccid;
2627:
2628: -- insert into igi_iac_adjustments
2629: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2630: x_rowid => l_rowid,
2631: x_adjustment_id => p_adjust_id_reinstate,
2632: x_book_type_code => g_book_type_code,
2633: x_code_combination_id => l_ccid,

Line 2663: -- insert into igi_iac_adjustments

2659: g_message := 'No account code combination found for General Fund';
2660: RAISE e_no_ccid_found;
2661: END IF;
2662:
2663: -- insert into igi_iac_adjustments
2664: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2665: x_rowid => l_rowid,
2666: x_adjustment_id => p_adjust_id_reinstate,
2667: x_book_type_code => g_book_type_code,

Line 2664: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

2660: RAISE e_no_ccid_found;
2661: END IF;
2662:
2663: -- insert into igi_iac_adjustments
2664: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
2665: x_rowid => l_rowid,
2666: x_adjustment_id => p_adjust_id_reinstate,
2667: x_book_type_code => g_book_type_code,
2668: x_code_combination_id => l_ccid,

Line 2941: FROM igi_iac_adjustments iaa,

2937: iaa.distribution_id,
2938: iaa.period_counter,
2939: iaa.adjustment_offset_type,
2940: iaa.report_ccid
2941: FROM igi_iac_adjustments iaa,
2942: igi_iac_transaction_headers iath
2943: WHERE iaa.adjustment_id = iath.adjustment_id
2944: AND iath.transaction_header_id = p_trx_header_id;
2945:

Line 2955: l_dr_cr_flag igi_iac_adjustments.dr_cr_flag%TYPE;

2951: l_latest_adj_id igi_iac_transaction_headers.adjustment_id%TYPE;
2952: l_latest_adj_status igi_iac_transaction_headers.adjustment_status%TYPE;
2953: l_prev_adjustment_id igi_iac_transaction_headers.adjustment_id%TYPE;
2954: l_adjust_id_reinstate igi_iac_transaction_headers.adjustment_id%TYPE;
2955: l_dr_cr_flag igi_iac_adjustments.dr_cr_flag%TYPE;
2956: l_ren_dist_id igi_iac_det_balances.distribution_id%TYPE;
2957: l_units_assigned fa_distribution_history.units_assigned%TYPE;
2958:
2959: l_path VARCHAR2(150);

Line 3017: -- find all the journal entries for the retirement from igi_iac_adjustments

3013: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Updated Headers table');
3014: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Latest adjustment id: '||l_latest_adj_id);
3015: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Reinstatement adjustment id: '||l_adjust_id_reinstate);
3016:
3017: -- find all the journal entries for the retirement from igi_iac_adjustments
3018: -- and create reverse journal entries for each of them for reinstatement
3019: FOR l_reverse_je IN c_reverse_je(p_fa_ret_rec.detail_info.transaction_header_id_in) LOOP
3020:
3021: -- the dr_cr_flag will reverse, if it was DR then it will become CR

Line 3044: -- insert into igi_iac_adjustments

3040: INTO l_units_assigned
3041: FROM fa_distribution_history
3042: WHERE distribution_id = l_reverse_je.distribution_id;
3043:
3044: -- insert into igi_iac_adjustments
3045: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
3046: x_rowid => l_rowid,
3047: x_adjustment_id => l_adjust_id_reinstate,
3048: x_book_type_code => l_reverse_je.book_type_code,

Line 3045: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(

3041: FROM fa_distribution_history
3042: WHERE distribution_id = l_reverse_je.distribution_id;
3043:
3044: -- insert into igi_iac_adjustments
3045: IGI_IAC_ADJUSTMENTS_PKG.Insert_Row(
3046: x_rowid => l_rowid,
3047: x_adjustment_id => l_adjust_id_reinstate,
3048: x_book_type_code => l_reverse_je.book_type_code,
3049: x_code_combination_id => l_reverse_je.code_combination_id,