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_TERMS_UTIL_PVT dependencies on FND_LOOKUPS

Line 1596: -- heading = < get meaning of G_UNASSIGNED_SECTION_CODE by quering fnd_lookups>.

1592:
1593: --------------------------------------------
1594: -- Call Simple API of okc_sections_b with following input
1595: -- doc_type=p_doc_type, doc_id=p_doc_id, scn_code=G_UNASSIGNED_SECTION_CODE,
1596: -- heading = < get meaning of G_UNASSIGNED_SECTION_CODE by quering fnd_lookups>.
1597: -- Set x_scn_id to id returned by simpel API.
1598: --------------------------------------------
1599: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1600: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7600: Calling Simple API to Create a Section');

Line 2437: l_name FND_LOOKUPS.MEANING%TYPE := null;

2433: FUNCTION GET_SECTION_NAME(p_article_version_id NUMBER)
2434: RETURN VARCHAR2 IS
2435:
2436: --l_name varchar2(80) := null;
2437: l_name FND_LOOKUPS.MEANING%TYPE := null;
2438: l_article_version_id NUMBER;
2439: cursor get_default_section_name(l_article_version_id NUMBER) is
2440: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and lookup_code = (
2441: select default_section from okc_article_versions where article_version_id = l_article_version_id);

Line 2440: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and lookup_code = (

2436: --l_name varchar2(80) := null;
2437: l_name FND_LOOKUPS.MEANING%TYPE := null;
2438: l_article_version_id NUMBER;
2439: cursor get_default_section_name(l_article_version_id NUMBER) is
2440: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and lookup_code = (
2441: select default_section from okc_article_versions where article_version_id = l_article_version_id);
2442:
2443: cursor get_unassigned_section_name is
2444: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and

Line 2444: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and

2440: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and lookup_code = (
2441: select default_section from okc_article_versions where article_version_id = l_article_version_id);
2442:
2443: cursor get_unassigned_section_name is
2444: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and
2445: lookup_code = 'UNASSIGNED';
2446:
2447:
2448: BEGIN

Line 2472: l_name FND_LOOKUPS.MEANING%TYPE;

2468: function get_section_name(p_article_version_id IN Number,
2469: p_template_id in Number)
2470: return varchar2 is
2471: --l_name varchar2(80);
2472: l_name FND_LOOKUPS.MEANING%TYPE;
2473:
2474: cursor get_article_section_name(l_article_version_id NUMBER) is
2475: select meaning from fnd_lookups
2476: where lookup_type = 'OKC_ARTICLE_SECTION'

Line 2475: select meaning from fnd_lookups

2471: --l_name varchar2(80);
2472: l_name FND_LOOKUPS.MEANING%TYPE;
2473:
2474: cursor get_article_section_name(l_article_version_id NUMBER) is
2475: select meaning from fnd_lookups
2476: where lookup_type = 'OKC_ARTICLE_SECTION'
2477: and lookup_code = (select default_section from okc_article_versions
2478: where article_version_id = l_article_version_id);
2479:

Line 2481: select meaning from fnd_lookups

2477: and lookup_code = (select default_section from okc_article_versions
2478: where article_version_id = l_article_version_id);
2479:
2480: cursor get_expert_section_name(l_template_id NUMBER) is
2481: select meaning from fnd_lookups
2482: where lookup_type = 'OKC_ARTICLE_SECTION'
2483: and lookup_code = (select xprt_scn_code from okc_terms_templates_all
2484: where template_id = l_template_id);
2485:

Line 2487: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION'

2483: and lookup_code = (select xprt_scn_code from okc_terms_templates_all
2484: where template_id = l_template_id);
2485:
2486: cursor get_unassigned_section_name is
2487: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION'
2488: and lookup_code = 'UNASSIGNED';
2489:
2490: Begin
2491:

Line 3874: FROM fnd_lookups

3870: AND rownum < 2;
3871:
3872: CURSOR fnd_section_name_csr is
3873: SELECT meaning
3874: FROM fnd_lookups
3875: WHERE lookup_code = 'UNASSIGNED' and lookup_type = 'OKC_ARTICLE_SECTION';
3876:
3877: -- muteshev bug#4327485 begin
3878: -- created new cursor selected_yn_csr