DBA Data[Home] [Help]

APPS.OKC_TERMS_MIGRATE_GRP dependencies on OKC_ARTICLES_ALL

Line 1708: article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE,

1704: l_doc_intent VARCHAR2(1);
1705:
1706: TYPE l_cls_type IS RECORD (
1707: article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE,
1708: article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE,
1709: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
1710: article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE,
1711: article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE,
1712: provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE,

Line 1711: article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE,

1707: article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE,
1708: article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE,
1709: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
1710: article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE,
1711: article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE,
1712: provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE,
1713: article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE,
1714: start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE,
1715: end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE);

Line 3003: FROM okc_k_articles_b kb, okc_articles_all a , okc_article_versions v

2999: l_k_art_id := p_k_clause_id;
3000: ELSIF p_clause_title IS NOT NULL AND p_clause_version IS NOT NULL THEN
3001:
3002: SELECT kb.id INTO l_k_art_id
3003: FROM okc_k_articles_b kb, okc_articles_all a , okc_article_versions v
3004: WHERE a.article_title = p_clause_title AND a.org_id = G_CURRENT_ORG_ID
3005: AND kb.document_type = p_doc_type AND kb.document_id = p_doc_id
3006: AND v.article_version_number = p_clause_version AND a.article_id = v.article_id
3007: AND kb.sav_sae_id = a.article_id AND kb.article_version_id = v.article_version_id;

Line 6106: article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE,

6102:
6103:
6104: TYPE l_cls_type IS RECORD (
6105: article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE,
6106: article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE,
6107: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
6108: article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE,
6109: article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE,
6110: provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE,

Line 6109: article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE,

6105: article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE,
6106: article_title OKC_ARTICLES_ALL.ARTICLE_TITLE%TYPE,
6107: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,
6108: article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE,
6109: article_intent OKC_ARTICLES_ALL.ARTICLE_INTENT%TYPE,
6110: provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%TYPE,
6111: article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE,
6112: start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE,
6113: end_date OKC_ARTICLE_VERSIONS.END_DATE%TYPE);