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_MESSAGES

Line 2641: delete from okc_review_messages where REVIEW_UPLD_TERMS_ID

2637:
2638: delete from okc_review_upld_header where document_type = p_document_type and
2639: document_id = p_document_id;
2640:
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

Line 2850: FROM OKC_REVIEW_MESSAGES m

2846: -- Initialize API return status to success
2847: x_return_status := FND_API.G_RET_STS_SUCCESS;
2848:
2849: DELETE
2850: FROM OKC_REVIEW_MESSAGES m
2851: WHERE m.REVIEW_UPLD_TERMS_id IN
2852: (SELECT REVIEW_UPLD_TERMS_id
2853: FROM okc_REVIEW_UPLD_TERMS
2854: WHERE document_id = p_document_id

Line 3202: okc_review_messages rev_msg ,

3198: count(*) err_warn_count,
3199: rev_msg.review_upld_terms_id,
3200: rev_msg.error_severity
3201: from
3202: okc_review_messages rev_msg ,
3203: okc_review_upld_terms rev_trm
3204: where
3205: rev_msg.review_upld_terms_id = rev_trm.review_upld_terms_id
3206: and rev_trm.document_type = p_document_type

Line 3825: insert into okc_review_messages (

3821: end if;
3822:
3823: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3824: -- and variable_code
3825: insert into okc_review_messages (
3826: review_messages_id,
3827: REVIEW_UPLD_TERMS_id,
3828: error_severity,
3829: message_name,

Line 3833: (select okc_review_messages_s1.nextval review_messages_id,

3829: message_name,
3830: object_version_number,
3831: variable_code
3832: )
3833: (select okc_review_messages_s1.nextval review_messages_id,
3834: var_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3835: 'W' error_severity,l_message_name ,1 object_version_number, var_csr.variable_code from dual
3836: where not exists (select 1 from okc_review_messages where review_upld_terms_id = var_csr.review_upld_terms_id
3837: and variable_code = var_csr.variable_code and message_name = l_message_name));

Line 3836: where not exists (select 1 from okc_review_messages where review_upld_terms_id = var_csr.review_upld_terms_id

3832: )
3833: (select okc_review_messages_s1.nextval review_messages_id,
3834: var_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3835: 'W' error_severity,l_message_name ,1 object_version_number, var_csr.variable_code from dual
3836: where not exists (select 1 from okc_review_messages where review_upld_terms_id = var_csr.review_upld_terms_id
3837: and variable_code = var_csr.variable_code and message_name = l_message_name));
3838:
3839: end loop;
3840:

Line 3860: insert into okc_review_messages (

3856: end if;
3857:
3858: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3859: -- and variable_code
3860: insert into okc_review_messages (
3861: review_messages_id,
3862: REVIEW_UPLD_TERMS_id,
3863: error_severity,
3864: message_name,

Line 3868: (select okc_review_messages_s1.nextval review_messages_id,

3864: message_name,
3865: object_version_number,
3866: variable_code
3867: )
3868: (select okc_review_messages_s1.nextval review_messages_id,
3869: valid_var_added_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3870: 'W' error_severity, l_message_name ,1 object_version_number, valid_var_added_csr.variable_code from dual
3871: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_var_added_csr.review_upld_terms_id
3872: and variable_code = valid_var_added_csr.variable_code and message_name = l_message_name));

Line 3871: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_var_added_csr.review_upld_terms_id

3867: )
3868: (select okc_review_messages_s1.nextval review_messages_id,
3869: valid_var_added_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3870: 'W' error_severity, l_message_name ,1 object_version_number, valid_var_added_csr.variable_code from dual
3871: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_var_added_csr.review_upld_terms_id
3872: and variable_code = valid_var_added_csr.variable_code and message_name = l_message_name));
3873: end loop;
3874:
3875: for valid_var_new_clause_csr in valid_var_new_clause(l_intent) loop

Line 3889: insert into okc_review_messages (

3885: end if;
3886:
3887: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3888: -- and variable_code
3889: insert into okc_review_messages (
3890: review_messages_id,
3891: REVIEW_UPLD_TERMS_id,
3892: error_severity,
3893: message_name,

Line 3897: (select okc_review_messages_s1.nextval review_messages_id,

3893: message_name,
3894: object_version_number,
3895: variable_code
3896: )
3897: (select okc_review_messages_s1.nextval review_messages_id,
3898: valid_var_new_clause_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3899: 'W' error_severity, l_message_name ,1 object_version_number, valid_var_new_clause_csr.variable_code from dual
3900: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_var_new_clause_csr.review_upld_terms_id
3901: and variable_code = valid_var_new_clause_csr.variable_code and message_name = l_message_name));

Line 3900: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_var_new_clause_csr.review_upld_terms_id

3896: )
3897: (select okc_review_messages_s1.nextval review_messages_id,
3898: valid_var_new_clause_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3899: 'W' error_severity, l_message_name ,1 object_version_number, valid_var_new_clause_csr.variable_code from dual
3900: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_var_new_clause_csr.review_upld_terms_id
3901: and variable_code = valid_var_new_clause_csr.variable_code and message_name = l_message_name));
3902: end loop;
3903:
3904: for valid_new_var_ibr_csr in valid_new_var_ibr(l_intent) loop

Line 3918: insert into okc_review_messages (

3914: end if;
3915:
3916: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3917: -- and variable_code
3918: insert into okc_review_messages (
3919: review_messages_id,
3920: REVIEW_UPLD_TERMS_id,
3921: error_severity,
3922: message_name,

Line 3926: (select okc_review_messages_s1.nextval review_messages_id,

3922: message_name,
3923: object_version_number,
3924: variable_code
3925: )
3926: (select okc_review_messages_s1.nextval review_messages_id,
3927: valid_new_var_ibr_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3928: 'W' error_severity, l_message_name ,1 object_version_number, valid_new_var_ibr_csr.variable_code from dual
3929: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_new_var_ibr_csr.review_upld_terms_id
3930: and variable_code = valid_new_var_ibr_csr.variable_code and message_name = l_message_name));

Line 3929: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_new_var_ibr_csr.review_upld_terms_id

3925: )
3926: (select okc_review_messages_s1.nextval review_messages_id,
3927: valid_new_var_ibr_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3928: 'W' error_severity, l_message_name ,1 object_version_number, valid_new_var_ibr_csr.variable_code from dual
3929: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_new_var_ibr_csr.review_upld_terms_id
3930: and variable_code = valid_new_var_ibr_csr.variable_code and message_name = l_message_name));
3931: end loop;
3932:
3933: for removed_var_csr in variables_removed loop

Line 3957: insert into okc_review_messages (

3953: 'D' from dual);
3954:
3955: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3956: -- and variable_code
3957: insert into okc_review_messages (
3958: review_messages_id,
3959: REVIEW_UPLD_TERMS_id,
3960: error_severity,
3961: message_name,

Line 3965: (select okc_review_messages_s1.nextval review_messages_id,

3961: message_name,
3962: object_version_number,
3963: variable_code
3964: )
3965: (select okc_review_messages_s1.nextval review_messages_id,
3966: removed_var_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3967: 'W' error_severity,'OKC_REVIEW_VAR_REMOVED' message_name ,1 object_version_number, removed_var_csr.variable_code from dual
3968: where not exists (select 1 from okc_review_messages where review_upld_terms_id = removed_var_csr.review_upld_terms_id
3969: and variable_code = removed_var_csr.variable_code and message_name = 'OKC_REVIEW_VAR_REMOVED'));

Line 3968: where not exists (select 1 from okc_review_messages where review_upld_terms_id = removed_var_csr.review_upld_terms_id

3964: )
3965: (select okc_review_messages_s1.nextval review_messages_id,
3966: removed_var_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3967: 'W' error_severity,'OKC_REVIEW_VAR_REMOVED' message_name ,1 object_version_number, removed_var_csr.variable_code from dual
3968: where not exists (select 1 from okc_review_messages where review_upld_terms_id = removed_var_csr.review_upld_terms_id
3969: and variable_code = removed_var_csr.variable_code and message_name = 'OKC_REVIEW_VAR_REMOVED'));
3970: end loop;
3971:
3972: l_message_name := 'OKC_REVIEW_INVALID_VARIABLE';

Line 3981: insert into okc_review_messages (

3977: where review_upld_terms_id = invalid_var_added_csr.review_upld_terms_id and action is null;
3978:
3979: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3980: -- and variable_code
3981: insert into okc_review_messages (
3982: review_messages_id,
3983: REVIEW_UPLD_TERMS_id,
3984: error_severity,
3985: message_name,

Line 3989: (select okc_review_messages_s1.nextval review_messages_id,

3985: message_name,
3986: object_version_number,
3987: variable_code
3988: )
3989: (select okc_review_messages_s1.nextval review_messages_id,
3990: invalid_var_added_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3991: 'W' error_severity, l_message_name ,1 object_version_number, invalid_var_added_csr.variable_code from dual
3992: where not exists (select 1 from okc_review_messages where review_upld_terms_id = invalid_var_added_csr.review_upld_terms_id
3993: and variable_code = invalid_var_added_csr.variable_code and message_name = l_message_name));

Line 3992: where not exists (select 1 from okc_review_messages where review_upld_terms_id = invalid_var_added_csr.review_upld_terms_id

3988: )
3989: (select okc_review_messages_s1.nextval review_messages_id,
3990: invalid_var_added_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3991: 'W' error_severity, l_message_name ,1 object_version_number, invalid_var_added_csr.variable_code from dual
3992: where not exists (select 1 from okc_review_messages where review_upld_terms_id = invalid_var_added_csr.review_upld_terms_id
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

Line 4066: insert into okc_review_messages (

4062: and action = 'UPDATED'
4063: and (DBMS_LOB.getlength(object_text)=0 OR object_text is null);
4064:
4065: for ibr_csr in is_article_ibr(l_user_access) loop
4066: insert into okc_review_messages (
4067: review_messages_id,
4068: REVIEW_UPLD_TERMS_id,
4069: error_severity,
4070: message_name,

Line 4074: (select okc_review_messages_s1.nextval review_messages_id,

4070: message_name,
4071: object_version_number
4072:
4073: )
4074: (select okc_review_messages_s1.nextval review_messages_id,
4075: ibr_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
4076: 'W' error_severity,'OKC_ARTICLE_UPDT_IBR' message_name ,1 object_version_number from dual);
4077: end loop;
4078:

Line 4080: insert into okc_review_messages (

4076: 'W' error_severity,'OKC_ARTICLE_UPDT_IBR' message_name ,1 object_version_number from dual);
4077: end loop;
4078:
4079: for mandatory_csr in is_article_mandatory(l_user_access) loop
4080: insert into okc_review_messages (
4081: review_messages_id,
4082: REVIEW_UPLD_TERMS_id,
4083: error_severity,
4084: message_name,

Line 4088: (select okc_review_messages_s1.nextval review_messages_id,

4084: message_name,
4085: object_version_number
4086:
4087: )
4088: (select okc_review_messages_s1.nextval review_messages_id,
4089: mandatory_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
4090: 'W' error_severity,'OKC_ARTICLE_IS_MANDATORY' message_name ,1 object_version_number from dual);
4091: end loop;
4092:

Line 4094: insert into okc_review_messages (

4090: 'W' error_severity,'OKC_ARTICLE_IS_MANDATORY' message_name ,1 object_version_number from dual);
4091: end loop;
4092:
4093: for lock_csr in is_article_text_locked(l_user_access) loop
4094: insert into okc_review_messages (
4095: review_messages_id,
4096: REVIEW_UPLD_TERMS_id,
4097: error_severity,
4098: message_name,

Line 4102: (select okc_review_messages_s1.nextval review_messages_id,

4098: message_name,
4099: object_version_number
4100:
4101: )
4102: (select okc_review_messages_s1.nextval review_messages_id,
4103: lock_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
4104: 'W' error_severity,'OKC_ARTICLE_UPDT_LOCK' message_name ,1 object_version_number from dual);
4105: end loop;
4106:

Line 4115: insert into okc_review_messages (

4111: end if;
4112: if(title_csr.object_type= 'ARTICLE') then
4113: l_message_name := 'OKC_UPLOAD_CLAUSE_TITLE_LONG';
4114: end if;
4115: insert into okc_review_messages (
4116: review_messages_id,
4117: REVIEW_UPLD_TERMS_id,
4118: error_severity,
4119: message_name,

Line 4123: (select okc_review_messages_s1.nextval review_messages_id,

4119: message_name,
4120: object_version_number
4121:
4122: )
4123: (select okc_review_messages_s1.nextval review_messages_id,
4124: title_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
4125: 'W' error_severity, l_message_name,1 object_version_number from dual);
4126:
4127: end loop;