APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKC_K_HEADERS_V

Line 545: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE

541: x_return_status OUT NOCOPY VARCHAR2,
542: x_msg_count OUT NOCOPY NUMBER,
543: x_msg_data OUT NOCOPY VARCHAR2,
544: p_lease_asset_id IN OKC_K_LINES_V.ID%TYPE,
545: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
546: ) IS
547:
548: l_api_name VARCHAR2(35) := 'check_service_link';
549: l_proc_name VARCHAR2(35) := 'CHECK_SERVICE_LINK';

Line 551: l_okl_chr_id OKC_K_HEADERS_V.ID%TYPE;

547:
548: l_api_name VARCHAR2(35) := 'check_service_link';
549: l_proc_name VARCHAR2(35) := 'CHECK_SERVICE_LINK';
550: l_api_version CONSTANT NUMBER := 1;
551: l_okl_chr_id OKC_K_HEADERS_V.ID%TYPE;
552: l_oks_chr_id OKC_K_HEADERS_V.ID%TYPE;
553: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_service_link';
554: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
555: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 552: l_oks_chr_id OKC_K_HEADERS_V.ID%TYPE;

548: l_api_name VARCHAR2(35) := 'check_service_link';
549: l_proc_name VARCHAR2(35) := 'CHECK_SERVICE_LINK';
550: l_api_version CONSTANT NUMBER := 1;
551: l_okl_chr_id OKC_K_HEADERS_V.ID%TYPE;
552: l_oks_chr_id OKC_K_HEADERS_V.ID%TYPE;
553: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_service_link';
554: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
555: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
556: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

Line 1813: FROM OKC_K_HEADERS_V chr,

1809: khr.deal_type,
1810: chr.scs_code,
1811: chr.sts_code,
1812: sts.meaning
1813: FROM OKC_K_HEADERS_V chr,
1814: OKC_STATUSES_V sts,
1815: OKL_K_HEADERS_V khr
1816: WHERE chr.id = p_contract_id
1817: AND chr.sts_code = sts.code