APPS.OKC_QP_UPGRADE_PUB dependencies on OKC_K_LINES_B

Line 672: l_itm_to_price_tbl varchar_tbl_type; -- holds item_to_price_yn for lse_id for lines in okc_k_lines_b

668: l_rul_pricelist_tbl num_tbl_type;
669: l_rul_object_code_tbl varchar_tbl_type;
670:
671: -- skekkar
672: l_itm_to_price_tbl varchar_tbl_type; -- holds item_to_price_yn for lse_id for lines in okc_k_lines_b
673: l_lse_id_tbl num_tbl_type; -- holds lse_id for lines in okc_k_lines_b
674: l_user_estimated_amount number := 0;
675: l_estimated_amount number := 0;
676: -- skekkar

Line 673: l_lse_id_tbl num_tbl_type; -- holds lse_id for lines in okc_k_lines_b

669: l_rul_object_code_tbl varchar_tbl_type;
670:
671: -- skekkar
672: l_itm_to_price_tbl varchar_tbl_type; -- holds item_to_price_yn for lse_id for lines in okc_k_lines_b
673: l_lse_id_tbl num_tbl_type; -- holds lse_id for lines in okc_k_lines_b
674: l_user_estimated_amount number := 0;
675: l_estimated_amount number := 0;
676: -- skekkar
677:

Line 756: FROM okc_k_lines_b

752: ,l_price_unit_tbl
753: ,l_priced_flag_tbl
754: ,l_price_list_tbl
755: ,l_lse_id_tbl
756: FROM okc_k_lines_b
757: CONNECT BY (prior id = cle_id AND dnz_chr_id=chr_rec.id )
758: START WITH chr_id = chr_rec.id;
759:
760:

Line 972: UPDATE okc_k_lines_b

968:
969: IF l_line_id_tbl.count > 0 THEN --#if12
970:
971: FORALL j IN NVL(l_line_id_tbl.FIRST,0)..NVL(l_line_id_tbl.LAST,-1)
972: UPDATE okc_k_lines_b
973: SET object_version_number = object_version_number+1,
974: last_updated_by = -1901903 ,--bug number
975: last_update_date = sysdate ,
976: line_list_price = l_line_list_price_tbl(j),

Line 1919: FROM okc_k_lines_b

1915: l_estimated_amt number := 0;
1916:
1917: CURSOR csr_estimated_amt IS
1918: SELECT SUM(NVL(price_negotiated,0))
1919: FROM okc_k_lines_b
1920: WHERE chr_id = p_chr_id;
1921:
1922: BEGIN
1923:

Line 1984: FROM okc_k_lines_b

1980: l_proc varchar2(72) := g_package||'create_manual_adjustment';
1981:
1982: CURSOR csr_man_adj IS
1983: SELECT *
1984: FROM okc_k_lines_b
1985: WHERE dnz_chr_id = p_chr_id
1986: AND NVL(price_level_ind,'N') = 'Y'
1987: AND NVL(line_list_price,0) <> NVL(price_negotiated,0);
1988:

Line 1999: l_k_lines_rec okc_k_lines_b%ROWTYPE;

1995: FROM qp_list_headers
1996: WHERE name = 'OKC_QP_UPGRADE'
1997: );
1998:
1999: l_k_lines_rec okc_k_lines_b%ROWTYPE;
2000: l_qp_list_lines_rec qp_list_lines%ROWTYPE;
2001: l_adj_amt number;
2002: l_id number;
2003: