APPS.AMS_UTILITY_PVT dependencies on AMS_LOOKUPS

Line 236: p_lookup_table_name IN VARCHAR2 := g_ams_lookups,

232: -- 07-jun-2002 sveerave if table name is specifically not passed, changes
233: -- are made to call overloaded procedure.
234: ---------------------------------------------------------------------
235: FUNCTION check_lookup_exists(
236: p_lookup_table_name IN VARCHAR2 := g_ams_lookups,
237: p_lookup_type IN VARCHAR2,
238: p_lookup_code IN VARCHAR2
239: )
240: Return VARCHAR2

Line 248: IF p_lookup_table_name = g_ams_lookups THEN

244: l_count NUMBER;
245:
246: BEGIN
247:
248: IF p_lookup_table_name = g_ams_lookups THEN
249: return check_lookup_exists (
250: p_lookup_type => p_lookup_type
251: , p_lookup_code => p_lookup_code
252: , p_view_application_id => 530

Line 972: -- This procedure will return the meaning from ams_lookups if

968: -- PROCEDURE
969: -- get_lookup_meaning
970: -- created by mpande 01/11/00
971: -- PURPOSE
972: -- This procedure will return the meaning from ams_lookups if
973: -- you pass the right lookup_type and lookup_code
974: -- HISTORY
975: -- 28-Apr-2000 choang Modified to use explicit cursor.
976: -- 07-Aug-2000 choang Added close cursor for success conditions

Line 989: FROM ams_lookups

985: )
986: IS
987: CURSOR c_meaning IS
988: SELECT meaning
989: FROM ams_lookups
990: WHERE lookup_type = UPPER (p_lookup_type)
991: AND lookup_code = UPPER (p_lookup_code);
992: BEGIN
993: OPEN c_meaning;

Line 1311: FROM ams_lookups

1307: l_meaning VARCHAR2(80);
1308:
1309: CURSOR c_meaning IS
1310: SELECT meaning
1311: FROM ams_lookups
1312: WHERE lookup_type = UPPER (p_lookup_type)
1313: AND lookup_code = UPPER (p_lookup_code);
1314: BEGIN
1315: OPEN c_meaning;