eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKC_TERMS_MIGRATE_GRP dependencies on OKC_ARTICLE_VERSIONS

Line 1707: article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE,

1703: ls_ref_sequence NUMBER := 0;
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,

Line 1709: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,

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,
1713: article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE,

Line 1710: article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE,

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,
1713: article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE,
1714: start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE,

Line 1712: provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%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);
1716:

Line 1713: article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%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);
1716:
1717: l_cls_type_rec l_cls_type;

Line 1714: start_date OKC_ARTICLE_VERSIONS.START_DATE%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);
1716:
1717: l_cls_type_rec l_cls_type;
1718:

Line 1715: end_date OKC_ARTICLE_VERSIONS.END_DATE%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);
1716:
1717: l_cls_type_rec l_cls_type;
1718:
1719: CURSOR l_sec_id_validate_csr IS

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 6105: article_id OKC_ARTICLE_VERSIONS.ARTICLE_ID%TYPE,

6101:
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,

Line 6107: article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE,

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,
6111: article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE,

Line 6108: article_version_number OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_NUMBER%TYPE,

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,
6111: article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%TYPE,
6112: start_date OKC_ARTICLE_VERSIONS.START_DATE%TYPE,

Line 6110: provision_yn OKC_ARTICLE_VERSIONS.PROVISION_YN%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);
6114:

Line 6111: article_status OKC_ARTICLE_VERSIONS.ARTICLE_STATUS%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);
6114:
6115: l_cls_type_rec l_cls_type;

Line 6112: start_date OKC_ARTICLE_VERSIONS.START_DATE%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);
6114:
6115: l_cls_type_rec l_cls_type;
6116:

Line 6113: end_date OKC_ARTICLE_VERSIONS.END_DATE%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);
6114:
6115: l_cls_type_rec l_cls_type;
6116:
6117: CURSOR l_cls_id_validate_csr IS