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 299: AND art.standard_yn = 'Y'

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

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

631: okc_debug.log('100: Validating article type and default section', 2);
632: END IF;
633:
634: -- Below Added for Bug 3737158
635: -- Standard clauses will be checked for valid lookup code
636:
637: OPEN l_article_lkup_csr (p_article_version_id);
638: FETCH l_article_lkup_csr INTO l_default_section, l_article_type;
639: IF l_article_lkup_csr%NOTFOUND THEN