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_XPRT_UTIL_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 3310: FROM OKC_ARTICLE_VERSIONS VERS

3306:
3307:
3308: CURSOR csr_provision (p_article_version_id NUMBER) IS
3309: SELECT NVL(PROVISION_YN,'N')
3310: FROM OKC_ARTICLE_VERSIONS VERS
3311: WHERE vers.article_version_id = p_article_version_id;
3312:
3313:
3314: CURSOR l_get_max_article_csr(p_article_id NUMBER) IS

Line 3316: FROM okc_article_versions

3312:
3313:
3314: CURSOR l_get_max_article_csr(p_article_id NUMBER) IS
3315: SELECT article_version_id
3316: FROM okc_article_versions
3317: WHERE article_id= p_article_id
3318: AND article_status in ('ON_HOLD','APPROVED')
3319: AND start_date = (SELECT MAX(start_date)
3320: FROM okc_article_versions

Line 3320: FROM okc_article_versions

3316: FROM okc_article_versions
3317: WHERE article_id= p_article_id
3318: AND article_status in ('ON_HOLD','APPROVED')
3319: AND start_date = (SELECT MAX(start_date)
3320: FROM okc_article_versions
3321: WHERE article_id= p_article_id
3322: AND article_status in ('ON_HOLD','APPROVED')
3323: );
3324:

Line 3843: FROM OKC_ARTICLE_VERSIONS VERS

3839: --
3840: --
3841: CURSOR csr_art_provision (p_article_id NUMBER) IS
3842: SELECT NVL(PROVISION_YN,'N')
3843: FROM OKC_ARTICLE_VERSIONS VERS
3844: WHERE vers.article_id = p_article_id;
3845:
3846: --cursors used for new OKC rules engine
3847:

Line 3862: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_article_versions ver

3858: AND outcome.object_type = 'CLAUSE';
3859:
3860: CURSOR c_expert_nonprovision_articles IS
3861: SELECT distinct outcome.object_value_id
3862: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_article_versions ver
3863: WHERE rultmp.doc_id = p_document_id
3864: AND rultmp.doc_type = p_document_type
3865: AND rultmp.condition_id IS NULL
3866: AND nvl(rultmp.result, '*' ) = 'Y'

Line 4646: okc_article_versions ver

4642:
4643: CURSOR l_approved_ver_csr(p_article_id NUMBER, effective_date DATE) IS
4644: SELECT ver.article_id, ver.article_version_id, 'L'
4645: FROM okc_articles_all art,
4646: okc_article_versions ver
4647: WHERE art.article_id = p_article_id
4648: AND art.article_id = ver.article_id
4649: AND ver.article_status IN ('APPROVED','ON_HOLD')
4650: AND nvl(effective_date,trunc(SYSDATE)) BETWEEN ver.start_date AND NVL(ver.end_date,TRUNC(SYSDATE));

Line 4655: FROM okc_article_versions ver

4651:
4652: -- bug 4106513
4653: CURSOR l_approved_latest_ver_csr(p_article_id NUMBER ) IS
4654: SELECT ver.article_id, ver.article_version_id, 'L'
4655: FROM okc_article_versions ver
4656: WHERE ver.article_id = p_article_id
4657: AND ver.article_status IN ('APPROVED','ON_HOLD')
4658: AND ver.start_date = (SELECT max(start_date)
4659: FROM okc_article_versions ver1

Line 4659: FROM okc_article_versions ver1

4655: FROM okc_article_versions ver
4656: WHERE ver.article_id = p_article_id
4657: AND ver.article_status IN ('APPROVED','ON_HOLD')
4658: AND ver.start_date = (SELECT max(start_date)
4659: FROM okc_article_versions ver1
4660: WHERE ver1.article_id = p_article_id
4661: AND ver1.article_status IN ('APPROVED','ON_HOLD'));
4662:
4663: BEGIN

Line 5782: from okc_article_versions

5778: FROM okc_articles_v art
5779: WHERE article_id=to_number(p_object_value_code)
5780: AND article_version_number=
5781: (select max(article_version_number)
5782: from okc_article_versions
5783: where article_id= Art.article_id);*/
5784: CURSOR c1 IS
5785: SELECT article_description
5786: FROM okc_article_versions art

Line 5786: FROM okc_article_versions art

5782: from okc_article_versions
5783: where article_id= Art.article_id);*/
5784: CURSOR c1 IS
5785: SELECT article_description
5786: FROM okc_article_versions art
5787: WHERE article_id=to_number(p_object_value_code)
5788: AND article_version_number=
5789: (select max(article_version_number)
5790: from okc_article_versions

Line 5790: from okc_article_versions

5786: FROM okc_article_versions art
5787: WHERE article_id=to_number(p_object_value_code)
5788: AND article_version_number=
5789: (select max(article_version_number)
5790: from okc_article_versions
5791: where article_id= to_number(p_object_value_code));
5792: --End:Perf Bug#5032199
5793:
5794: CURSOR C2 IS

Line 6350: FROM okc_article_versions Art

6346: RETURN VARCHAR2 IS
6347:
6348: Cursor c1 is
6349: SELECT decode(article_status,'ON_HOLD','N','EXPIRED','N','Y') valid_yn
6350: FROM okc_article_versions Art
6351: WHERE article_id= p_object_id
6352: AND article_version_number=
6353: (select max(article_version_number)
6354: from okc_article_versions

Line 6354: from okc_article_versions

6350: FROM okc_article_versions Art
6351: WHERE article_id= p_object_id
6352: AND article_version_number=
6353: (select max(article_version_number)
6354: from okc_article_versions
6355: where article_id= Art.article_id);
6356:
6357:
6358: Cursor c2 is

Line 7079: FROM OKC_ARTICLE_VERSIONS VERS

7075: --
7076: --
7077: CURSOR csr_art_provision (p_article_id NUMBER) IS
7078: SELECT NVL(PROVISION_YN,'N')
7079: FROM OKC_ARTICLE_VERSIONS VERS
7080: WHERE vers.article_id = p_article_id;
7081:
7082: --
7083: -- Currsor to Get Line number for deviation

Line 7110: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_article_versions ver

7106: AND outcome.object_type = 'CLAUSE';
7107:
7108: CURSOR c_expert_nonprovision_articles IS
7109: SELECT distinct outcome.object_value_id
7110: FROM okc_xprt_rule_eval_result_t rultmp, okc_xprt_rule_hdrs_all_v rul, okc_xprt_rule_outcomes_act_v outcome, okc_article_versions ver
7111: WHERE rultmp.doc_id = p_document_id
7112: AND rultmp.doc_type = p_document_type
7113: AND rultmp.condition_id IS NULL
7114: AND nvl(rultmp.result, '*' ) = 'Y'

Line 7826: l_def_scn_code okc_article_versions.default_section%TYPE;

7822: l_api_version CONSTANT NUMBER := 1;
7823: l_api_name CONSTANT VARCHAR2(30) := 'get_article_details';
7824:
7825: l_xprt_scn_code okc_terms_templates_all.xprt_scn_code%TYPE;
7826: l_def_scn_code okc_article_versions.default_section%TYPE;
7827: l_scn_code okc_sections_b.scn_code%TYPE;
7828:
7829:
7830: l_article_number OKC_ARTICLES_ALL.article_number%TYPE;

Line 7835: FROM okc_articles_all a,okc_article_versions ver

7831:
7832: --Bug#4757731 cursor to get clause title and clause description
7833: CURSOR csr_clause_details(b_article_id NUMBER, b_article_version_id NUMBER) IS
7834: SELECT article_title,article_description, a.article_number
7835: FROM okc_articles_all a,okc_article_versions ver
7836: WHERE a.article_id = b_article_id
7837: AND a.article_id = ver.article_id
7838: AND ver.article_version_id = b_article_version_id;
7839:

Line 7852: FROM OKC_ARTICLE_VERSIONS VERS

7848: -- From Library
7849:
7850: CURSOR csr_lib_clause_desc_scn (b_article_id NUMBER, b_article_version_id NUMBER) IS
7851: SELECT nvl(default_section,'UNASSIGNED') scn_code
7852: FROM OKC_ARTICLE_VERSIONS VERS
7853: WHERE vers.article_id = b_article_id
7854: AND vers.article_version_id = b_article_version_id;
7855:
7856: CURSOR csr_xprt_scn_code IS