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 630: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;

626: l_msg_data Varchar2(2000);
627: l_api_version Number := 1;
628: l_init_msg_list Varchar2(1) := 'F';
629:
630: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
631: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
632:
633: CURSOR get_lines_attr_csr (p_cle_id NUMBER) IS
634: SELECT *

Line 631: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;

627: l_api_version Number := 1;
628: l_init_msg_list Varchar2(1) := 'F';
629:
630: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
631: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
632:
633: CURSOR get_lines_attr_csr (p_cle_id NUMBER) IS
634: SELECT *
635: FROM oks_k_lines_v

Line 1748: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;

1744:
1745:
1746: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1747: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1748: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1749: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1750:
1751: CURSOR old_cle_csr(p_cle_id NUMBER) IS
1752: SELECT orig_system_id1

Line 1749: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;

1745:
1746: l_bil_sch_out_tbl OKS_BILL_SCH.ItemBillSch_tbl;
1747: l_strlvl_tbl OKS_BILL_SCH.StreamLvl_tbl;
1748: l_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1749: x_klnv_tbl oks_kln_pvt.klnv_tbl_type;
1750:
1751: CURSOR old_cle_csr(p_cle_id NUMBER) IS
1752: SELECT orig_system_id1
1753: FROM okc_k_lines_b