APPS.OKL_AM_CREATE_QUOTE_PVT dependencies on OKC_K_HEADERS_V

Line 1609: l_contract_number OKC_K_HEADERS_V.CONTRACT_NUMBER%TYPE;

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

Line 3066: -- okc_k_headers_b instead of okc_k_headers_v

3062: x_assn_tbl OUT NOCOPY assn_tbl_type,
3063: p_term_from_intf IN VARCHAR2 DEFAULT 'N') AS
3064:
3065: -- SECHAWLA 14-APR-03 2902588 : Added contract_number in the SELECT clause. Changed FROM claue to use
3066: -- okc_k_headers_b instead of okc_k_headers_v
3067: -- Cursor to get the end date of the contract
3068: CURSOR cur_k_end_date ( p_chr_id NUMBER) IS
3069: SELECT contract_number, end_date
3070: FROM OKC_K_HEADERS_B

Line 3081: OKC_K_HEADERS_V KHR

3077: CURSOR cur_k_assets ( p_chr_id NUMBER ) IS
3078: SELECT COUNT(OKLV.id )
3079: FROM OKC_K_LINES_V OKLV,
3080: OKC_LINE_STYLES_V OLSV,
3081: OKC_K_HEADERS_V KHR
3082: WHERE OKLV.lse_id = OLSV.id
3083: AND OLSV.lty_code = 'FREE_FORM1'
3084: AND OKLV.chr_id = p_chr_id
3085: AND OKLV.sts_code = KHR.sts_code