APPS.OKS_SETUP_UTIL_PUB dependencies on OKS_KLN_PVT

Line 187: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;

183: where dnz_chr_id=p_chr_id
184: and cle_id =p_cle_id;
185:
186: get_ccr_rec get_ccr%rowtype;
187: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
188: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
189: l_error_tbl OKC_API.ERROR_TBL_TYPE;
190:
191: Begin

Line 188: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;

184: and cle_id =p_cle_id;
185:
186: get_ccr_rec get_ccr%rowtype;
187: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
188: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
189: l_error_tbl OKC_API.ERROR_TBL_TYPE;
190:
191: Begin
192: l_return_status := OKC_API.G_RET_STS_SUCCESS;

Line 635: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;

631: l_msg_data Varchar2(2000);
632: l_api_version Number := 1;
633: l_init_msg_list Varchar2(1) := 'F';
634:
635: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
636: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
637:
638: CURSOR get_lines_attr_csr (p_cle_id NUMBER) IS
639: SELECT *

Line 636: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;

632: l_api_version Number := 1;
633: l_init_msg_list Varchar2(1) := 'F';
634:
635: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
636: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
637:
638: CURSOR get_lines_attr_csr (p_cle_id NUMBER) IS
639: SELECT *
640: FROM oks_k_lines_v

Line 1756: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;

1752:
1753:
1754: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1755: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1756: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1757: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1758:
1759: CURSOR old_cle_csr(p_cle_id NUMBER) IS
1760: SELECT orig_system_id1

Line 1757: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;

1753:
1754: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1755: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1756: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1757: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1758:
1759: CURSOR old_cle_csr(p_cle_id NUMBER) IS
1760: SELECT orig_system_id1
1761: FROM okc_k_lines_b