750: l_request_id := xla_environment_pkg.g_Req_Id ;
751:
752: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
753: trace
754: (p_msg => 'SQL- Insert xla_diag_ledgers the ledger_id ='||p_ledger_id
755: ,p_level => C_LEVEL_STATEMENT
756: ,p_module => l_log_module);
757: END IF;
758:
755: ,p_level => C_LEVEL_STATEMENT
756: ,p_module => l_log_module);
757: END IF;
758:
759: INSERT INTO xla_diag_ledgers
760: (
761: application_id
762: , ledger_id
763: , primary_ledger_id
808: WHERE application_id = p_application_id
809: AND ledger_id = p_ledger_id
810: AND primary_ledger_id = p_primary_ledger_id
811: AND not exists (SELECT 'x'
812: FROM xla_diag_ledgers
813: WHERE application_id = p_application_id
814: AND ledger_id = p_ledger_id
815: AND primary_ledger_id = p_primary_ledger_id
816: AND accounting_request_id = l_request_id