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 1993: from okc_k_articles_b akb, okc_review_upld_terms ar

1989: and ar.review_upld_terms_id= p_review_upld_terms_id;
1990:
1991: CURSOR is_article_mandatory (p_review_upld_terms_id NUMBER) is
1992: SELECT 'Y'
1993: from okc_k_articles_b akb, okc_review_upld_terms ar
1994: where akb.id = ar.object_id
1995: and akb.mandatory_yn = 'Y'
1996: and ar.review_upld_terms_id= p_review_upld_terms_id;
1997:

Line 2453: UPDATE okc_k_articles_b

2449: 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');
2450: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'13100: Clause Title=' || obj_titles(i));
2451: END IF;
2452:
2453: UPDATE okc_k_articles_b
2454: SET scn_id = l_ref_id
2455: WHERE id = obj_ids(i);
2456:
2457: OKC_K_NON_STD_ART_GRP.create_non_std_article(

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

2553: END IF;
2554:
2555: IF ((l_user_access = 'SUPER_USER' ) OR is_mandatory_text <> 'Y') then
2556: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2557: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14000: Before invoking delete on okc_k_articles_b');
2558: END IF;
2559: IF p_mode = 'AMEND' THEN
2560:
2561: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2565: UPDATE okc_k_articles_b kart

2561: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2562: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14100: B4 delete k_art mode=AMEND, objectID='||obj_ids(i));
2563: END IF;
2564:
2565: UPDATE okc_k_articles_b kart
2566: SET kart.last_updated_by = fnd_global.user_id,
2567: kart.last_update_date = sysdate,
2568: kart.amendment_operation_code = 'DELETED',
2569: kart.summary_amend_operation_code =

Line 2583: DELETE FROM okc_k_articles_b

2579: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2580: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14200: after delete k_art, objectID='||obj_ids(i));
2581: END IF;
2582:
2583: DELETE FROM okc_k_articles_b
2584: WHERE id = obj_ids(i);
2585: END IF;
2586:
2587: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

2584: WHERE id = obj_ids(i);
2585: END IF;
2586:
2587: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2588: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14300: After delete on okc_k_articles_b');
2589: END IF;
2590: END IF; --IF ((l_user_access = 'SUPER_USER' )
2591: END IF; --IF obj_types(i) = 'SECTION' THEN
2592: --ELSE

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

2605: WHERE id = obj_ids(i)
2606: AND obj_types(i) = 'SECTION';
2607:
2608: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14500: Before Bulk update of okc_k_articles_b');
2610: END IF;
2611:
2612: FORALL i IN rut_ids.FIRST..rut_ids.LAST
2613: UPDATE okc_k_articles_b

Line 2613: UPDATE okc_k_articles_b

2609: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'14500: Before Bulk update of okc_k_articles_b');
2610: END IF;
2611:
2612: FORALL i IN rut_ids.FIRST..rut_ids.LAST
2613: UPDATE okc_k_articles_b
2614: SET scn_id = pobj_ids(i),
2615: display_sequence = disp_seqs(i)
2616: WHERE id = obj_ids(i)
2617: AND obj_types(i) = 'ARTICLE';

Line 2950: l_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;

2946: l_section_counter NUMBER;
2947: l_doc_num_scheme OKC_TEMPLATE_USAGES.DOC_NUMBERING_SCHEME%TYPE;
2948: l_user_access VARCHAR2(30);
2949: l_message_name FND_NEW_MESSAGES.MESSAGE_NAME%TYPE;
2950: l_sequence OKC_K_ARTICLES_B.DISPLAY_SEQUENCE%TYPE;
2951: l_count NUMBER;
2952: l_prev_rev_id OKC_REVIEW_UPLD_TERMS.REVIEW_UPLD_TERMS_ID%TYPE;
2953: l_prev_new_parent_id OKC_REVIEW_UPLD_TERMS.NEW_PARENT_ID%TYPE;
2954: l_intent OKC_BUS_DOC_TYPES_B.INTENT%TYPE;

Line 3023: from okc_k_art_variables art_var, okc_k_articles_b kart

3019:
3020: cursor current_variable_values is
3021: select art_var.cat_id, art_var.variable_code, art_var.variable_type, art_var.external_yn,
3022: art_var.attribute_value_set_id,art_var.variable_value_id, art_var.variable_value
3023: from okc_k_art_variables art_var, okc_k_articles_b kart
3024: where art_var.cat_id = kart.id
3025: and kart.document_type = p_document_type and kart.document_id = p_document_id;
3026:
3027: cursor variable_values_changed is

Line 3176: from okc_k_articles_b akb, okc_review_upld_terms ar

3172: and p_user_access <> 'SUPER_USER';
3173:
3174: CURSOR is_article_mandatory(p_user_access VARCHAR2) is
3175: SELECT 'Y', ACTION, review_upld_terms_id, object_title
3176: from okc_k_articles_b akb, okc_review_upld_terms ar
3177: where akb.id = ar.object_id
3178: and akb.mandatory_yn = 'Y'
3179: and ar.document_type = p_document_type
3180: and ar.document_id = p_document_id

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

3389: and object_type = 'SECTION' and new_parent_id = p_document_id;
3390:
3391:
3392: update okc_REVIEW_UPLD_TERMS rev
3393: set rev.article_id = (select sav_sae_id from okc_k_articles_b
3394: where document_type = p_document_type
3395: and document_id = p_document_id
3396: and id = rev.object_id)
3397:

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

3394: where document_type = p_document_type
3395: and document_id = p_document_id
3396: and id = rev.object_id)
3397:
3398: ,rev.article_version_id = (select article_version_id from okc_k_articles_b
3399: where document_type = p_document_type
3400: and document_id = p_document_id
3401: and id = rev.object_id)
3402: where document_type = p_document_type

