DBA Data[Home] [Help]

APPS.OE_HEADER_UTIL dependencies on OE_ID_TO_VALUE

Line 5650: l_header_val_rec.accounting_rule := OE_Id_To_Value.Accounting_Rule

5646: p_header_rec.accounting_rule_id <> FND_API.G_MISS_NUM) AND
5647: NOT OE_GLOBALS.Equal(p_header_rec.accounting_rule_id,
5648: p_old_header_rec.accounting_rule_id)
5649: THEN
5650: l_header_val_rec.accounting_rule := OE_Id_To_Value.Accounting_Rule
5651: ( p_accounting_rule_id => p_header_rec.accounting_rule_id
5652: );
5653: END IF;
5654:

Line 5660: l_header_val_rec.agreement := OE_Id_To_Value.Agreement

5656: p_header_rec.agreement_id <> FND_API.G_MISS_NUM) AND
5657: NOT OE_GLOBALS.Equal(p_header_rec.agreement_id,
5658: p_old_header_rec.agreement_id)
5659: THEN
5660: l_header_val_rec.agreement := OE_Id_To_Value.Agreement
5661: ( p_agreement_id => p_header_rec.agreement_id
5662: );
5663: END IF;
5664:

Line 5670: l_header_val_rec.conversion_type := OE_Id_To_Value.Conversion_Type

5666: p_header_rec.conversion_type_code <> FND_API.G_MISS_CHAR) AND
5667: NOT OE_GLOBALS.Equal(p_header_rec.conversion_type_code,
5668: p_old_header_rec.conversion_type_code)
5669: THEN
5670: l_header_val_rec.conversion_type := OE_Id_To_Value.Conversion_Type
5671: ( p_conversion_type_code => p_header_rec.conversion_type_code
5672: );
5673: END IF;
5674:

Line 5680: l_header_val_rec.deliver_to_contact := OE_Id_To_Value.Deliver_To_Contact

5676: p_header_rec.deliver_to_contact_id <> FND_API.G_MISS_NUM) AND
5677: NOT OE_GLOBALS.Equal(p_header_rec.deliver_to_contact_id,
5678: p_old_header_rec.deliver_to_contact_id)
5679: THEN
5680: l_header_val_rec.deliver_to_contact := OE_Id_To_Value.Deliver_To_Contact
5681: ( p_deliver_to_contact_id => p_header_rec.deliver_to_contact_id
5682: );
5683: END IF;
5684:

Line 5715: l_header_val_rec.fob_point := OE_Id_To_Value.Fob_Point

5711: p_header_rec.fob_point_code <> FND_API.G_MISS_CHAR) AND
5712: NOT OE_GLOBALS.Equal(p_header_rec.fob_point_code,
5713: p_old_header_rec.fob_point_code)
5714: THEN
5715: l_header_val_rec.fob_point := OE_Id_To_Value.Fob_Point
5716: ( p_fob_point_code => p_header_rec.fob_point_code
5717: );
5718: END IF;
5719:

Line 5725: l_header_val_rec.freight_terms := OE_Id_To_Value.Freight_Terms

5721: p_header_rec.freight_terms_code <> FND_API.G_MISS_CHAR) AND
5722: NOT OE_GLOBALS.Equal(p_header_rec.freight_terms_code,
5723: p_old_header_rec.freight_terms_code)
5724: THEN
5725: l_header_val_rec.freight_terms := OE_Id_To_Value.Freight_Terms
5726: ( p_freight_terms_code => p_header_rec.freight_terms_code
5727: );
5728: END IF;
5729:

Line 5735: l_header_val_rec.freight_carrier := OE_Id_To_Value.Freight_Carrier

5731: p_header_rec.freight_carrier_code <> FND_API.G_MISS_CHAR) AND
5732: NOT OE_GLOBALS.Equal(p_header_rec.freight_carrier_code,
5733: p_old_header_rec.freight_carrier_code)
5734: THEN
5735: l_header_val_rec.freight_carrier := OE_Id_To_Value.Freight_Carrier
5736: ( p_freight_carrier_code => p_header_rec.freight_carrier_code
5737: , p_ship_from_org_id => p_header_rec.ship_from_org_id
5738: );
5739: END IF;

Line 5745: l_header_val_rec.shipping_method := OE_Id_To_Value.ship_method

