[Home] [Help]
1: PACKAGE BODY Okl_Qa_Data_Integrity AS
2: /* $Header: OKLRQADB.pls 120.182.12020000.10 2013/04/18 18:36:47 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;
1916: CLOSE c_contract_name;
1917: -- gboomina modified for Bug 6329395 - End
1918:
1919: -- udhenuko bug#6786775
1920: -- Added an if condition in OKL_QA_DATA_INTEGRITY.check_payment_type to throw the error message
1921: --for contracts having Interest Calculation Method NOT EQUAL TO Fixed and Revenue Recognition Method NOT EQUAL TO
1922: --'STREAMS' for cases where print lead day value used in payment terms is greater than Rate delay.
1923: IF l_interest_calculation_basis <> 'FIXED'
1924: AND l_revenue_recognition_method <> 'STREAMS'
11604: lx_pool_status okl_subsidy_pools_b.decision_status_code%TYPE;
11605: lx_pool_balance okl_subsidy_pools_b.total_subsidy_amount%TYPE;
11606: lv_subsidy_amount okl_k_lines.subsidy_override_amount%TYPE;
11607: -- sjalasut, added local variables to support logging
11608: l_module CONSTANT fnd_log_messages.MODULE%TYPE := 'okl.plsql.OKL_QA_DATA_INTEGRITY.CHECK_SUBSIDIES_ERRORS';
11609: l_debug_enabled VARCHAR2(10);
11610: is_debug_statement_on BOOLEAN;
11611:
11612:
14371:
14372: END check_interest_start_date;
14373: --Bug# 13478101: End
14374:
14375: END Okl_Qa_Data_Integrity;