APPS.OKC_REVIEW_UPLD_TERMS_PVT dependencies on OKC_ARTICLE_VERSIONS

Line 1950: from okc_article_versions av, okc_review_upld_terms ar

1946: document_id = p_document_id;
1947:
1948: CURSOR is_article_ibr (p_review_upld_terms_id NUMBER) is
1949: SELECT 'Y'
1950: from okc_article_versions av, okc_review_upld_terms ar
1951: where av.article_version_id = ar.article_version_id
1952: and av.insert_by_reference = 'Y'
1953: and ar.review_upld_terms_id= p_review_upld_terms_id;
1954:

Line 1964: from okc_article_versions av, okc_review_upld_terms ar

1960: and ar.review_upld_terms_id= p_review_upld_terms_id;
1961:
1962: CURSOR is_article_text_locked (p_review_upld_terms_id NUMBER) is
1963: SELECT 'Y'
1964: from okc_article_versions av, okc_review_upld_terms ar
1965: where av.article_version_id = ar.article_version_id
1966: and av.lock_text = 'Y'
1967: and ar.review_upld_terms_id= p_review_upld_terms_id;
1968:

Line 2925: OKC_REVIEW_UPLD_TERMS rev, okc_article_versions av

2921: kart_var.variable_value kart_variable_value, rev_var.variable_value rev_variable_value,
2922: kart_var.variable_type, rev_var.variable_value_id
2923:
2924: FROM OKC_REVIEW_VAR_VALUES rev_var, okc_k_art_variables kart_var,
2925: OKC_REVIEW_UPLD_TERMS rev, okc_article_versions av
2926: WHERE rev.object_id = kart_var.cat_id
2927: AND rev.REVIEW_UPLD_TERMS_id = rev_var.REVIEW_UPLD_TERMS_id
2928: AND kart_var.variable_code = rev_var.variable_code
2929: AND av.article_version_id = rev.article_version_id

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

2941: and nvl(av.insert_by_reference,'N') <> 'Y';
2942:
2943: cursor variables_removed is
2944: select rev.review_upld_terms_id, kart_var.variable_code, variable_name, language, description
2945: from okc_k_art_variables kart_var, okc_review_upld_terms rev, okc_bus_variables_tl bustl, okc_article_versions av
2946: where rev.object_id = kart_var.cat_id
2947: and rev.document_type = p_document_type and rev.document_id = p_document_id
2948: and rev.article_version_id = av.article_version_id
2949: and kart_var.variable_code not in (select variable_code from okc_review_Var_values rev_var

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

2957: select rev.review_upld_terms_id, rev_var.variable_code, rev_var.variable_type,
2958: decode(rev_var.variable_value,
2959: NULL, 'N',
2960: 'Y') modified
2961: from okc_review_upld_Terms rev, okc_review_var_values rev_var, okc_article_versions av
2962: where rev.document_type = p_document_type and rev.document_id = p_document_id
2963: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
2964: and av.article_version_id = rev.article_version_id
2965: and not exists(

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

3019: cursor valid_new_var_ibr(p_intent VARCHAR2) is
3020: select rev.review_upld_terms_id, rev_var.variable_code, rev_var.variable_type,
3021: decode(rev_var.variable_value,
3022: NULL, 'N', 'Y') modified
3023: from okc_review_upld_terms rev, okc_review_var_values rev_var, okc_article_versions av
3024: where rev.document_type = p_document_type and rev.document_id = p_document_id
3025: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3026: and av.article_version_id = rev.article_version_id
3027: and (

Line 3056: from okc_article_versions av, okc_review_upld_terms ar

3052:
3053:
3054: CURSOR is_article_ibr(p_user_access VARCHAR2) is
3055: SELECT 'Y', ACTION, review_upld_terms_id, object_title
3056: from okc_article_versions av, okc_review_upld_terms ar
3057: where av.article_version_id = ar.article_version_id
3058: and av.insert_by_reference = 'Y'
3059: and ar.document_type = p_document_type
3060: and ar.document_id = p_document_id

Line 3078: from okc_article_versions av, okc_review_upld_terms ar

3074: and p_user_access <> 'SUPER_USER';
3075:
3076: CURSOR is_article_text_locked(p_user_access VARCHAR2) is
3077: SELECT 'Y', ACTION, review_upld_terms_id, object_title
3078: from okc_article_versions av, okc_review_upld_terms ar
3079: where av.article_version_id = ar.article_version_id
3080: and av.lock_text = 'Y'
3081: and ar.document_type = p_document_type
3082: and ar.document_id = p_document_id

Line 3130: from okc_review_upld_terms ut, okc_article_versions ver

3126: |||||

|

|

|

|

|

|

|

|

|

|

|

|