APPS.OKS_BILL_UTIL_PUB dependencies on OKC_K_HEADERS_B

Line 3179: ,OKC_K_HEADERS_B Hdr

3175: ,line.line_number
3176: FROM
3177: OKC_K_PARTY_ROLES_B okp
3178: ,OKC_K_LINES_B line
3179: ,OKC_K_HEADERS_B Hdr
3180: WHERE Hdr.id = line.dnz_chr_id
3181: AND line.id = p_line_id
3182: AND okp.dnz_chr_id = hdr.id
3183: AND okp.rle_code in ( 'CUSTOMER','SUBSCRIBER');

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

3251: l_line_id Number := 0;
3252: l_contracts_total Number := 0;
3253: l_rejected_con_total Number := 0;
3254:
3255: l_cont_num OKC_K_HEADERS_B.CONTRACT_NUMBER%type := Null;
3256: l_cont_num_mod OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%type := Null ;
3257: l_bil_amt Varchar2(16) := Null ;
3258: l_line_num Varchar2(300) := Null;
3259:

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

3252: l_contracts_total Number := 0;
3253: l_rejected_con_total Number := 0;
3254:
3255: l_cont_num OKC_K_HEADERS_B.CONTRACT_NUMBER%type := Null;
3256: l_cont_num_mod OKC_K_HEADERS_B.CONTRACT_NUMBER_MODIFIER%type := Null ;
3257: l_bil_amt Varchar2(16) := Null ;
3258: l_line_num Varchar2(300) := Null;
3259:
3260: l_string Varchar2(2000) := ' ' ;

Line 3794: FROM okc_k_headers_b

3790: WHERE BCL.CLE_ID = P_LINE_ID ;
3791:
3792: CURSOR l_hdr_csr(p_hdr_id NUMBER) IS
3793: SELECT currency_code
3794: FROM okc_k_headers_b
3795: WHERE id = p_HDR_id;
3796:
3797: L_GET_OKS_LINES_REC L_GET_OKS_LINES_CSR%ROWTYPE ;
3798: L_GET_BCL_LINES_REC L_GET_BCL_LINES_CSR%ROWTYPE ;

Line 4819: UPDATE okc_k_headers_b SET estimated_amount = l_hdr_amt

4815: OPEN l_hdr_Amt_csr;
4816: FETCH l_hdr_Amt_csr INTO l_hdr_amt ;
4817: CLOSE l_hdr_Amt_csr ;
4818:
4819: UPDATE okc_k_headers_b SET estimated_amount = l_hdr_amt
4820: WHERE id = p_dnz_chr_id;
4821: END IF;
4822:
4823: END Adjust_line_price;