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.PO_EDA_DATATEMPLATE_PKG dependencies on STANDARD

Line 744: AND art.standard_yn = 'N'

740: AND kartb.document_id = decode(ISMOD,'N',DOCUMENTID,DRAFTID)
741: AND kartb.sav_sae_id = art.article_id
742: AND kartb.article_version_id = ver.article_version_id
743: AND art.article_id = ver.article_id
744: AND art.standard_yn = 'N'
745: AND kartb.ref_article_id IS NULL
746: AND KARTB.scn_id = p_scn_id;
747:
748:

Line 1121: AND art.standard_yn = 'N'

1117: WHERE kartb.document_id = DOCUMENTID
1118: AND kartb.sav_sae_id = art.article_id
1119: AND kartb.article_version_id = ver.article_version_id
1120: AND art.article_id = ver.article_id
1121: AND art.standard_yn = 'N'
1122: AND kartb.ref_article_id IS NULL
1123: GROUP BY scn_id
1124: ORDER BY scn_id;
1125:

Line 1133: AND art.standard_yn = 'N'

1129: WHERE kartb.document_id = DRAFTID
1130: AND kartb.sav_sae_id = art.article_id
1131: AND kartb.article_version_id = ver.article_version_id
1132: AND art.article_id = ver.article_id
1133: AND art.standard_yn = 'N'
1134: AND kartb.ref_article_id IS NULL
1135: GROUP BY scn_id
1136: ORDER BY scn_id;
1137:

Line 2180: -- Standard call to get message count and if count is 1, get message info.

2176: ELSE
2177: NULL;
2178: END IF;
2179:
2180: -- Standard call to get message count and if count is 1, get message info.
2181: EXCEPTION
2182: WHEN OTHERS THEN
2183: --ROLLBACK TO g_Get_System_Variables;
2184:

Line 2866: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',

2862: FUNCTION getregulationURLMod(p_docid number, p_draftid number, p_doctype varchar2) RETURN CLOB AS
2863: cursor csr_addedURLs is
2864: (select distinct RegulationURL from
2865: (SELECT
2866: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2867: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2868: ' '),
2869: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2870: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

Line 2883: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',

2879: and kartb.scn_id = scn.id))
2880: minus
2881: (select distinct RegulationURL from
2882: (SELECT
2883: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2884: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2885: ' '),
2886: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2887: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

Line 2901: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',

2897:
2898: cursor csr_deletedURLs is
2899: (select distinct RegulationURL from
2900: (SELECT
2901: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2902: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2903: ' '),
2904: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2905: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn

Line 2918: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',

2914: and kartb.scn_id = scn.id))
2915: minus
2916: (select distinct RegulationURL from
2917: (SELECT
2918: Decode(art.standard_yn,'Y',decode(article_type,'FAR','http://www.arnet.gov',
2919: 'DFARS','http://www.acq.osd.mil/dpap/dars/index.html',
2920: ' '),
2921: nvl(ver.REFERENCE_SOURCE,' ')) RegulationURL
2922: FROM okc_k_articles_b kartb,okc_articles_all art, okc_article_versions ver, po_headers_merge_v poh, okc_sections_b scn