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 57: -- Procedure to insert data into IGI_IAC_ADJUSTMENTS

53: dep_expense_catchup NUMBER
54: );
55:
56: -- ===============================================================================
57: -- Procedure to insert data into IGI_IAC_ADJUSTMENTS
58: -- ===============================================================================
59: PROCEDURE insert_data_adj(p_adjustment_id in igi_iac_adjustments.adjustment_id%type,
60: p_book_type_code in igi_iac_adjustments.book_type_code%type,
61: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,

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

55:
56: -- ===============================================================================
57: -- Procedure to insert data into IGI_IAC_ADJUSTMENTS
58: -- ===============================================================================
59: PROCEDURE insert_data_adj(p_adjustment_id in igi_iac_adjustments.adjustment_id%type,
60: p_book_type_code in igi_iac_adjustments.book_type_code%type,
61: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
62: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
63: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,

Line 60: p_book_type_code in igi_iac_adjustments.book_type_code%type,

56: -- ===============================================================================
57: -- Procedure to insert data into IGI_IAC_ADJUSTMENTS
58: -- ===============================================================================
59: PROCEDURE insert_data_adj(p_adjustment_id in igi_iac_adjustments.adjustment_id%type,
60: p_book_type_code in igi_iac_adjustments.book_type_code%type,
61: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
62: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
63: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
64: p_amount in igi_iac_adjustments.amount%type,

Line 61: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,

57: -- Procedure to insert data into IGI_IAC_ADJUSTMENTS
58: -- ===============================================================================
59: PROCEDURE insert_data_adj(p_adjustment_id in igi_iac_adjustments.adjustment_id%type,
60: p_book_type_code in igi_iac_adjustments.book_type_code%type,
61: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
62: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
63: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
64: p_amount in igi_iac_adjustments.amount%type,
65: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,

Line 62: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,

58: -- ===============================================================================
59: PROCEDURE insert_data_adj(p_adjustment_id in igi_iac_adjustments.adjustment_id%type,
60: p_book_type_code in igi_iac_adjustments.book_type_code%type,
61: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
62: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
63: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
64: p_amount in igi_iac_adjustments.amount%type,
65: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
66: p_units_assigned in igi_iac_adjustments.units_assigned%type,

Line 63: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,

59: PROCEDURE insert_data_adj(p_adjustment_id in igi_iac_adjustments.adjustment_id%type,
60: p_book_type_code in igi_iac_adjustments.book_type_code%type,
61: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
62: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
63: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
64: p_amount in igi_iac_adjustments.amount%type,
65: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
66: p_units_assigned in igi_iac_adjustments.units_assigned%type,
67: p_asset_id in igi_iac_adjustments.asset_id%type,

Line 64: p_amount in igi_iac_adjustments.amount%type,

60: p_book_type_code in igi_iac_adjustments.book_type_code%type,
61: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
62: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
63: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
64: p_amount in igi_iac_adjustments.amount%type,
65: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
66: p_units_assigned in igi_iac_adjustments.units_assigned%type,
67: p_asset_id in igi_iac_adjustments.asset_id%type,
68: p_distribution_id in igi_iac_adjustments.distribution_id%type,

Line 65: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,

61: p_code_combination_id in igi_iac_adjustments.code_combination_id%type,
62: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
63: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
64: p_amount in igi_iac_adjustments.amount%type,
65: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
66: p_units_assigned in igi_iac_adjustments.units_assigned%type,
67: p_asset_id in igi_iac_adjustments.asset_id%type,
68: p_distribution_id in igi_iac_adjustments.distribution_id%type,
69: p_period_counter in igi_iac_adjustments.period_counter%type,

Line 66: p_units_assigned in igi_iac_adjustments.units_assigned%type,

62: p_set_of_books_id in igi_iac_adjustments.set_of_books_id%type,
63: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
64: p_amount in igi_iac_adjustments.amount%type,
65: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
66: p_units_assigned in igi_iac_adjustments.units_assigned%type,
67: p_asset_id in igi_iac_adjustments.asset_id%type,
68: p_distribution_id in igi_iac_adjustments.distribution_id%type,
69: p_period_counter in igi_iac_adjustments.period_counter%type,
70: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,

Line 67: p_asset_id in igi_iac_adjustments.asset_id%type,

63: p_dr_cr_flag in igi_iac_adjustments.dr_cr_flag%type,
64: p_amount in igi_iac_adjustments.amount%type,
65: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
66: p_units_assigned in igi_iac_adjustments.units_assigned%type,
67: p_asset_id in igi_iac_adjustments.asset_id%type,
68: p_distribution_id in igi_iac_adjustments.distribution_id%type,
69: p_period_counter in igi_iac_adjustments.period_counter%type,
70: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,
71: p_report_ccid IN igi_iac_adjustments.report_ccid%TYPE,

Line 68: p_distribution_id in igi_iac_adjustments.distribution_id%type,

64: p_amount in igi_iac_adjustments.amount%type,
65: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
66: p_units_assigned in igi_iac_adjustments.units_assigned%type,
67: p_asset_id in igi_iac_adjustments.asset_id%type,
68: p_distribution_id in igi_iac_adjustments.distribution_id%type,
69: p_period_counter in igi_iac_adjustments.period_counter%type,
70: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,
71: p_report_ccid IN igi_iac_adjustments.report_ccid%TYPE,
72: p_event_id IN number

Line 69: p_period_counter in igi_iac_adjustments.period_counter%type,

65: p_adjustment_type in igi_iac_adjustments.adjustment_type%type,
66: p_units_assigned in igi_iac_adjustments.units_assigned%type,
67: p_asset_id in igi_iac_adjustments.asset_id%type,
68: p_distribution_id in igi_iac_adjustments.distribution_id%type,
69: p_period_counter in igi_iac_adjustments.period_counter%type,
70: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,
71: p_report_ccid IN igi_iac_adjustments.report_ccid%TYPE,
72: p_event_id IN number
73: )

Line 70: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,

66: p_units_assigned in igi_iac_adjustments.units_assigned%type,
67: p_asset_id in igi_iac_adjustments.asset_id%type,
68: p_distribution_id in igi_iac_adjustments.distribution_id%type,
69: p_period_counter in igi_iac_adjustments.period_counter%type,
70: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,
71: p_report_ccid IN igi_iac_adjustments.report_ccid%TYPE,
72: p_event_id IN number
73: )
74: IS

Line 71: p_report_ccid IN igi_iac_adjustments.report_ccid%TYPE,

67: p_asset_id in igi_iac_adjustments.asset_id%type,
68: p_distribution_id in igi_iac_adjustments.distribution_id%type,
69: p_period_counter in igi_iac_adjustments.period_counter%type,
70: p_adj_offset_type IN igi_iac_adjustments.adjustment_offset_type%TYPE,
71: p_report_ccid IN igi_iac_adjustments.report_ccid%TYPE,
72: p_event_id IN number
73: )
74: IS
75: l_rowid ROWID;

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

80:
81: l_path := g_path||'insert_data_adj';
82:
83: IF p_amount <> 0 THEN
84: -- Call to TBH for insert into IGI_IAC_ADJUSTMENTS
85: IGI_IAC_ADJUSTMENTS_PKG.insert_row(
86: x_rowid =>l_rowid,
87: x_adjustment_id =>p_adjustment_id,
88: x_book_type_code =>p_book_type_code,

Line 85: IGI_IAC_ADJUSTMENTS_PKG.insert_row(

81: l_path := g_path||'insert_data_adj';
82:
83: IF p_amount <> 0 THEN
84: -- Call to TBH for insert into IGI_IAC_ADJUSTMENTS
85: IGI_IAC_ADJUSTMENTS_PKG.insert_row(
86: x_rowid =>l_rowid,
87: x_adjustment_id =>p_adjustment_id,
88: x_book_type_code =>p_book_type_code,
89: x_code_combination_id =>p_code_combination_id,

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

577: AND period_counter = cp_period_counter
578: AND asset_id = p_asset_id;
579:
580: -- cursor to get the operating expense amount
581: CURSOR c_op_expense_amt(cp_asset_id igi_iac_adjustments.asset_id%TYPE,
582: cp_book_type_code igi_iac_adjustments.book_type_code%TYPE,
583: cp_tfr_prd_counter igi_iac_adjustments.period_counter%TYPE,
584: cp_cur_prd_counter igi_iac_adjustments.period_counter%TYPE
585: )

Line 582: cp_book_type_code igi_iac_adjustments.book_type_code%TYPE,

578: AND asset_id = p_asset_id;
579:
580: -- cursor to get the operating expense amount
581: CURSOR c_op_expense_amt(cp_asset_id igi_iac_adjustments.asset_id%TYPE,
582: cp_book_type_code igi_iac_adjustments.book_type_code%TYPE,
583: cp_tfr_prd_counter igi_iac_adjustments.period_counter%TYPE,
584: cp_cur_prd_counter igi_iac_adjustments.period_counter%TYPE
585: )
586: IS

Line 583: cp_tfr_prd_counter igi_iac_adjustments.period_counter%TYPE,

579:
580: -- cursor to get the operating expense amount
581: CURSOR c_op_expense_amt(cp_asset_id igi_iac_adjustments.asset_id%TYPE,
582: cp_book_type_code igi_iac_adjustments.book_type_code%TYPE,
583: cp_tfr_prd_counter igi_iac_adjustments.period_counter%TYPE,
584: cp_cur_prd_counter igi_iac_adjustments.period_counter%TYPE
585: )
586: IS
587: SELECT nvl(sum(decode(aj.dr_cr_flag, 'CR', 1, -1) *AJ.Amount), 0) op_expense_amt

Line 584: cp_cur_prd_counter igi_iac_adjustments.period_counter%TYPE

580: -- cursor to get the operating expense amount
581: CURSOR c_op_expense_amt(cp_asset_id igi_iac_adjustments.asset_id%TYPE,
582: cp_book_type_code igi_iac_adjustments.book_type_code%TYPE,
583: cp_tfr_prd_counter igi_iac_adjustments.period_counter%TYPE,
584: cp_cur_prd_counter igi_iac_adjustments.period_counter%TYPE
585: )
586: IS
587: SELECT nvl(sum(decode(aj.dr_cr_flag, 'CR', 1, -1) *AJ.Amount), 0) op_expense_amt
588: FROM igi_iac_adjustments aj,

Line 588: FROM igi_iac_adjustments aj,

584: cp_cur_prd_counter igi_iac_adjustments.period_counter%TYPE
585: )
586: IS
587: SELECT nvl(sum(decode(aj.dr_cr_flag, 'CR', 1, -1) *AJ.Amount), 0) op_expense_amt
588: FROM igi_iac_adjustments aj,
589: igi_iac_transaction_headers ith
590: WHERE aj.asset_id = cp_asset_id
591: AND aj.book_type_code = cp_book_type_code
592: AND aj.period_counter BETWEEN cp_tfr_prd_counter AND cp_cur_prd_counter

Line 1040: l_interco_ccid igi_iac_adjustments.code_combination_id%TYPE;

1036: l_transfer_units FA_DISTRIBUTION_HISTORY.units_assigned%TYPE;
1037:
1038: l_interco_count NUMBER;
1039: l_interco_amount NUMBER ;
1040: l_interco_ccid igi_iac_adjustments.code_combination_id%TYPE;
1041: l_interco_drcr_flag igi_iac_adjustments.dr_cr_flag%TYPE;
1042:
1043: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
1044: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;

Line 1041: l_interco_drcr_flag igi_iac_adjustments.dr_cr_flag%TYPE;

1037:
1038: l_interco_count NUMBER;
1039: l_interco_amount NUMBER ;
1040: l_interco_ccid igi_iac_adjustments.code_combination_id%TYPE;
1041: l_interco_drcr_flag igi_iac_adjustments.dr_cr_flag%TYPE;
1042:
1043: l_reval_reserve IGI_IAC_DET_BALANCES.reval_reserve_cost%type;
1044: l_general_fund IGI_IAC_DET_BALANCES.general_fund_acc%type;
1045: l_Backlog_deprn_reserve IGI_IAC_DET_BALANCES.deprn_reserve_backlog%type;

Line 1078: l_reval_ccid igi_iac_adjustments.code_combination_id%TYPE;

1074: l_general_fund_per_sum igi_iac_det_balances.general_fund_per%TYPE ;
1075: l_reval_reserve_backlog_sum igi_iac_det_balances.reval_reserve_backlog%TYPE ;
1076: l_operating_acct_backlog_sum igi_iac_det_balances.operating_acct_backlog%TYPE;
1077:
1078: l_reval_ccid igi_iac_adjustments.code_combination_id%TYPE;
1079: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;
1080: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1081: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1082: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;

Line 1079: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;

1075: l_reval_reserve_backlog_sum igi_iac_det_balances.reval_reserve_backlog%TYPE ;
1076: l_operating_acct_backlog_sum igi_iac_det_balances.operating_acct_backlog%TYPE;
1077:
1078: l_reval_ccid igi_iac_adjustments.code_combination_id%TYPE;
1079: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;
1080: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1081: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1082: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1083: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;

Line 1080: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;

1076: l_operating_acct_backlog_sum igi_iac_det_balances.operating_acct_backlog%TYPE;
1077:
1078: l_reval_ccid igi_iac_adjustments.code_combination_id%TYPE;
1079: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;
1080: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1081: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1082: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1083: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1084: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;

Line 1081: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;

1077:
1078: l_reval_ccid igi_iac_adjustments.code_combination_id%TYPE;
1079: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;
1080: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1081: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1082: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1083: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1084: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1085:

Line 1082: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;

1078: l_reval_ccid igi_iac_adjustments.code_combination_id%TYPE;
1079: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;
1080: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1081: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1082: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1083: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1084: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1085:
1086: l_sob_id igi_iac_adjustments.set_of_books_id%TYPE;

Line 1083: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;

1079: l_gen_fund_ccid igi_iac_adjustments.code_combination_id%TYPE;
1080: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1081: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1082: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1083: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1084: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1085:
1086: l_sob_id igi_iac_adjustments.set_of_books_id%TYPE;
1087: l_coa_id NUMBER;

Line 1084: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;

1080: l_backlog_ccid igi_iac_adjustments.code_combination_id%TYPE;
1081: l_deprn_ccid igi_iac_adjustments.code_combination_id%TYPE;
1082: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1083: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1084: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1085:
1086: l_sob_id igi_iac_adjustments.set_of_books_id%TYPE;
1087: l_coa_id NUMBER;
1088: l_currency VARCHAR2(15);

Line 1086: l_sob_id igi_iac_adjustments.set_of_books_id%TYPE;

1082: l_cost_ccid igi_iac_adjustments.code_combination_id%TYPE;
1083: l_op_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1084: l_expense_ccid igi_iac_adjustments.code_combination_id%TYPE;
1085:
1086: l_sob_id igi_iac_adjustments.set_of_books_id%TYPE;
1087: l_coa_id NUMBER;
1088: l_currency VARCHAR2(15);
1089: l_precision NUMBER;
1090:

Line 1095: l_dist_op_exp igi_iac_adjustments.amount%TYPE;

1091: l_prorate_factor NUMBER;
1092: l_deprn_expense NUMBER;
1093: l_deprn_expense_old_sum NUMBER;
1094: l_deprn_expense_imp_sum NUMBER;
1095: l_dist_op_exp igi_iac_adjustments.amount%TYPE;
1096: l_dist_op_exp_old_sum igi_iac_adjustments.amount%TYPE;
1097: l_dist_op_exp_imp_sum igi_iac_adjustments.amount%TYPE;
1098: l_fa_deprn_expense NUMBER;
1099: l_fa_deprn_expense_old_sum NUMBER;

Line 1096: l_dist_op_exp_old_sum igi_iac_adjustments.amount%TYPE;

1092: l_deprn_expense NUMBER;
1093: l_deprn_expense_old_sum NUMBER;
1094: l_deprn_expense_imp_sum NUMBER;
1095: l_dist_op_exp igi_iac_adjustments.amount%TYPE;
1096: l_dist_op_exp_old_sum igi_iac_adjustments.amount%TYPE;
1097: l_dist_op_exp_imp_sum igi_iac_adjustments.amount%TYPE;
1098: l_fa_deprn_expense NUMBER;
1099: l_fa_deprn_expense_old_sum NUMBER;
1100: l_fa_deprn_expense_imp_sum NUMBER;

Line 1097: l_dist_op_exp_imp_sum igi_iac_adjustments.amount%TYPE;

1093: l_deprn_expense_old_sum NUMBER;
1094: l_deprn_expense_imp_sum NUMBER;
1095: l_dist_op_exp igi_iac_adjustments.amount%TYPE;
1096: l_dist_op_exp_old_sum igi_iac_adjustments.amount%TYPE;
1097: l_dist_op_exp_imp_sum igi_iac_adjustments.amount%TYPE;
1098: l_fa_deprn_expense NUMBER;
1099: l_fa_deprn_expense_old_sum NUMBER;
1100: l_fa_deprn_expense_imp_sum NUMBER;
1101:

Line 1115: l_adj_offset_type igi_iac_adjustments.adjustment_offset_type%TYPE;

1111: l_iac_deprn_period_amount NUMBER;
1112: l_fa_deprn_period_amount NUMBER;
1113: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;
1114:
1115: l_adj_offset_type igi_iac_adjustments.adjustment_offset_type%TYPE;
1116: l_report_ccid igi_iac_adjustments.report_ccid%TYPE;
1117:
1118: l_path VARCHAR2(150);
1119: l_mesg VARCHAR2(500);

Line 1116: l_report_ccid igi_iac_adjustments.report_ccid%TYPE;

1112: l_fa_deprn_period_amount NUMBER;
1113: l_deprn_amount igi_iac_asset_balances.deprn_amount%TYPE;
1114:
1115: l_adj_offset_type igi_iac_adjustments.adjustment_offset_type%TYPE;
1116: l_report_ccid igi_iac_adjustments.report_ccid%TYPE;
1117:
1118: l_path VARCHAR2(150);
1119: l_mesg VARCHAR2(500);
1120:

Line 1518: -- igi_iac_fa_deprn and igi_iac_adjustments

1514: l_expense_ccid
1515: );
1516:
1517: -- prepare distribution data for igi_iac_det_balances
1518: -- igi_iac_fa_deprn and igi_iac_adjustments
1519: -- Rounding All amounts
1520: IF IGI_IAC_COMMON_UTILS.Iac_round(l_reval_reserve,
1521: p_asset_hdr_rec.book_type_code) THEN
1522: null;

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

2537: AND period_counter = p_period_counter;
2538:
2539: /* Cursor to select impacted distributions for roll back */
2540:
2541: CURSOR c_dist(c_adjustment_id igi_iac_adjustments.adjustment_id%type) IS
2542: SELECT distribution_id
2543: FROM igi_iac_det_balances
2544: WHERE adjustment_id=c_adjustment_id;
2545:

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

2542: SELECT distribution_id
2543: FROM igi_iac_det_balances
2544: WHERE adjustment_id=c_adjustment_id;
2545:
2546: CURSOR c_fa_dist(cp_adjustment_id igi_iac_adjustments.adjustment_id%type,
2547: cp_asset_id igi_iac_fa_deprn.asset_id%TYPE) IS
2548: SELECT book_type_code,asset_id,period_counter,distribution_id,adjustment_id
2549: FROM igi_iac_fa_deprn
2550: WHERE asset_id = cp_asset_id

Line 2636: /* DELETE from igi_iac_adjustments

2632: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2633: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Deleting From adjustments...');
2634: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'============================================================');
2635:
2636: /* DELETE from igi_iac_adjustments
2637: WHERE book_type_code=p_book_type_code
2638: AND period_counter=p_period_counter
2639: AND adjustment_id=l_trans_headers.adjustment_id; */
2640:

Line 2641: IGI_IAC_ADJUSTMENTS_PKG.delete_row(

2637: WHERE book_type_code=p_book_type_code
2638: AND period_counter=p_period_counter
2639: AND adjustment_id=l_trans_headers.adjustment_id; */
2640:
2641: IGI_IAC_ADJUSTMENTS_PKG.delete_row(
2642: x_adjustment_id =>l_trans_headers.adjustment_id
2643: );
2644:
2645: OPEN c_prev_data(l_trans_headers.adjustment_id);