DBA Data[Home] [Help]

APPS.OKS_REPRICE_PVT dependencies on OKS_K_HEADERS_B

Line 30: l_price_uom oks_k_headers_b.price_uom%TYPE;

26: l_return_status VARCHAR2 (1)
27: := okc_api.g_ret_sts_success;
28: l_msg_count NUMBER;
29: l_msg_data VARCHAR2 (2000);
30: l_price_uom oks_k_headers_b.price_uom%TYPE;
31: invalid_uom_exception EXCEPTION;
32:
33: CURSOR cur_get_lines IS
34: SELECT oks.ID,

Line 45: FROM oks_k_headers_b

41: AND okc.ID = oks.cle_id;
42:
43: CURSOR cur_hdr_uom IS
44: SELECT price_uom
45: FROM oks_k_headers_b
46: WHERE chr_id = p_chr_id;
47: BEGIN
48: -- start debug log
49: IF (fnd_log.level_procedure >= fnd_log.g_current_runtime_level) THEN

Line 993: UPDATE oks_k_headers_b

989: OPEN l_toplinetax_csr;
990: FETCH l_toplinetax_csr INTO l_tot_topline_tax;
991: CLOSE l_toplinetax_csr;
992:
993: UPDATE oks_k_headers_b
994: SET tax_amount = l_tot_topline_tax
995: WHERE chr_id = p_chr_id;
996: -- end added skekkar to update header tax amount
997: */

Line 2958: FROM oks_k_headers_b

2954: --'LST' AS renewal_pricing_type, -- Bug 6016714
2955: renewal_markup_percent,
2956: chr_id,
2957: ID
2958: FROM oks_k_headers_b
2959: WHERE chr_id = p_chr_id;
2960:
2961: CURSOR l_line_csr (
2962: p_line_id NUMBER