APPS.OZF_UTILITY_PVT dependencies on OZF_LOOKUPS

Line 275: p_lookup_table_name IN VARCHAR2 := g_ozf_lookups,

271: -- 07-jun-2002 sveerave if table name is specifically not passed, changes
272: -- are made to call overloaded procedure.
273: ---------------------------------------------------------------------
274: FUNCTION check_lookup_exists(
275: p_lookup_table_name IN VARCHAR2 := g_ozf_lookups,
276: p_lookup_type IN VARCHAR2,
277: p_lookup_code IN VARCHAR2
278: )
279: Return VARCHAR2

Line 287: IF p_lookup_table_name = g_ozf_lookups THEN

283: l_count NUMBER;
284:
285: BEGIN
286:
287: IF p_lookup_table_name = g_ozf_lookups THEN
288: return check_lookup_exists (
289: p_lookup_type => p_lookup_type
290: , p_lookup_code => p_lookup_code
291: , p_view_application_id => 682

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

1005: -- PROCEDURE
1006: -- get_lookup_meaning
1007: -- created by mpande 01/11/00
1008: -- PURPOSE
1009: -- This procedure will return the meaning from ozf_lookups if
1010: -- you pass the right lookup_type and lookup_code
1011: -- HISTORY
1012: -- 28-Apr-2000 choang Modified to use explicit cursor.
1013: -- 07-Aug-2000 choang Added close cursor for success conditions

Line 1026: FROM ozf_lookups

1022: )
1023: IS
1024: CURSOR c_meaning IS
1025: SELECT meaning
1026: FROM ozf_lookups
1027: WHERE lookup_type = UPPER (p_lookup_type)
1028: AND lookup_code = UPPER (p_lookup_code);
1029: BEGIN
1030: OPEN c_meaning;

Line 1346: FROM ozf_lookups

1342: l_meaning VARCHAR2(80);
1343:
1344: CURSOR c_meaning IS
1345: SELECT meaning
1346: FROM ozf_lookups
1347: WHERE lookup_type = UPPER (p_lookup_type)
1348: AND lookup_code = UPPER (p_lookup_code);
1349: BEGIN
1350: OPEN c_meaning;