APPS.AP_WEB_FND_LOOKUPS_PKG dependencies on FND_LOOKUPS

Line 1: PACKAGE BODY AP_WEB_FND_LOOKUPS_PKG AS

1: PACKAGE BODY AP_WEB_FND_LOOKUPS_PKG AS
2: /* $Header: apwlupsb.pls 115.1 2002/12/26 10:13:20 srinvenk noship $ */
3:
4:
5: /* --------------------------------------------------------

Line 9: * - Called by SQL script to get the Meaning from FND_LOOKUPS table

5: /* --------------------------------------------------------
6: * Written by:
7: * David Tong
8: * Purpose:
9: * - Called by SQL script to get the Meaning from FND_LOOKUPS table
10: * - For performance purpose, we embeded the select statement in this
11: * function instead of calling a procedure
12: * Input:
13: * p_lookup_code - Lookup Code

Line 34: FROM FND_LOOKUPS

30: g_langCode := l_langCode;
31:
32: SELECT MEANING
33: INTO g_yesMeaning
34: FROM FND_LOOKUPS
35: WHERE LOOKUP_TYPE = 'YES_NO'
36: AND LOOKUP_CODE = 'Y';
37:
38: SELECT MEANING

Line 40: FROM FND_LOOKUPS

36: AND LOOKUP_CODE = 'Y';
37:
38: SELECT MEANING
39: INTO g_noMeaning
40: FROM FND_LOOKUPS
41: WHERE LOOKUP_TYPE = 'YES_NO'
42: AND LOOKUP_CODE = 'N';
43: end if;
44:

Line 59: END AP_WEB_FND_LOOKUPS_PKG;

55: return null;
56: END getYesNoMeaning;
57:
58:
59: END AP_WEB_FND_LOOKUPS_PKG;