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 1638: -- heading = < get meaning of G_UNASSIGNED_SECTION_CODE by quering fnd_lookups>.

1634:
1635: --------------------------------------------
1636: -- Call Simple API of okc_sections_b with following input
1637: -- doc_type=p_doc_type, doc_id=p_doc_id, scn_code=G_UNASSIGNED_SECTION_CODE,
1638: -- heading = < get meaning of G_UNASSIGNED_SECTION_CODE by quering fnd_lookups>.
1639: -- Set x_scn_id to id returned by simpel API.
1640: --------------------------------------------
1641: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1642: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7600: Calling Simple API to Create a Section');

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

2475: FUNCTION GET_SECTION_NAME(p_article_version_id NUMBER)
2476: RETURN VARCHAR2 IS
2477:
2478: --l_name varchar2(80) := null;
2479: l_name FND_LOOKUPS.MEANING%TYPE := null;
2480: l_article_version_id NUMBER;
2481: cursor get_default_section_name(l_article_version_id NUMBER) is
2482: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and lookup_code = (
2483: select default_section from okc_article_versions where article_version_id = l_article_version_id);

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

2478: --l_name varchar2(80) := null;
2479: l_name FND_LOOKUPS.MEANING%TYPE := null;
2480: l_article_version_id NUMBER;
2481: cursor get_default_section_name(l_article_version_id NUMBER) is
2482: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and lookup_code = (
2483: select default_section from okc_article_versions where article_version_id = l_article_version_id);
2484:
2485: cursor get_unassigned_section_name is
2486: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and

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

2482: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and lookup_code = (
2483: select default_section from okc_article_versions where article_version_id = l_article_version_id);
2484:
2485: cursor get_unassigned_section_name is
2486: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION' and
2487: lookup_code = 'UNASSIGNED';
2488:
2489:
2490: BEGIN

Line 2514: l_name FND_LOOKUPS.MEANING%TYPE;

2510: function get_section_name(p_article_version_id IN Number,
2511: p_template_id in Number)
2512: return varchar2 is
2513: --l_name varchar2(80);
2514: l_name FND_LOOKUPS.MEANING%TYPE;
2515:
2516: cursor get_article_section_name(l_article_version_id NUMBER) is
2517: select meaning from fnd_lookups
2518: where lookup_type = 'OKC_ARTICLE_SECTION'

Line 2517: select meaning from fnd_lookups

2513: --l_name varchar2(80);
2514: l_name FND_LOOKUPS.MEANING%TYPE;
2515:
2516: cursor get_article_section_name(l_article_version_id NUMBER) is
2517: select meaning from fnd_lookups
2518: where lookup_type = 'OKC_ARTICLE_SECTION'
2519: and lookup_code = (select default_section from okc_article_versions
2520: where article_version_id = l_article_version_id);
2521:

Line 2523: select meaning from fnd_lookups

2519: and lookup_code = (select default_section from okc_article_versions
2520: where article_version_id = l_article_version_id);
2521:
2522: cursor get_expert_section_name(l_template_id NUMBER) is
2523: select meaning from fnd_lookups
2524: where lookup_type = 'OKC_ARTICLE_SECTION'
2525: and lookup_code = (select xprt_scn_code from okc_terms_templates_all
2526: where template_id = l_template_id);
2527:

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

2525: and lookup_code = (select xprt_scn_code from okc_terms_templates_all
2526: where template_id = l_template_id);
2527:
2528: cursor get_unassigned_section_name is
2529: select meaning from fnd_lookups where lookup_type = 'OKC_ARTICLE_SECTION'
2530: and lookup_code = 'UNASSIGNED';
2531:
2532: Begin
2533:

Line 3923: FROM fnd_lookups

3919: AND rownum < 2;
3920:
3921: CURSOR fnd_section_name_csr is
3922: SELECT meaning
3923: FROM fnd_lookups
3924: WHERE lookup_code = 'UNASSIGNED' and lookup_type = 'OKC_ARTICLE_SECTION';
3925:
3926: -- muteshev bug#4327485 begin
3927: -- created new cursor selected_yn_csr