APPS.OKC_REVIEW_UPLD_TERMS_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 1894: TYPE obj_text_wml_tab IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE INDEX BY BINARY_INTEGER;

1890: TYPE orut_id_tab IS TABLE OF OKC_REVIEW_UPLD_TERMS.OLD_REVIEW_UPLD_TERMS_ID%TYPE INDEX BY BINARY_INTEGER;
1891: TYPE curr_obj_id_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1892: TYPE curr_disp_seq_tab IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
1893: --2 way word sync with clause edit
1894: TYPE obj_text_wml_tab IS TABLE OF OKC_ARTICLE_VERSIONS.ARTICLE_TEXT_IN_WORD%TYPE INDEX BY BINARY_INTEGER;
1895:
1896: rut_ids rut_id_tab;
1897: upld_levels upld_level_tab;
1898: obj_ids obj_id_tab;

Line 1986: from okc_article_versions av, okc_review_upld_terms ar

1982: document_id = p_document_id;
1983:
1984: CURSOR is_article_ibr (p_review_upld_terms_id NUMBER) is
1985: SELECT 'Y'
1986: from okc_article_versions av, okc_review_upld_terms ar
1987: where av.article_version_id = ar.article_version_id
1988: and av.insert_by_reference = 'Y'
1989: and ar.review_upld_terms_id= p_review_upld_terms_id;
1990:

Line 2000: from okc_article_versions av, okc_review_upld_terms ar

1996: and ar.review_upld_terms_id= p_review_upld_terms_id;
1997:
1998: CURSOR is_article_text_locked (p_review_upld_terms_id NUMBER) is
1999: SELECT 'Y'
2000: from okc_article_versions av, okc_review_upld_terms ar
2001: where av.article_version_id = ar.article_version_id
2002: and av.lock_text = 'Y'
2003: and ar.review_upld_terms_id= p_review_upld_terms_id;
2004:

Line 3034: OKC_REVIEW_UPLD_TERMS rev, okc_article_versions av

3030: kart_var.variable_value kart_variable_value, rev_var.variable_value rev_variable_value,
3031: kart_var.variable_type, rev_var.variable_value_id
3032:
3033: FROM OKC_REVIEW_VAR_VALUES rev_var, okc_k_art_variables kart_var,
3034: OKC_REVIEW_UPLD_TERMS rev, okc_article_versions av
3035: WHERE rev.object_id = kart_var.cat_id
3036: AND rev.REVIEW_UPLD_TERMS_id = rev_var.REVIEW_UPLD_TERMS_id
3037: AND kart_var.variable_code = rev_var.variable_code
3038: AND av.article_version_id = rev.article_version_id

Line 3054: from okc_k_art_variables kart_var, okc_review_upld_terms rev, okc_bus_variables_tl bustl, okc_article_versions av

3050: and nvl(av.insert_by_reference,'N') <> 'Y';
3051:
3052: cursor variables_removed is
3053: select rev.review_upld_terms_id, kart_var.variable_code, variable_name, language, description
3054: from okc_k_art_variables kart_var, okc_review_upld_terms rev, okc_bus_variables_tl bustl, okc_article_versions av
3055: where rev.object_id = kart_var.cat_id
3056: and rev.document_type = p_document_type and rev.document_id = p_document_id
3057: and rev.article_version_id = av.article_version_id
3058: and kart_var.variable_code not in (select variable_code from okc_review_Var_values rev_var

Line 3070: from okc_review_upld_Terms rev, okc_review_var_values rev_var, okc_article_versions av

3066: select rev.review_upld_terms_id, rev_var.variable_code, rev_var.variable_type,
3067: decode(rev_var.variable_value,
3068: NULL, 'N',
3069: 'Y') modified
3070: from okc_review_upld_Terms rev, okc_review_var_values rev_var, okc_article_versions av
3071: where rev.document_type = p_document_type and rev.document_id = p_document_id
3072: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3073: and av.article_version_id = rev.article_version_id
3074: and not exists(

Line 3132: from okc_review_upld_terms rev, okc_review_var_values rev_var, okc_article_versions av

3128: cursor valid_new_var_ibr(p_intent VARCHAR2) is
3129: select rev.review_upld_terms_id, rev_var.variable_code, rev_var.variable_type,
3130: decode(rev_var.variable_value,
3131: NULL, 'N', 'Y') modified
3132: from okc_review_upld_terms rev, okc_review_var_values rev_var, okc_article_versions av
3133: where rev.document_type = p_document_type and rev.document_id = p_document_id
3134: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3135: and av.article_version_id = rev.article_version_id
3136: and (

Line 3165: from okc_article_versions av, okc_review_upld_terms ar

3161:
3162:
3163: CURSOR is_article_ibr(p_user_access VARCHAR2) is
3164: SELECT 'Y', ACTION, review_upld_terms_id, object_title
3165: from okc_article_versions av, okc_review_upld_terms ar
3166: where av.article_version_id = ar.article_version_id
3167: and av.insert_by_reference = 'Y'
3168: and ar.document_type = p_document_type
3169: and ar.document_id = p_document_id

Line 3187: from okc_article_versions av, okc_review_upld_terms ar

3183: and p_user_access <> 'SUPER_USER';
3184:
3185: CURSOR is_article_text_locked(p_user_access VARCHAR2) is
3186: SELECT 'Y', ACTION, review_upld_terms_id, object_title
3187: from okc_article_versions av, okc_review_upld_terms ar
3188: where av.article_version_id = ar.article_version_id
3189: and av.lock_text = 'Y'
3190: and ar.document_type = p_document_type
3191: and ar.document_id = p_document_id

Line 3239: from okc_review_upld_terms ut, okc_article_versions ver

3235: |||||

|

|

|

|

|

|

|

|

|

|

|

|