eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGI_IMP_IAC_PREPARE_PKG dependencies on IGI_IMP_IAC_INTERFACE

Line 115: l_imp_interface igi_imp_iac_interface%Rowtype;

111:
112: l_corp_book_info C_Corp_Book_Info%Rowtype;
113: l_corp_deprn_details C_Corp_Deprn_Details%Rowtype;
114: l_corp_deprn_summary C_Corp_Deprn_Summary%Rowtype;
115: l_imp_interface igi_imp_iac_interface%Rowtype;
116: l_hist_info igi_iac_types.fa_hist_asset_info;
117:
118: --===========================FND_LOG.START=====================================
119: g_state_level NUMBER;

Line 159: Procedure Populate_Interface(p_interface_rec igi_imp_iac_interface%Rowtype) Is

155: p_string => 'Error during update of Request Status to ' || p_flag);
156: Raise;
157: End;
158:
159: Procedure Populate_Interface(p_interface_rec igi_imp_iac_interface%Rowtype) Is
160: l_path_name VARCHAR2(150);
161: Begin
162:
163: l_path_name := g_path||'populate_interface';

Line 165: Insert into igi_imp_iac_interface(

161: Begin
162:
163: l_path_name := g_path||'populate_interface';
164:
165: Insert into igi_imp_iac_interface(
166: Asset_id,
167: Asset_number,
168: Book_type_code,
169: Category_id,

Line 268: p_string => 'Created a record in igi_imp_iac_interface, Book Type Code : ' ||

264: p_interface_rec.Valid_flag); -- Added as a part of fix for Bug 5137813
265: If Sql%found Then
266: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
267: p_full_path => l_path_name,
268: p_string => 'Created a record in igi_imp_iac_interface, Book Type Code : ' ||
269: p_interface_rec.Book_type_code ||
270: ' ,Asset Id : ' || p_interface_rec.Asset_id ||
271: ' ,Asset Number : ' || p_interface_rec.Asset_number ||
272: ' ,Category Id : ' || p_interface_rec.Category_id);

Line 278: p_string => 'Error during creation of record in igi_imp_iac_interface, '

274: Exception
275: When Others Then
276: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
277: p_full_path => l_path_name,
278: p_string => 'Error during creation of record in igi_imp_iac_interface, '
279: ||'Book Type Code : ' ||p_interface_rec.Book_type_code
280: ||' ,Asset Id : ' || p_interface_rec.Asset_id
281: ||' ,Asset Number : ' || p_interface_rec.Asset_number
282: ||' ,Category Id : ' || p_interface_rec.Category_id);

Line 292: Insert into igi_imp_iac_interface_ctrl(

288: Begin
289:
290: l_path_name := g_path||'populate_interface_data';
291:
292: Insert into igi_imp_iac_interface_ctrl(
293: book_type_code,
294: category_id,
295: created_by,
296: creation_date,

Line 313: p_string => 'Created a record in igi_imp_iac_interface_ctrl for Book ' || p_book );

309: fnd_global.login_id);
310: If Sql%found Then
311: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
312: p_full_path => l_path_name,
313: p_string => 'Created a record in igi_imp_iac_interface_ctrl for Book ' || p_book );
314: End if;
315: Exception
316: When Others Then
317: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,

Line 319: p_string => ' Error during creation of record in igi_imp_iac_interface_ctrl for Book ' || p_book);

315: Exception
316: When Others Then
317: igi_iac_debug_pkg.debug_other_string(p_level => g_error_level,
318: p_full_path => l_path_name,
319: p_string => ' Error during creation of record in igi_imp_iac_interface_ctrl for Book ' || p_book);
320: Raise;
321: End;
322:
323: Procedure Initialise_Variables(p_corp_book_info in out NOCOPY C_Corp_Book_Info%Rowtype,

Line 326: p_imp_interface in out NOCOPY igi_imp_iac_interface%Rowtype,

322:
323: Procedure Initialise_Variables(p_corp_book_info in out NOCOPY C_Corp_Book_Info%Rowtype,
324: p_corp_deprn_details in out NOCOPY C_Corp_Deprn_Details%Rowtype,
325: p_corp_deprn_summary in out NOCOPY C_Corp_Deprn_Summary%Rowtype,
326: p_imp_interface in out NOCOPY igi_imp_iac_interface%Rowtype,
327: p_hist_info in out NOCOPY igi_iac_types.fa_hist_asset_info,
328: p_fiscal_year in out NOCOPY number,
329: p_book_last_per_counter in out NOCOPY number,
330: p_corp_last_per_counter in out NOCOPY number,

Line 337: l_initialise_interface igi_imp_iac_interface%Rowtype;

333:
334: l_initialise_corp_book C_Corp_Book_Info%Rowtype;
335: l_initialise_corp_details C_Corp_Deprn_Details%Rowtype;
336: l_initialise_corp_summary C_Corp_Deprn_Summary%Rowtype;
337: l_initialise_interface igi_imp_iac_interface%Rowtype;
338: l_initialise_hist_info igi_iac_types.fa_hist_asset_info;
339:
340:
341: p_corp_book_info_old C_Corp_Book_Info%Rowtype;

Line 344: p_imp_interface_old igi_imp_iac_interface%Rowtype;

340:
341: p_corp_book_info_old C_Corp_Book_Info%Rowtype;
342: p_corp_deprn_details_old C_Corp_Deprn_Details%Rowtype;
343: p_corp_deprn_summary_old C_Corp_Deprn_Summary%Rowtype;
344: p_imp_interface_old igi_imp_iac_interface%Rowtype;
345: p_hist_info_old igi_iac_types.fa_hist_asset_info;
346: p_fiscal_year_old number;
347: p_book_last_per_counter_old number;
348: p_corp_last_per_counter_old number;

Line 592: Select igi_imp_iac_interface_group_s.nextval

588: If l_rec_ctr > l_max_records then
589: l_rec_ctr := 1;
590: End if;
591: If l_rec_ctr = 1 then
592: Select igi_imp_iac_interface_group_s.nextval
593: Into l_group_id
594: From dual;
595: End if;
596:

Line 1031: From igi_imp_iac_interface_py_add

1027: General_fund_Periodic,
1028: Operating_account_ytd,
1029: cummulative_reval_factor,
1030: current_reval_factor
1031: From igi_imp_iac_interface_py_add
1032: Where book_type_code = p_book
1033: and category_id = p_category_id
1034: and asset_id = p_asset_id;
1035:

Line 1092: Select igi_imp_iac_interface_group_s.nextval

1088: If l_rec_ctr > l_max_records then
1089: l_rec_ctr := 1;
1090: End if;
1091: If l_rec_ctr = 1 then
1092: Select igi_imp_iac_interface_group_s.nextval
1093: Into l_group_id
1094: From dual;
1095: igi_iac_debug_pkg.debug_other_string(p_level => g_state_level,
1096: p_full_path => l_path_name,