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_ARTICLE_STATUS_CHANGE_PVT dependencies on STANDARD

Line 297: AND art.standard_yn = 'Y'

293: SELECT org_id, article_status, global_yn, art.article_id
294: FROM okc_articles_all art, okc_article_versions ver
295: WHERE ver.article_id = art.article_id
296: AND ver.article_version_id = cp_article_version_id
297: AND art.standard_yn = 'Y'
298: FOR UPDATE OF start_date;
299: l_article_version_rec l_article_version_csr%ROWTYPE;
300: BEGIN
301:

Line 623: -- Standard clauses will be checked for valid lookup code

619: okc_debug.log('100: Validating article type and default section', 2);
620: END IF;
621:
622: -- Below Added for Bug 3737158
623: -- Standard clauses will be checked for valid lookup code
624:
625: OPEN l_article_lkup_csr (p_article_version_id);
626: FETCH l_article_lkup_csr INTO l_default_section, l_article_type;
627: IF l_article_lkup_csr%NOTFOUND THEN