5741: p_header_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND
5742: NOT OE_GLOBALS.Equal(p_header_rec.shipping_method_code,
5743: p_old_header_rec.shipping_method_code)
5744: THEN
5745: l_header_val_rec.shipping_method := OE_Id_To_Value.ship_method
5746: ( p_ship_method_code => p_header_rec.shipping_method_code
5747: );
5748: END IF;
5749:

Line 5755: l_header_val_rec.invoice_to_contact := OE_Id_To_Value.Invoice_To_Contact

5751: p_header_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM) AND
5752: NOT OE_GLOBALS.Equal(p_header_rec.invoice_to_contact_id,
5753: p_old_header_rec.invoice_to_contact_id)
5754: THEN
5755: l_header_val_rec.invoice_to_contact := OE_Id_To_Value.Invoice_To_Contact
5756: ( p_invoice_to_contact_id => p_header_rec.invoice_to_contact_id
5757: );
5758: END IF;
5759:

Line 5791: l_header_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule

5787: p_header_rec.invoicing_rule_id <> FND_API.G_MISS_NUM) AND
5788: NOT OE_GLOBALS.Equal(p_header_rec.invoicing_rule_id,
5789: p_old_header_rec.invoicing_rule_id)
5790: THEN
5791: l_header_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule
5792: ( p_invoicing_rule_id => p_header_rec.invoicing_rule_id
5793: );
5794: END IF;
5795:

Line 5801: l_header_val_rec.order_source := OE_Id_To_Value.Order_Source

5797: p_header_rec.order_source_id <> FND_API.G_MISS_NUM) AND
5798: NOT OE_GLOBALS.Equal(p_header_rec.order_source_id,
5799: p_old_header_rec.order_source_id)
5800: THEN
5801: l_header_val_rec.order_source := OE_Id_To_Value.Order_Source
5802: ( p_order_source_id => p_header_rec.order_source_id
5803: );
5804: END IF;
5805:

Line 5811: l_header_val_rec.order_date_type := OE_Id_To_Value.Order_Date_Type

5807: p_header_rec.order_date_type_code <> FND_API.G_MISS_CHAR) AND
5808: NOT OE_GLOBALS.Equal(p_header_rec.order_date_type_code,
5809: p_old_header_rec.order_date_type_code)
5810: THEN
5811: l_header_val_rec.order_date_type := OE_Id_To_Value.Order_Date_Type
5812: ( p_order_date_type_code => p_header_rec.order_date_type_code
5813: );
5814: END IF;
5815:

Line 5821: l_header_val_rec.order_type := OE_Id_To_Value.Order_Type

5817: p_header_rec.order_type_id <> FND_API.G_MISS_NUM) AND
5818: NOT OE_GLOBALS.Equal(p_header_rec.order_type_id,
5819: p_old_header_rec.order_type_id)
5820: THEN
5821: l_header_val_rec.order_type := OE_Id_To_Value.Order_Type
5822: ( p_order_type_id => p_header_rec.order_type_id
5823: );
5824: END IF;
5825:

Line 5831: l_header_val_rec.payment_term := OE_Id_To_Value.Payment_Term

5827: p_header_rec.payment_term_id <> FND_API.G_MISS_NUM) AND
5828: NOT OE_GLOBALS.Equal(p_header_rec.payment_term_id,
5829: p_old_header_rec.payment_term_id)
5830: THEN
5831: l_header_val_rec.payment_term := OE_Id_To_Value.Payment_Term
5832: ( p_payment_term_id => p_header_rec.payment_term_id
5833: );
5834: END IF;
5835:

Line 5841: l_header_val_rec.price_list := OE_Id_To_Value.Price_List

5837: p_header_rec.price_list_id <> FND_API.G_MISS_NUM) AND
5838: NOT OE_GLOBALS.Equal(p_header_rec.price_list_id,
5839: p_old_header_rec.price_list_id)
5840: THEN
5841: l_header_val_rec.price_list := OE_Id_To_Value.Price_List
5842: ( p_price_list_id => p_header_rec.price_list_id
5843: );
5844: END IF;
5845:

Line 5851: l_header_val_rec.return_reason := OE_Id_To_Value.return_reason

5847: p_header_rec.return_reason_code <> FND_API.G_MISS_CHAR) AND
5848: NOT OE_GLOBALS.Equal(p_header_rec.return_reason_code,
5849: p_old_header_rec.return_reason_code)
5850: THEN
5851: l_header_val_rec.return_reason := OE_Id_To_Value.return_reason
5852: ( p_return_reason_code => p_header_rec.return_reason_code
5853: );
5854: END IF;
5855:

