APPS.AS_FOUNDATION_PVT dependencies on FND_COMMON_LOOKUPS

Line 417: -- G_FND_COMMON_LOOKUPS VARCHAR2 := 'FND_COMMON_LOOKUPS',

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'
419:
420: FUNCTION get_lookupMeaning
421: ( p_lookup_type IN VARCHAR2,

Line 461: cursor fnd_common_lookups_meaning_csr(l_lookup_type VARCHAR2,

457: from cs_lookups
458: where lookup_code = l_lookup_code
459: and lookup_type = l_lookup_type;
460:
461: cursor fnd_common_lookups_meaning_csr(l_lookup_type VARCHAR2,
462: l_lookup_code VARCHAR2) is
463: select meaning
464: from fnd_common_lookups
465: where lookup_code = l_lookup_code

Line 464: from fnd_common_lookups

460:
461: cursor fnd_common_lookups_meaning_csr(l_lookup_type VARCHAR2,
462: l_lookup_code VARCHAR2) is
463: select meaning
464: from fnd_common_lookups
465: where lookup_code = l_lookup_code
466: and lookup_type = l_lookup_type;
467:
468: l_meaning VARCHAR2(80);

Line 502: elsif p_tablename = G_FND_COMMON_LOOKUPS

498: open cs_lookups_meaning_csr(p_lookup_type, p_lookup_code);
499: fetch cs_lookups_meaning_csr into l_meaning;
500: close cs_lookups_meaning_csr;
501: return l_meaning;
502: elsif p_tablename = G_FND_COMMON_LOOKUPS
503: then
504: open fnd_common_lookups_meaning_csr(p_lookup_type, p_lookup_code);
505: fetch fnd_common_lookups_meaning_csr into l_meaning;
506: close fnd_common_lookups_meaning_csr;

Line 504: open fnd_common_lookups_meaning_csr(p_lookup_type, p_lookup_code);

500: close cs_lookups_meaning_csr;
501: return l_meaning;
502: elsif p_tablename = G_FND_COMMON_LOOKUPS
503: then
504: open fnd_common_lookups_meaning_csr(p_lookup_type, p_lookup_code);
505: fetch fnd_common_lookups_meaning_csr into l_meaning;
506: close fnd_common_lookups_meaning_csr;
507: return l_meaning;
508: else

Line 505: fetch fnd_common_lookups_meaning_csr into l_meaning;

501: return l_meaning;
502: elsif p_tablename = G_FND_COMMON_LOOKUPS
503: then
504: open fnd_common_lookups_meaning_csr(p_lookup_type, p_lookup_code);
505: fetch fnd_common_lookups_meaning_csr into l_meaning;
506: close fnd_common_lookups_meaning_csr;
507: return l_meaning;
508: else
509: raise fnd_api.g_exc_error;

Line 506: close fnd_common_lookups_meaning_csr;

502: elsif p_tablename = G_FND_COMMON_LOOKUPS
503: then
504: open fnd_common_lookups_meaning_csr(p_lookup_type, p_lookup_code);
505: fetch fnd_common_lookups_meaning_csr into l_meaning;
506: close fnd_common_lookups_meaning_csr;
507: return l_meaning;
508: else
509: raise fnd_api.g_exc_error;
510: return NULL;