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_REVIEW_VAR_VALUES

Line 2645: delete from OKC_REVIEW_VAR_VALUES where REVIEW_UPLD_TERMS_ID

2641: delete from okc_review_messages where REVIEW_UPLD_TERMS_ID
2642: in (select REVIEW_UPLD_TERMS_ID from okc_REVIEW_UPLD_TERMS where document_type = p_document_type and
2643: document_id = p_document_id);
2644:
2645: delete from OKC_REVIEW_VAR_VALUES where REVIEW_UPLD_TERMS_ID
2646: in (select REVIEW_UPLD_TERMS_ID from okc_REVIEW_UPLD_TERMS where document_type = p_document_type and
2647: document_id = p_document_id);
2648:
2649: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2862: FROM OKC_REVIEW_VAR_VALUES v

2858: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: After Delete Review Messages');
2859: END IF;
2860:
2861: DELETE
2862: FROM OKC_REVIEW_VAR_VALUES v
2863: WHERE v.REVIEW_UPLD_TERMS_id IN
2864: (SELECT REVIEW_UPLD_TERMS_id
2865: FROM okc_REVIEW_UPLD_TERMS
2866: WHERE document_id = p_document_id

Line 3015: from OKC_REVIEW_VAR_VALUES rev_var, okc_REVIEW_UPLD_TERMS rev

3011: cursor review_variable_values is
3012: select rev_var.variable_value_id, rev_var.REVIEW_UPLD_TERMS_id, rev_var.variable_name,
3013: rev_var.language, rev_var.variable_code, rev_var.variable_type, rev_var.attribute_value_set_id,
3014: rev_var.variable_value_id
3015: from OKC_REVIEW_VAR_VALUES rev_var, okc_REVIEW_UPLD_TERMS rev
3016: where rev_var.REVIEW_UPLD_TERMS_id = rev.REVIEW_UPLD_TERMS_id
3017: and rev.document_type = p_document_type and rev.document_id = p_document_id;
3018:
3019:

Line 3033: FROM OKC_REVIEW_VAR_VALUES rev_var, okc_k_art_variables kart_var,

3029: rev_var.variable_name variable_name,
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

Line 3058: and kart_var.variable_code not in (select variable_code from okc_review_Var_values rev_var

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
3059: where rev_var.review_upld_terms_id = rev.review_upld_terms_id)
3060: and rev.action not in ('DELETED','MERGED')
3061: and bustl.variable_code = kart_var.variable_code
3062: and language = userenv('LANG')

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 3097: from okc_review_upld_terms rev, okc_review_var_values rev_var

3093: and nvl(av.insert_by_reference,'N') <> 'Y';
3094:
3095: cursor invalid_variable_added(p_intent VARCHAR2) is
3096: select rev.review_upld_terms_id, rev_var.variable_code, rev_var.variable_type
3097: from okc_review_upld_terms rev, okc_review_var_values rev_var
3098: where document_type = p_document_type and rev.document_id = p_document_id
3099: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3100: and ((rev_var.variable_type in ('S','D') and not exists (select 'x' from okc_variable_doc_types var_doc where var_doc.variable_code = rev_var.variable_code
3101: and var_doc.doc_type = p_document_type))

Line 3111: from okc_review_upld_Terms rev, okc_review_var_values rev_var

3107: cursor valid_var_new_clause(p_intent VARCHAR2) is
3108: select rev.review_upld_terms_id, rev_var.variable_code, rev_var.variable_type,
3109: decode(rev_var.variable_value,
3110: NULL, 'N', 'Y') modified
3111: from okc_review_upld_Terms rev, okc_review_var_values rev_var
3112: where rev.document_type = p_document_type and rev.document_id = p_document_id
3113: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3114: and (
3115: (rev_var.variable_type = 'U'

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 3809: update OKC_REVIEW_VAR_VALUES

3805:
3806:
3807: l_message_name := 'OKC_REVIEW_VAR_VAL_CHG';
3808: for var_csr in variable_values_changed loop
3809: update OKC_REVIEW_VAR_VALUES
3810: set changed = 'Y'
3811: where REVIEW_UPLD_TERMS_id = var_csr.REVIEW_UPLD_TERMS_id;
3812:
3813: if(var_csr.variable_type = 'U') then

Line 3848: update OKC_REVIEW_VAR_VALUES

3844: update okc_review_upld_terms
3845: set action='UPDATED'
3846: where review_upld_terms_id = valid_var_added_csr.review_upld_terms_id and action is null;
3847:
3848: update OKC_REVIEW_VAR_VALUES
3849: set changed = 'A'
3850: where REVIEW_UPLD_TERMS_id = valid_var_added_csr.REVIEW_UPLD_TERMS_id;
3851:
3852: if(valid_var_added_csr.modified='Y') then

Line 3877: update OKC_REVIEW_VAR_VALUES

3873: end loop;
3874:
3875: for valid_var_new_clause_csr in valid_var_new_clause(l_intent) loop
3876:
3877: update OKC_REVIEW_VAR_VALUES
3878: set changed = 'A'
3879: where REVIEW_UPLD_TERMS_id = valid_var_new_clause_csr.REVIEW_UPLD_TERMS_id;
3880:
3881: if(valid_var_new_clause_csr.modified='Y') then

Line 3906: update OKC_REVIEW_VAR_VALUES

3902: end loop;
3903:
3904: for valid_new_var_ibr_csr in valid_new_var_ibr(l_intent) loop
3905:
3906: update OKC_REVIEW_VAR_VALUES
3907: set changed = 'A'
3908: where REVIEW_UPLD_TERMS_id = valid_new_var_ibr_csr.REVIEW_UPLD_TERMS_id;
3909:
3910: if(valid_new_var_ibr_csr.modified='Y') then

Line 3939: insert into okc_review_var_values(

3935: update okc_review_upld_terms
3936: set action='UPDATED'
3937: where review_upld_terms_id = removed_var_csr.review_upld_terms_id and action is null;
3938:
3939: insert into okc_review_var_values(
3940: review_var_values_id,
3941: review_upld_terms_id,
3942: variable_name,
3943: language,

Line 3947: (select okc_review_var_values_s1.nextval,

3943: language,
3944: variable_code,
3945: object_version_number,
3946: changed)
3947: (select okc_review_var_values_s1.nextval,
3948: removed_var_csr.review_upld_terms_id,
3949: removed_var_csr.variable_name,
3950: removed_var_csr.language,
3951: removed_var_csr.variable_code,

Line 3997: delete from okc_review_var_values revvar

3993: and variable_code = invalid_var_added_csr.variable_code and message_name = l_message_name));
3994: end loop;
3995:
3996: -- Delete the duplicate variable rows for the given document_type, document_id
3997: delete from okc_review_var_values revvar
3998: where revvar.rowid > (select min(rowid) from okc_review_var_values
3999: where review_upld_terms_id = revvar.review_upld_terms_id
4000: and revvar.variable_code = variable_code)
4001: and exists(select 1 from okc_Review_upld_terms rev

Line 3998: where revvar.rowid > (select min(rowid) from okc_review_var_values

3994: end loop;
3995:
3996: -- Delete the duplicate variable rows for the given document_type, document_id
3997: delete from okc_review_var_values revvar
3998: where revvar.rowid > (select min(rowid) from okc_review_var_values
3999: where review_upld_terms_id = revvar.review_upld_terms_id
4000: and revvar.variable_code = variable_code)
4001: and exists(select 1 from okc_Review_upld_terms rev
4002: where revvar.review_upld_terms_id = rev.review_upld_terms_id