APPS.OKS_EXTWARPRGM_OSO_PVT dependencies on OKC_K_LINES_V

Line 188: From OKC_K_LINES_V KL

184: , p_EndDate Date ) Return Number Is
185:
186: Cursor l_Service_Csr Is
187: Select KL.Id Cle_Id
188: From OKC_K_LINES_V KL
189: ,OKC_K_ITEMS_V KI
190: Where KL.dnz_chr_id = p_ChrId
191: And KL.lse_id In (14, 19)
192: And KL.Id = KI.cle_Id

Line 401: Select Start_Date, End_Date From OKC_K_LINES_V

397: x_status OUT NOCOPY VarChar2
398: )
399: Is
400: Cursor l_line_csr Is
401: Select Start_Date, End_Date From OKC_K_LINES_V
402: Where id = p_cle_id;
403:
404: l_line_csr_rec l_line_csr%ROWTYPE;
405:

Line 960: Select cle_id From OKC_K_LINES_V

956: x_msg_data OUT NOCOPY Varchar2
957: )
958: Is
959: Cursor l_parent_line_Csr is
960: Select cle_id From OKC_K_LINES_V
961: Where id = p_covered_line_id;
962:
963: l_api_version CONSTANT NUMBER := 1.0;
964: l_init_msg_list CONSTANT VARCHAR2(1) := OKC_API.G_FALSE;

Line 3828: Set Estimated_amount = (Select sum(price_negotiated) from Okc_k_lines_v

3824: If Not l_return_status = 'S' then
3825: Raise G_EXCEPTION_HALT_VALIDATION;
3826: End if;
3827: Update Okc_k_headers_b
3828: Set Estimated_amount = (Select sum(price_negotiated) from Okc_k_lines_v
3829: Where dnz_chr_id = l_chrid)
3830: Where id = l_chrid ;
3831: Launch_Workflow ( 'INSTALL BASE ACTIVITY : NEW ' || fnd_global.local_chr(10) ||
3832: 'Contract Number : ' || get_contract_number (l_chrid) || fnd_global.local_chr(10) ||