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_ARTICLE_VERSIONS

Line 1840: l_display_name okc_article_versions.display_name%TYPE;

1836: Function Get_latest_art_version(p_article_id IN NUMBER,
1837: p_org_id IN NUMBER,
1838: p_eff_date IN DATE)
1839: RETURN Varchar2 IS
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,

Line 1845: okc_article_versions ver

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
1849: AND ver.start_date <= nvl(p_eff_date,sysdate)

Line 1851: from okc_article_versions ver1

1847: AND art.article_id = p_article_id
1848: AND art.article_id = ver.article_id
1849: AND ver.start_date <= nvl(p_eff_date,sysdate)
1850: AND ver.start_date = (select max(start_date)
1851: from okc_article_versions ver1
1852: where ver1.article_id = ver.article_id
1853: and ver1.start_date <= nvl(p_eff_date,sysdate)
1854: and ver1.article_status = ver.article_status)
1855: AND (ver.article_status = 'APPROVED' OR

Line 1857: from okc_article_versions ver2

1853: and ver1.start_date <= nvl(p_eff_date,sysdate)
1854: and ver1.article_status = ver.article_status)
1855: AND (ver.article_status = 'APPROVED' OR
1856: not exists (select 1
1857: from okc_article_versions ver2
1858: where ver2.article_id = art.article_id
1859: and ver2.start_date <= nvl(p_eff_date,sysdate)
1860: and ver2.article_status = 'APPROVED'));
1861:

Line 1873: l_article_version_id okc_article_versions.article_version_id%TYPE;

1869: /* Modified Cursor for Bug 4956969 */
1870: Function Get_latest_tmpl_art_version_id(p_article_id IN NUMBER,
1871: p_eff_date IN DATE)
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

Line 1877: okc_article_versions ver

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)
1881: AND ver.start_date = (select max(start_date)

Line 1882: from okc_article_versions ver1

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)
1881: AND ver.start_date = (select max(start_date)
1882: from okc_article_versions ver1
1883: where ver1.article_id = ver.article_id
1884: and ver1.start_date <= nvl(p_eff_date,sysdate)
1885: and ver1.article_status = ver.article_status)
1886: AND (ver.article_status = 'APPROVED' OR

Line 1888: from okc_article_versions ver2

1884: and ver1.start_date <= nvl(p_eff_date,sysdate)
1885: and ver1.article_status = ver.article_status)
1886: AND (ver.article_status = 'APPROVED' OR
1887: not exists (select 1
1888: from okc_article_versions ver2
1889: where ver2.article_id = art.article_id
1890: and ver2.start_date <= nvl(p_eff_date,sysdate)
1891: and ver2.article_status = 'APPROVED'));
1892: BEGIN

Line 2003: okc_article_versions ver

1999:
2000: CURSOR alt_csr IS
2001: SELECT 1
2002: FROM okc_article_relatns_all reln,
2003: okc_article_versions ver
2004: WHERE reln.source_article_id = p_article_id
2005: AND reln.relationship_type = 'ALTERNATE'
2006: AND reln.target_article_id = ver.article_id
2007: AND NVL(p_eff_date,SYSDATE) BETWEEN ver.start_date AND NVL(ver.end_date, nvl(p_eff_date,SYSDATE))

Line 2044: okc_article_versions ver,

2040:
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

Line 2285: FROM okc_article_versions

2281: FUNCTION get_article_version_number(p_art_version_id IN NUMBER)
2282: RETURN Varchar2 IS
2283: CURSOR csr_art_ver IS
2284: SELECT article_version_number
2285: FROM okc_article_versions
2286: WHERE article_version_id = p_art_version_id;
2287:
2288: l_article_version_number VARCHAR2(240);
2289:

Line 2397: FROM okc_article_versions a

2393: WHERE a.article_id = p_article_id;
2394:
2395: CURSOR csr_article_display_name IS
2396: SELECT a.display_name
2397: FROM okc_article_versions a
2398: WHERE a.article_version_id = p_article_version_id;
2399:
2400: l_article_title VARCHAR2(450) :='';
2401: l_article_number VARCHAR2(450) :='';

Line 2483: select default_section from okc_article_versions where article_version_id = l_article_version_id);

2479: l_name FND_LOOKUPS.MEANING%TYPE := null;
2480: l_article_version_id NUMBER;
2481: cursor get_default_section_name(l_article_version_id NUMBER) is
2482: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and lookup_code = (
2483: select default_section from okc_article_versions where article_version_id = l_article_version_id);
2484:
2485: cursor get_unassigned_section_name is
2486: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and
2487: lookup_code = 'UNASSIGNED';

Line 2519: and lookup_code = (select default_section from okc_article_versions

2515:
2516: cursor get_article_section_name(l_article_version_id NUMBER) is
2517: select meaning from fnd_lookups
2518: where lookup_type = 'OKC_ARTICLE_SECTION'
2519: and lookup_code = (select default_section from okc_article_versions
2520: where article_version_id = l_article_version_id);
2521:
2522: cursor get_expert_section_name(l_template_id NUMBER) is
2523: select meaning from fnd_lookups

Line 2638: FROM okc_article_versions

2634:
2635: CURSOR l_get_latest_article_csr(p_article_effective_date IN DATE) IS
2636: SELECT article_version_id ,
2637: article_version_number
2638: FROM okc_article_versions
2639: WHERE article_id= p_article_id
2640: AND article_status in ('ON_HOLD','APPROVED')
2641: AND sysdate >= Start_date
2642: AND sysdate <= nvl(end_date,sysdate+1)

Line 2647: FROM okc_article_versions

2643: AND p_document_type <> 'TEMPLATE'
2644: UNION ALL
2645: SELECT article_version_id ,
2646: article_version_number
2647: FROM okc_article_versions
2648: WHERE article_id= p_article_id
2649: AND nvl(p_article_effective_date,sysdate) >= Start_date
2650: AND nvl(p_article_effective_date,sysdate) <= nvl(end_date, nvl(p_article_effective_date,sysdate) +1)
2651: AND p_document_type = 'TEMPLATE'

Line 2658: FROM OKC_ARTICLE_VERSIONS VERS,

2654: CURSOR l_get_local_article_csr(p_article_effective_date IN DATE, b_local_org_id IN NUMBER) IS
2655: SELECT ADP.LOCAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
2656: ADP.ADOPTION_TYPE,
2657: VERS1.ARTICLE_ID
2658: FROM OKC_ARTICLE_VERSIONS VERS,
2659: OKC_ARTICLE_ADOPTIONS ADP,
2660: OKC_ARTICLE_VERSIONS VERS1
2661: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2662: AND VERS.ARTICLE_ID = p_article_id

Line 2660: OKC_ARTICLE_VERSIONS VERS1

2656: ADP.ADOPTION_TYPE,
2657: VERS1.ARTICLE_ID
2658: FROM OKC_ARTICLE_VERSIONS VERS,
2659: OKC_ARTICLE_ADOPTIONS ADP,
2660: OKC_ARTICLE_VERSIONS VERS1
2661: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2662: AND VERS.ARTICLE_ID = p_article_id
2663: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
2664: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(p_article_effective_date,sysdate) +1)

Line 2675: FROM OKC_ARTICLE_VERSIONS VERS,

2671: UNION ALL
2672: SELECT ADP.GLOBAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
2673: ADP.ADOPTION_TYPE,
2674: VERS.ARTICLE_ID
2675: FROM OKC_ARTICLE_VERSIONS VERS,
2676: OKC_ARTICLE_ADOPTIONS ADP
2677: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2678: AND VERS.ARTICLE_ID = p_article_id
2679: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE

Line 2690: FROM OKC_ARTICLE_VERSIONS VERS,

2686: UNION ALL
2687: SELECT ADP.LOCAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
2688: ADP.ADOPTION_TYPE,
2689: VERS1.ARTICLE_ID
2690: FROM OKC_ARTICLE_VERSIONS VERS,
2691: OKC_ARTICLE_ADOPTIONS ADP,
2692: OKC_ARTICLE_VERSIONS VERS1
2693: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2694: AND VERS.ARTICLE_ID = p_article_id

Line 2692: OKC_ARTICLE_VERSIONS VERS1

2688: ADP.ADOPTION_TYPE,
2689: VERS1.ARTICLE_ID
2690: FROM OKC_ARTICLE_VERSIONS VERS,
2691: OKC_ARTICLE_ADOPTIONS ADP,
2692: OKC_ARTICLE_VERSIONS VERS1
2693: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2694: AND VERS.ARTICLE_ID = p_article_id
2695: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE
2696: AND nvl(p_article_effective_date,sysdate) <= nvl(VERS.end_date, nvl(p_article_effective_date,sysdate) +1)

Line 2706: FROM OKC_ARTICLE_VERSIONS VERS,

2702: UNION ALL
2703: SELECT ADP.GLOBAL_ARTICLE_VERSION_ID LOCAL_ARTICLE_VERSION_ID,
2704: ADP.ADOPTION_TYPE,
2705: VERS.ARTICLE_ID
2706: FROM OKC_ARTICLE_VERSIONS VERS,
2707: OKC_ARTICLE_ADOPTIONS ADP
2708: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VERS.ARTICLE_VERSION_ID
2709: AND VERS.ARTICLE_ID = p_article_id
2710: AND nvl(p_article_effective_date,sysdate) >= VERS.START_DATE

Line 2725: FROM okc_article_versions

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
2725: FROM okc_article_versions
2726: WHERE article_version_id= b_article__version_id;
2727: l_api_name CONSTANT VARCHAR2(30) := 'get_latest_article_details';
2728: l_effective_date DATE := null;
2729: l_article_version_id NUMBER;

Line 3601: l_article_version_id okc_article_versions.article_version_id%TYPE;

3597: p_doc_type IN VARCHAR2 DEFAULT NULL,
3598: p_doc_id IN NUMBER DEFAULT NULL
3599: ,p_org_id in number default null) RETURN NUMBER
3600: IS
3601: l_article_version_id okc_article_versions.article_version_id%TYPE;
3602: l_effective_date DATE;
3603: l_article_org_id NUMBER;
3604: l_current_org_id NUMBER;
3605: l_api_name CONSTANT VARCHAR2(30) := 'get_latest_tmpl_art_version_id';

Line 3613: OKC_ARTICLE_VERSIONS ARTV

3609: -- new cursor to get draft/rejected versions from table OKC_TMPL_DRAFT_CLAUSES
3610: CURSOR l_draft_selected_ver_csr IS
3611: SELECT ARTV.article_version_id
3612: FROM OKC_TMPL_DRAFT_CLAUSES TMPLC,
3613: OKC_ARTICLE_VERSIONS ARTV
3614: WHERE TMPLC.template_id = p_doc_id
3615: AND TMPLC.article_id = p_article_id
3616: AND TMPLC.selected_yn = 'Y'
3617: AND ARTV.article_id = TMPLC.article_id

Line 3629: okc_article_versions ver

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)
3633: -- begin change

Line 3647: okc_article_versions ver

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
3651: -- changed to a future date, making this cursor return nothing

Line 3656: FROM okc_article_versions ver1

3652: -- The draft clause status can also change to pending approval
3653: -- or an approved clause can be put on hold after including in the template
3654: -- AND ver.start_date <= cp_effective_date
3655: AND ver.start_date = (SELECT max(start_date)
3656: FROM okc_article_versions ver1
3657: WHERE ver1.article_id = ver.article_id
3658: --AND ver1.start_date <= cp_effective_date
3659: --AND ver1.article_status = 'APPROVED'
3660: );

Line 3666: OKC_ARTICLE_VERSIONS ARTV

