APPS.OKS_REPRICE_PVT dependencies on OKS_K_LINES_B

Line 38: oks_k_lines_b oks

34: SELECT oks.ID,
35: oks.cle_id,
36: oks.object_version_number -- bug 4638902
37: FROM okc_k_lines_b okc,
38: oks_k_lines_b oks
39: WHERE okc.dnz_chr_id = p_chr_id
40: AND okc.lse_id IN (1, 7, 9, 25, 19)
41: AND okc.ID = oks.cle_id;
42:

Line 407: FROM oks_k_lines_b kln,

403: := 'do_prorating_pp';
404:
405: CURSOR l_oks_elements (p_line_id NUMBER) IS
406: SELECT itm.number_of_items,kln.toplvl_uom_code,lin.date_terminated
407: FROM oks_k_lines_b kln,
408: okc_k_items itm,
409: okc_k_lines_b lin
410: WHERE kln.cle_id = p_line_id
411: and itm.cle_id = kln.cle_id

Line 833: FROM oks_k_lines_b

829: CURSOR l_sublinetax_csr (
830: c_cle_id IN NUMBER
831: ) IS
832: SELECT SUM (NVL (tax_amount, 0)) topline_tax
833: FROM oks_k_lines_b
834: WHERE dnz_chr_id = p_chr_id
835: AND cle_id IN ( SELECT id
836: FROM okc_k_lines_b
837: WHERE dnz_chr_id = p_chr_id

Line 846: FROM oks_k_lines_b

842:
843: -- added skekkar to update tax amount for header
844: CURSOR l_toplinetax_csr IS
845: SELECT SUM (NVL (tax_amount, 0)) header_tax
846: FROM oks_k_lines_b
847: WHERE dnz_chr_id = p_chr_id
848: AND cle_id IN ( SELECT id
849: FROM okc_k_lines_b
850: WHERE dnz_chr_id = p_chr_id

Line 945: UPDATE oks_k_lines_b

941: OPEN l_sublinetax_csr (l_line_id);
942: FETCH l_sublinetax_csr INTO l_tot_subline_tax;
943: CLOSE l_sublinetax_csr;
944:
945: UPDATE oks_k_lines_b
946: SET tax_amount = l_tot_subline_tax
947: WHERE cle_id = l_line_id;
948: -- end added skekkar
949: */

Line 1152: -- update column clvl_extended_amt in oks_k_lines_b with price_negotiated

1148: l_kln_rec_in.ID := l_k_det_rec.ID;
1149: l_kln_rec_in.object_version_number := l_k_det_rec.object_version_number;
1150:
1151: -- bug 4865683 SKEKKAR
1152: -- update column clvl_extended_amt in oks_k_lines_b with price_negotiated
1153: l_kln_rec_in.clvl_extended_amt := NVL(p_amount,0) ;
1154: -- end added
1155:
1156: oks_contract_line_pub.update_line (p_api_version => 1.0,

Line 1979: FROM oks_k_lines_b

1975: CURSOR l_usage_type_csr (
1976: p_cle_id NUMBER
1977: ) IS
1978: SELECT usage_type
1979: FROM oks_k_lines_b
1980: WHERE cle_id = p_cle_id;
1981:
1982: CURSOR l_subs_elements_csr (
1983: p_line_id NUMBER

Line 2979: FROM oks_k_lines_b

2975: CURSOR l_usage_type_csr (
2976: p_cle_id NUMBER
2977: ) IS
2978: SELECT usage_type
2979: FROM oks_k_lines_b
2980: WHERE cle_id = p_cle_id;
2981:
2982: CURSOR l_subs_elements_csr (
2983: p_line_id NUMBER