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_ADDITIONS_PKG dependencies on IGI_IAC_DET_BALANCES

Line 941: CURSOR c_get_distributions(p_asset_id igi_iac_det_balances.asset_id%TYPE,

937: WHERE book_type_code = p_book_type_code
938: AND period_counter = p_period_counter
939: AND transaction_type_code = 'ADDITION';
940:
941: CURSOR c_get_distributions(p_asset_id igi_iac_det_balances.asset_id%TYPE,
942: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
943: SELECT distribution_id
944: FROM igi_iac_det_balances
945: WHERE book_type_code = p_book_type_code

Line 942: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS

938: AND period_counter = p_period_counter
939: AND transaction_type_code = 'ADDITION';
940:
941: CURSOR c_get_distributions(p_asset_id igi_iac_det_balances.asset_id%TYPE,
942: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
943: SELECT distribution_id
944: FROM igi_iac_det_balances
945: WHERE book_type_code = p_book_type_code
946: AND asset_id = p_asset_id;

Line 944: FROM igi_iac_det_balances

940:
941: CURSOR c_get_distributions(p_asset_id igi_iac_det_balances.asset_id%TYPE,
942: p_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
943: SELECT distribution_id
944: FROM igi_iac_det_balances
945: WHERE book_type_code = p_book_type_code
946: AND asset_id = p_asset_id;
947:
948: /* Bug 2425914 vgadde 21/06/2002 */

Line 950: CURSOR c_get_revaluation_info(p_asset_id igi_iac_det_balances.asset_id%TYPE) IS

946: AND asset_id = p_asset_id;
947:
948: /* Bug 2425914 vgadde 21/06/2002 */
949: /* Modified query to fecth records created by ADDITION only */
950: CURSOR c_get_revaluation_info(p_asset_id igi_iac_det_balances.asset_id%TYPE) IS
951: SELECT a.revaluation_id
952: FROM igi_iac_revaluations r,igi_iac_reval_asset_rules a
953: WHERE a.revaluation_id = r.revaluation_id
954: AND a.book_type_code = p_book_type_code

Line 983: CURSOR c_get_fa_distributions(cp_asset_id igi_iac_det_balances.asset_id%TYPE,

979: WHERE asset_id = p_asset_id
980: AND book_type_code = p_book_type_code
981: AND revaluation_id = p_revaluation_id;
982:
983: CURSOR c_get_fa_distributions(cp_asset_id igi_iac_det_balances.asset_id%TYPE,
984: cp_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
985: SELECT distribution_id
986: FROM igi_iac_fa_deprn
987: WHERE book_type_code = p_book_type_code

Line 984: cp_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS

980: AND book_type_code = p_book_type_code
981: AND revaluation_id = p_revaluation_id;
982:
983: CURSOR c_get_fa_distributions(cp_asset_id igi_iac_det_balances.asset_id%TYPE,
984: cp_adjustment_id igi_iac_det_balances.adjustment_id%TYPE) IS
985: SELECT distribution_id
986: FROM igi_iac_fa_deprn
987: WHERE book_type_code = p_book_type_code
988: AND asset_id = cp_asset_id

Line 1029: /* Delete records from igi_iac_det_balances */

1025: END IF;
1026:
1027: CLOSE c_get_adjustments;
1028:
1029: /* Delete records from igi_iac_det_balances */
1030: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1031: p_full_path => l_path_name,
1032: p_string => ' Deleting records from igi_iac_det_balances');
1033: FOR l_det_balance IN c_get_distributions(l_asset_info.asset_id,

Line 1032: p_string => ' Deleting records from igi_iac_det_balances');

1028:
1029: /* Delete records from igi_iac_det_balances */
1030: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1031: p_full_path => l_path_name,
1032: p_string => ' Deleting records from igi_iac_det_balances');
1033: FOR l_det_balance IN c_get_distributions(l_asset_info.asset_id,
1034: l_asset_info.adjustment_id) LOOP
1035: igi_iac_det_balances_pkg.delete_row(
1036: x_adjustment_id => l_asset_info.adjustment_id,

Line 1035: igi_iac_det_balances_pkg.delete_row(

1031: p_full_path => l_path_name,
1032: p_string => ' Deleting records from igi_iac_det_balances');
1033: FOR l_det_balance IN c_get_distributions(l_asset_info.asset_id,
1034: l_asset_info.adjustment_id) LOOP
1035: igi_iac_det_balances_pkg.delete_row(
1036: x_adjustment_id => l_asset_info.adjustment_id,
1037: x_asset_id => l_asset_info.asset_id,
1038: x_distribution_id => l_det_balance.distribution_id,
1039: x_book_type_code => p_book_type_code,