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_REVIEW_UPLD_TERMS_PVT dependencies on OKC_K_ARTICLES_B

Line 1957: from okc_k_articles_b akb, okc_review_upld_terms ar

1953: and ar.review_upld_terms_id= p_review_upld_terms_id;
1954:
1955: CURSOR is_article_mandatory (p_review_upld_terms_id NUMBER) is
1956: SELECT 'Y'
1957: from okc_k_articles_b akb, okc_review_upld_terms ar
1958: where akb.id = ar.object_id
1959: and akb.mandatory_yn = 'Y'
1960: and ar.review_upld_terms_id= p_review_upld_terms_id;
1961:

Line 2356: UPDATE okc_k_articles_b

2352: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13000: Before invoking OKC_K_NON_STD_ART_GRP.create_non_std_article');
2353: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13100: Clause Title=' || obj_titles(i));
2354: END IF;
2355:
2356: UPDATE okc_k_articles_b
2357: SET scn_id = l_ref_id
2358: WHERE id = obj_ids(i);
2359:
2360: OKC_K_NON_STD_ART_GRP.create_non_std_article(

Line 2455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14000: Before invoking delete on okc_k_articles_b');

2451: END IF;
2452:
2453: IF ((l_user_access = 'SUPER_USER' ) OR is_mandatory_text <> 'Y') then
2454: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2455: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14000: Before invoking delete on okc_k_articles_b');
2456: END IF;
2457: IF p_mode = 'AMEND' THEN
2458:
2459: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2463: UPDATE okc_k_articles_b kart

2459: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2460: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14100: B4 delete k_art mode=AMEND, objectID='||obj_ids(i));
2461: END IF;
2462:
2463: UPDATE okc_k_articles_b kart
2464: SET kart.last_updated_by = fnd_global.user_id,
2465: kart.last_update_date = sysdate,
2466: kart.amendment_operation_code = 'DELETED',
2467: kart.summary_amend_operation_code =

Line 2481: DELETE FROM okc_k_articles_b

2477: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2478: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14200: after delete k_art, objectID='||obj_ids(i));
2479: END IF;
2480:
2481: DELETE FROM okc_k_articles_b
2482: WHERE id = obj_ids(i);
2483: END IF;
2484:
2485: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2486: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14300: After delete on okc_k_articles_b');

2482: WHERE id = obj_ids(i);
2483: END IF;
2484:
2485: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2486: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14300: After delete on okc_k_articles_b');
2487: END IF;
2488: END IF; --IF ((l_user_access = 'SUPER_USER' )
2489: END IF; --IF obj_types(i) = 'SECTION' THEN
2490: --ELSE

Line 2507: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14500: Before Bulk update of okc_k_articles_b');

2503: WHERE id = obj_ids(i)
2504: AND obj_types(i) = 'SECTION';
2505:
2506: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2507: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14500: Before Bulk update of okc_k_articles_b');
2508: END IF;
2509:
2510: FORALL i IN rut_ids.FIRST..rut_ids.LAST
2511: UPDATE okc_k_articles_b

Line 2511: UPDATE okc_k_articles_b

2507: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14500: Before Bulk update of okc_k_articles_b');
2508: END IF;
2509:
2510: FORALL i IN rut_ids.FIRST..rut_ids.LAST
2511: UPDATE okc_k_articles_b
2512: SET scn_id = pobj_ids(i),
2513: display_sequence = disp_seqs(i)
2514: WHERE id = obj_ids(i)
2515: AND obj_types(i) = 'ARTICLE';

Line 2841: l_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;

2837: l_section_counter NUMBER;
2838: l_doc_num_scheme OKC_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE;
2839: l_user_access VARCHAR2(30);
2840: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2841: l_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2842: l_count NUMBER;
2843: l_prev_rev_id OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE;
2844: l_prev_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
2845: l_intent OKC_BUS_DOC_TYPES_B.INTENT%TYPE;

Line 2914: from okc_k_art_variables art_var, okc_k_articles_b kart

2910:
2911: cursor current_variable_values is
2912: select art_var.cat_id, art_var.variable_code, art_var.variable_type, art_var.external_yn,
2913: art_var.attribute_value_set_id,art_var.variable_value_id, art_var.variable_value
2914: from okc_k_art_variables art_var, okc_k_articles_b kart
2915: where art_var.cat_id = kart.id
2916: and kart.document_type = p_document_type and kart.document_id = p_document_id;
2917:
2918: cursor variable_values_changed is

Line 3067: from okc_k_articles_b akb, okc_review_upld_terms ar

3063: and p_user_access <> 'SUPER_USER';
3064:
3065: CURSOR is_article_mandatory(p_user_access VARCHAR2) is
3066: SELECT 'Y', ACTION, review_upld_terms_id, object_title
3067: from okc_k_articles_b akb, okc_review_upld_terms ar
3068: where akb.id = ar.object_id
3069: and akb.mandatory_yn = 'Y'
3070: and ar.document_type = p_document_type
3071: and ar.document_id = p_document_id

Line 3282: set rev.article_id = (select sav_sae_id from okc_k_articles_b

3278: and object_type = 'SECTION' and new_parent_id = p_document_id;
3279:
3280:
3281: update okc_REVIEW_UPLD_TERMS rev
3282: set rev.article_id = (select sav_sae_id from okc_k_articles_b
3283: where document_type = p_document_type
3284: and document_id = p_document_id
3285: and id = rev.object_id)
3286:

Line 3287: ,rev.article_version_id = (select article_version_id from okc_k_articles_b

3283: where document_type = p_document_type
3284: and document_id = p_document_id
3285: and id = rev.object_id)
3286:
3287: ,rev.article_version_id = (select article_version_id from okc_k_articles_b
3288: where document_type = p_document_type
3289: and document_id = p_document_id
3290: and id = rev.object_id)
3291: where document_type = p_document_type

Line 3297: and exists (select 1 from okc_k_articles_b kart

3293: and object_type = 'ARTICLE'
3294: and object_id is not null
3295: and article_id is null
3296: and article_version_id is null
3297: and exists (select 1 from okc_k_articles_b kart
3298: where document_type = p_document_type
3299: and document_id = p_document_id
3300: and id = rev.object_id);
3301:

Line 3348: FROM OKC_K_ARTICLES_B A

3344: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE
3345: AND NEW_PARENT_ID IS NOT NULL
3346: AND ((OBJECT_TYPE = 'ARTICLE'
3347: AND ( NOT EXISTS (SELECT 1
3348: FROM OKC_K_ARTICLES_B A
3349: WHERE A.ID = UT.OBJECT_ID
3350: AND A.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3351: AND A.DOCUMENT_ID = UT.DOCUMENT_ID) OR
3352: EXISTS (SELECT 1

Line 3353: FROM OKC_K_ARTICLES_B A1

3349: WHERE A.ID = UT.OBJECT_ID
3350: AND A.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3351: AND A.DOCUMENT_ID = UT.DOCUMENT_ID) OR
3352: EXISTS (SELECT 1
3353: FROM OKC_K_ARTICLES_B A1
3354: WHERE A1.ID = UT.OBJECT_ID
3355: AND A1.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3356: AND A1.DOCUMENT_ID = UT.DOCUMENT_ID
3357: AND NVL(A1.AMENDMENT_OPERATION_CODE,'ZZZ') = 'DELETED') )

Line 3429: FROM OKC_K_ARTICLES_B KART,

3425: FND_GLOBAL.USER_ID,
3426: SYSDATE,
3427: FND_GLOBAL.USER_ID,
3428: SYSDATE
3429: FROM OKC_K_ARTICLES_B KART,
3430: OKC_ARTICLES_ALL ART,
3431: OKC_ARTICLE_VERSIONS VER
3432: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3433: AND ART.ARTICLE_ID = VER.ARTICLE_ID

Line 3528: FROM OKC_K_ARTICLES_B KART

3524:
3525: UPDATE OKC_REVIEW_UPLD_TERMS UT
3526: SET ACTION='UPDATED',
3527: DISPLAY_SEQ = (select KART.display_sequence
3528: FROM OKC_K_ARTICLES_B KART
3529: WHERE KART.ID = UT.OBJECT_ID)
3530: WHERE ACTION IS NULL
3531: AND DOCUMENT_ID = P_DOCUMENT_ID
3532: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE

Line 3537: FROM OKC_K_ARTICLES_B KART,

3533: AND OBJECT_TYPE = 'ARTICLE'
3534: AND EXISTS
3535: (
3536: SELECT 1
3537: FROM OKC_K_ARTICLES_B KART,
3538: OKC_ARTICLES_ALL ART,
3539: OKC_ARTICLE_VERSIONS VER
3540: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3541: AND ART.ARTICLE_ID = VER.ARTICLE_ID

Line 3599: FROM OKC_K_ARTICLES_B KART,

3595: WHERE DOCUMENT_ID = P_DOCUMENT_ID
3596: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE
3597: AND OBJECT_TYPE = 'ARTICLE'
3598: AND EXISTS (SELECT 1
3599: FROM OKC_K_ARTICLES_B KART,
3600: OKC_ARTICLES_ALL ART
3601: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3602: AND KART.ID = UT.OBJECT_ID
3603: AND KART.DOCUMENT_TYPE = UT.DOCUMENT_TYPE

Line 3889: from OKC_K_ARTICLES_B kart, OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER

3885:
3886: update okc_review_upld_terms rev
3887: set action = 'DELETED',
3888: object_title = (select nvl(ver.display_name,art. article_title)
3889: from OKC_K_ARTICLES_B kart, OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
3890: where kart.id = rev.object_id
3891: and kart.sav_sae_id = art.article_id
3892: and kart.article_version_id = ver.article_version_id
3893: and art.article_id = ver.article_id)

Line 3894: ,object_text = (select ver.article_text from OKC_K_ARTICLES_B kart, OKC_ARTICLE_VERSIONS VER

3890: where kart.id = rev.object_id
3891: and kart.sav_sae_id = art.article_id
3892: and kart.article_version_id = ver.article_version_id
3893: and art.article_id = ver.article_id)
3894: ,object_text = (select ver.article_text from OKC_K_ARTICLES_B kart, OKC_ARTICLE_VERSIONS VER
3895: where kart.id = rev.object_id
3896: and kart.article_Version_id = ver.article_version_id)
3897:
3898: where document_type = p_document_type