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 DUAL

Line 64: SELECT OKC_REVIEW_UPLD_TERMS_S1.NEXTVAL FROM DUAL;

60: p_REVIEW_UPLD_TERMS_id IN NUMBER,
61: x_REVIEW_UPLD_TERMS_id OUT NOCOPY NUMBER
62: ) RETURN VARCHAR2 IS
63: CURSOR l_seq_csr IS
64: SELECT OKC_REVIEW_UPLD_TERMS_S1.NEXTVAL FROM DUAL;
65: BEGIN
66: IF (l_debug = 'Y') THEN
67: Okc_Debug.Log('100: Entered get_seq_id', 2);
68: END IF;

Line 3374: SYSDATE from dual);

3370: FND_GLOBAL.LOGIN_ID,
3371: FND_GLOBAL.USER_ID,
3372: SYSDATE,
3373: FND_GLOBAL.USER_ID,
3374: SYSDATE from dual);
3375:
3376: END IF;
3377: CLOSE check_document_row_exists;
3378:

Line 3516: (SELECT to_clob(ver.reference_text) FROM dual WHERE Nvl(ver.insert_by_reference,'N') = 'Y'

3512: KART.ID,
3513: 'ARTICLE',
3514: nvl(VER.DISPLAY_NAME,ART.ARTICLE_TITLE),
3515: -- Fix for bug# 5223552. Fix for inserting Clause/Reference Text based on IBR flag in review tbl based for 'Deleted' Clause
3516: (SELECT to_clob(ver.reference_text) FROM dual WHERE Nvl(ver.insert_by_reference,'N') = 'Y'
3517: UNION ALL
3518: SELECT VER.ARTICLE_TEXT FROM dual WHERE Nvl(ver.insert_by_reference,'N') = 'N'
3519: ),
3520: 'SECTION',

Line 3518: SELECT VER.ARTICLE_TEXT FROM dual WHERE Nvl(ver.insert_by_reference,'N') = 'N'

3514: nvl(VER.DISPLAY_NAME,ART.ARTICLE_TITLE),
3515: -- Fix for bug# 5223552. Fix for inserting Clause/Reference Text based on IBR flag in review tbl based for 'Deleted' Clause
3516: (SELECT to_clob(ver.reference_text) FROM dual WHERE Nvl(ver.insert_by_reference,'N') = 'Y'
3517: UNION ALL
3518: SELECT VER.ARTICLE_TEXT FROM dual WHERE Nvl(ver.insert_by_reference,'N') = 'N'
3519: ),
3520: 'SECTION',
3521: KART.SCN_ID,
3522: KART.SAV_SAE_ID,

Line 3835: 'W' error_severity,l_message_name ,1 object_version_number, var_csr.variable_code from dual

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));
3838:
3839: end loop;

Line 3870: 'W' error_severity, l_message_name ,1 object_version_number, valid_var_added_csr.variable_code from dual

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));
3873: end loop;
3874:

Line 3899: 'W' error_severity, l_message_name ,1 object_version_number, valid_var_new_clause_csr.variable_code from dual

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));
3902: end loop;
3903:

Line 3928: 'W' error_severity, l_message_name ,1 object_version_number, valid_new_var_ibr_csr.variable_code from dual

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));
3931: end loop;
3932:

Line 3953: 'D' from dual);

3949: removed_var_csr.variable_name,
3950: removed_var_csr.language,
3951: removed_var_csr.variable_code,
3952: 1,
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 (

Line 3967: 'W' error_severity,'OKC_REVIEW_VAR_REMOVED' message_name ,1 object_version_number, removed_var_csr.variable_code from dual

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'));
3970: end loop;
3971:

Line 3991: 'W' error_severity, l_message_name ,1 object_version_number, invalid_var_added_csr.variable_code from dual

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));
3994: end loop;
3995:

Line 4076: 'W' error_severity,'OKC_ARTICLE_UPDT_IBR' message_name ,1 object_version_number from dual);

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:
4079: for mandatory_csr in is_article_mandatory(l_user_access) loop
4080: insert into okc_review_messages (

Line 4090: 'W' error_severity,'OKC_ARTICLE_IS_MANDATORY' message_name ,1 object_version_number from dual);

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:
4093: for lock_csr in is_article_text_locked(l_user_access) loop
4094: insert into okc_review_messages (

Line 4104: 'W' error_severity,'OKC_ARTICLE_UPDT_LOCK' message_name ,1 object_version_number from dual);

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:
4107: l_message_name := 'OKC_UPLOAD_CLAUSE_TITLE_LONG';
4108: for title_csr in check_sec_clause_title loop

Line 4125: 'W' error_severity, l_message_name,1 object_version_number from dual);

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;
4128: for upd_csr in update_err_warn_csr loop
4129: if (upd_csr.error_severity = 'E') then

Line 4384: FROM dual);

4380: FND_GLOBAL.USER_ID,
4381: SYSDATE,
4382: FND_GLOBAL.USER_ID,
4383: SYSDATE
4384: FROM dual);
4385:
4386: --------------------------------------------
4387: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;