APPS.PVX_UTILITY_PVT dependencies on PV_LOOKUPS

Line 117: p_lookup_table_name IN VARCHAR2 := g_pv_lookups,

113: -- check_lookup_exists
114: --
115: ---------------------------------------------------------------------
116: FUNCTION check_lookup_exists(
117: p_lookup_table_name IN VARCHAR2 := g_pv_lookups,
118: p_lookup_type IN VARCHAR2,
119: p_lookup_code IN VARCHAR2
120: )
121: Return VARCHAR2

Line 325: FROM pv_lookups

321: )
322: IS
323: CURSOR c_meaning IS
324: SELECT meaning
325: FROM pv_lookups
326: WHERE lookup_type = UPPER (p_lookup_type)
327: AND lookup_code = UPPER (p_lookup_code);
328: BEGIN
329: OPEN c_meaning;

Line 629: FROM pv_lookups

625: l_meaning VARCHAR2(80);
626:
627: CURSOR c_meaning IS
628: SELECT meaning
629: FROM pv_lookups
630: WHERE lookup_type = UPPER (p_lookup_type)
631: AND lookup_code = UPPER (p_lookup_code);
632: BEGIN
633: OPEN c_meaning;

Line 803: l_lookup_exists := PVX_UTILITY_PVT.check_lookup_exists( p_lookup_table_name => 'PV_LOOKUPS',

799: l_lookup_type := 'PV_INTERACTION_OBJECT_TYPE';--'AMS_SYS_ARC_QUALIFIER';
800: l_lookup_code := p_arc_history_for_entity_code;
801:
802: -- Validate histry entity code against lookup table
803: l_lookup_exists := PVX_UTILITY_PVT.check_lookup_exists( p_lookup_table_name => 'PV_LOOKUPS',
804: p_lookup_type => l_lookup_type,
805: p_lookup_code => l_lookup_code );
806:
807: IF NOT FND_API.to_boolean(l_lookup_exists) THEN

Line 823: l_history_code := PVX_UTILITY_PVT.check_lookup_exists( p_lookup_table_name => 'PV_LOOKUPS',

819: l_lookup_type := 'PV_HISTORY_CATEGORY';
820: l_lookup_code := p_history_category_code;
821:
822: -- Validate History Catagory Code
823: l_history_code := PVX_UTILITY_PVT.check_lookup_exists( p_lookup_table_name => 'PV_LOOKUPS',
824: p_lookup_type => l_lookup_type,
825: p_lookup_code => l_lookup_code );
826:
827: