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 1802: FROM okc_articles_all art,

1798: l_display_name okc_article_versions.display_name%TYPE;
1799: l_global_org_id number;
1800: CURSOR ver_csr IS
1801: SELECT nvl(ver.display_name,art.article_title) name
1802: FROM okc_articles_all art,
1803: okc_article_versions ver
1804: WHERE art.org_id = p_org_id
1805: AND art.article_id = p_article_id
1806: AND art.article_id = ver.article_id

Line 1834: FROM okc_articles_all art,

1830: RETURN NUMBER IS
1831: l_article_version_id okc_article_versions.article_version_id%TYPE;
1832: CURSOR ver_csr IS
1833: SELECT ver.article_version_id
1834: FROM okc_articles_all art,
1835: okc_article_versions ver
1836: WHERE art.article_id = p_article_id
1837: AND art.article_id = ver.article_id
1838: AND ver.start_date <= nvl(p_eff_date,sysdate)

Line 2003: okc_articles_all art

1999: CURSOR alt_csr(cp_effective_date DATE) IS
2000: SELECT 1
2001: FROM okc_article_relatns_all reln,
2002: okc_article_versions ver,
2003: okc_articles_all art
2004: WHERE reln.source_article_id = p_article_id
2005: AND reln.relationship_type = 'ALTERNATE'
2006: AND reln.target_article_id = art.article_id
2007: AND art.article_id = ver.article_id

Line 2350: FROM okc_articles_all a

2346: RETURN Varchar2 IS
2347:
2348: CURSOR csr_article_title IS
2349: SELECT a.article_title, a.article_number
2350: FROM okc_articles_all a
2351: WHERE a.article_id = p_article_id;
2352:
2353: CURSOR csr_article_display_name IS
2354: SELECT a.display_name

Line 2678: FROM OKC_ARTICLES_ALL

2674: ;
2675:
2676: CURSOR l_get_article_org_csr IS
2677: SELECT org_id
2678: FROM OKC_ARTICLES_ALL
2679: WHERE article_id = p_article_id;
2680:
2681: CURSOR l_article_number (b_article__version_id IN NUMBER) IS
2682: SELECT article_version_number

Line 3585: FROM okc_articles_all art,

3581:
3582: -- modify this cursor to exclude versions from the the table OKC_DRAFT_CLAUSES
3583: CURSOR l_draft_ver_csr(cp_effective_date DATE) IS
3584: SELECT ver.article_version_id
3585: FROM okc_articles_all art,
3586: okc_article_versions ver
3587: WHERE art.article_id = p_article_id
3588: AND art.article_id = ver.article_id
3589: AND cp_effective_date BETWEEN ver.start_date AND NVL(ver.end_date,cp_effective_date+1)

Line 3603: FROM okc_articles_all art,

3599:
3600: -- last effort to get a clause for template in draft status
3601: CURSOR l_draft_latest_ver_csr(cp_effective_date DATE) IS
3602: SELECT ver.article_version_id
3603: FROM okc_articles_all art,
3604: okc_article_versions ver
3605: WHERE art.article_id = p_article_id
3606: AND art.article_id = ver.article_id
3607: -- Bugs 4018610, 4018467, the start date of draft clause can be

Line 3638: FROM okc_articles_all art,

3634:
3635:
3636: CURSOR l_approved_ver_csr(cp_effective_date DATE) IS
3637: SELECT ver.article_version_id
3638: FROM okc_articles_all art,
3639: okc_article_versions ver
3640: WHERE art.article_id = p_article_id
3641: AND art.article_id = ver.article_id
3642: AND ver.article_status IN ('APPROVED','EXPIRED','ON_HOLD')

Line 3647: FROM okc_articles_all art,

3643: AND cp_effective_date BETWEEN ver.start_date AND NVL(ver.end_date,cp_effective_date+1);
3644:
3645: CURSOR l_approved_latest_ver_csr(cp_effective_date DATE) IS
3646: SELECT ver.article_version_id
3647: FROM okc_articles_all art,
3648: okc_article_versions ver
3649: WHERE art.article_id = p_article_id
3650: AND art.article_id = ver.article_id
3651: AND ver.start_date <= cp_effective_date

Line 3663: FROM OKC_ARTICLES_ALL

3659: -- cursor to get article org id and local org id
3660: CURSOR l_get_article_org_csr(b_article_id NUMBER) IS
3661: SELECT org_id,
3662: mo_global.get_current_org_id() current_org_id
3663: FROM OKC_ARTICLES_ALL
3664: WHERE article_id = b_article_id;
3665:
3666: -- cursor to get latest adopted article version id for global article
3667: CURSOR l_get_max_adopted_article_csr(b_article_id IN NUMBER, b_current_org_id IN NUMBER) IS

Line 3799: l_article_id OKC.OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;

3795: x_msg_data OUT NOCOPY VARCHAR2)
3796: IS
3797: l_api_name CONSTANT VARCHAR2(30) := 'create_tmpl_clauses_to_submit';
3798: l_effective_date DATE;
3799: l_article_id OKC.OKC_ARTICLES_ALL.ARTICLE_ID%TYPE;
3800: l_section_name OKC.OKC_SECTIONS_B.HEADING%TYPE;
3801: l_article_label OKC.OKC_SECTIONS_B.LABEL%TYPE;
3802: l_multiple_sections VARCHAR2(1);
3803: l_return_status VARCHAR2(1);

Line 3825: okc_articles_all oaa

3821: oav.article_id,
3822: oav.start_date,
3823: oav.end_date
3824: FROM okc_article_Versions oav,
3825: okc_articles_all oaa
3826: WHERE oav.article_id = oaa.article_id
3827: AND oaa.org_id = cp_org_id
3828: AND oav.article_status IN ('DRAFT','REJECTED')
3829: AND oav.start_date <= cp_effective_date

Line 3850: okc_articles_all oaa

3846: cp_template_id NUMBER)IS
3847: SELECT oav.article_version_id,
3848: oav.article_id
3849: FROM okc_article_Versions oav,
3850: okc_articles_all oaa
3851: WHERE oav.article_id = oaa.article_id
3852: AND oaa.org_id = cp_org_id
3853: AND oav.article_status IN ('DRAFT','REJECTED')
3854: AND oaa.standard_yn = 'Y'

Line 5079: l_article_version_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;

5075: p_document_type IN VARCHAR2,
5076: p_document_id IN NUMBER ) RETURN NUMBER
5077: IS
5078:
5079: l_article_version_number OKC_ARTICLES_ALL.ARTICLE_NUMBER%TYPE;
5080: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;
5081: l_local_article_id OKC_K_ARTICLES_B.ORIG_ARTICLE_ID%TYPE;
5082: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;
5083: l_ref_article_id OKC_K_ARTICLES_B.REF_ARTICLE_ID%TYPE;