Line 5861: l_header_val_rec.salesrep := OE_Id_To_Value.salesrep

5857: p_header_rec.salesrep_id <> FND_API.G_MISS_NUM) AND
5858: NOT OE_GLOBALS.Equal(p_header_rec.salesrep_id,
5859: p_old_header_rec.salesrep_id)
5860: THEN
5861: l_header_val_rec.salesrep := OE_Id_To_Value.salesrep
5862: ( p_salesrep_id => p_header_rec.salesrep_id
5863: );
5864: END IF;
5865:

Line 5871: l_header_val_rec.sales_channel:= OE_Id_To_Value.sales_channel

5867: p_header_rec.sales_channel_code <> FND_API.G_MISS_CHAR) AND
5868: NOT OE_GLOBALS.Equal(p_header_rec.sales_channel_code,
5869: p_old_header_rec.sales_channel_code)
5870: THEN
5871: l_header_val_rec.sales_channel:= OE_Id_To_Value.sales_channel
5872: ( p_sales_channel_code => p_header_rec.sales_channel_code
5873: );
5874: END IF;
5875:

Line 5881: l_header_val_rec.shipment_priority := OE_Id_To_Value.Shipment_Priority

5877: p_header_rec.shipment_priority_code <> FND_API.G_MISS_CHAR) AND
5878: NOT OE_GLOBALS.Equal(p_header_rec.shipment_priority_code,
5879: p_old_header_rec.shipment_priority_code)
5880: THEN
5881: l_header_val_rec.shipment_priority := OE_Id_To_Value.Shipment_Priority
5882: ( p_shipment_priority_code => p_header_rec.shipment_priority_code
5883: );
5884: END IF;
5885:

Line 5891: l_header_val_rec.Demand_Class := OE_Id_To_Value.Demand_Class

5887: p_header_rec.demand_class_code <> FND_API.G_MISS_CHAR) AND
5888: NOT OE_GLOBALS.Equal(p_header_rec.demand_class_code,
5889: p_old_header_rec.demand_class_code)
5890: THEN
5891: l_header_val_rec.Demand_Class := OE_Id_To_Value.Demand_Class
5892: ( p_demand_class_code => p_header_rec.demand_class_code
5893: );
5894: END IF;
5895:

Line 5901: OE_Id_To_Value.Ship_From_Org

5897: p_header_rec.ship_from_org_id <> FND_API.G_MISS_NUM) AND
5898: NOT OE_GLOBALS.Equal(p_header_rec.ship_from_org_id,
5899: p_old_header_rec.ship_from_org_id)
5900: THEN
5901: OE_Id_To_Value.Ship_From_Org
5902: ( p_ship_from_org_id => p_header_rec.ship_from_org_id
5903: , x_ship_from_address1 => l_header_val_rec.ship_from_address1
5904: , x_ship_from_address2 => l_header_val_rec.ship_from_address2
5905: , x_ship_from_address3 => l_header_val_rec.ship_from_address3

Line 5917: l_header_val_rec.ship_to_contact := OE_Id_To_Value.Ship_To_Contact

5913: p_header_rec.ship_to_contact_id <> FND_API.G_MISS_NUM) AND
5914: NOT OE_GLOBALS.Equal(p_header_rec.ship_to_contact_id,
5915: p_old_header_rec.ship_to_contact_id)
5916: THEN
5917: l_header_val_rec.ship_to_contact := OE_Id_To_Value.Ship_To_Contact
5918: ( p_ship_to_contact_id => p_header_rec.ship_to_contact_id
5919: );
5920: END IF;
5921:

Line 5953: l_header_val_rec.sold_to_contact := OE_Id_To_Value.Sold_To_Contact

5949: p_header_rec.sold_to_contact_id <> FND_API.G_MISS_NUM) AND
5950: NOT OE_GLOBALS.Equal(p_header_rec.sold_to_contact_id,
5951: p_old_header_rec.sold_to_contact_id)
5952: THEN
5953: l_header_val_rec.sold_to_contact := OE_Id_To_Value.Sold_To_Contact
5954: ( p_sold_to_contact_id => p_header_rec.sold_to_contact_id
5955: );
5956: END IF;
5957:

Line 5963: OE_Id_To_Value.Sold_To_Org

