APPS.OKL_INS_QUOTE_PVT dependencies on OKC_K_HEADERS_V

Line 571: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST

567: ) RETURN VARCHAR2 IS
568: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
569: CURSOR okc_k_status_csr(p_khr_id IN NUMBER) IS
570: SELECT STE_CODE
571: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST
572: WHERE KHR.ID = p_khr_id
573: AND KHR.STS_CODE = OST.CODE ;
574:
575: BEGIN

Line 2459: FROM OKC_K_HEADERS_V

2455: IS
2456: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2457: CURSOR okc_k_term_csr(p_khr_id IN NUMBER) IS
2458: SELECT START_DATE,END_DATE
2459: FROM OKC_K_HEADERS_V
2460: WHERE OKC_K_HEADERS_V.ID = p_khr_id;
2461: BEGIN
2462: x_return_status := l_return_status;
2463: OPEN okc_k_term_csr(p_khr_id);

Line 2460: WHERE OKC_K_HEADERS_V.ID = p_khr_id;

2456: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2457: CURSOR okc_k_term_csr(p_khr_id IN NUMBER) IS
2458: SELECT START_DATE,END_DATE
2459: FROM OKC_K_HEADERS_V
2460: WHERE OKC_K_HEADERS_V.ID = p_khr_id;
2461: BEGIN
2462: x_return_status := l_return_status;
2463: OPEN okc_k_term_csr(p_khr_id);
2464: FETCH okc_k_term_csr INTO x_date_from, x_date_to ;

Line 2495: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST

2491: l_status VARCHAR2(80);
2492: --p_contract_status VARCHAR2(1):= '?';
2493: CURSOR okc_k_status_csr IS
2494: SELECT STE_CODE
2495: FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST
2496: WHERE KHR.ID = p_khr_id
2497: AND KHR.STS_CODE = OST.CODE ;
2498:
2499:

Line 2512: 'OKC_K_HEADERS_V',

2508: g_no_parent_record,
2509: g_col_name_token,
2510: 'ste_code',
2511: g_child_table_token ,
2512: 'OKC_K_HEADERS_V',
2513: g_parent_table_token ,
2514: 'OKC_STATUSES_B');
2515: END IF;
2516: CLOSE okc_k_status_csr ;

Line 6066: l_khr_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR ;

6062: activated_pol_tbl OKL_INS_QUOTE_PVT.policy_tbl_type ;
6063: nonactivated_pol_tbl OKL_INS_QUOTE_PVT.policy_tbl_type;
6064: l_activated_counter NUMBER := 0;
6065: l_notactivated_counter NUMBER := 0;
6066: l_khr_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE := OKC_API.G_MISS_CHAR ;
6067:
6068: -- Bug 3742614 Modified Cursor definition
6069: CURSOR okl_eli_policies_csr(l_afterlease_criteria IN NUMBER,l_percentage_criteria IN NUMBER )
6070: IS