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 2539: delete from okc_review_messages where REVIEW_UPLD_TERMS_ID

2535:
2536: delete from okc_review_upld_header where document_type = p_document_type and
2537: document_id = p_document_id;
2538:
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

Line 2741: FROM OKC_REVIEW_MESSAGES m

2737: -- Initialize API return status to success
2738: x_return_status := FND_API.G_RET_STS_SUCCESS;
2739:
2740: DELETE
2741: FROM OKC_REVIEW_MESSAGES m
2742: WHERE m.REVIEW_UPLD_TERMS_id IN
2743: (SELECT REVIEW_UPLD_TERMS_id
2744: FROM okc_REVIEW_UPLD_TERMS
2745: WHERE document_id = p_document_id

Line 3093: okc_review_messages rev_msg ,

3089: count(*) err_warn_count,
3090: rev_msg.review_upld_terms_id,
3091: rev_msg.error_severity
3092: from
3093: okc_review_messages rev_msg ,
3094: okc_review_upld_terms rev_trm
3095: where
3096: rev_msg.review_upld_terms_id = rev_trm.review_upld_terms_id
3097: and rev_trm.document_type = p_document_type

Line 3672: insert into okc_review_messages (

3668: end if;
3669:
3670: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3671: -- and variable_code
3672: insert into okc_review_messages (
3673: review_messages_id,
3674: REVIEW_UPLD_TERMS_id,
3675: error_severity,
3676: message_name,

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 3683: where not exists (select 1 from okc_review_messages where review_upld_terms_id = var_csr.review_upld_terms_id

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));
3685:
3686: end loop;
3687:

Line 3707: insert into okc_review_messages (

3703: end if;
3704:
3705: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3706: -- and variable_code
3707: insert into okc_review_messages (
3708: review_messages_id,
3709: REVIEW_UPLD_TERMS_id,
3710: error_severity,
3711: 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 3718: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_var_added_csr.review_upld_terms_id

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));
3720: end loop;
3721:
3722: for valid_var_new_clause_csr in valid_var_new_clause(l_intent) loop

Line 3736: insert into okc_review_messages (

3732: end if;
3733:
3734: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3735: -- and variable_code
3736: insert into okc_review_messages (
3737: review_messages_id,
3738: REVIEW_UPLD_TERMS_id,
3739: error_severity,
3740: 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 3747: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_var_new_clause_csr.review_upld_terms_id

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));
3749: end loop;
3750:
3751: for valid_new_var_ibr_csr in valid_new_var_ibr(l_intent) loop

Line 3765: insert into okc_review_messages (

3761: end if;
3762:
3763: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3764: -- and variable_code
3765: insert into okc_review_messages (
3766: review_messages_id,
3767: REVIEW_UPLD_TERMS_id,
3768: error_severity,
3769: 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 3776: where not exists (select 1 from okc_review_messages where review_upld_terms_id = valid_new_var_ibr_csr.review_upld_terms_id

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));
3778: end loop;
3779:
3780: for removed_var_csr in variables_removed loop

Line 3804: insert into okc_review_messages (

3800: 'D' from dual);
3801:
3802: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3803: -- and variable_code
3804: insert into okc_review_messages (
3805: review_messages_id,
3806: REVIEW_UPLD_TERMS_id,
3807: error_severity,
3808: 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 3815: where not exists (select 1 from okc_review_messages where review_upld_terms_id = removed_var_csr.review_upld_terms_id

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'));
3817: end loop;
3818:
3819: l_message_name := 'OKC_REVIEW_INVALID_VARIABLE';

Line 3828: insert into okc_review_messages (

3824: where review_upld_terms_id = invalid_var_added_csr.review_upld_terms_id and action is null;
3825:
3826: -- Insert the message only if the same message does not exist for that review_upld_terms_id
3827: -- and variable_code
3828: insert into okc_review_messages (
3829: review_messages_id,
3830: REVIEW_UPLD_TERMS_id,
3831: error_severity,
3832: message_name,

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 3839: where not exists (select 1 from okc_review_messages where review_upld_terms_id = invalid_var_added_csr.review_upld_terms_id

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));
3841: end loop;
3842:
3843: -- Delete the duplicate variable rows for the given document_type, document_id

Line 3905: insert into okc_review_messages (

3901: and action = 'UPDATED'
3902: and (DBMS_LOB.getlength(object_text)=0 OR object_text is null);
3903:
3904: for ibr_csr in is_article_ibr(l_user_access) loop
3905: insert into okc_review_messages (
3906: review_messages_id,
3907: REVIEW_UPLD_TERMS_id,
3908: error_severity,
3909: 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 3919: insert into okc_review_messages (

3915: 'W' error_severity,'OKC_ARTICLE_UPDT_IBR' message_name ,1 object_version_number from dual);
3916: end loop;
3917:
3918: for mandatory_csr in is_article_mandatory(l_user_access) loop
3919: insert into okc_review_messages (
3920: review_messages_id,
3921: REVIEW_UPLD_TERMS_id,
3922: error_severity,
3923: message_name,

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 3933: insert into okc_review_messages (

3929: 'W' error_severity,'OKC_ARTICLE_IS_MANDATORY' message_name ,1 object_version_number from dual);
3930: end loop;
3931:
3932: for lock_csr in is_article_text_locked(l_user_access) loop
3933: insert into okc_review_messages (
3934: review_messages_id,
3935: REVIEW_UPLD_TERMS_id,
3936: error_severity,
3937: message_name,

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 3954: insert into okc_review_messages (

3950: end if;
3951: if(title_csr.object_type= 'ARTICLE') then
3952: l_message_name := 'OKC_UPLOAD_CLAUSE_TITLE_LONG';
3953: end if;
3954: insert into okc_review_messages (
3955: review_messages_id,
3956: REVIEW_UPLD_TERMS_id,
3957: error_severity,
3958: message_name,

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;