APPS.OKS_BILL_UTIL_PUB dependencies on OKC_K_HEADERS_B

Line 3213: ,OKC_K_HEADERS_B Hdr

3209: ,line.line_number
3210: FROM
3211: OKC_K_PARTY_ROLES_B okp
3212: ,OKC_K_LINES_B line
3213: ,OKC_K_HEADERS_B Hdr
3214: WHERE Hdr.id = line.dnz_chr_id
3215: AND line.id = p_line_id
3216: AND okp.dnz_chr_id = hdr.id
3217: AND okp.rle_code in ( 'CUSTOMER','SUBSCRIBER');

Line 3289: l_cont_num OKC_K_HEADERS_B.CONTRACT_NUMBER%type := Null;

3285: l_line_id Number := 0;
3286: l_contracts_total Number := 0;
3287: l_rejected_con_total Number := 0;
3288:
3289: l_cont_num OKC_K_HEADERS_B.CONTRACT_NUMBER%type := Null;
3290: l_cont_num_mod OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%type := Null ;
3291: l_bil_amt Varchar2(16) := Null ;
3292: l_line_num Varchar2(300) := Null;
3293:

Line 3290: l_cont_num_mod OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%type := Null ;

3286: l_contracts_total Number := 0;
3287: l_rejected_con_total Number := 0;
3288:
3289: l_cont_num OKC_K_HEADERS_B.CONTRACT_NUMBER%type := Null;
3290: l_cont_num_mod OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%type := Null ;
3291: l_bil_amt Varchar2(16) := Null ;
3292: l_line_num Varchar2(300) := Null;
3293:
3294: l_string Varchar2(2000) := ' ' ;

Line 3829: FROM okc_k_headers_b

3825: WHERE BCL.CLE_ID = P_LINE_ID ;
3826:
3827: CURSOR l_hdr_csr(p_hdr_id NUMBER) IS
3828: SELECT currency_code
3829: FROM okc_k_headers_b
3830: WHERE id = p_HDR_id;
3831:
3832: L_GET_OKS_LINES_REC L_GET_OKS_LINES_CSR%ROWTYPE ;
3833: L_GET_BCL_LINES_REC L_GET_BCL_LINES_CSR%ROWTYPE ;

Line 4239: FROM okc_k_headers_b

4235: FROM OKS_BILL_CONT_LINES BCL
4236: WHERE BCL.CLE_ID = P_LINE_ID ;
4237: CURSOR l_hdr_csr(p_hdr_id NUMBER) IS
4238: SELECT currency_code
4239: FROM okc_k_headers_b
4240: WHERE id = p_HDR_id;
4241: L_GET_OKS_LINES_REC L_GET_OKS_LINES_CSR%ROWTYPE ;
4242: L_GET_BCL_LINES_REC L_GET_BCL_LINES_CSR%ROWTYPE ;
4243: SUBTYPE BCLV_REC_TYPE IS OKS_BILLCONT_PVT.BCLV_REC_TYPE;

Line 5313: UPDATE okc_k_headers_b SET estimated_amount = l_hdr_amt

5309: OPEN l_hdr_Amt_csr;
5310: FETCH l_hdr_Amt_csr INTO l_hdr_amt ;
5311: CLOSE l_hdr_Amt_csr ;
5312:
5313: UPDATE okc_k_headers_b SET estimated_amount = l_hdr_amt
5314: WHERE id = p_dnz_chr_id;
5315: END IF;
5316:
5317: END Adjust_line_price;