APPS.OKL_AM_LEASE_LOAN_TRMNT_PVT dependencies on OKC_K_HEADERS_V

Line 523: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE

519: x_return_status OUT NOCOPY VARCHAR2,
520: x_msg_count OUT NOCOPY NUMBER,
521: x_msg_data OUT NOCOPY VARCHAR2,
522: p_lease_asset_id IN OKC_K_LINES_V.ID%TYPE,
523: x_service_contract_id OUT NOCOPY OKC_K_HEADERS_V.ID%TYPE
524: ) IS
525:
526: l_api_name VARCHAR2(35) := 'check_service_link';
527: l_proc_name VARCHAR2(35) := 'CHECK_SERVICE_LINK';

Line 529: l_okl_chr_id OKC_K_HEADERS_V.ID%TYPE;

525:
526: l_api_name VARCHAR2(35) := 'check_service_link';
527: l_proc_name VARCHAR2(35) := 'CHECK_SERVICE_LINK';
528: l_api_version CONSTANT NUMBER := 1;
529: l_okl_chr_id OKC_K_HEADERS_V.ID%TYPE;
530: l_oks_chr_id OKC_K_HEADERS_V.ID%TYPE;
531: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_service_link';
532: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
533: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);

Line 530: l_oks_chr_id OKC_K_HEADERS_V.ID%TYPE;

526: l_api_name VARCHAR2(35) := 'check_service_link';
527: l_proc_name VARCHAR2(35) := 'CHECK_SERVICE_LINK';
528: l_api_version CONSTANT NUMBER := 1;
529: l_okl_chr_id OKC_K_HEADERS_V.ID%TYPE;
530: l_oks_chr_id OKC_K_HEADERS_V.ID%TYPE;
531: l_module_name VARCHAR2(500) := G_MODULE_NAME || 'check_service_link';
532: is_debug_exception_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_EXCEPTION);
533: is_debug_procedure_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_PROCEDURE);
534: is_debug_statement_on boolean := OKL_DEBUG_PUB.Check_Log_On (l_module_name, G_LEVEL_STATEMENT);

Line 1791: FROM OKC_K_HEADERS_V chr,

1787: khr.deal_type,
1788: chr.scs_code,
1789: chr.sts_code,
1790: sts.meaning
1791: FROM OKC_K_HEADERS_V chr,
1792: OKC_STATUSES_V sts,
1793: OKL_K_HEADERS_V khr
1794: WHERE chr.id = p_contract_id
1795: AND chr.sts_code = sts.code