APPS.IGI_IAC_REVAL_CONCURRENT dependencies on IGI_IAC_TRANSACTION_HEADERS

Line 153: from igi_iac_transaction_headers

149: and ac.category_id = cp_category_id
150: and ac.asset_id = fadd.asset_id
151: and nvl(ac.selected_for_reval_flag,'X') = 'Y'
152: and exists ( select 1
153: from igi_iac_transaction_headers
154: where asset_id = ac.asset_id
155: and book_type_code = ac.book_type_code
156: and mass_reference_id = ac.revaluation_id
157: and adjustment_status = 'PREVIEW'

Line 239: -- Adjustment_status of igi_iac_transaction_headers is updated

235: else
236: l_failure_ct := l_failure_ct + 1;
237: end if;
238: --
239: -- Adjustment_status of igi_iac_transaction_headers is updated
240: -- from 'PREVIEW' to 'RUN'.
241: --
242: IF IGI_IAC_REVAL_CRUD.adjustment_status_to_run
243: ( fp_reval_id => l_reval.revaluation_id

Line 271: from igi_iac_transaction_headers

267: */
268: begin
269: select adjustment_id
270: into l_adjustment_id
271: from igi_iac_transaction_headers
272: where book_type_code = l_reval.book_type_code
273: and asset_id = l_asset_id(l_loop_count)
274: and adjustment_id_out is null
275: ;

Line 421: from igi_iac_transaction_headers

417: and r.category_id = cp_category_id
418: and nvl(r.selected_for_reval_flag,'X') = 'Y'
419: and r.asset_id = fadd.asset_id
420: and not exists ( select 'x'
421: from igi_iac_transaction_headers
422: where asset_id = r.asset_id
423: and book_type_code = r.book_type_code
424: and mass_reference_id = r.revaluation_id
425: and transaction_type_code = 'REVALUATION'

Line 604: from igi_iac_transaction_headers

600: function preview_mode_hist_delete ( fp_revaluation_id in number)
601: return boolean is
602: cursor c_reval_rates is
603: select distinct asset_id, book_type_code, period_counter
604: from igi_iac_transaction_headers
605: where mass_reference_id = fp_revaluation_id
606: and transaction_type_code = 'REVALUATION'
607: ;
608: cursor c_txn_headers (cp_book_type_code in varchar2

Line 613: from igi_iac_transaction_headers t

609: ,cp_asset_id in number
610: ,cp_period_counter in number
611: ) is
612: select adjustment_id
613: from igi_iac_transaction_headers t
614: where book_type_code = cp_book_type_code
615: and asset_id = cp_asset_id
616: and transaction_type_code = 'REVALUATION'
617: and period_counter = cp_period_counter

Line 652: delete igi_iac_transaction_headers

648: and revaluation_id = fp_revaluation_id
649: and book_type_code = l_rates.book_type_code
650: ;
651: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+delete from the transaction headers table');
652: delete igi_iac_transaction_headers
653: where adjustment_id = l_headers.adjustment_id
654: and adjustment_id_out is null
655: /* and not exists ( select 'x'
656: from igi_iac_transaction_headers

Line 656: from igi_iac_transaction_headers

652: delete igi_iac_transaction_headers
653: where adjustment_id = l_headers.adjustment_id
654: and adjustment_id_out is null
655: /* and not exists ( select 'x'
656: from igi_iac_transaction_headers
657: where adjustment_id_out = l_headers.adjustment_id
658: )*/
659: ;
660: if sql%notfound then

Line 669: from igi_iac_transaction_headers

665: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+update previous transaction row if one exists');
666: declare
667: cursor c_exist is
668: select 'x'
669: from igi_iac_transaction_headers
670: where adjustment_id_out = l_headers.adjustment_id
671: ;
672: l_exists_prev boolean := false;
673: begin

Line 679: update igi_iac_transaction_headers

675: l_exists_prev := true;
676: end loop;
677: if l_exists_prev then
678: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+previous transaction row exists');
679: update igi_iac_transaction_headers
680: set adjustment_id_out = null
681: where adjustment_id_out = l_headers.adjustment_id
682: and book_type_code = l_rates.book_type_code
683: and asset_id = l_rates.asset_id

Line 686: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+error occurred in igi_iac_transaction_headers');

682: and book_type_code = l_rates.book_type_code
683: and asset_id = l_rates.asset_id
684: ;
685: if sql%notfound then
686: igi_iac_debug_pkg.debug_other_string(g_state_level,l_path,'+error occurred in igi_iac_transaction_headers');
687: rollback;
688: return false;
689: end if;
690: end if;

Line 740: from igi_iac_transaction_headers

736: function preview_mode_hist_available ( fp_revaluation_id in number )
737: return boolean is
738: cursor c_pmha is
739: select distinct asset_id, book_type_code, period_counter
740: from igi_iac_transaction_headers
741: where mass_reference_id = fp_revaluation_id
742: and transaction_type_code = 'REVALUATION'
743: and adjustment_status = 'PREVIEW'
744: ;

Line 765: from igi_iac_transaction_headers

761: function run_mode_hist_available ( fp_revaluation_id in number )
762: return boolean is
763: cursor c_rmha is
764: select distinct asset_id, book_type_code, period_counter
765: from igi_iac_transaction_headers
766: where mass_reference_id = fp_revaluation_id
767: and transaction_type_code = 'REVALUATION'
768: and adjustment_status = 'RUN'
769: ;

Line 812: -- if this is in preview mode, create entries in igi_iac_transaction_headers

808: END IF;
809: /*
810: -- conditions
811: -- **********
812: -- if this is in preview mode, create entries in igi_iac_transaction_headers
813: -- if the user resubmits the record in the preview mode, delete the existing records
814: -- and re-generate!
815: -- if the user is in run mode and there are no run mode records, only preview records,
816: -- then update the preview information to show that it is live.