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 2543: delete from OKC_REVIEW_VAR_VALUES where REVIEW_UPLD_TERMS_ID

2539: delete from okc_review_messages where REVIEW_UPLD_TERMS_ID
2540: in (select REVIEW_UPLD_TERMS_ID from okc_REVIEW_UPLD_TERMS where document_type = p_document_type and
2541: document_id = p_document_id);
2542:
2543: delete from OKC_REVIEW_VAR_VALUES where REVIEW_UPLD_TERMS_ID
2544: in (select REVIEW_UPLD_TERMS_ID from okc_REVIEW_UPLD_TERMS where document_type = p_document_type and
2545: document_id = p_document_id);
2546:
2547: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2753: FROM OKC_REVIEW_VAR_VALUES v

2749: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'200: After Delete Review Messages');
2750: END IF;
2751:
2752: DELETE
2753: FROM OKC_REVIEW_VAR_VALUES v
2754: WHERE v.REVIEW_UPLD_TERMS_id IN
2755: (SELECT REVIEW_UPLD_TERMS_id
2756: FROM okc_REVIEW_UPLD_TERMS
2757: WHERE document_id = p_document_id

Line 2906: from OKC_REVIEW_VAR_VALUES rev_var, okc_REVIEW_UPLD_TERMS rev

2902: cursor review_variable_values is
2903: select rev_var.variable_value_id, rev_var.REVIEW_UPLD_TERMS_id, rev_var.variable_name,
2904: rev_var.language, rev_var.variable_code, rev_var.variable_type, rev_var.attribute_value_set_id,
2905: rev_var.variable_value_id
2906: from OKC_REVIEW_VAR_VALUES rev_var, okc_REVIEW_UPLD_TERMS rev
2907: where rev_var.REVIEW_UPLD_TERMS_id = rev.REVIEW_UPLD_TERMS_id
2908: and rev.document_type = p_document_type and rev.document_id = p_document_id;
2909:
2910:

Line 2924: FROM OKC_REVIEW_VAR_VALUES rev_var, okc_k_art_variables kart_var,

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

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

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
2950: where rev_var.review_upld_terms_id = rev.review_upld_terms_id)
2951: and rev.action not in ('DELETED','MERGED')
2952: and bustl.variable_code = kart_var.variable_code
2953: and language = userenv('LANG')

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

2984: and nvl(av.insert_by_reference,'N') <> 'Y';
2985:
2986: cursor invalid_variable_added(p_intent VARCHAR2) is
2987: select rev.review_upld_terms_id, rev_var.variable_code, rev_var.variable_type
2988: from okc_review_upld_terms rev, okc_review_var_values rev_var
2989: where document_type = p_document_type and rev.document_id = p_document_id
2990: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
2991: 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
2992: and var_doc.doc_type = p_document_type))

Line 3002: from okc_review_upld_Terms rev, okc_review_var_values rev_var

2998: cursor valid_var_new_clause(p_intent VARCHAR2) is
2999: select rev.review_upld_terms_id, rev_var.variable_code, rev_var.variable_type,
3000: decode(rev_var.variable_value,
3001: NULL, 'N', 'Y') modified
3002: from okc_review_upld_Terms rev, okc_review_var_values rev_var
3003: where rev.document_type = p_document_type and rev.document_id = p_document_id
3004: and rev_var.review_upld_terms_id = rev.review_upld_terms_id
3005: and (
3006: (rev_var.variable_type = 'U'

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

3652:
3653:
3654: l_message_name := 'OKC_REVIEW_VAR_VAL_CHG';
3655: for var_csr in variable_values_changed loop
3656: update OKC_REVIEW_VAR_VALUES
3657: set changed = 'Y'
3658: where REVIEW_UPLD_TERMS_id = var_csr.REVIEW_UPLD_TERMS_id;
3659:
3660: if(var_csr.variable_type = 'U') then

Line 3695: update OKC_REVIEW_VAR_VALUES

3691: update okc_review_upld_terms
3692: set action='UPDATED'
3693: where review_upld_terms_id = valid_var_added_csr.review_upld_terms_id and action is null;
3694:
3695: update OKC_REVIEW_VAR_VALUES
3696: set changed = 'A'
3697: where REVIEW_UPLD_TERMS_id = valid_var_added_csr.REVIEW_UPLD_TERMS_id;
3698:
3699: if(valid_var_added_csr.modified='Y') then

Line 3724: update OKC_REVIEW_VAR_VALUES

3720: end loop;
3721:
3722: for valid_var_new_clause_csr in valid_var_new_clause(l_intent) loop
3723:
3724: update OKC_REVIEW_VAR_VALUES
3725: set changed = 'A'
3726: where REVIEW_UPLD_TERMS_id = valid_var_new_clause_csr.REVIEW_UPLD_TERMS_id;
3727:
3728: if(valid_var_new_clause_csr.modified='Y') then

Line 3753: update OKC_REVIEW_VAR_VALUES

3749: end loop;
3750:
3751: for valid_new_var_ibr_csr in valid_new_var_ibr(l_intent) loop
3752:
3753: update OKC_REVIEW_VAR_VALUES
3754: set changed = 'A'
3755: where REVIEW_UPLD_TERMS_id = valid_new_var_ibr_csr.REVIEW_UPLD_TERMS_id;
3756:
3757: if(valid_new_var_ibr_csr.modified='Y') then

Line 3786: insert into okc_review_var_values(

3782: update okc_review_upld_terms
3783: set action='UPDATED'
3784: where review_upld_terms_id = removed_var_csr.review_upld_terms_id and action is null;
3785:
3786: insert into okc_review_var_values(
3787: review_var_values_id,
3788: review_upld_terms_id,
3789: variable_name,
3790: language,

Line 3794: (select okc_review_var_values_s1.nextval,

3790: language,
3791: variable_code,
3792: object_version_number,
3793: changed)
3794: (select okc_review_var_values_s1.nextval,
3795: removed_var_csr.review_upld_terms_id,
3796: removed_var_csr.variable_name,
3797: removed_var_csr.language,
3798: removed_var_csr.variable_code,

Line 3844: delete from okc_review_var_values revvar

3840: and variable_code = invalid_var_added_csr.variable_code and message_name = l_message_name));
3841: end loop;
3842:
3843: -- Delete the duplicate variable rows for the given document_type, document_id
3844: delete from okc_review_var_values revvar
3845: where revvar.rowid > (select min(rowid) from okc_review_var_values
3846: where review_upld_terms_id = revvar.review_upld_terms_id
3847: and revvar.variable_code = variable_code)
3848: and exists(select 1 from okc_Review_upld_terms rev

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

3841: end loop;
3842:
3843: -- Delete the duplicate variable rows for the given document_type, document_id
3844: delete from okc_review_var_values revvar
3845: where revvar.rowid > (select min(rowid) from okc_review_var_values
3846: where review_upld_terms_id = revvar.review_upld_terms_id
3847: and revvar.variable_code = variable_code)
3848: and exists(select 1 from okc_Review_upld_terms rev
3849: where revvar.review_upld_terms_id = rev.review_upld_terms_id