DBA Data[Home] [Help]

APPS.IGI_IAC_ADDITIONS_PKG dependencies on IGI_IAC_REVAL_ASSET_RULES

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

757: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
758:
759: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
760: p_full_path => l_path_name,
761: p_string => ' Inserting into igi_iac_reval_asset_rules');
762: l_rowid := NULL;
763: igi_iac_reval_asset_rules_pkg.insert_row
764: (l_rowid,
765: l_revaluation_id,

Line 763: igi_iac_reval_asset_rules_pkg.insert_row

759: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
760: p_full_path => l_path_name,
761: p_string => ' Inserting into igi_iac_reval_asset_rules');
762: l_rowid := NULL;
763: igi_iac_reval_asset_rules_pkg.insert_row
764: (l_rowid,
765: l_revaluation_id,
766: l_reval_asset_params(l_idx1).book_type_code,
767: l_reval_asset_params(l_idx1).category_id,

Line 952: FROM igi_iac_revaluations r,igi_iac_reval_asset_rules a

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
955: AND a.asset_id = p_asset_id
956: AND r.calling_program = 'ADDITION';

Line 1114: /* Delete records from igi_iac_reval_asset_rules */

1110: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1111: p_full_path => l_path_name,
1112: p_string => ' Revaluation Id :'||to_char(l_revaluation_id));
1113:
1114: /* Delete records from igi_iac_reval_asset_rules */
1115: IF (l_revaluation_id IS NOT NULL) THEN
1116:
1117: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1118: p_full_path => l_path_name,

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

1115: IF (l_revaluation_id IS NOT NULL) THEN
1116:
1117: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1118: p_full_path => l_path_name,
1119: p_string => ' Deleting records from igi_iac_reval_asset_rules');
1120: igi_iac_reval_asset_rules_pkg.delete_row(
1121: x_asset_id => l_asset_info.asset_id,
1122: x_book_type_code => p_book_type_code,
1123: x_revaluation_id => l_revaluation_id);

Line 1120: igi_iac_reval_asset_rules_pkg.delete_row(

1116:
1117: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1118: p_full_path => l_path_name,
1119: p_string => ' Deleting records from igi_iac_reval_asset_rules');
1120: igi_iac_reval_asset_rules_pkg.delete_row(
1121: x_asset_id => l_asset_info.asset_id,
1122: x_book_type_code => p_book_type_code,
1123: x_revaluation_id => l_revaluation_id);
1124: