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.

[Home] [Help]

APPS.OKC_REVIEW_UPLD_TERMS_PVT dependencies on OKC_REVIEW_MESSAGES_S1

Line 3680: (select okc_review_messages_s1.nextval review_messages_id,

3676: message_name,
3677: object_version_number,
3678: variable_code
3679: )
3680: (select okc_review_messages_s1.nextval review_messages_id,
3681: var_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3682: 'W' error_severity,l_message_name ,1 object_version_number, var_csr.variable_code from dual
3683: where not exists (select 1 from okc_review_messages where review_upld_terms_id = var_csr.review_upld_terms_id
3684: and variable_code = var_csr.variable_code and message_name = l_message_name));

Line 3715: (select okc_review_messages_s1.nextval review_messages_id,

3711: message_name,
3712: object_version_number,
3713: variable_code
3714: )
3715: (select okc_review_messages_s1.nextval review_messages_id,
3716: valid_var_added_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3717: 'W' error_severity, l_message_name ,1 object_version_number, valid_var_added_csr.variable_code from dual
3718: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_var_added_csr.review_upld_terms_id
3719: and variable_code = valid_var_added_csr.variable_code and message_name = l_message_name));

Line 3744: (select okc_review_messages_s1.nextval review_messages_id,

3740: message_name,
3741: object_version_number,
3742: variable_code
3743: )
3744: (select okc_review_messages_s1.nextval review_messages_id,
3745: valid_var_new_clause_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3746: 'W' error_severity, l_message_name ,1 object_version_number, valid_var_new_clause_csr.variable_code from dual
3747: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_var_new_clause_csr.review_upld_terms_id
3748: and variable_code = valid_var_new_clause_csr.variable_code and message_name = l_message_name));

Line 3773: (select okc_review_messages_s1.nextval review_messages_id,

3769: message_name,
3770: object_version_number,
3771: variable_code
3772: )
3773: (select okc_review_messages_s1.nextval review_messages_id,
3774: valid_new_var_ibr_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3775: 'W' error_severity, l_message_name ,1 object_version_number, valid_new_var_ibr_csr.variable_code from dual
3776: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_new_var_ibr_csr.review_upld_terms_id
3777: and variable_code = valid_new_var_ibr_csr.variable_code and message_name = l_message_name));

Line 3812: (select okc_review_messages_s1.nextval review_messages_id,

3808: message_name,
3809: object_version_number,
3810: variable_code
3811: )
3812: (select okc_review_messages_s1.nextval review_messages_id,
3813: removed_var_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3814: 'W' error_severity,'OKC_REVIEW_VAR_REMOVED' message_name ,1 object_version_number, removed_var_csr.variable_code from dual
3815: where not exists (select 1 from okc_review_messages where review_upld_terms_id = removed_var_csr.review_upld_terms_id
3816: and variable_code = removed_var_csr.variable_code and message_name = 'OKC_REVIEW_VAR_REMOVED'));

Line 3836: (select okc_review_messages_s1.nextval review_messages_id,

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

Line 3913: (select okc_review_messages_s1.nextval review_messages_id,

3909: message_name,
3910: object_version_number
3911:
3912: )
3913: (select okc_review_messages_s1.nextval review_messages_id,
3914: ibr_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3915: 'W' error_severity,'OKC_ARTICLE_UPDT_IBR' message_name ,1 object_version_number from dual);
3916: end loop;
3917:

Line 3927: (select okc_review_messages_s1.nextval review_messages_id,

3923: message_name,
3924: object_version_number
3925:
3926: )
3927: (select okc_review_messages_s1.nextval review_messages_id,
3928: mandatory_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3929: 'W' error_severity,'OKC_ARTICLE_IS_MANDATORY' message_name ,1 object_version_number from dual);
3930: end loop;
3931:

Line 3941: (select okc_review_messages_s1.nextval review_messages_id,

3937: message_name,
3938: object_version_number
3939:
3940: )
3941: (select okc_review_messages_s1.nextval review_messages_id,
3942: lock_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3943: 'W' error_severity,'OKC_ARTICLE_UPDT_LOCK' message_name ,1 object_version_number from dual);
3944: end loop;
3945:

Line 3962: (select okc_review_messages_s1.nextval review_messages_id,

3958: message_name,
3959: object_version_number
3960:
3961: )
3962: (select okc_review_messages_s1.nextval review_messages_id,
3963: title_csr.REVIEW_UPLD_TERMS_id REVIEW_UPLD_TERMS_id,
3964: 'W' error_severity, l_message_name,1 object_version_number from dual);
3965:
3966: end loop;