APPS.OZF_UTILITY_PVT dependencies on OZF_LOOKUPS

Line 292: p_lookup_table_name IN VARCHAR2 := g_ozf_lookups,

288: -- 07-jun-2002 sveerave if table name is specifically not passed, changes
289: -- are made to call overloaded procedure.
290: ---------------------------------------------------------------------
291: FUNCTION check_lookup_exists(
292: p_lookup_table_name IN VARCHAR2 := g_ozf_lookups,
293: p_lookup_type IN VARCHAR2,
294: p_lookup_code IN VARCHAR2
295: )
296: Return VARCHAR2

Line 304: IF p_lookup_table_name = g_ozf_lookups THEN

300: l_count NUMBER;
301:
302: BEGIN
303:
304: IF p_lookup_table_name = g_ozf_lookups THEN
305: return check_lookup_exists (
306: p_lookup_type => p_lookup_type
307: , p_lookup_code => p_lookup_code
308: , p_view_application_id => 682

Line 1034: -- This procedure will return the meaning from ozf_lookups if

1030: -- PROCEDURE
1031: -- get_lookup_meaning
1032: -- created by mpande 01/11/00
1033: -- PURPOSE
1034: -- This procedure will return the meaning from ozf_lookups if
1035: -- you pass the right lookup_type and lookup_code
1036: -- HISTORY
1037: -- 28-Apr-2000 choang Modified to use explicit cursor.
1038: -- 07-Aug-2000 choang Added close cursor for success conditions

Line 1051: FROM ozf_lookups

1047: )
1048: IS
1049: CURSOR c_meaning IS
1050: SELECT meaning
1051: FROM ozf_lookups
1052: WHERE lookup_type = UPPER (p_lookup_type)
1053: AND lookup_code = UPPER (p_lookup_code);
1054: BEGIN
1055: OPEN c_meaning;

Line 1371: FROM ozf_lookups

1367: l_meaning VARCHAR2(80);
1368:
1369: CURSOR c_meaning IS
1370: SELECT meaning
1371: FROM ozf_lookups
1372: WHERE lookup_type = UPPER (p_lookup_type)
1373: AND lookup_code = UPPER (p_lookup_code);
1374: BEGIN
1375: OPEN c_meaning;