[Home] [Help]
1: PACKAGE BODY Okl_Qa_Data_Integrity AS
2: /* $Header: OKLRQADB.pls 120.153.12010000.12 2009/02/09 05:26:25 rpillay ship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
1792: CLOSE c_contract_name;
1793: -- gboomina modified for Bug 6329395 - End
1794:
1795: -- udhenuko bug#6786775
1796: -- Added an if condition in OKL_QA_DATA_INTEGRITY.check_payment_type to throw the error message
1797: --for contracts having Interest Calculation Method NOT EQUAL TO Fixed and Revenue Recognition Method NOT EQUAL TO
1798: --'STREAMS' for cases where print lead day value used in payment terms is greater than Rate delay.
1799: IF l_interest_calculation_basis <> 'FIXED'
1800: AND l_revenue_recognition_method <> 'STREAMS'
11181: lx_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
11182: lx_pool_balance okl_subsidy_pools_b.total_subsidy_amount%TYPE;
11183: lv_subsidy_amount okl_k_lines.subsidy_override_amount%TYPE;
11184: -- sjalasut, added local variables to support logging
11185: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_QA_DATA_INTEGRITY.CHECK_SUBSIDIES_ERRORS';
11186: l_debug_enabled VARCHAR2(10);
11187: is_debug_statement_on BOOLEAN;
11188:
11189:
12916:
12917: END check_book_class_cmptblty;
12918:
12919:
12920: END Okl_Qa_Data_Integrity;