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_UTIL_PVT dependencies on OKC_ARTICLES_ALL

Line 1844: FROM okc_articles_all art,

1840: l_display_name okc_article_versions.display_name%TYPE;
1841: l_global_org_id number;
1842: CURSOR ver_csr IS
1843: SELECT nvl(ver.display_name,art.article_title) name
1844: FROM okc_articles_all art,
1845: okc_article_versions ver
1846: WHERE art.org_id = p_org_id
1847: AND art.article_id = p_article_id
1848: AND art.article_id = ver.article_id

Line 1876: FROM okc_articles_all art,

1872: RETURN NUMBER IS
1873: l_article_version_id okc_article_versions.article_version_id%TYPE;
1874: CURSOR ver_csr IS
1875: SELECT ver.article_version_id
1876: FROM okc_articles_all art,
1877: okc_article_versions ver
1878: WHERE art.article_id = p_article_id
1879: AND art.article_id = ver.article_id
1880: AND ver.start_date <= nvl(p_eff_date,sysdate)

Line 2045: okc_articles_all art

2041: CURSOR alt_csr(cp_effective_date DATE) IS
2042: SELECT 1
2043: FROM okc_article_relatns_all reln,
2044: okc_article_versions ver,
2045: okc_articles_all art
2046: WHERE reln.source_article_id = p_article_id
2047: AND reln.relationship_type = 'ALTERNATE'
2048: AND reln.target_article_id = art.article_id
2049: AND art.article_id = ver.article_id

Line 2392: FROM okc_articles_all a

2388: RETURN Varchar2 IS
2389:
2390: CURSOR csr_article_title IS
2391: SELECT a.article_title, a.article_number
2392: FROM okc_articles_all a
2393: WHERE a.article_id = p_article_id;
2394:
2395: CURSOR csr_article_display_name IS
2396: SELECT a.display_name

Line 2720: FROM OKC_ARTICLES_ALL

2716: ;
2717:
2718: CURSOR l_get_article_org_csr IS
2719: SELECT org_id
2720: FROM OKC_ARTICLES_ALL
2721: WHERE article_id = p_article_id;
2722:
2723: CURSOR l_article_number (b_article__version_id IN NUMBER) IS
2724: SELECT article_version_number

Line 3628: FROM okc_articles_all art,

3624:
3625: -- modify this cursor to exclude versions from the the table OKC_DRAFT_CLAUSES
3626: CURSOR l_draft_ver_csr(cp_effective_date DATE) IS
3627: SELECT ver.article_version_id
3628: FROM okc_articles_all art,
3629: okc_article_versions ver
3630: WHERE art.article_id = p_article_id
3631: AND art.article_id = ver.article_id
3632: AND cp_effective_date BETWEEN ver.start_date AND NVL(ver.end_date,cp_effective_date+1)

Line 3646: FROM okc_articles_all art,

3642:
3643: -- last effort to get a clause for template in draft status
3644: CURSOR l_draft_latest_ver_csr(cp_effective_date DATE) IS
3645: SELECT ver.article_version_id
3646: FROM okc_articles_all art,
3647: okc_article_versions ver
3648: WHERE art.article_id = p_article_id
3649: AND art.article_id = ver.article_id
3650: -- Bugs 4018610, 4018467, the start date of draft clause can be

Line 3681: FROM okc_articles_all art,

3677:
3678:
3679: CURSOR l_approved_ver_csr(cp_effective_date DATE) IS
3680: SELECT ver.article_version_id
3681: FROM okc_articles_all art,
3682: okc_article_versions ver
3683: WHERE art.article_id = p_article_id
3684: AND art.article_id = ver.article_id
3685: AND ver.article_status IN ('APPROVED','EXPIRED','ON_HOLD')

Line 3690: FROM okc_articles_all art,

3686: AND cp_effective_date BETWEEN ver.start_date AND NVL(ver.end_date,cp_effective_date+1);
3687:
3688: CURSOR l_approved_latest_ver_csr(cp_effective_date DATE) IS
3689: SELECT ver.article_version_id
3690: FROM okc_articles_all art,
3691: okc_article_versions ver
3692: WHERE art.article_id = p_article_id
3693: AND art.article_id = ver.article_id
3694: AND ver.start_date <= cp_effective_date

Line 3706: FROM OKC_ARTICLES_ALL

3702: -- cursor to get article org id and local org id
3703: CURSOR l_get_article_org_csr(b_article_id NUMBER) IS
3704: SELECT org_id,
3705: mo_global.get_current_org_id() current_org_id
3706: FROM OKC_ARTICLES_ALL
3707: WHERE article_id = b_article_id;
3708:
3709: -- cursor to get latest adopted article version id for global article
3710: CURSOR l_get_max_adopted_article_csr(b_article_id IN NUMBER, b_current_org_id IN NUMBER) IS

Line 3848: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;

3844: x_msg_data OUT NOCOPY VARCHAR2)
3845: IS
3846: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpl_clauses_to_submit';
3847: l_effective_date DATE;
3848: l_article_id OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;
3849: l_section_name OKC_SECTIONS_B.HEADING%TYPE;
3850: l_article_label OKC_SECTIONS_B.LABEL%TYPE;
3851: l_multiple_sections VARCHAR2(1);
3852: l_return_status VARCHAR2(1);

Line 3874: okc_articles_all oaa

3870: oav.article_id,
3871: oav.start_date,
3872: oav.end_date
3873: FROM okc_article_Versions oav,
3874: okc_articles_all oaa
3875: WHERE oav.article_id = oaa.article_id
3876: AND oaa.org_id = cp_org_id
3877: AND oav.article_status IN ('DRAFT','REJECTED')
3878: AND oav.start_date <= cp_effective_date

Line 3899: okc_articles_all oaa

3895: cp_template_id NUMBER)IS
3896: SELECT oav.article_version_id,
3897: oav.article_id
3898: FROM okc_article_Versions oav,
3899: okc_articles_all oaa
3900: WHERE oav.article_id = oaa.article_id
3901: AND oaa.org_id = cp_org_id
3902: AND oav.article_status IN ('DRAFT','REJECTED')
3903: AND oaa.standard_yn = 'Y'

Line 5128: l_article_version_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;

5124: p_document_type IN VARCHAR2,
5125: p_document_id IN NUMBER ) RETURN NUMBER
5126: IS
5127:
5128: l_article_version_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
5129: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
5130: l_local_article_id OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE;
5131: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
5132: l_ref_article_id OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE;