863: l_sec sec_tbl_type;
864:
865: CURSOR c_scc IS
866: SELECT scn_id
867: FROM okc_section_contents_v
868: WHERE id = p_scc_id;
869:
870: CURSOR c_scn(p_scn_id IN NUMBER) IS
871: SELECT id,level
1537: WHERE cat_id = p_id;
1538:
1539: CURSOR c_scc IS
1540: SELECT id
1541: FROM okc_section_contents_v
1542: WHERE cat_id = p_cat_id;
1543:
1544: BEGIN
1545: IF (l_debug = 'Y') THEN
8804: ATTRIBUTE12,
8805: ATTRIBUTE13,
8806: ATTRIBUTE14,
8807: ATTRIBUTE15
8808: FROM OKC_SECTION_CONTENTS_V
8809: WHERE ID = p_scc_id;
8810: BEGIN
8811: OPEN c_sccv_rec;
8812: FETCH c_sccv_rec