APPS.OE_OE_FORM_LINE dependencies on OE_LOOKUPS

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

3852:
3853: IF (p_line_rec.shipment_priority_code is not null) or
3854: (p_Line_rec.freight_terms_code is not null) THEN
3855: BEGIN
3856: FOR oe_lookups in c2(p_line_rec.shipment_priority_code,
3857: p_Line_rec.freight_terms_code)
3858: LOOP
3859: IF oe_lookups.lookup_type='SHIPMENT_PRIORITY'then
3860: x_line_val_rec.shipment_priority:=oe_lookups.meaning;

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

3855: BEGIN
3856: FOR oe_lookups in c2(p_line_rec.shipment_priority_code,
3857: p_Line_rec.freight_terms_code)
3858: LOOP
3859: IF oe_lookups.lookup_type='SHIPMENT_PRIORITY'then
3860: x_line_val_rec.shipment_priority:=oe_lookups.meaning;
3861: ELSIF oe_lookups.lookup_type='FREIGHT_TERMS' then
3862: x_line_val_rec.freight_terms:=oe_lookups.meaning;
3863: END IF;

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

3856: FOR oe_lookups in c2(p_line_rec.shipment_priority_code,
3857: p_Line_rec.freight_terms_code)
3858: LOOP
3859: IF oe_lookups.lookup_type='SHIPMENT_PRIORITY'then
3860: x_line_val_rec.shipment_priority:=oe_lookups.meaning;
3861: ELSIF oe_lookups.lookup_type='FREIGHT_TERMS' then
3862: x_line_val_rec.freight_terms:=oe_lookups.meaning;
3863: END IF;
3864: END LOOP;

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

3857: p_Line_rec.freight_terms_code)
3858: LOOP
3859: IF oe_lookups.lookup_type='SHIPMENT_PRIORITY'then
3860: x_line_val_rec.shipment_priority:=oe_lookups.meaning;
3861: ELSIF oe_lookups.lookup_type='FREIGHT_TERMS' then
3862: x_line_val_rec.freight_terms:=oe_lookups.meaning;
3863: END IF;
3864: END LOOP;
3865: END;

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

3858: LOOP
3859: IF oe_lookups.lookup_type='SHIPMENT_PRIORITY'then
3860: x_line_val_rec.shipment_priority:=oe_lookups.meaning;
3861: ELSIF oe_lookups.lookup_type='FREIGHT_TERMS' then
3862: x_line_val_rec.freight_terms:=oe_lookups.meaning;
3863: END IF;
3864: END LOOP;
3865: END;
3866: END IF;

Line 4429: FROM oe_lookups

4425: IF p_line_rec.service_reference_type_code IS NOT NULL THEN
4426: BEGIN
4427: Select meaning
4428: INTO x_line_val_rec.service_reference_type
4429: FROM oe_lookups
4430: WHERE lookup_code=p_line_rec.service_Reference_type_code
4431: and lookup_type = 'SERVICE_REFERENCE_TYPE_CODE';
4432: EXCEPTION
4433: WHEN NO_DATA_FOUND THEN

Line 4491: from oe_lookups

4487: IF (p_line_rec.source_type_code is not null) THEN
4488: BEGIN
4489: select meaning
4490: into x_line_val_rec.source_type
4491: from oe_lookups
4492: where lookup_code=p_line_rec.source_type_code
4493: AND lookup_type='SOURCE_TYPE';
4494:
4495: EXCEPTION

Line 4940: FROM OE_LOOKUPS

4936: IF p_line_rec.calculate_price_flag IS NOT NULL THEN
4937: BEGIN
4938: SELECT MEANING
4939: INTO x_line_val_rec.calculate_price_descr
4940: FROM OE_LOOKUPS
4941: WHERE LOOKUP_CODE = p_line_rec.calculate_price_flag
4942: AND LOOKUP_TYPE = 'CALCULATE_PRICE_FLAG';
4943: EXCEPTION
4944: WHEN NO_DATA_FOUND THEN

Line 5198: from oe_lookups

5194: IF p_line_rec.ib_owner IS NOT NULL THEN
5195:
5196: BEGIN
5197: select meaning into x_line_val_rec.ib_owner_dsp
5198: from oe_lookups
5199: where
5200: ( lookup_type='ITEM_OWNER' OR lookup_type='ONT_INSTALL_BASE') and lookup_code=p_line_rec.ib_owner;
5201: EXCEPTION
5202:

Line 5216: from oe_lookups

5212: IF p_line_rec.ib_current_location IS NOT NULL THEN
5213:
5214: BEGIN
5215: select meaning into x_line_val_rec.ib_current_location_dsp
5216: from oe_lookups
5217: where
5218: ( lookup_type='ITEM_CURRENT_LOCATION' OR lookup_type='ONT_INSTALL_BASE')and lookup_code=p_line_rec.ib_current_location;
5219: EXCEPTION
5220:

Line 5234: from oe_lookups

5230: IF p_line_rec.ib_installed_at_location IS NOT NULL THEN
5231:
5232: BEGIN
5233: select meaning into x_line_val_rec.ib_installed_at_location_dsp
5234: from oe_lookups
5235: where
5236: (lookup_type='ITEM_INSTALL_LOCATION' OR lookup_type='ONT_INSTALL_BASE')and lookup_code=p_line_rec.ib_installed_at_location;
5237: EXCEPTION
5238: