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

Line 273: -- Allow only standard clauses

269: RETURN VARCHAR2
270: IS
271: -- Need to check whether any conditions required for global clauses
272: -- Do not allow future dated clauses
273: -- Allow only standard clauses
274: -- Check Org ID
275: -- Get the validation from ArticlesSearchExpVO.xml
276: CURSOR c_validate_clause
277: IS

Line 281: AND standard_yn = 'Y'

277: IS
278: SELECT 'Y'
279: FROM okc_articles_all
280: WHERE org_id = g_org_id
281: AND standard_yn = 'Y'
282: AND article_id = p_article_id
283: AND article_intent = p_intent;
284:
285: CURSOR cur_val_adopted_article

Line 292: AND art.standard_yn = 'Y'

288: FROM okc_articles_all art,
289: okc_article_versions ver,
290: okc_article_adoptions adp
291: WHERE art.article_id = ver.article_id
292: AND art.standard_yn = 'Y'
293: AND ver.global_yn = 'Y'
294: AND ver.article_status = 'APPROVED'
295: AND adp.global_article_version_id = ver.article_version_id
296: AND adp.adoption_type = 'ADOPTED'