APPS.OKS_RENCPY_PVT dependencies on OKC_SECTION_CONTENTS

Line 169: --Proceudre copy_sections - Makes a copy of the okc_sections and okc_section_contents.

165: ----------------------------------------------------------------------------
166: --Function specs to populate pl/sql record with database values ends
167: ----------------------------------------------------------------------------
168: ----------------------------------------------------------------------------
169: --Proceudre copy_sections - Makes a copy of the okc_sections and okc_section_contents.
170: ----------------------------------------------------------------------------
171: PROCEDURE copy_sections(
172: p_api_version IN NUMBER,
173: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

Line 198: FROM okc_section_contents

194: l_sec sec_tbl_type;
195:
196: CURSOR c_scc IS
197: SELECT scn_id
198: FROM okc_section_contents
199: WHERE id = p_scc_id;
200:
201: CURSOR c_scn(p_scn_id IN NUMBER) IS
202: SELECT id, LEVEL

Line 657: FROM okc_section_contents

653: WHERE cat_id = p_id;
654:
655: CURSOR c_scc IS
656: SELECT id
657: FROM okc_section_contents
658: WHERE cat_id = p_cat_id;
659:
660: BEGIN
661: x_return_status := l_return_status;

Line 3733: FROM OKC_SECTION_CONTENTS_V

3729: ATTRIBUTE12,
3730: ATTRIBUTE13,
3731: ATTRIBUTE14,
3732: ATTRIBUTE15
3733: FROM OKC_SECTION_CONTENTS_V
3734: WHERE ID = p_scc_id;
3735: BEGIN
3736: OPEN c_sccv_rec;
3737: FETCH c_sccv_rec