APPS.OKC_VERSION_PVT dependencies on OKC_SUBCLASSES_B

Line 356: l_cls_code OKC_SUBCLASSES_B.CLS_CODE%TYPE:=OKC_API.G_MISS_CHAR;

352: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
353: l_chr_id Number;
354: l_major_version Number;
355: l_cvmv_rec cvmv_rec_type;
356: l_cls_code OKC_SUBCLASSES_B.CLS_CODE%TYPE:=OKC_API.G_MISS_CHAR;
357: l_pdf_id NUMBER := NULL;
358: l_string VARCHAR2(4000);
359: proc_string VARCHAR2(4000);
360: l_msg_data varchar2(2000);

Line 368: FROM okc_k_headers_b, okc_subclasses_b

364:
365: -- Cursor to get the class code
366: CURSOR cur_scs(p_chr_id number) is
367: SELECT cls_code
368: FROM okc_k_headers_b, okc_subclasses_b
369: WHERE id = p_chr_id and code = scs_code;
370:
371: -- Cursor created to get the PDF_ID for a particular Class
372: CURSOR c_pdf(p_cls_code VARCHAR2) IS

Line 796: from okc_k_headers_b a,okc_subclasses_b b

792: nowait;
793:
794: cursor c_curs is
795: select b.cls_code
796: from okc_k_headers_b a,okc_subclasses_b b
797: where a.scs_code=b.code and a.id = p_chr_id;
798:
799: l_dummy varchar2(1);
800:

Line 1661: l_cls_code OKC_SUBCLASSES_B.CLS_CODE%TYPE:=OKC_API.G_MISS_CHAR;

1657: l_api_version CONSTANT NUMBER := 1;
1658: l_api_name CONSTANT VARCHAR2(30) := 'V_erase_saved_version';
1659: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1660:
1661: l_cls_code OKC_SUBCLASSES_B.CLS_CODE%TYPE:=OKC_API.G_MISS_CHAR;
1662: l_pdf_id NUMBER := NULL;
1663: l_string VARCHAR2(32000);
1664: proc_string VARCHAR2(32000);
1665:

Line 1669: FROM okc_k_headers_b, okc_subclasses_b

1665:
1666: -- Cursor to get the class code
1667: CURSOR cur_scs(p_chr_id number) is
1668: SELECT cls_code
1669: FROM okc_k_headers_b, okc_subclasses_b
1670: WHERE id = p_chr_id and code = scs_code;
1671:
1672: -- Cursor created to get the PDF_ID for a particular Class
1673: CURSOR c_pdf(p_cls_code VARCHAR2) IS