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_TRANSFERS_PKG dependencies on IGI_IAC_ADJUSTMENTS

Line 80: -- Procedure to insert data into IGI_IAC_ADJUSTMENTS

76: Raise;
77: END;
78:
79: -- ===============================================================================
80: -- Procedure to insert data into IGI_IAC_ADJUSTMENTS
81: -- ===============================================================================
82: PROCEDURE insert_data_adj(p_adjustment_id in igi_iac_adjustments.adjustment_id%type,
83: p_book_type_code in igi_iac_adjustments.book_type_code%type,
84: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,

Line 82: PROCEDURE insert_data_adj(p_adjustment_id in igi_iac_adjustments.adjustment_id%type,

78:
79: -- ===============================================================================
80: -- Procedure to insert data into IGI_IAC_ADJUSTMENTS
81: -- ===============================================================================
82: PROCEDURE insert_data_adj(p_adjustment_id in igi_iac_adjustments.adjustment_id%type,
83: p_book_type_code in igi_iac_adjustments.book_type_code%type,
84: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
85: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
86: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,

Line 83: p_book_type_code in igi_iac_adjustments.book_type_code%type,

79: -- ===============================================================================
80: -- Procedure to insert data into IGI_IAC_ADJUSTMENTS
81: -- ===============================================================================
82: PROCEDURE insert_data_adj(p_adjustment_id in igi_iac_adjustments.adjustment_id%type,
83: p_book_type_code in igi_iac_adjustments.book_type_code%type,
84: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
85: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
86: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
87: p_amount in igi_iac_adjustments.amount%type,

Line 84: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,

80: -- Procedure to insert data into IGI_IAC_ADJUSTMENTS
81: -- ===============================================================================
82: PROCEDURE insert_data_adj(p_adjustment_id in igi_iac_adjustments.adjustment_id%type,
83: p_book_type_code in igi_iac_adjustments.book_type_code%type,
84: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
85: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
86: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
87: p_amount in igi_iac_adjustments.amount%type,
88: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,

Line 85: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,

81: -- ===============================================================================
82: PROCEDURE insert_data_adj(p_adjustment_id in igi_iac_adjustments.adjustment_id%type,
83: p_book_type_code in igi_iac_adjustments.book_type_code%type,
84: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
85: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
86: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
87: p_amount in igi_iac_adjustments.amount%type,
88: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
89: p_units_assigned in igi_iac_adjustments.units_assigned%type,

Line 86: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,

82: PROCEDURE insert_data_adj(p_adjustment_id in igi_iac_adjustments.adjustment_id%type,
83: p_book_type_code in igi_iac_adjustments.book_type_code%type,
84: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
85: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
86: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
87: p_amount in igi_iac_adjustments.amount%type,
88: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
89: p_units_assigned in igi_iac_adjustments.units_assigned%type,
90: p_asset_id in igi_iac_adjustments.asset_id%type,

Line 87: p_amount in igi_iac_adjustments.amount%type,

83: p_book_type_code in igi_iac_adjustments.book_type_code%type,
84: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
85: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
86: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
87: p_amount in igi_iac_adjustments.amount%type,
88: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
89: p_units_assigned in igi_iac_adjustments.units_assigned%type,
90: p_asset_id in igi_iac_adjustments.asset_id%type,
91: p_distribution_id in igi_iac_adjustments.distribution_id%type,

Line 88: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,

84: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
85: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
86: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
87: p_amount in igi_iac_adjustments.amount%type,
88: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
89: p_units_assigned in igi_iac_adjustments.units_assigned%type,
90: p_asset_id in igi_iac_adjustments.asset_id%type,
91: p_distribution_id in igi_iac_adjustments.distribution_id%type,
92: p_period_counter in igi_iac_adjustments.period_counter%type,

Line 89: p_units_assigned in igi_iac_adjustments.units_assigned%type,

85: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
86: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
87: p_amount in igi_iac_adjustments.amount%type,
88: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
89: p_units_assigned in igi_iac_adjustments.units_assigned%type,
90: p_asset_id in igi_iac_adjustments.asset_id%type,
91: p_distribution_id in igi_iac_adjustments.distribution_id%type,
92: p_period_counter in igi_iac_adjustments.period_counter%type,
93: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,

Line 90: p_asset_id in igi_iac_adjustments.asset_id%type,

86: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
87: p_amount in igi_iac_adjustments.amount%type,
88: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
89: p_units_assigned in igi_iac_adjustments.units_assigned%type,
90: p_asset_id in igi_iac_adjustments.asset_id%type,
91: p_distribution_id in igi_iac_adjustments.distribution_id%type,
92: p_period_counter in igi_iac_adjustments.period_counter%type,
93: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,
94: p_report_ccid IN igi_iac_adjustments.report_ccid%TYPE,

Line 91: p_distribution_id in igi_iac_adjustments.distribution_id%type,

87: p_amount in igi_iac_adjustments.amount%type,
88: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
89: p_units_assigned in igi_iac_adjustments.units_assigned%type,
90: p_asset_id in igi_iac_adjustments.asset_id%type,
91: p_distribution_id in igi_iac_adjustments.distribution_id%type,
92: p_period_counter in igi_iac_adjustments.period_counter%type,
93: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,
94: p_report_ccid IN igi_iac_adjustments.report_ccid%TYPE,
95: p_event_id IN number

Line 92: p_period_counter in igi_iac_adjustments.period_counter%type,

88: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
89: p_units_assigned in igi_iac_adjustments.units_assigned%type,
90: p_asset_id in igi_iac_adjustments.asset_id%type,
91: p_distribution_id in igi_iac_adjustments.distribution_id%type,
92: p_period_counter in igi_iac_adjustments.period_counter%type,
93: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,
94: p_report_ccid IN igi_iac_adjustments.report_ccid%TYPE,
95: p_event_id IN number
96: )

Line 93: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,

89: p_units_assigned in igi_iac_adjustments.units_assigned%type,
90: p_asset_id in igi_iac_adjustments.asset_id%type,
91: p_distribution_id in igi_iac_adjustments.distribution_id%type,
92: p_period_counter in igi_iac_adjustments.period_counter%type,
93: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,
94: p_report_ccid IN igi_iac_adjustments.report_ccid%TYPE,
95: p_event_id IN number
96: )
97: IS

Line 94: p_report_ccid IN igi_iac_adjustments.report_ccid%TYPE,

90: p_asset_id in igi_iac_adjustments.asset_id%type,
91: p_distribution_id in igi_iac_adjustments.distribution_id%type,
92: p_period_counter in igi_iac_adjustments.period_counter%type,
93: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,
94: p_report_ccid IN igi_iac_adjustments.report_ccid%TYPE,
95: p_event_id IN number
96: )
97: IS
98: l_rowid ROWID;

Line 107: -- Call to TBH for insert into IGI_IAC_ADJUSTMENTS

103:
104: l_path := g_path||'insert_data_adj';
105:
106: IF p_amount <> 0 THEN
107: -- Call to TBH for insert into IGI_IAC_ADJUSTMENTS
108: IGI_IAC_ADJUSTMENTS_PKG.insert_row(
109: x_rowid =>l_rowid,
110: x_adjustment_id =>p_adjustment_id,
111: x_book_type_code =>p_book_type_code,

Line 108: IGI_IAC_ADJUSTMENTS_PKG.insert_row(

104: l_path := g_path||'insert_data_adj';
105:
106: IF p_amount <> 0 THEN
107: -- Call to TBH for insert into IGI_IAC_ADJUSTMENTS
108: IGI_IAC_ADJUSTMENTS_PKG.insert_row(
109: x_rowid =>l_rowid,
110: x_adjustment_id =>p_adjustment_id,
111: x_book_type_code =>p_book_type_code,
112: x_code_combination_id =>p_code_combination_id,

Line 651: CURSOR c_op_expense_amt(cp_asset_id igi_iac_adjustments.asset_id%TYPE,

647: AND period_counter = cp_period_counter
648: AND asset_id = p_asset_id;
649:
650: -- cursor to get the operating expense amount
651: CURSOR c_op_expense_amt(cp_asset_id igi_iac_adjustments.asset_id%TYPE,
652: cp_book_type_code igi_iac_adjustments.book_type_code%TYPE,
653: cp_tfr_prd_counter igi_iac_adjustments.period_counter%TYPE,
654: cp_cur_prd_counter igi_iac_adjustments.period_counter%TYPE
655: )

Line 652: cp_book_type_code igi_iac_adjustments.book_type_code%TYPE,

648: AND asset_id = p_asset_id;
649:
650: -- cursor to get the operating expense amount
651: CURSOR c_op_expense_amt(cp_asset_id igi_iac_adjustments.asset_id%TYPE,
652: cp_book_type_code igi_iac_adjustments.book_type_code%TYPE,
653: cp_tfr_prd_counter igi_iac_adjustments.period_counter%TYPE,
654: cp_cur_prd_counter igi_iac_adjustments.period_counter%TYPE
655: )
656: IS

Line 653: cp_tfr_prd_counter igi_iac_adjustments.period_counter%TYPE,

649:
650: -- cursor to get the operating expense amount
651: CURSOR c_op_expense_amt(cp_asset_id igi_iac_adjustments.asset_id%TYPE,
652: cp_book_type_code igi_iac_adjustments.book_type_code%TYPE,
653: cp_tfr_prd_counter igi_iac_adjustments.period_counter%TYPE,
654: cp_cur_prd_counter igi_iac_adjustments.period_counter%TYPE
655: )
656: IS
657: SELECT nvl(sum(decode(aj.dr_cr_flag, 'CR', 1, -1) *AJ.Amount), 0) op_expense_amt

Line 654: cp_cur_prd_counter igi_iac_adjustments.period_counter%TYPE

650: -- cursor to get the operating expense amount
651: CURSOR c_op_expense_amt(cp_asset_id igi_iac_adjustments.asset_id%TYPE,
652: cp_book_type_code igi_iac_adjustments.book_type_code%TYPE,
653: cp_tfr_prd_counter igi_iac_adjustments.period_counter%TYPE,
654: cp_cur_prd_counter igi_iac_adjustments.period_counter%TYPE
655: )
656: IS
657: SELECT nvl(sum(decode(aj.dr_cr_flag, 'CR', 1, -1) *AJ.Amount), 0) op_expense_amt
658: FROM igi_iac_adjustments aj,

Line 658: FROM igi_iac_adjustments aj,

654: cp_cur_prd_counter igi_iac_adjustments.period_counter%TYPE
655: )
656: IS
657: SELECT nvl(sum(decode(aj.dr_cr_flag, 'CR', 1, -1) *AJ.Amount), 0) op_expense_amt
658: FROM igi_iac_adjustments aj,
659: igi_iac_transaction_headers ith
660: WHERE aj.asset_id = cp_asset_id
661: AND aj.book_type_code = cp_book_type_code
662: AND aj.period_counter BETWEEN cp_tfr_prd_counter AND cp_cur_prd_counter

Line 1131: l_interco_ccid igi_iac_adjustments.code_combination_id%TYPE;

1127: l_transfer_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1128:
1129: l_interco_count NUMBER;
1130: l_interco_amount NUMBER ;
1131: l_interco_ccid igi_iac_adjustments.code_combination_id%TYPE;
1132: l_interco_drcr_flag igi_iac_adjustments.dr_cr_flag%TYPE;
1133:
1134: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
1135: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;

Line 1132: l_interco_drcr_flag igi_iac_adjustments.dr_cr_flag%TYPE;

1128:
1129: l_interco_count NUMBER;
1130: l_interco_amount NUMBER ;
1131: l_interco_ccid igi_iac_adjustments.code_combination_id%TYPE;
1132: l_interco_drcr_flag igi_iac_adjustments.dr_cr_flag%TYPE;
1133:
1134: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
1135: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
1136: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;

Line 1169: l_reval_ccid igi_iac_adjustments.code_combination_id%TYPE;

1165: l_general_fund_per_sum igi_iac_det_balances.general_fund_per%TYPE ;
1166: l_reval_reserve_backlog_sum igi_iac_det_balances.reval_reserve_backlog%TYPE ;
1167: l_operating_acct_backlog_sum igi_iac_det_balances.operating_acct_backlog%TYPE;
1168:
1169: l_reval_ccid igi_iac_adjustments.code_combination_id%TYPE;
1170: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;
1171: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1172: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1173: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;

Line 1170: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;

1166: l_reval_reserve_backlog_sum igi_iac_det_balances.reval_reserve_backlog%TYPE ;
1167: l_operating_acct_backlog_sum igi_iac_det_balances.operating_acct_backlog%TYPE;
1168:
1169: l_reval_ccid igi_iac_adjustments.code_combination_id%TYPE;
1170: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;
1171: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1172: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1173: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1174: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;

Line 1171: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;

1167: l_operating_acct_backlog_sum igi_iac_det_balances.operating_acct_backlog%TYPE;
1168:
1169: l_reval_ccid igi_iac_adjustments.code_combination_id%TYPE;
1170: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;
1171: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1172: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1173: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1174: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1175: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;

Line 1172: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;

1168:
1169: l_reval_ccid igi_iac_adjustments.code_combination_id%TYPE;
1170: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;
1171: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1172: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1173: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1174: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1175: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1176:

Line 1173: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;

1169: l_reval_ccid igi_iac_adjustments.code_combination_id%TYPE;
1170: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;
1171: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1172: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1173: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1174: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1175: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1176:
1177: l_sob_id igi_iac_adjustments.set_of_books_id%TYPE;

Line 1174: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;

1170: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;
1171: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1172: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1173: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1174: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1175: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1176:
1177: l_sob_id igi_iac_adjustments.set_of_books_id%TYPE;
1178: l_coa_id NUMBER;

Line 1175: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;

1171: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1172: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1173: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1174: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1175: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1176:
1177: l_sob_id igi_iac_adjustments.set_of_books_id%TYPE;
1178: l_coa_id NUMBER;
1179: l_currency VARCHAR2(15);

Line 1177: l_sob_id igi_iac_adjustments.set_of_books_id%TYPE;

1173: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1174: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1175: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1176:
1177: l_sob_id igi_iac_adjustments.set_of_books_id%TYPE;
1178: l_coa_id NUMBER;
1179: l_currency VARCHAR2(15);
1180: l_precision NUMBER;
1181:

Line 1186: l_dist_op_exp igi_iac_adjustments.amount%TYPE;

1182: l_prorate_factor NUMBER;
1183: l_deprn_expense NUMBER;
1184: l_deprn_expense_old_sum NUMBER;
1185: l_deprn_expense_imp_sum NUMBER;
1186: l_dist_op_exp igi_iac_adjustments.amount%TYPE;
1187: l_dist_op_exp_old_sum igi_iac_adjustments.amount%TYPE;
1188: l_dist_op_exp_imp_sum igi_iac_adjustments.amount%TYPE;
1189: l_fa_deprn_expense NUMBER;
1190: l_fa_deprn_expense_old_sum NUMBER;

Line 1187: l_dist_op_exp_old_sum igi_iac_adjustments.amount%TYPE;

1183: l_deprn_expense NUMBER;
1184: l_deprn_expense_old_sum NUMBER;
1185: l_deprn_expense_imp_sum NUMBER;
1186: l_dist_op_exp igi_iac_adjustments.amount%TYPE;
1187: l_dist_op_exp_old_sum igi_iac_adjustments.amount%TYPE;
1188: l_dist_op_exp_imp_sum igi_iac_adjustments.amount%TYPE;
1189: l_fa_deprn_expense NUMBER;
1190: l_fa_deprn_expense_old_sum NUMBER;
1191: l_fa_deprn_expense_imp_sum NUMBER;

Line 1188: l_dist_op_exp_imp_sum igi_iac_adjustments.amount%TYPE;

1184: l_deprn_expense_old_sum NUMBER;
1185: l_deprn_expense_imp_sum NUMBER;
1186: l_dist_op_exp igi_iac_adjustments.amount%TYPE;
1187: l_dist_op_exp_old_sum igi_iac_adjustments.amount%TYPE;
1188: l_dist_op_exp_imp_sum igi_iac_adjustments.amount%TYPE;
1189: l_fa_deprn_expense NUMBER;
1190: l_fa_deprn_expense_old_sum NUMBER;
1191: l_fa_deprn_expense_imp_sum NUMBER;
1192:

Line 1206: l_adj_offset_type igi_iac_adjustments.adjustment_offset_type%TYPE;

1202: l_iac_deprn_period_amount NUMBER;
1203: l_fa_deprn_period_amount NUMBER;
1204: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;
1205:
1206: l_adj_offset_type igi_iac_adjustments.adjustment_offset_type%TYPE;
1207: l_report_ccid igi_iac_adjustments.report_ccid%TYPE;
1208:
1209: l_path VARCHAR2(150);
1210: l_mesg VARCHAR2(500);

Line 1207: l_report_ccid igi_iac_adjustments.report_ccid%TYPE;

1203: l_fa_deprn_period_amount NUMBER;
1204: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;
1205:
1206: l_adj_offset_type igi_iac_adjustments.adjustment_offset_type%TYPE;
1207: l_report_ccid igi_iac_adjustments.report_ccid%TYPE;
1208:
1209: l_path VARCHAR2(150);
1210: l_mesg VARCHAR2(500);
1211:

Line 1686: -- igi_iac_fa_deprn and igi_iac_adjustments

1682: RETURN FALSE;
1683: END IF;
1684:
1685: -- prepare distribution data for igi_iac_det_balances
1686: -- igi_iac_fa_deprn and igi_iac_adjustments
1687: -- Rounding All amounts
1688: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve,
1689: p_asset_hdr_rec.book_type_code) THEN
1690: null;

Line 2780: CURSOR c_dist(c_adjustment_id igi_iac_adjustments.adjustment_id%type) IS

2776: AND period_counter = p_period_counter;
2777:
2778: /* Cursor to select impacted distributions for roll back */
2779:
2780: CURSOR c_dist(c_adjustment_id igi_iac_adjustments.adjustment_id%type) IS
2781: SELECT distribution_id
2782: FROM igi_iac_det_balances
2783: WHERE adjustment_id=c_adjustment_id;
2784:

Line 2785: CURSOR c_fa_dist(cp_adjustment_id igi_iac_adjustments.adjustment_id%type,

2781: SELECT distribution_id
2782: FROM igi_iac_det_balances
2783: WHERE adjustment_id=c_adjustment_id;
2784:
2785: CURSOR c_fa_dist(cp_adjustment_id igi_iac_adjustments.adjustment_id%type,
2786: cp_asset_id igi_iac_fa_deprn.asset_id%TYPE) IS
2787: SELECT book_type_code,asset_id,period_counter,distribution_id,adjustment_id
2788: FROM igi_iac_fa_deprn
2789: WHERE asset_id = cp_asset_id

Line 2875: /* DELETE from igi_iac_adjustments

2871: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2872: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From adjustments...');
2873: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2874:
2875: /* DELETE from igi_iac_adjustments
2876: WHERE book_type_code=p_book_type_code
2877: AND period_counter=p_period_counter
2878: AND adjustment_id=l_trans_headers.adjustment_id; */
2879:

Line 2880: IGI_IAC_ADJUSTMENTS_PKG.delete_row(

2876: WHERE book_type_code=p_book_type_code
2877: AND period_counter=p_period_counter
2878: AND adjustment_id=l_trans_headers.adjustment_id; */
2879:
2880: IGI_IAC_ADJUSTMENTS_PKG.delete_row(
2881: x_adjustment_id =>l_trans_headers.adjustment_id
2882: );
2883:
2884: OPEN c_prev_data(l_trans_headers.adjustment_id);