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.AS_FOUNDATION_PVT dependencies on AS_LOOKUPS

Line 413: -- G_AS_LOOKUPS VARCHAR2 := 'AS_LOOKUPS',

409: );
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',

Line 426: cursor as_lookups_meaning_csr(l_lookup_type VARCHAR2,

422: p_lookup_code IN VARCHAR2,
423: p_tablename IN VARCHAR2
424: ) RETURN VARCHAR2 IS
425:
426: cursor as_lookups_meaning_csr(l_lookup_type VARCHAR2,
427: l_lookup_code VARCHAR2) is
428: select meaning
429: from as_lookups
430: where lookup_code = l_lookup_code

Line 429: from as_lookups

425:
426: cursor as_lookups_meaning_csr(l_lookup_type VARCHAR2,
427: l_lookup_code VARCHAR2) is
428: select meaning
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,

Line 470: if p_tablename = G_AS_LOOKUPS

466: and lookup_type = l_lookup_type;
467:
468: l_meaning VARCHAR2(80);
469: begin
470: if p_tablename = G_AS_LOOKUPS
471: then
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;

Line 472: open as_lookups_meaning_csr(p_lookup_type, p_lookup_code);

468: l_meaning VARCHAR2(80);
469: begin
470: if p_tablename = G_AS_LOOKUPS
471: then
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

Line 473: fetch as_lookups_meaning_csr into l_meaning;

469: begin
470: if p_tablename = G_AS_LOOKUPS
471: then
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

Line 474: close as_lookups_meaning_csr;

470: if p_tablename = G_AS_LOOKUPS
471: then
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);