5959: p_header_rec.sold_to_org_id <> FND_API.G_MISS_NUM) AND
5960: NOT OE_GLOBALS.Equal(p_header_rec.sold_to_org_id,
5961: p_old_header_rec.sold_to_org_id)
5962: THEN
5963: OE_Id_To_Value.Sold_To_Org
5964: ( p_sold_to_org_id => p_header_rec.sold_to_org_id
5965: , x_org => l_header_val_rec.sold_to_org
5966: , x_customer_number => l_header_val_rec.customer_number
5967: --added for Ac. Desc, Registry ID Project

Line 5978: l_header_val_rec.tax_exempt := OE_Id_To_Value.Tax_Exempt

5974: p_header_rec.tax_exempt_flag <> FND_API.G_MISS_CHAR) AND
5975: NOT OE_GLOBALS.Equal(p_header_rec.tax_exempt_flag,
5976: p_old_header_rec.tax_exempt_flag)
5977: THEN
5978: l_header_val_rec.tax_exempt := OE_Id_To_Value.Tax_Exempt
5979: ( p_tax_exempt_flag => p_header_rec.tax_exempt_flag
5980: );
5981: END IF;
5982:

Line 5988: l_header_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason

5984: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR) AND
5985: NOT OE_GLOBALS.Equal(p_header_rec.tax_exempt_reason_code,
5986: p_old_header_rec.tax_exempt_reason_code)
5987: THEN
5988: l_header_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason
5989: ( p_tax_exempt_reason_code => p_header_rec.tax_exempt_reason_code
5990: );
5991: END IF;
5992:

Line 5998: l_header_val_rec.tax_point := OE_Id_To_Value.Tax_Point

5994: p_header_rec.tax_point_code <> FND_API.G_MISS_CHAR) AND
5995: NOT OE_GLOBALS.Equal(p_header_rec.tax_point_code,
5996: p_old_header_rec.tax_point_code)
5997: THEN
5998: l_header_val_rec.tax_point := OE_Id_To_Value.Tax_Point
5999: ( p_tax_point_code => p_header_rec.tax_point_code
6000: );
6001: END IF;
6002:

Line 6008: l_header_val_rec.payment_type := OE_Id_To_Value.Payment_Type

6004: p_header_rec.payment_type_code <> FND_API.G_MISS_CHAR) AND
6005: NOT OE_GLOBALS.Equal(p_header_rec.payment_type_code,
6006: p_old_header_rec.payment_type_code)
6007: THEN
6008: l_header_val_rec.payment_type := OE_Id_To_Value.Payment_Type
6009: ( p_payment_type_code => p_header_rec.payment_type_code
6010: );
6011: END IF;
6012: --R12 CC Encryption

Line 6018: l_header_val_rec.credit_card := OE_Id_To_Value.Credit_Card

6014: p_header_rec.credit_card_code <> FND_API.G_MISS_CHAR) AND
6015: NOT OE_GLOBALS.Equal(p_header_rec.credit_card_code,
6016: p_old_header_rec.credit_card_code)
6017: THEN
6018: l_header_val_rec.credit_card := OE_Id_To_Value.Credit_Card
6019: ( p_credit_card_code => p_header_rec.credit_card_code
6020: );
6021: END IF;
6022: -- QUOTING changes

Line 6030: OE_ID_TO_VALUE.CUSTOMER_LOCATION

6026: NOT OE_GLOBALS.Equal(p_header_rec.sold_to_site_use_id,
6027: p_old_header_rec.sold_to_site_use_id)
6028: THEN
6029:
6030: OE_ID_TO_VALUE.CUSTOMER_LOCATION
6031: ( p_sold_to_site_use_id => p_header_rec.sold_to_site_use_id
6032: , x_sold_to_location_address1 => l_header_val_rec.sold_to_location_address1
6033: , x_sold_to_location_address2 => l_header_val_rec.sold_to_location_address2
6034: , x_sold_to_location_address3 => l_header_val_rec.sold_to_location_address3

Line 6050: l_header_val_rec.transaction_phase := OE_Id_To_Value.Transaction_Phase

6046: p_header_rec.transaction_phase_code <> FND_API.G_MISS_CHAR) AND
6047: NOT OE_GLOBALS.Equal(p_header_rec.transaction_phase_code,
6048: p_old_header_rec.transaction_phase_code)
6049: THEN
6050: l_header_val_rec.transaction_phase := OE_Id_To_Value.Transaction_Phase
6051: ( p_transaction_phase_code => p_header_rec.transaction_phase_code
6052: );
6053: END IF;
6054:

