APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on OKC_SECTIONS_B

Line 592: FROM okc_sections_b

588: IS
589: CURSOR cur_validate_section
590: IS
591: SELECT 'Y'
592: FROM okc_sections_b
593: WHERE document_type = 'TEMPLATE'
594: AND document_id = p_template_id
595: AND ID = p_scn_id;
596:

Line 2021: /* SELECT okc_sections_b_s.NEXTVAL

2017: IS
2018: BEGIN
2019: IF p_section_rec.ID = okc_api.g_miss_num
2020: THEN
2021: /* SELECT okc_sections_b_s.NEXTVAL
2022: INTO p_section_rec.ID
2023: FROM DUAL; */
2024: p_section_rec.ID := NULL;
2025: END IF;

Line 3315: DELETE FROM okc_sections_b

3311: );
3312: RAISE fnd_api.g_exc_error;
3313: ELSE
3314: FORALL i IN 1 .. p_section_id_tbl.COUNT
3315: DELETE FROM okc_sections_b
3316: WHERE ID = p_section_id_tbl (i)
3317: AND document_type = 'TEMPLATE'
3318: AND document_id = p_template_id
3319: RETURNING ID