APPS.IGI_IMP_IAC_PREPARE_PKG dependencies on IGI_IMP_IAC_CONTROLS

Line 137: Update igi_imp_iac_controls

133: Begin
134:
135: l_path_name := g_path||'set_process_status';
136:
137: Update igi_imp_iac_controls
138: Set Request_status = p_flag,
139: Request_id = fnd_global.conc_request_id,
140: Request_date = sysdate,
141: Last_updated_by = fnd_global.user_id,

Line 148: p_string => 'igi_imp_iac_controls updated, Request_status set to '

144: Where book_type_code = p_book;
145: If Sql%found Then
146: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
147: p_full_path => l_path_name,
148: p_string => 'igi_imp_iac_controls updated, Request_status set to '
149: || p_flag || ' for Book ' || p_book);
150: End If;
151: Exception
152: When Others Then

Line 413: From igi_imp_iac_controls ict,

409: ict.corp_book corp_book,
410: ict.period_counter -1 corp_last_per_counter,
411: dp2.fiscal_year corp_per_fiscal_year,
412: dp2.period_num corp_curr_period_num
413: From igi_imp_iac_controls ict,
414: fa_book_controls bk,
415: fa_deprn_periods dp1,
416: fa_deprn_periods dp2
417: Where ict.book_type_code = p_book_type_code