APPS.PV_ATTRIBUTE_PVT dependencies on PV_LOOKUPS

Line 162: FOR x IN (select meaning from pv_lookups

158:
159: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
160: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_TYPE_STYLE_NOT_CREATE');
161:
162: FOR x IN (select meaning from pv_lookups
163: where lookup_type = 'PV_ATTRIBUTE_TYPE'
164: and lookup_code = l_attribute_rec.attribute_type
165: ) LOOP
166: l_meaning := x.meaning;

Line 170: FOR x IN (select meaning from pv_lookups

166: l_meaning := x.meaning;
167: END LOOP;
168: Fnd_Message.set_token('ATTRIBUTE_TYPE',l_meaning);
169:
170: FOR x IN (select meaning from pv_lookups
171: where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
172: and lookup_code = l_attribute_rec.display_style
173: ) LOOP
174: l_meaning := x.meaning;

Line 543: -- FOR x IN (select meaning from pv_lookups

539:
540: -- FND_MESSAGE.set_name('PV', 'PV_ATTR_NOT_CHANGE_STYLE');
541: -- FND_MESSAGE.set_token('NAME',p_attribute_rec.name);
542:
543: -- FOR x IN (select meaning from pv_lookups
544: -- where lookup_type = 'PV_ATTRIBUTE_TYPE'
545: -- and lookup_code = p_attribute_rec.attribute_type
546: -- ) LOOP
547: -- l_meaning := x.meaning;

Line 551: -- FOR x IN (select meaning from pv_lookups

547: -- l_meaning := x.meaning;
548: -- END LOOP;
549: -- Fnd_Message.set_token('TYPE',l_meaning);
550:
551: -- FOR x IN (select meaning from pv_lookups
552: -- where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
553: -- and lookup_code = l_ref_attribute_rec.display_style
554: -- ) LOOP
555: -- l_meaning := x.meaning;

Line 559: -- FOR x IN (select meaning from pv_lookups

555: -- l_meaning := x.meaning;
556: -- END LOOP;
557: -- FND_MESSAGE.set_token('FROM',l_meaning);
558:
559: -- FOR x IN (select meaning from pv_lookups
560: -- where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
561: -- and lookup_code = p_attribute_rec.display_style
562: -- ) LOOP
563: -- l_meaning := x.meaning;

Line 606: FOR x IN (select meaning from pv_lookups

602:
603: FND_MESSAGE.set_name('PV', 'PV_ATTR_NOT_CHANGE_STYLE');
604: FND_MESSAGE.set_token('NAME',p_attribute_rec.name);
605:
606: FOR x IN (select meaning from pv_lookups
607: where lookup_type = 'PV_ATTRIBUTE_TYPE'
608: and lookup_code = p_attribute_rec.attribute_type
609: ) LOOP
610: l_meaning := x.meaning;

Line 614: FOR x IN (select meaning from pv_lookups

610: l_meaning := x.meaning;
611: END LOOP;
612: Fnd_Message.set_token('TYPE',l_meaning);
613:
614: FOR x IN (select meaning from pv_lookups
615: where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
616: and lookup_code = l_ref_attribute_rec.display_style
617: ) LOOP
618: l_meaning := x.meaning;

Line 622: FOR x IN (select meaning from pv_lookups

618: l_meaning := x.meaning;
619: END LOOP;
620: FND_MESSAGE.set_token('FROM',l_meaning);
621:
622: FOR x IN (select meaning from pv_lookups
623: where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
624: and lookup_code = p_attribute_rec.display_style
625: ) LOOP
626: l_meaning := x.meaning;

Line 854: pv_lookups lkp

850:
851: select resp.RESPONSIBILITY_NAME, lkp.meaning
852: from pv_attrib_resp_mappings val,
853: FND_RESPONSIBILITY_VL resp,
854: pv_lookups lkp
855: where
856: val.attribute_id= pc_attribute_id and
857: resp.RESPONSIBILITY_ID = val.responsibility_id and
858: resp.application_id = 691 and

Line 962: FOR y IN (select meaning from pv_lookups

958: for x in lc_check_attr_enty_vals (pc_attribute_id =>p_attribute_id)
959: loop
960: l_delete_flag := 'N';
961:
962: FOR y IN (select meaning from pv_lookups
963: where lookup_type = 'PV_VALID_ENTY_VALUE_TYPES'
964: and lookup_code = x.entity
965: ) LOOP
966: l_meaning := y.meaning;