DBA Data[Home] [Help]

APPS.OKC_K_ARTICLES_PVT dependencies on OKC_TERMS_UTIL_GRP

Line 1305: AND p_document_type <> OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE

1301: END IF;
1302:
1303: -- this validation is not required for templates
1304: IF p_sav_sae_id IS NOT NULL AND p_article_version_id IS NOT NULL
1305: AND p_document_type <> OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE
1306: THEN
1307: l_dummy_var := '?';
1308: OPEN l_validate_article_csr;
1309: FETCH l_validate_article_csr into l_dummy_var;

Line 1752: decode(p_document_type, OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,NULL,p_article_version_id),

1748: p_scn_id,
1749: p_label,
1750: p_amendment_description,
1751: p_amendment_operation_code,
1752: decode(p_document_type, OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,NULL,p_article_version_id),
1753: p_change_nonstd_yn,
1754: p_orig_system_reference_code,
1755: p_orig_system_reference_id1,
1756: p_orig_system_reference_id2,

Line 2295: ARTICLE_VERSION_ID = decode(p_document_type,OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,NULL,p_article_version_id),

2291: DNZ_CHR_ID = l_chr_id,
2292: LABEL = p_label,
2293: AMENDMENT_DESCRIPTION = p_amendment_description,
2294: AMENDMENT_OPERATION_CODE = p_amendment_operation_code,
2295: ARTICLE_VERSION_ID = decode(p_document_type,OKC_TERMS_UTIL_GRP.G_TMPL_DOC_TYPE,NULL,p_article_version_id),
2296: CHANGE_NONSTD_YN = p_change_nonstd_yn,
2297: ORIG_SYSTEM_REFERENCE_CODE = p_orig_system_reference_code,
2298: ORIG_SYSTEM_REFERENCE_ID1 = p_orig_system_reference_id1,
2299: ORIG_SYSTEM_REFERENCE_ID2 = p_orig_system_reference_id2,