APPS.IGI_IAC_ADDITIONS_PKG dependencies on IGI_IAC_REVALUATIONS

Line 349: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;

345: l_fa_asset_info igi_iac_types.iac_reval_fa_asset_info_tab;
346: l_reval_params igi_iac_types.iac_reval_params;
347: l_reval_asset igi_iac_types.iac_reval_input_asset;
348: l_reval_asset_out igi_iac_types.iac_reval_output_asset;
349: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;
350: l_user_id NUMBER DEFAULT fnd_global.user_id;
351: l_login_id NUMBER DEFAULT fnd_global.login_id;
352: l_current_reval_factor igi_iac_asset_balances.current_reval_factor%TYPE;
353: l_cumulative_reval_factor igi_iac_asset_balances.cumulative_reval_factor%TYPE;

Line 722: p_string => ' Last Revaluation - Inserting into igi_iac_revaluations');

718: /* Last revaluation - Insert records into revaluation tables*/
719: IF (p_calling_function <> 'UPGRADE') THEN
720: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
721: p_full_path => l_path_name,
722: p_string => ' Last Revaluation - Inserting into igi_iac_revaluations');
723:
724: l_rowid := NULL;
725: l_revaluation_id := NULL;
726:

Line 727: igi_iac_revaluations_pkg.insert_row

723:
724: l_rowid := NULL;
725: l_revaluation_id := NULL;
726:
727: igi_iac_revaluations_pkg.insert_row
728: (l_rowid,
729: l_revaluation_id,
730: p_book_type_code,
731: sysdate,

Line 935: FROM igi_iac_revaluations r,igi_iac_reval_asset_rules a

931: /* Bug 2425914 vgadde 21/06/2002 */
932: /* Modified query to fecth records created by ADDITION only */
933: CURSOR c_get_revaluation_info(p_asset_id igi_iac_det_balances.asset_id%TYPE) IS
934: SELECT a.revaluation_id
935: FROM igi_iac_revaluations r,igi_iac_reval_asset_rules a
936: WHERE a.revaluation_id = r.revaluation_id
937: AND a.book_type_code = p_book_type_code
938: AND a.asset_id = p_asset_id
939: AND r.calling_program = 'ADDITION';

Line 974: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;

970: WHERE book_type_code = p_book_type_code
971: AND asset_id = cp_asset_id
972: AND adjustment_id = cp_adjustment_id;
973:
974: l_revaluation_id igi_iac_revaluations.revaluation_id%TYPE;
975: l_dummy VARCHAR2(1);
976: l_path_name VARCHAR2(150) := g_path||'do_rollback_addition';
977:
978: BEGIN

Line 1108: /* Delete records from igi_iac_revaluations */

1104: x_asset_id => l_asset_info.asset_id,
1105: x_book_type_code => p_book_type_code,
1106: x_revaluation_id => l_revaluation_id);
1107:
1108: /* Delete records from igi_iac_revaluations */
1109: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1110: p_full_path => l_path_name,
1111: p_string => ' Deleting records from igi_iac_revaluations');
1112: igi_iac_revaluations_pkg.delete_row(

Line 1111: p_string => ' Deleting records from igi_iac_revaluations');

1107:
1108: /* Delete records from igi_iac_revaluations */
1109: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1110: p_full_path => l_path_name,
1111: p_string => ' Deleting records from igi_iac_revaluations');
1112: igi_iac_revaluations_pkg.delete_row(
1113: x_revaluation_id => l_revaluation_id);
1114:
1115: /* Delete records from igi_iac_revaluation_rates */

Line 1112: igi_iac_revaluations_pkg.delete_row(

1108: /* Delete records from igi_iac_revaluations */
1109: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1110: p_full_path => l_path_name,
1111: p_string => ' Deleting records from igi_iac_revaluations');
1112: igi_iac_revaluations_pkg.delete_row(
1113: x_revaluation_id => l_revaluation_id);
1114:
1115: /* Delete records from igi_iac_revaluation_rates */
1116: OPEN c_get_revaluation_rates(l_asset_info.asset_id,l_revaluation_id);