APPS.OKC_IMP_TERMS_TEMPLATES_PVT dependencies on OKC_K_ARTICLES_B

Line 2982: INSERT INTO okc_k_articles_b

2978: RAISE;
2979: END;
2980:
2981: -- Call Insert Statement.
2982: INSERT INTO okc_k_articles_b
2983: (ID, sav_sae_id,
2984: sav_sav_release, sbt_code,
2985: cat_type, chr_id,
2986: cle_id, cat_id,

Line 3022: VALUES (okc_k_articles_b_s.NEXTVAL, p_article_rec.sav_sae_id,

3018: last_amended_by,
3019: last_amendment_date,
3020: mandatory_rwa
3021: )
3022: VALUES (okc_k_articles_b_s.NEXTVAL, p_article_rec.sav_sae_id,
3023: p_article_rec.sav_sav_release, p_article_rec.sbt_code,
3024: p_article_rec.cat_type, p_article_rec.chr_id,
3025: p_article_rec.cle_id, p_article_rec.cat_id,
3026: p_article_rec.dnz_chr_id,

Line 3228: DELETE FROM okc_k_articles_b

3224: );
3225: RAISE fnd_api.g_exc_error;
3226: ELSE
3227: FORALL i IN 1 .. p_k_article_id_tbl.COUNT
3228: DELETE FROM okc_k_articles_b
3229: WHERE ID = p_k_article_id_tbl (i)
3230: AND document_type = 'TEMPLATE'
3231: AND document_id = p_template_id
3232: RETURNING ID

Line 3325: DELETE FROM okc_k_articles_b

3321: END IF;
3322:
3323: -- Delete Articles associated with the section
3324: FORALL i IN 1 .. x_section_id_tbl.COUNT
3325: DELETE FROM okc_k_articles_b
3326: WHERE scn_id = x_section_id_tbl (i)
3327: AND document_type = 'TEMPLATE'
3328: AND document_id = p_template_id;
3329: x_return_status := g_ret_sts_success;