Line 6060: l_header_val_rec.user_status := OE_Id_To_Value.User_Status

6056: p_header_rec.user_status_code <> FND_API.G_MISS_CHAR) AND
6057: NOT OE_GLOBALS.Equal(p_header_rec.user_status_code,
6058: p_old_header_rec.user_status_code)
6059: THEN
6060: l_header_val_rec.user_status := OE_Id_To_Value.User_Status
6061: ( p_user_status_code => p_header_rec.user_status_code
6062: );
6063: END IF;
6064:

Line 6071: OE_ID_TO_VALUE.End_Customer(

6067: --distributed orders
6068: IF (p_header_rec.end_customer_id IS NOT NULL AND
6069: p_header_rec.end_customer_id <> FND_API.G_MISS_NUM)
6070: THEN
6071: OE_ID_TO_VALUE.End_Customer(
6072: p_end_customer_id => p_header_rec.end_customer_id
6073: ,x_end_customer_name => l_header_val_rec.end_customer_name
6074: ,x_end_customer_number => l_header_val_rec.end_customer_number);
6075: END IF;

Line 6081: OE_ID_TO_VALUE.end_customer_Contact(p_end_customer_contact_id => p_header_rec.end_customer_contact_id);

6077: IF (p_header_rec.end_customer_contact_id IS NOT NULL AND
6078: p_header_rec.end_customer_contact_id <> FND_API.G_MISS_NUM)
6079: THEN
6080: l_header_val_rec.end_customer_contact :=
6081: OE_ID_TO_VALUE.end_customer_Contact(p_end_customer_contact_id => p_header_rec.end_customer_contact_id);
6082: END IF;
6083:
6084: IF (p_header_rec.end_customer_site_use_id IS NOT NULL AND
6085: p_header_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM)

Line 6087: OE_ID_TO_VALUE.end_customer_site_use(

6083:
6084: IF (p_header_rec.end_customer_site_use_id IS NOT NULL AND
6085: p_header_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM)
6086: THEN
6087: OE_ID_TO_VALUE.end_customer_site_use(
6088: p_end_customer_site_use_id => p_header_rec.end_customer_site_use_id
6089: ,x_end_customer_address1 => l_header_val_rec.end_customer_site_address1
6090: ,x_end_customer_address2 => l_header_val_rec.end_customer_site_address2
6091: ,x_end_customer_address3 => l_header_val_rec.end_customer_site_address3

Line 6115: l_header_val_rec.ib_owner_dsp := OE_Id_To_Value.ib_owner

6111: p_header_rec.ib_owner <> FND_API.G_MISS_CHAR) AND
6112: NOT OE_GLOBALS.Equal(p_header_rec.ib_owner,
6113: p_old_header_rec.ib_owner)
6114: THEN
6115: l_header_val_rec.ib_owner_dsp := OE_Id_To_Value.ib_owner
6116: ( p_ib_owner => p_header_rec.ib_owner
6117: );
6118: END IF;
6119:

Line 6125: l_header_val_rec.ib_current_location_dsp := OE_Id_To_Value.ib_current_location(

6121: p_header_rec.ib_current_location <> FND_API.G_MISS_CHAR) AND
6122: NOT OE_GLOBALS.Equal(p_header_rec.ib_current_location,
6123: p_old_header_rec.ib_current_location)
6124: THEN
6125: l_header_val_rec.ib_current_location_dsp := OE_Id_To_Value.ib_current_location(
6126: p_ib_current_location=>p_header_rec.ib_current_location
6127: );
6128: END IF;
6129:

Line 6135: l_header_val_rec.ib_installed_at_location_dsp := OE_Id_To_Value.ib_installed_at_location(

6131: p_header_rec.ib_installed_at_location <> FND_API.G_MISS_CHAR) AND
6132: NOT OE_GLOBALS.Equal(p_header_rec.ib_installed_at_location,
6133: p_old_header_rec.ib_installed_at_location)
6134: THEN
6135: l_header_val_rec.ib_installed_at_location_dsp := OE_Id_To_Value.ib_installed_at_location(
6136: p_ib_installed_at_location=>p_header_rec.ib_installed_at_location
6137: );
6138: END IF;
6139:

Line 9709: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');

9705:
9706: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
9707: THEN
9708:
9709: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
9710: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
9711: OE_MSG_PUB.Add;
9712:
9713: END IF;