APPS.OKL_AM_CREATE_QUOTE_PVT dependencies on OKC_K_HEADERS_V

Line 1608: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

1604: l_k_end_date DATE;
1605: l_rule_found BOOLEAN := FALSE;
1606: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_ERROR;
1607: l_contract_status OKC_STATUSES_V.MEANING%TYPE;
1608: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;
1609: l_missing_lines BOOLEAN := FALSE;
1610: l_missing_asset_qty BOOLEAN := FALSE;
1611: l_partial_asset_line BOOLEAN := FALSE;
1612: l_invalid_lines BOOLEAN := FALSE;

Line 3010: -- okc_k_headers_b instead of okc_k_headers_v

3006: x_tqlv_tbl OUT NOCOPY tqlv_tbl_type,
3007: x_assn_tbl OUT NOCOPY assn_tbl_type) AS
3008:
3009: -- SECHAWLA 14-APR-03 2902588 : Added contract_number in the SELECT clause. Changed FROM claue to use
3010: -- okc_k_headers_b instead of okc_k_headers_v
3011: -- Cursor to get the end date of the contract
3012: CURSOR cur_k_end_date ( p_chr_id NUMBER) IS
3013: SELECT contract_number, end_date
3014: FROM OKC_K_HEADERS_B

Line 3025: OKC_K_HEADERS_V KHR

3021: CURSOR cur_k_assets ( p_chr_id NUMBER ) IS
3022: SELECT COUNT(OKLV.id )
3023: FROM OKC_K_LINES_V OKLV,
3024: OKC_LINE_STYLES_V OLSV,
3025: OKC_K_HEADERS_V KHR
3026: WHERE OKLV.lse_id = OLSV.id
3027: AND OLSV.lty_code = 'FREE_FORM1'
3028: AND OKLV.chr_id = p_chr_id
3029: AND OKLV.sts_code = KHR.sts_code