APPS.IGI_IAC_REVAL_CRUD dependencies on IGI_IAC_ADJUSTMENTS

Line 2126: update igi_iac_adjustments

2122: for l_check in c_check loop
2123: l_can_update := true;
2124: end loop;
2125: if l_can_update then
2126: update igi_iac_adjustments
2127: set transfer_to_gl_flag = 'Y'
2128: where adjustment_id in ( select adjustment_id
2129: from igi_iac_transaction_headers
2130: where mass_reference_id = fp_reval_id

Line 2169: update igi_iac_adjustments

2165: for l_check in c_check loop
2166: l_can_update := true;
2167: end loop;
2168: if l_can_update then
2169: update igi_iac_adjustments
2170: set event_id = fp_event_id
2171: where adjustment_id in ( select adjustment_id
2172: from igi_iac_transaction_headers
2173: where mass_reference_id = fp_reval_id

Line 2180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_adjustments');

2176: and book_type_code = fp_book_type_code
2177: and transfer_to_gl_flag = 'Y';
2178:
2179: if sql%found then
2180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_adjustments');
2181: else
2182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_adjustments');
2183: end if;
2184:

Line 2182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_adjustments');

2178:
2179: if sql%found then
2180: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_adjustments');
2181: else
2182: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_adjustments');
2183: end if;
2184:
2185: update igi_iac_transaction_headers
2186: set event_id = fp_event_id