DBA Data[Home] [Help]

APPS.PV_ENTITY_ATTRIBUTE_PVT dependencies on PV_LOOKUPS

Line 120: FOR x IN (select meaning from pv_lookups

116: ) then
117:
118: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
119: Fnd_Message.set_name('PV', 'PV_ENTY_ATTR_ERROR');
120: FOR x IN (select meaning from pv_lookups
121: where lookup_type = 'PV_ATTRIBUTE_ENTITY_TYPE'
122: and lookup_code = p_entity_attr_rec.entity
123: ) LOOP
124: l_meaning := x.meaning;

Line 128: FOR x IN (select meaning from pv_lookups

124: l_meaning := x.meaning;
125: END LOOP;
126: Fnd_Message.set_token('ENTITY',l_meaning);
127:
128: FOR x IN (select meaning from pv_lookups
129: where lookup_type = 'PV_ATTRIBUTE_TYPE'
130: and lookup_code = l_attribute_type
131: ) LOOP
132: l_meaning := x.meaning;

Line 136: FOR x IN (select meaning from pv_lookups

132: l_meaning := x.meaning;
133: END LOOP;
134: Fnd_Message.set_token('ATTR_TYPE',l_meaning);
135:
136: FOR x IN (select meaning from pv_lookups
137: where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
138: and lookup_code = l_display_style
139: ) LOOP
140: l_meaning := x.meaning;

Line 682: select meaning from pv_lookups

678: l_exec_sql_text VARCHAR2(2000);
679: l_package_name VARCHAR2(1000);
680: l_entity_meaning VARCHAR2(80);
681: CURSOR c_get_lookup_meaning(cv_lookup_code VARCHAR2) IS
682: select meaning from pv_lookups
683: where lookup_type = 'PV_ATTRIBUTE_ENTITY_TYPE'
684: and lookup_code= cv_lookup_code
685: ;
686: