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_IMPORT_PKG dependencies on IGI_IMP_IAC_INTERFACE

Line 219: CURSOR c_validate_asset (cp_asset_id igi_imp_iac_interface.asset_id%TYPE,

215: FROM igi_imp_iac_intermediate
216: WHERE errored_flag IS NULL;
217:
218: -- Validate the asset
219: CURSOR c_validate_asset (cp_asset_id igi_imp_iac_interface.asset_id%TYPE,
220: cp_asset_number igi_imp_iac_interface.asset_number%TYPE,
221: cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
222: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
223: SELECT COUNT(*)

Line 220: cp_asset_number igi_imp_iac_interface.asset_number%TYPE,

216: WHERE errored_flag IS NULL;
217:
218: -- Validate the asset
219: CURSOR c_validate_asset (cp_asset_id igi_imp_iac_interface.asset_id%TYPE,
220: cp_asset_number igi_imp_iac_interface.asset_number%TYPE,
221: cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
222: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
223: SELECT COUNT(*)
224: FROM igi_imp_iac_interface

Line 221: cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,

217:
218: -- Validate the asset
219: CURSOR c_validate_asset (cp_asset_id igi_imp_iac_interface.asset_id%TYPE,
220: cp_asset_number igi_imp_iac_interface.asset_number%TYPE,
221: cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
222: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
223: SELECT COUNT(*)
224: FROM igi_imp_iac_interface
225: WHERE asset_id = cp_asset_id

Line 222: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS

218: -- Validate the asset
219: CURSOR c_validate_asset (cp_asset_id igi_imp_iac_interface.asset_id%TYPE,
220: cp_asset_number igi_imp_iac_interface.asset_number%TYPE,
221: cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
222: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
223: SELECT COUNT(*)
224: FROM igi_imp_iac_interface
225: WHERE asset_id = cp_asset_id
226: AND asset_number = cp_asset_number

Line 224: FROM igi_imp_iac_interface

220: cp_asset_number igi_imp_iac_interface.asset_number%TYPE,
221: cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
222: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
223: SELECT COUNT(*)
224: FROM igi_imp_iac_interface
225: WHERE asset_id = cp_asset_id
226: AND asset_number = cp_asset_number
227: AND book_type_code = cp_book_type_code
228: AND category_id = cp_category_id;

Line 235: (cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,

231: -- Bug 2499880 Start(1)
232: --
233: -- Check transfer to IAC
234: CURSOR c_chk_transfer_to_iac
235: (cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
236: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
237: SELECT transfer_status
238: FROM igi_imp_iac_interface_ctrl
239: WHERE book_type_code = cp_book_type_code

Line 236: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS

232: --
233: -- Check transfer to IAC
234: CURSOR c_chk_transfer_to_iac
235: (cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
236: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
237: SELECT transfer_status
238: FROM igi_imp_iac_interface_ctrl
239: WHERE book_type_code = cp_book_type_code
240: AND category_id = cp_category_id;

Line 238: FROM igi_imp_iac_interface_ctrl

234: CURSOR c_chk_transfer_to_iac
235: (cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
236: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
237: SELECT transfer_status
238: FROM igi_imp_iac_interface_ctrl
239: WHERE book_type_code = cp_book_type_code
240: AND category_id = cp_category_id;
241:
242: Cursor C_book_class( cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE) is

Line 242: Cursor C_book_class( cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE) is

238: FROM igi_imp_iac_interface_ctrl
239: WHERE book_type_code = cp_book_type_code
240: AND category_id = cp_category_id;
241:
242: Cursor C_book_class( cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE) is
243: Select book_class
244: from fa_booK_controls
245: where book_type_code = cp_book_type_code;
246:

Line 247: cursor c_deprn_flag(cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,

243: Select book_class
244: from fa_booK_controls
245: where book_type_code = cp_book_type_code;
246:
247: cursor c_deprn_flag(cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
248: cp_asset_id igi_imp_iac_interface.asset_id%TYPE ) is
249: select depreciate_flag
250: from fa_books
251: where book_type_code =cp_book_type_code

Line 248: cp_asset_id igi_imp_iac_interface.asset_id%TYPE ) is

244: from fa_booK_controls
245: where book_type_code = cp_book_type_code;
246:
247: cursor c_deprn_flag(cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
248: cp_asset_id igi_imp_iac_interface.asset_id%TYPE ) is
249: select depreciate_flag
250: from fa_books
251: where book_type_code =cp_book_type_code
252: and asset_id =cp_asset_id

Line 258: l_book_type_code igi_imp_iac_interface.book_type_code%TYPE;

254:
255: -- Bug 2499880 End(1)
256: --
257:
258: l_book_type_code igi_imp_iac_interface.book_type_code%TYPE;
259: l_category_id igi_imp_iac_interface.category_id%TYPE;
260:
261: --
262: -- Bug 2499880 Start(2)

Line 259: l_category_id igi_imp_iac_interface.category_id%TYPE;

255: -- Bug 2499880 End(1)
256: --
257:
258: l_book_type_code igi_imp_iac_interface.book_type_code%TYPE;
259: l_category_id igi_imp_iac_interface.category_id%TYPE;
260:
261: --
262: -- Bug 2499880 Start(2)
263: --

Line 264: l_transfer_status igi_imp_iac_interface_ctrl.transfer_status%TYPE;

260:
261: --
262: -- Bug 2499880 Start(2)
263: --
264: l_transfer_status igi_imp_iac_interface_ctrl.transfer_status%TYPE;
265: --
266: -- Bug 2499880 End(2)
267: --
268: l_deprn_flag fa_books.depreciate_flag%type;

Line 407: UPDATE igi_imp_iac_interface

403: -- Close c_book_class;
404:
405: IF l_deprn_flag = 'YES' THEN
406: -- Update the asset data to interface
407: UPDATE igi_imp_iac_interface
408: SET cost_mhca = cv_recs_to_process.cost_mhca
409: ,ytd_mhca = cv_recs_to_process.ytd_mhca
410: ,accum_deprn_mhca = cv_recs_to_process.accum_deprn_mhca
411: ,reval_reserve_mhca = cv_recs_to_process.reval_reserve_mhca

Line 429: UPDATE igi_imp_iac_interface

425: AND book_type_code = cv_recs_to_process.book_type_code
426: AND category_id = cv_recs_to_process.category_id;
427: ELSE
428:
429: UPDATE igi_imp_iac_interface
430: SET cost_mhca = cv_recs_to_process.cost_mhca
431: ,reval_reserve_mhca = cv_recs_to_process.reval_reserve_mhca
432: ,operating_account_cost = (-1) * cv_recs_to_process.operating_account_cost
433: ,import_file = l_file_name

Line 519: igi_imp_iac_interface_ctrl.book_type_code%TYPE,

515: WHERE book_type_code = cp_book_type_code;
516:
517: -- Cursor to validate category id
518: CURSOR c_category_id (cp_book_type_code
519: igi_imp_iac_interface_ctrl.book_type_code%TYPE,
520: cp_category_id
521: igi_imp_iac_interface_ctrl.category_id%TYPE) IS
522: SELECT COUNT(*)
523: FROM igi_imp_iac_interface_ctrl

Line 521: igi_imp_iac_interface_ctrl.category_id%TYPE) IS

517: -- Cursor to validate category id
518: CURSOR c_category_id (cp_book_type_code
519: igi_imp_iac_interface_ctrl.book_type_code%TYPE,
520: cp_category_id
521: igi_imp_iac_interface_ctrl.category_id%TYPE) IS
522: SELECT COUNT(*)
523: FROM igi_imp_iac_interface_ctrl
524: WHERE book_type_code = cp_book_type_code
525: AND category_id = cp_category_id;

Line 523: FROM igi_imp_iac_interface_ctrl

519: igi_imp_iac_interface_ctrl.book_type_code%TYPE,
520: cp_category_id
521: igi_imp_iac_interface_ctrl.category_id%TYPE) IS
522: SELECT COUNT(*)
523: FROM igi_imp_iac_interface_ctrl
524: WHERE book_type_code = cp_book_type_code
525: AND category_id = cp_category_id;
526:
527: -- Cursor for count of files to process

Line 528: CURSOR c_group_count (cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,

524: WHERE book_type_code = cp_book_type_code
525: AND category_id = cp_category_id;
526:
527: -- Cursor for count of files to process
528: CURSOR c_group_count (cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
529: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
530: SELECT COUNT(DISTINCT group_id)
531: FROM igi_imp_iac_interface
532: WHERE book_type_code = cp_book_type_code

Line 529: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS

525: AND category_id = cp_category_id;
526:
527: -- Cursor for count of files to process
528: CURSOR c_group_count (cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
529: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
530: SELECT COUNT(DISTINCT group_id)
531: FROM igi_imp_iac_interface
532: WHERE book_type_code = cp_book_type_code
533: AND category_id = cp_category_id

Line 531: FROM igi_imp_iac_interface

527: -- Cursor for count of files to process
528: CURSOR c_group_count (cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
529: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
530: SELECT COUNT(DISTINCT group_id)
531: FROM igi_imp_iac_interface
532: WHERE book_type_code = cp_book_type_code
533: AND category_id = cp_category_id
534: AND group_id IS NOT NULL;
535:

Line 537: CURSOR c_group_id (cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,

533: AND category_id = cp_category_id
534: AND group_id IS NOT NULL;
535:
536: -- Cursor to build file names to import
537: CURSOR c_group_id (cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
538: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
539: SELECT DISTINCT group_id
540: FROM igi_imp_iac_interface
541: WHERE book_type_code = cp_book_type_code

Line 538: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS

534: AND group_id IS NOT NULL;
535:
536: -- Cursor to build file names to import
537: CURSOR c_group_id (cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
538: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
539: SELECT DISTINCT group_id
540: FROM igi_imp_iac_interface
541: WHERE book_type_code = cp_book_type_code
542: AND category_id = cp_category_id

Line 540: FROM igi_imp_iac_interface

536: -- Cursor to build file names to import
537: CURSOR c_group_id (cp_book_type_code igi_imp_iac_interface.book_type_code%TYPE,
538: cp_category_id igi_imp_iac_interface.category_id%TYPE) IS
539: SELECT DISTINCT group_id
540: FROM igi_imp_iac_interface
541: WHERE book_type_code = cp_book_type_code
542: AND category_id = cp_category_id
543: AND group_id IS NOT NULL;
544:

Line 545: l_book_type_code igi_imp_iac_interface.book_type_code%TYPE;

541: WHERE book_type_code = cp_book_type_code
542: AND category_id = cp_category_id
543: AND group_id IS NOT NULL;
544:
545: l_book_type_code igi_imp_iac_interface.book_type_code%TYPE;
546: -- l_new_book_type_code igi_imp_iac_interface.book_type_code%TYPE; -- Bug No. 2843747 (Tpradhan) - Coommented since no longer in use
547: l_category_id igi_imp_iac_interface.category_id%TYPE;
548: l_category_name VARCHAR2(350);
549:

Line 546: -- l_new_book_type_code igi_imp_iac_interface.book_type_code%TYPE; -- Bug No. 2843747 (Tpradhan) - Coommented since no longer in use

542: AND category_id = cp_category_id
543: AND group_id IS NOT NULL;
544:
545: l_book_type_code igi_imp_iac_interface.book_type_code%TYPE;
546: -- l_new_book_type_code igi_imp_iac_interface.book_type_code%TYPE; -- Bug No. 2843747 (Tpradhan) - Coommented since no longer in use
547: l_category_id igi_imp_iac_interface.category_id%TYPE;
548: l_category_name VARCHAR2(350);
549:
550: l_request_status igi_imp_iac_controls.request_status%TYPE;

Line 547: l_category_id igi_imp_iac_interface.category_id%TYPE;

543: AND group_id IS NOT NULL;
544:
545: l_book_type_code igi_imp_iac_interface.book_type_code%TYPE;
546: -- l_new_book_type_code igi_imp_iac_interface.book_type_code%TYPE; -- Bug No. 2843747 (Tpradhan) - Coommented since no longer in use
547: l_category_id igi_imp_iac_interface.category_id%TYPE;
548: l_category_name VARCHAR2(350);
549:
550: l_request_status igi_imp_iac_controls.request_status%TYPE;
551: l_message VARCHAR2(1000);