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_S1

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 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 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 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 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 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 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 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 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 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;