APPS.OE_OE_FORM_LINE dependencies on OE_LOOKUPS

Line 3757: FOR oe_lookups in c2(p_line_rec.shipment_priority_code,

3753:
3754: IF (p_line_rec.shipment_priority_code is not null) or
3755: (p_Line_rec.freight_terms_code is not null) THEN
3756: BEGIN
3757: FOR oe_lookups in c2(p_line_rec.shipment_priority_code,
3758: p_Line_rec.freight_terms_code)
3759: LOOP
3760: IF oe_lookups.lookup_type='SHIPMENT_PRIORITY'then
3761: x_line_val_rec.shipment_priority:=oe_lookups.meaning;

Line 3760: IF oe_lookups.lookup_type='SHIPMENT_PRIORITY'then

3756: BEGIN
3757: FOR oe_lookups in c2(p_line_rec.shipment_priority_code,
3758: p_Line_rec.freight_terms_code)
3759: LOOP
3760: IF oe_lookups.lookup_type='SHIPMENT_PRIORITY'then
3761: x_line_val_rec.shipment_priority:=oe_lookups.meaning;
3762: ELSIF oe_lookups.lookup_type='FREIGHT_TERMS' then
3763: x_line_val_rec.freight_terms:=oe_lookups.meaning;
3764: END IF;

Line 3761: x_line_val_rec.shipment_priority:=oe_lookups.meaning;

3757: FOR oe_lookups in c2(p_line_rec.shipment_priority_code,
3758: p_Line_rec.freight_terms_code)
3759: LOOP
3760: IF oe_lookups.lookup_type='SHIPMENT_PRIORITY'then
3761: x_line_val_rec.shipment_priority:=oe_lookups.meaning;
3762: ELSIF oe_lookups.lookup_type='FREIGHT_TERMS' then
3763: x_line_val_rec.freight_terms:=oe_lookups.meaning;
3764: END IF;
3765: END LOOP;

Line 3762: ELSIF oe_lookups.lookup_type='FREIGHT_TERMS' then

3758: p_Line_rec.freight_terms_code)
3759: LOOP
3760: IF oe_lookups.lookup_type='SHIPMENT_PRIORITY'then
3761: x_line_val_rec.shipment_priority:=oe_lookups.meaning;
3762: ELSIF oe_lookups.lookup_type='FREIGHT_TERMS' then
3763: x_line_val_rec.freight_terms:=oe_lookups.meaning;
3764: END IF;
3765: END LOOP;
3766: END;

Line 3763: x_line_val_rec.freight_terms:=oe_lookups.meaning;

3759: LOOP
3760: IF oe_lookups.lookup_type='SHIPMENT_PRIORITY'then
3761: x_line_val_rec.shipment_priority:=oe_lookups.meaning;
3762: ELSIF oe_lookups.lookup_type='FREIGHT_TERMS' then
3763: x_line_val_rec.freight_terms:=oe_lookups.meaning;
3764: END IF;
3765: END LOOP;
3766: END;
3767: END IF;

Line 4160: FROM oe_lookups

4156: IF p_line_rec.service_reference_type_code IS NOT NULL THEN
4157: BEGIN
4158: Select meaning
4159: INTO x_line_val_rec.service_reference_type
4160: FROM oe_lookups
4161: WHERE lookup_code=p_line_rec.service_Reference_type_code
4162: and lookup_type = 'SERVICE_REFERENCE_TYPE_CODE';
4163: EXCEPTION
4164: WHEN NO_DATA_FOUND THEN

Line 4213: from oe_lookups

4209: IF (p_line_rec.source_type_code is not null) THEN
4210: BEGIN
4211: select meaning
4212: into x_line_val_rec.source_type
4213: from oe_lookups
4214: where lookup_code=p_line_rec.source_type_code
4215: AND lookup_type='SOURCE_TYPE';
4216:
4217: EXCEPTION

Line 4662: FROM OE_LOOKUPS

4658: IF p_line_rec.calculate_price_flag IS NOT NULL THEN
4659: BEGIN
4660: SELECT MEANING
4661: INTO x_line_val_rec.calculate_price_descr
4662: FROM OE_LOOKUPS
4663: WHERE LOOKUP_CODE = p_line_rec.calculate_price_flag
4664: AND LOOKUP_TYPE = 'CALCULATE_PRICE_FLAG';
4665: EXCEPTION
4666: WHEN NO_DATA_FOUND THEN

Line 4920: from oe_lookups

4916: IF p_line_rec.ib_owner IS NOT NULL THEN
4917:
4918: BEGIN
4919: select meaning into x_line_val_rec.ib_owner_dsp
4920: from oe_lookups
4921: where
4922: ( lookup_type='ITEM_OWNER' OR lookup_type='ONT_INSTALL_BASE') and lookup_code=p_line_rec.ib_owner;
4923: EXCEPTION
4924:

Line 4938: from oe_lookups

4934: IF p_line_rec.ib_current_location IS NOT NULL THEN
4935:
4936: BEGIN
4937: select meaning into x_line_val_rec.ib_current_location_dsp
4938: from oe_lookups
4939: where
4940: ( lookup_type='ITEM_CURRENT_LOCATION' OR lookup_type='ONT_INSTALL_BASE')and lookup_code=p_line_rec.ib_current_location;
4941: EXCEPTION
4942:

Line 4956: from oe_lookups

4952: IF p_line_rec.ib_installed_at_location IS NOT NULL THEN
4953:
4954: BEGIN
4955: select meaning into x_line_val_rec.ib_installed_at_location_dsp
4956: from oe_lookups
4957: where
4958: (lookup_type='ITEM_INSTALL_LOCATION' OR lookup_type='ONT_INSTALL_BASE')and lookup_code=p_line_rec.ib_installed_at_location;
4959: EXCEPTION
4960: