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_TEMPLATE_USAGES_PVT dependencies on FND_PROFILE

Line 1920: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN

1916: END IF;
1917:
1918: DELETE FROM OKC_TEMPLATE_USAGES WHERE DOCUMENT_TYPE = p_DOCUMENT_TYPE AND DOCUMENT_ID = p_DOCUMENT_ID;
1919:
1920: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN
1921: DELETE FROM OKC_XPRT_DOC_QUES_RESPONSE WHERE DOC_TYPE = p_DOCUMENT_TYPE AND DOC_ID = p_DOCUMENT_ID;
1922: END IF;
1923:
1924: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2123: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine

2119: FROM OKC_TEMPLATE_USAGES
2120: WHERE document_type = p_doc_type and document_id = p_doc_id;
2121:
2122: --If contract expert uses new okc rules engine, then save responses also into history table.
2123: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
2124: OKC_XPRT_RULES_ENGINE_PVT.create_xprt_responses_version(p_doc_id, p_doc_type, p_major_version); -- stores responses into history table
2125: END IF;
2126:
2127: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2236: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine

2232: FROM OKC_TEMPLATE_USAGES_H
2233: WHERE document_type = p_doc_type and document_id = p_doc_id AND major_version = p_major_version;
2234:
2235: --If contract expert uses new okc rules engine, then copy resposnes from history table to base table.
2236: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
2237: OKC_XPRT_RULES_ENGINE_PVT.restore_xprt_responses_version(p_doc_id, p_doc_type, p_major_version); -- copying responses from history table
2238: END IF;
2239:
2240: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2286: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine

2282: AND document_id = p_doc_id
2283: AND major_version = p_major_version;
2284:
2285: --If contract expert uses new okc rules engine, then delete resposnes from history table.
2286: IF nvl(fnd_profile.value('OKC_USE_CONTRACTS_RULES_ENGINE'), 'N') = 'Y' THEN --okc rules engine
2287: OKC_XPRT_RULES_ENGINE_PVT.delete_xprt_responses_version(p_doc_id, p_doc_type, p_major_version); -- deleting responses from history table
2288: END IF;
2289:
2290: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN