APPS.IGI_IAC_REVAL_CONCURRENT dependencies on IGI_IAC_TYPES

Line 190: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Status '|| IGI_IAC_TYPES.gc_running_status);

186: l_failure_ct := 0;
187: l_path := g_path||'preview_mode_hist_transform';
188:
189: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin preview_mode_hist_transform');
190: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'Status '|| IGI_IAC_TYPES.gc_running_status);
191:
192: savepoint sp;
193: for l_reval in c_revaluations loop -- get the revaluation for preview
194: -- found record to process.

Line 395: -- and upper(iir.status) = IGI_IAC_TYPES.gc_previewed_status

391: select iir.revaluation_id, iir.book_type_code
392: from igi_iac_revaluations iir
393: where iir.revaluation_id = fp_revaluation_id
394: and iir.book_type_code = fp_book_type_code
395: -- and upper(iir.status) = IGI_IAC_TYPES.gc_previewed_status
396: ;
397:
398: cursor c_reval_categories (cp_revaluation_id in number
399: , cp_book_type_code in varchar2

Line 433: l_reval_messages IGI_IAC_TYPES.iac_reval_mesg;

429: l_success_ct number ;
430:
431: l_path varchar2(100) ;
432:
433: l_reval_messages IGI_IAC_TYPES.iac_reval_mesg;
434: l_reval_messages_idx IGI_IAC_TYPES.iac_reval_mesg_idx ;
435: l_reval_exceptions IGI_IAC_TYPES.iac_reval_exceptions;
436: l_reval_exceptions_idx IGI_IAC_TYPES.iac_reval_exceptions_idx ;
437:

Line 434: l_reval_messages_idx IGI_IAC_TYPES.iac_reval_mesg_idx ;

430:
431: l_path varchar2(100) ;
432:
433: l_reval_messages IGI_IAC_TYPES.iac_reval_mesg;
434: l_reval_messages_idx IGI_IAC_TYPES.iac_reval_mesg_idx ;
435: l_reval_exceptions IGI_IAC_TYPES.iac_reval_exceptions;
436: l_reval_exceptions_idx IGI_IAC_TYPES.iac_reval_exceptions_idx ;
437:
438: /* Bulk Fetch */

Line 435: l_reval_exceptions IGI_IAC_TYPES.iac_reval_exceptions;

431: l_path varchar2(100) ;
432:
433: l_reval_messages IGI_IAC_TYPES.iac_reval_mesg;
434: l_reval_messages_idx IGI_IAC_TYPES.iac_reval_mesg_idx ;
435: l_reval_exceptions IGI_IAC_TYPES.iac_reval_exceptions;
436: l_reval_exceptions_idx IGI_IAC_TYPES.iac_reval_exceptions_idx ;
437:
438: /* Bulk Fetch */
439: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.ASSET_ID%TYPE

Line 436: l_reval_exceptions_idx IGI_IAC_TYPES.iac_reval_exceptions_idx ;

432:
433: l_reval_messages IGI_IAC_TYPES.iac_reval_mesg;
434: l_reval_messages_idx IGI_IAC_TYPES.iac_reval_mesg_idx ;
435: l_reval_exceptions IGI_IAC_TYPES.iac_reval_exceptions;
436: l_reval_exceptions_idx IGI_IAC_TYPES.iac_reval_exceptions_idx ;
437:
438: /* Bulk Fetch */
439: TYPE asset_id_tbl_type IS TABLE OF IGI_IAC_REVAL_ASSET_RULES.ASSET_ID%TYPE
440: INDEX BY BINARY_INTEGER;

Line 465: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'status '|| IGI_IAC_TYPES.gc_previewed_status);

461: l_reval_messages_idx := 1;
462: l_reval_exceptions_idx := 1;
463:
464: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'begin preview_mode_hist_generate');
465: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'status '|| IGI_IAC_TYPES.gc_previewed_status);
466:
467: savepoint sp;
468: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+after savepoint');
469: for l_reval in c_revaluations loop -- get the revaluation for preview

Line 513: l_reval_output_asset IGI_IAC_TYPES.iac_reval_output_asset;

509: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Period counter : '|| fp_period_counter);
510: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- calling program: IGIIARVC');
511: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
512: declare
513: l_reval_output_asset IGI_IAC_TYPES.iac_reval_output_asset;
514: begin
515: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- ------------------------------------------- ');
516: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset number : '|| l_asset_no(l_loop_count));
517: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'>> -- Asset id : '|| l_asset_id(l_loop_count) );