3662: -- new cursor to get draft/rejected versions from table OKC_TMPL_DRAFT_CLAUSES
3663: CURSOR l_pen_app_selected_ver_csr IS
3664: SELECT ARTV.article_version_id
3665: FROM OKC_TMPL_DRAFT_CLAUSES TMPLC,
3666: OKC_ARTICLE_VERSIONS ARTV
3667: WHERE TMPLC.template_id = p_doc_id
3668: AND TMPLC.article_id = p_article_id
3669: AND TMPLC.selected_yn = 'Y'
3670: AND ARTV.article_id = TMPLC.article_id

Line 3682: okc_article_versions ver

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')
3686: AND cp_effective_date BETWEEN ver.start_date AND NVL(ver.end_date,cp_effective_date+1);

Line 3691: okc_article_versions ver

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
3695: AND ver.article_status IN ('APPROVED','EXPIRED','ON_HOLD')

Line 3697: FROM okc_article_versions ver1

3693: AND art.article_id = ver.article_id
3694: AND ver.start_date <= cp_effective_date
3695: AND ver.article_status IN ('APPROVED','EXPIRED','ON_HOLD')
3696: AND ver.start_date = (SELECT max(start_date)
3697: FROM okc_article_versions ver1
3698: WHERE ver1.article_id = ver.article_id
3699: AND ver1.start_date <= cp_effective_date
3700: AND ver1.article_status IN ('APPROVED','EXPIRED','ON_HOLD'));
3701:

Line 3713: OKC_ARTICLE_VERSIONS VER

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
3711: SELECT ADP.GLOBAL_ARTICLE_VERSION_ID
3712: FROM OKC_ARTICLE_ADOPTIONS ADP,
3713: OKC_ARTICLE_VERSIONS VER
3714: WHERE ADP.GLOBAL_ARTICLE_VERSION_ID = VER.article_version_id
3715: AND VER.article_id = b_article_id
3716: AND ADP.LOCAL_ORG_ID = b_current_org_id
3717: --AND ADP.adoption_status IN ( 'APPROVED', 'ON_HOLD')

Line 3873: FROM okc_article_Versions oav,

3869: oav.article_version_id,
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')

Line 3898: FROM okc_article_Versions oav,

3894: CURSOR draft_articles_csr (cp_org_id NUMBER, cp_effective_date DATE,
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')

Line 3913: SELECT 'Y' from okc_Article_versions

3909: AND oka.document_type='TEMPLATE');
3910:
3911: CURSOR valid_ver_csr (cp_article_id NUMBER, cp_article_version_id NUMBER,
3912: cp_template_effective_date DATE) IS
3913: SELECT 'Y' from okc_Article_versions
3914: WHERE article_id = cp_article_id
3915: AND article_version_id <> cp_article_version_id
3916: AND article_status = 'APPROVED'
3917: AND start_date <= cp_template_effective_date

Line 4210: okc_article_versions ver

4206: lc_org_id NUMBER) IS
4207: SELECT 'Y'
4208: FROM okc_terms_templates_all tmpl,
4209: okc_k_articles_b kart,
4210: okc_article_versions ver
4211: WHERE tmpl.template_id = lc_tmpl_id
4212: AND kart.document_id = tmpl.template_id
4213: AND kart.document_type = 'TEMPLATE'
4214: AND ver.article_id = kart.sav_sae_id

Line 4218: okc_article_versions ver1

4214: AND ver.article_id = kart.sav_sae_id
4215: AND ver.global_yn = 'Y'
4216: AND NOT EXISTS (SELECT 1
4217: FROM okc_article_adoptions adp,
4218: okc_article_versions ver1
4219: WHERE adp.global_article_version_id = ver1.article_version_id
4220: AND ver1.article_id = ver.article_id
4221: AND adp.local_org_id = lc_org_id
4222: AND adp.adoption_status IN ( 'APPROVED', 'ON_HOLD')

Line 5129: l_article_version_id OKC_ARTICLE_VERSIONS.ARTICLE_VERSION_ID%TYPE;

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;
5133:

Line 5131: l_adoption_type OKC_ARTICLE_VERSIONS.ADOPTION_TYPE%TYPE;

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;
5133:
5134:
5135: -- Fix for bug# 5235082. Changed the query to use id instead of sav_sae_id