Line 3408: and exists (select 1 from okc_k_articles_b kart

3404: and object_type = 'ARTICLE'
3405: and object_id is not null
3406: and article_id is null
3407: and article_version_id is null
3408: and exists (select 1 from okc_k_articles_b kart
3409: where document_type = p_document_type
3410: and document_id = p_document_id
3411: and id = rev.object_id);
3412:

Line 3459: FROM OKC_K_ARTICLES_B A

3455: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE
3456: AND NEW_PARENT_ID IS NOT NULL
3457: AND ((OBJECT_TYPE = 'ARTICLE'
3458: AND ( NOT EXISTS (SELECT 1
3459: FROM OKC_K_ARTICLES_B A
3460: WHERE A.ID = UT.OBJECT_ID
3461: AND A.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3462: AND A.DOCUMENT_ID = UT.DOCUMENT_ID) OR
3463: EXISTS (SELECT 1

Line 3464: FROM OKC_K_ARTICLES_B A1

3460: WHERE A.ID = UT.OBJECT_ID
3461: AND A.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3462: AND A.DOCUMENT_ID = UT.DOCUMENT_ID) OR
3463: EXISTS (SELECT 1
3464: FROM OKC_K_ARTICLES_B A1
3465: WHERE A1.ID = UT.OBJECT_ID
3466: AND A1.DOCUMENT_TYPE = UT.DOCUMENT_TYPE
3467: AND A1.DOCUMENT_ID = UT.DOCUMENT_ID
3468: AND NVL(A1.AMENDMENT_OPERATION_CODE,'ZZZ') = 'DELETED') )

Line 3541: FROM OKC_K_ARTICLES_B KART,

3537: FND_GLOBAL.USER_ID,
3538: SYSDATE,
3539: FND_GLOBAL.USER_ID,
3540: SYSDATE
3541: FROM OKC_K_ARTICLES_B KART,
3542: OKC_ARTICLES_ALL ART,
3543: OKC_ARTICLE_VERSIONS VER
3544: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3545: AND ART.ARTICLE_ID = VER.ARTICLE_ID

Line 3644: FROM OKC_K_ARTICLES_B KART

3640:
3641: UPDATE OKC_REVIEW_UPLD_TERMS UT
3642: SET ACTION='UPDATED',
3643: DISPLAY_SEQ = (select KART.display_sequence
3644: FROM OKC_K_ARTICLES_B KART
3645: WHERE KART.ID = UT.OBJECT_ID)
3646: WHERE ACTION IS NULL
3647: AND DOCUMENT_ID = P_DOCUMENT_ID
3648: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE

Line 3653: FROM OKC_K_ARTICLES_B KART,

3649: AND OBJECT_TYPE = 'ARTICLE'
3650: AND EXISTS
3651: (
3652: SELECT 1
3653: FROM OKC_K_ARTICLES_B KART,
3654: OKC_ARTICLES_ALL ART,
3655: OKC_ARTICLE_VERSIONS VER
3656: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3657: AND ART.ARTICLE_ID = VER.ARTICLE_ID

Line 3674: FROM OKC_K_ARTICLES_B KART

3670:
3671: UPDATE OKC_REVIEW_UPLD_TERMS UT
3672: SET ACTION='UPDATED',
3673: DISPLAY_SEQ = (select KART.display_sequence
3674: FROM OKC_K_ARTICLES_B KART
3675: WHERE KART.ID = UT.OBJECT_ID)
3676: WHERE ACTION IS NULL
3677: AND DOCUMENT_ID = P_DOCUMENT_ID
3678: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE

Line 3683: FROM OKC_K_ARTICLES_B KART,

3679: AND OBJECT_TYPE = 'ARTICLE'
3680: AND EXISTS
3681: (
3682: SELECT 1
3683: FROM OKC_K_ARTICLES_B KART,
3684: OKC_ARTICLES_ALL ART,
3685: OKC_ARTICLE_VERSIONS VER
3686: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3687: AND ART.ARTICLE_ID = VER.ARTICLE_ID

Line 3752: FROM OKC_K_ARTICLES_B KART,

3748: WHERE DOCUMENT_ID = P_DOCUMENT_ID
3749: AND DOCUMENT_TYPE = P_DOCUMENT_TYPE
3750: AND OBJECT_TYPE = 'ARTICLE'
3751: AND EXISTS (SELECT 1
3752: FROM OKC_K_ARTICLES_B KART,
3753: OKC_ARTICLES_ALL ART
3754: WHERE KART.SAV_SAE_ID = ART.ARTICLE_ID
3755: AND KART.ID = UT.OBJECT_ID
3756: AND KART.DOCUMENT_TYPE = UT.DOCUMENT_TYPE

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

4046:
4047: update okc_review_upld_terms rev
4048: set action = 'DELETED',
4049: object_title = (select nvl(ver.display_name,art. article_title)
4050: from OKC_K_ARTICLES_B kart, OKC_ARTICLES_ALL ART, OKC_ARTICLE_VERSIONS VER
4051: where kart.id = rev.object_id
4052: and kart.sav_sae_id = art.article_id
4053: and kart.article_version_id = ver.article_version_id
4054: and art.article_id = ver.article_id)

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

4051: where kart.id = rev.object_id
4052: and kart.sav_sae_id = art.article_id
4053: and kart.article_version_id = ver.article_version_id
4054: and art.article_id = ver.article_id)
4055: ,object_text = (select ver.article_text from OKC_K_ARTICLES_B kart, OKC_ARTICLE_VERSIONS VER
4056: where kart.id = rev.object_id
4057: and kart.article_Version_id = ver.article_version_id)
4058:
4059: where document_type = p_document_type