DBA Data[Home] [Help]

APPS.IGI_IAC_ADDITIONS_PKG dependencies on IGI_IAC_REVAL_ASSET_RULES

Line 744: p_string => ' Inserting into igi_iac_reval_asset_rules');

740: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
741:
742: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
743: p_full_path => l_path_name,
744: p_string => ' Inserting into igi_iac_reval_asset_rules');
745: l_rowid := NULL;
746: igi_iac_reval_asset_rules_pkg.insert_row
747: (l_rowid,
748: l_revaluation_id,

Line 746: igi_iac_reval_asset_rules_pkg.insert_row

742: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
743: p_full_path => l_path_name,
744: p_string => ' Inserting into igi_iac_reval_asset_rules');
745: l_rowid := NULL;
746: igi_iac_reval_asset_rules_pkg.insert_row
747: (l_rowid,
748: l_revaluation_id,
749: l_reval_asset_params(l_idx1).book_type_code,
750: l_reval_asset_params(l_idx1).category_id,

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 1097: /* Delete records from igi_iac_reval_asset_rules */

1093: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1094: p_full_path => l_path_name,
1095: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
1096:
1097: /* Delete records from igi_iac_reval_asset_rules */
1098: IF (l_revaluation_id IS NOT NULL) THEN
1099:
1100: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1101: p_full_path => l_path_name,

Line 1102: p_string => ' Deleting records from igi_iac_reval_asset_rules');

1098: IF (l_revaluation_id IS NOT NULL) THEN
1099:
1100: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1101: p_full_path => l_path_name,
1102: p_string => ' Deleting records from igi_iac_reval_asset_rules');
1103: igi_iac_reval_asset_rules_pkg.delete_row(
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);

Line 1103: igi_iac_reval_asset_rules_pkg.delete_row(

1099:
1100: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1101: p_full_path => l_path_name,
1102: p_string => ' Deleting records from igi_iac_reval_asset_rules');
1103: igi_iac_reval_asset_rules_pkg.delete_row(
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: