APPS.AS_FOUNDATION_PVT dependencies on AR_LOOKUPS

Line 414: -- G_AR_LOOKUPS VARCHAR2 := 'AR_LOOKUPS',

410: end;
411:
412: -- Notes: The valid inputs for p_tablename are:
413: -- G_AS_LOOKUPS VARCHAR2 := 'AS_LOOKUPS',
414: -- G_AR_LOOKUPS VARCHAR2 := 'AR_LOOKUPS',
415: -- G_SO_LOOKUPS VARCHAR2 := 'SO_LOOKUPS',
416: -- G_HR_LOOKUPS VARCHAR2 := 'HR_LOOKUPS',
417: -- G_FND_COMMON_LOOKUPS VARCHAR2 := 'FND_COMMON_LOOKUPS',
418: -- G_CS_LOOKUPS VARCHAR2 := 'CS_LOOKUPS'

Line 433: cursor ar_lookups_meaning_csr(l_lookup_type VARCHAR2,

429: from as_lookups
430: where lookup_code = l_lookup_code
431: and lookup_type = l_lookup_type;
432:
433: cursor ar_lookups_meaning_csr(l_lookup_type VARCHAR2,
434: l_lookup_code VARCHAR2) is
435: select meaning
436: from ar_lookups
437: where lookup_code = l_lookup_code

Line 436: from ar_lookups

432:
433: cursor ar_lookups_meaning_csr(l_lookup_type VARCHAR2,
434: l_lookup_code VARCHAR2) is
435: select meaning
436: from ar_lookups
437: where lookup_code = l_lookup_code
438: and lookup_type = l_lookup_type;
439: /*
440: cursor so_lookups_meaning_csr(l_lookup_type VARCHAR2,

Line 476: elsif p_tablename = G_AR_LOOKUPS

472: open as_lookups_meaning_csr(p_lookup_type, p_lookup_code);
473: fetch as_lookups_meaning_csr into l_meaning;
474: close as_lookups_meaning_csr;
475: return l_meaning;
476: elsif p_tablename = G_AR_LOOKUPS
477: then
478: open ar_lookups_meaning_csr(p_lookup_type, p_lookup_code);
479: fetch ar_lookups_meaning_csr into l_meaning;
480: close ar_lookups_meaning_csr;

Line 478: open ar_lookups_meaning_csr(p_lookup_type, p_lookup_code);

474: close as_lookups_meaning_csr;
475: return l_meaning;
476: elsif p_tablename = G_AR_LOOKUPS
477: then
478: open ar_lookups_meaning_csr(p_lookup_type, p_lookup_code);
479: fetch ar_lookups_meaning_csr into l_meaning;
480: close ar_lookups_meaning_csr;
481: return l_meaning;
482: /*

Line 479: fetch ar_lookups_meaning_csr into l_meaning;

475: return l_meaning;
476: elsif p_tablename = G_AR_LOOKUPS
477: then
478: open ar_lookups_meaning_csr(p_lookup_type, p_lookup_code);
479: fetch ar_lookups_meaning_csr into l_meaning;
480: close ar_lookups_meaning_csr;
481: return l_meaning;
482: /*
483: elsif p_tablename = G_SO_LOOKUPS

Line 480: close ar_lookups_meaning_csr;

476: elsif p_tablename = G_AR_LOOKUPS
477: then
478: open ar_lookups_meaning_csr(p_lookup_type, p_lookup_code);
479: fetch ar_lookups_meaning_csr into l_meaning;
480: close ar_lookups_meaning_csr;
481: return l_meaning;
482: /*
483: elsif p_tablename = G_SO_LOOKUPS
484: then