APPS.IGI_IAC_REVAL_CRUD dependencies on IGI_IAC_ADJUSTMENTS

Line 2079: update igi_iac_adjustments

2075: for l_check in c_check loop
2076: l_can_update := true;
2077: end loop;
2078: if l_can_update then
2079: update igi_iac_adjustments
2080: set transfer_to_gl_flag = 'Y'
2081: where adjustment_id in ( select adjustment_id
2082: from igi_iac_transaction_headers
2083: where mass_reference_id = fp_reval_id

Line 2122: update igi_iac_adjustments

2118: for l_check in c_check loop
2119: l_can_update := true;
2120: end loop;
2121: if l_can_update then
2122: update igi_iac_adjustments
2123: set event_id = fp_event_id
2124: where adjustment_id in ( select adjustment_id
2125: from igi_iac_transaction_headers
2126: where mass_reference_id = fp_reval_id

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

2129: and book_type_code = fp_book_type_code
2130: and transfer_to_gl_flag = 'Y';
2131:
2132: if sql%found then
2133: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_adjustments');
2134: else
2135: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_adjustments');
2136: end if;
2137:

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

2131:
2132: if sql%found then
2133: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'stamped event_id in igi_iac_adjustments');
2134: else
2135: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'No records found to stamp event_id in igi_iac_adjustments');
2136: end if;
2137:
2138: update igi_iac_transaction_headers
2139: set event_id = fp_event_id