DBA Data[Home] [Help]

APPS.OE_HEADER_UTIL dependencies on OE_ID_TO_VALUE

Line 5500: l_header_val_rec.accounting_rule := OE_Id_To_Value.Accounting_Rule

5496: p_header_rec.accounting_rule_id <> FND_API.G_MISS_NUM) AND
5497: NOT OE_GLOBALS.Equal(p_header_rec.accounting_rule_id,
5498: p_old_header_rec.accounting_rule_id)
5499: THEN
5500: l_header_val_rec.accounting_rule := OE_Id_To_Value.Accounting_Rule
5501: ( p_accounting_rule_id => p_header_rec.accounting_rule_id
5502: );
5503: END IF;
5504:

Line 5510: l_header_val_rec.agreement := OE_Id_To_Value.Agreement

5506: p_header_rec.agreement_id <> FND_API.G_MISS_NUM) AND
5507: NOT OE_GLOBALS.Equal(p_header_rec.agreement_id,
5508: p_old_header_rec.agreement_id)
5509: THEN
5510: l_header_val_rec.agreement := OE_Id_To_Value.Agreement
5511: ( p_agreement_id => p_header_rec.agreement_id
5512: );
5513: END IF;
5514:

Line 5520: l_header_val_rec.conversion_type := OE_Id_To_Value.Conversion_Type

5516: p_header_rec.conversion_type_code <> FND_API.G_MISS_CHAR) AND
5517: NOT OE_GLOBALS.Equal(p_header_rec.conversion_type_code,
5518: p_old_header_rec.conversion_type_code)
5519: THEN
5520: l_header_val_rec.conversion_type := OE_Id_To_Value.Conversion_Type
5521: ( p_conversion_type_code => p_header_rec.conversion_type_code
5522: );
5523: END IF;
5524:

Line 5530: l_header_val_rec.deliver_to_contact := OE_Id_To_Value.Deliver_To_Contact

5526: p_header_rec.deliver_to_contact_id <> FND_API.G_MISS_NUM) AND
5527: NOT OE_GLOBALS.Equal(p_header_rec.deliver_to_contact_id,
5528: p_old_header_rec.deliver_to_contact_id)
5529: THEN
5530: l_header_val_rec.deliver_to_contact := OE_Id_To_Value.Deliver_To_Contact
5531: ( p_deliver_to_contact_id => p_header_rec.deliver_to_contact_id
5532: );
5533: END IF;
5534:

Line 5565: l_header_val_rec.fob_point := OE_Id_To_Value.Fob_Point

5561: p_header_rec.fob_point_code <> FND_API.G_MISS_CHAR) AND
5562: NOT OE_GLOBALS.Equal(p_header_rec.fob_point_code,
5563: p_old_header_rec.fob_point_code)
5564: THEN
5565: l_header_val_rec.fob_point := OE_Id_To_Value.Fob_Point
5566: ( p_fob_point_code => p_header_rec.fob_point_code
5567: );
5568: END IF;
5569:

Line 5575: l_header_val_rec.freight_terms := OE_Id_To_Value.Freight_Terms

5571: p_header_rec.freight_terms_code <> FND_API.G_MISS_CHAR) AND
5572: NOT OE_GLOBALS.Equal(p_header_rec.freight_terms_code,
5573: p_old_header_rec.freight_terms_code)
5574: THEN
5575: l_header_val_rec.freight_terms := OE_Id_To_Value.Freight_Terms
5576: ( p_freight_terms_code => p_header_rec.freight_terms_code
5577: );
5578: END IF;
5579:

Line 5585: l_header_val_rec.freight_carrier := OE_Id_To_Value.Freight_Carrier

5581: p_header_rec.freight_carrier_code <> FND_API.G_MISS_CHAR) AND
5582: NOT OE_GLOBALS.Equal(p_header_rec.freight_carrier_code,
5583: p_old_header_rec.freight_carrier_code)
5584: THEN
5585: l_header_val_rec.freight_carrier := OE_Id_To_Value.Freight_Carrier
5586: ( p_freight_carrier_code => p_header_rec.freight_carrier_code
5587: , p_ship_from_org_id => p_header_rec.ship_from_org_id
5588: );
5589: END IF;

Line 5595: l_header_val_rec.shipping_method := OE_Id_To_Value.ship_method

5591: p_header_rec.shipping_method_code <> FND_API.G_MISS_CHAR) AND
5592: NOT OE_GLOBALS.Equal(p_header_rec.shipping_method_code,
5593: p_old_header_rec.shipping_method_code)
5594: THEN
5595: l_header_val_rec.shipping_method := OE_Id_To_Value.ship_method
5596: ( p_ship_method_code => p_header_rec.shipping_method_code
5597: );
5598: END IF;
5599:

Line 5605: l_header_val_rec.invoice_to_contact := OE_Id_To_Value.Invoice_To_Contact

5601: p_header_rec.invoice_to_contact_id <> FND_API.G_MISS_NUM) AND
5602: NOT OE_GLOBALS.Equal(p_header_rec.invoice_to_contact_id,
5603: p_old_header_rec.invoice_to_contact_id)
5604: THEN
5605: l_header_val_rec.invoice_to_contact := OE_Id_To_Value.Invoice_To_Contact
5606: ( p_invoice_to_contact_id => p_header_rec.invoice_to_contact_id
5607: );
5608: END IF;
5609:

Line 5641: l_header_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule

5637: p_header_rec.invoicing_rule_id <> FND_API.G_MISS_NUM) AND
5638: NOT OE_GLOBALS.Equal(p_header_rec.invoicing_rule_id,
5639: p_old_header_rec.invoicing_rule_id)
5640: THEN
5641: l_header_val_rec.invoicing_rule := OE_Id_To_Value.Invoicing_Rule
5642: ( p_invoicing_rule_id => p_header_rec.invoicing_rule_id
5643: );
5644: END IF;
5645:

Line 5651: l_header_val_rec.order_source := OE_Id_To_Value.Order_Source

5647: p_header_rec.order_source_id <> FND_API.G_MISS_NUM) AND
5648: NOT OE_GLOBALS.Equal(p_header_rec.order_source_id,
5649: p_old_header_rec.order_source_id)
5650: THEN
5651: l_header_val_rec.order_source := OE_Id_To_Value.Order_Source
5652: ( p_order_source_id => p_header_rec.order_source_id
5653: );
5654: END IF;
5655:

Line 5661: l_header_val_rec.order_date_type := OE_Id_To_Value.Order_Date_Type

5657: p_header_rec.order_date_type_code <> FND_API.G_MISS_CHAR) AND
5658: NOT OE_GLOBALS.Equal(p_header_rec.order_date_type_code,
5659: p_old_header_rec.order_date_type_code)
5660: THEN
5661: l_header_val_rec.order_date_type := OE_Id_To_Value.Order_Date_Type
5662: ( p_order_date_type_code => p_header_rec.order_date_type_code
5663: );
5664: END IF;
5665:

Line 5671: l_header_val_rec.order_type := OE_Id_To_Value.Order_Type

5667: p_header_rec.order_type_id <> FND_API.G_MISS_NUM) AND
5668: NOT OE_GLOBALS.Equal(p_header_rec.order_type_id,
5669: p_old_header_rec.order_type_id)
5670: THEN
5671: l_header_val_rec.order_type := OE_Id_To_Value.Order_Type
5672: ( p_order_type_id => p_header_rec.order_type_id
5673: );
5674: END IF;
5675:

Line 5681: l_header_val_rec.payment_term := OE_Id_To_Value.Payment_Term

5677: p_header_rec.payment_term_id <> FND_API.G_MISS_NUM) AND
5678: NOT OE_GLOBALS.Equal(p_header_rec.payment_term_id,
5679: p_old_header_rec.payment_term_id)
5680: THEN
5681: l_header_val_rec.payment_term := OE_Id_To_Value.Payment_Term
5682: ( p_payment_term_id => p_header_rec.payment_term_id
5683: );
5684: END IF;
5685:

Line 5691: l_header_val_rec.price_list := OE_Id_To_Value.Price_List

5687: p_header_rec.price_list_id <> FND_API.G_MISS_NUM) AND
5688: NOT OE_GLOBALS.Equal(p_header_rec.price_list_id,
5689: p_old_header_rec.price_list_id)
5690: THEN
5691: l_header_val_rec.price_list := OE_Id_To_Value.Price_List
5692: ( p_price_list_id => p_header_rec.price_list_id
5693: );
5694: END IF;
5695:

Line 5701: l_header_val_rec.return_reason := OE_Id_To_Value.return_reason

5697: p_header_rec.return_reason_code <> FND_API.G_MISS_CHAR) AND
5698: NOT OE_GLOBALS.Equal(p_header_rec.return_reason_code,
5699: p_old_header_rec.return_reason_code)
5700: THEN
5701: l_header_val_rec.return_reason := OE_Id_To_Value.return_reason
5702: ( p_return_reason_code => p_header_rec.return_reason_code
5703: );
5704: END IF;
5705:

Line 5711: l_header_val_rec.salesrep := OE_Id_To_Value.salesrep

5707: p_header_rec.salesrep_id <> FND_API.G_MISS_NUM) AND
5708: NOT OE_GLOBALS.Equal(p_header_rec.salesrep_id,
5709: p_old_header_rec.salesrep_id)
5710: THEN
5711: l_header_val_rec.salesrep := OE_Id_To_Value.salesrep
5712: ( p_salesrep_id => p_header_rec.salesrep_id
5713: );
5714: END IF;
5715:

Line 5721: l_header_val_rec.sales_channel:= OE_Id_To_Value.sales_channel

5717: p_header_rec.sales_channel_code <> FND_API.G_MISS_CHAR) AND
5718: NOT OE_GLOBALS.Equal(p_header_rec.sales_channel_code,
5719: p_old_header_rec.sales_channel_code)
5720: THEN
5721: l_header_val_rec.sales_channel:= OE_Id_To_Value.sales_channel
5722: ( p_sales_channel_code => p_header_rec.sales_channel_code
5723: );
5724: END IF;
5725:

Line 5731: l_header_val_rec.shipment_priority := OE_Id_To_Value.Shipment_Priority

5727: p_header_rec.shipment_priority_code <> FND_API.G_MISS_CHAR) AND
5728: NOT OE_GLOBALS.Equal(p_header_rec.shipment_priority_code,
5729: p_old_header_rec.shipment_priority_code)
5730: THEN
5731: l_header_val_rec.shipment_priority := OE_Id_To_Value.Shipment_Priority
5732: ( p_shipment_priority_code => p_header_rec.shipment_priority_code
5733: );
5734: END IF;
5735:

Line 5741: l_header_val_rec.Demand_Class := OE_Id_To_Value.Demand_Class

5737: p_header_rec.demand_class_code <> FND_API.G_MISS_CHAR) AND
5738: NOT OE_GLOBALS.Equal(p_header_rec.demand_class_code,
5739: p_old_header_rec.demand_class_code)
5740: THEN
5741: l_header_val_rec.Demand_Class := OE_Id_To_Value.Demand_Class
5742: ( p_demand_class_code => p_header_rec.demand_class_code
5743: );
5744: END IF;
5745:

Line 5751: OE_Id_To_Value.Ship_From_Org

5747: p_header_rec.ship_from_org_id <> FND_API.G_MISS_NUM) AND
5748: NOT OE_GLOBALS.Equal(p_header_rec.ship_from_org_id,
5749: p_old_header_rec.ship_from_org_id)
5750: THEN
5751: OE_Id_To_Value.Ship_From_Org
5752: ( p_ship_from_org_id => p_header_rec.ship_from_org_id
5753: , x_ship_from_address1 => l_header_val_rec.ship_from_address1
5754: , x_ship_from_address2 => l_header_val_rec.ship_from_address2
5755: , x_ship_from_address3 => l_header_val_rec.ship_from_address3

Line 5767: l_header_val_rec.ship_to_contact := OE_Id_To_Value.Ship_To_Contact

5763: p_header_rec.ship_to_contact_id <> FND_API.G_MISS_NUM) AND
5764: NOT OE_GLOBALS.Equal(p_header_rec.ship_to_contact_id,
5765: p_old_header_rec.ship_to_contact_id)
5766: THEN
5767: l_header_val_rec.ship_to_contact := OE_Id_To_Value.Ship_To_Contact
5768: ( p_ship_to_contact_id => p_header_rec.ship_to_contact_id
5769: );
5770: END IF;
5771:

Line 5803: l_header_val_rec.sold_to_contact := OE_Id_To_Value.Sold_To_Contact

5799: p_header_rec.sold_to_contact_id <> FND_API.G_MISS_NUM) AND
5800: NOT OE_GLOBALS.Equal(p_header_rec.sold_to_contact_id,
5801: p_old_header_rec.sold_to_contact_id)
5802: THEN
5803: l_header_val_rec.sold_to_contact := OE_Id_To_Value.Sold_To_Contact
5804: ( p_sold_to_contact_id => p_header_rec.sold_to_contact_id
5805: );
5806: END IF;
5807:

Line 5813: OE_Id_To_Value.Sold_To_Org

5809: p_header_rec.sold_to_org_id <> FND_API.G_MISS_NUM) AND
5810: NOT OE_GLOBALS.Equal(p_header_rec.sold_to_org_id,
5811: p_old_header_rec.sold_to_org_id)
5812: THEN
5813: OE_Id_To_Value.Sold_To_Org
5814: ( p_sold_to_org_id => p_header_rec.sold_to_org_id
5815: , x_org => l_header_val_rec.sold_to_org
5816: , x_customer_number => l_header_val_rec.customer_number
5817: --added for Ac. Desc, Registry ID Project

Line 5828: l_header_val_rec.tax_exempt := OE_Id_To_Value.Tax_Exempt

5824: p_header_rec.tax_exempt_flag <> FND_API.G_MISS_CHAR) AND
5825: NOT OE_GLOBALS.Equal(p_header_rec.tax_exempt_flag,
5826: p_old_header_rec.tax_exempt_flag)
5827: THEN
5828: l_header_val_rec.tax_exempt := OE_Id_To_Value.Tax_Exempt
5829: ( p_tax_exempt_flag => p_header_rec.tax_exempt_flag
5830: );
5831: END IF;
5832:

Line 5838: l_header_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason

5834: p_header_rec.tax_exempt_reason_code <> FND_API.G_MISS_CHAR) AND
5835: NOT OE_GLOBALS.Equal(p_header_rec.tax_exempt_reason_code,
5836: p_old_header_rec.tax_exempt_reason_code)
5837: THEN
5838: l_header_val_rec.tax_exempt_reason := OE_Id_To_Value.Tax_Exempt_Reason
5839: ( p_tax_exempt_reason_code => p_header_rec.tax_exempt_reason_code
5840: );
5841: END IF;
5842:

Line 5848: l_header_val_rec.tax_point := OE_Id_To_Value.Tax_Point

5844: p_header_rec.tax_point_code <> FND_API.G_MISS_CHAR) AND
5845: NOT OE_GLOBALS.Equal(p_header_rec.tax_point_code,
5846: p_old_header_rec.tax_point_code)
5847: THEN
5848: l_header_val_rec.tax_point := OE_Id_To_Value.Tax_Point
5849: ( p_tax_point_code => p_header_rec.tax_point_code
5850: );
5851: END IF;
5852:

Line 5858: l_header_val_rec.payment_type := OE_Id_To_Value.Payment_Type

5854: p_header_rec.payment_type_code <> FND_API.G_MISS_CHAR) AND
5855: NOT OE_GLOBALS.Equal(p_header_rec.payment_type_code,
5856: p_old_header_rec.payment_type_code)
5857: THEN
5858: l_header_val_rec.payment_type := OE_Id_To_Value.Payment_Type
5859: ( p_payment_type_code => p_header_rec.payment_type_code
5860: );
5861: END IF;
5862: --R12 CC Encryption

Line 5868: l_header_val_rec.credit_card := OE_Id_To_Value.Credit_Card

5864: p_header_rec.credit_card_code <> FND_API.G_MISS_CHAR) AND
5865: NOT OE_GLOBALS.Equal(p_header_rec.credit_card_code,
5866: p_old_header_rec.credit_card_code)
5867: THEN
5868: l_header_val_rec.credit_card := OE_Id_To_Value.Credit_Card
5869: ( p_credit_card_code => p_header_rec.credit_card_code
5870: );
5871: END IF;
5872: -- QUOTING changes

Line 5880: OE_ID_TO_VALUE.CUSTOMER_LOCATION

5876: NOT OE_GLOBALS.Equal(p_header_rec.sold_to_site_use_id,
5877: p_old_header_rec.sold_to_site_use_id)
5878: THEN
5879:
5880: OE_ID_TO_VALUE.CUSTOMER_LOCATION
5881: ( p_sold_to_site_use_id => p_header_rec.sold_to_site_use_id
5882: , x_sold_to_location_address1 => l_header_val_rec.sold_to_location_address1
5883: , x_sold_to_location_address2 => l_header_val_rec.sold_to_location_address2
5884: , x_sold_to_location_address3 => l_header_val_rec.sold_to_location_address3

Line 5900: l_header_val_rec.transaction_phase := OE_Id_To_Value.Transaction_Phase

5896: p_header_rec.transaction_phase_code <> FND_API.G_MISS_CHAR) AND
5897: NOT OE_GLOBALS.Equal(p_header_rec.transaction_phase_code,
5898: p_old_header_rec.transaction_phase_code)
5899: THEN
5900: l_header_val_rec.transaction_phase := OE_Id_To_Value.Transaction_Phase
5901: ( p_transaction_phase_code => p_header_rec.transaction_phase_code
5902: );
5903: END IF;
5904:

Line 5910: l_header_val_rec.user_status := OE_Id_To_Value.User_Status

5906: p_header_rec.user_status_code <> FND_API.G_MISS_CHAR) AND
5907: NOT OE_GLOBALS.Equal(p_header_rec.user_status_code,
5908: p_old_header_rec.user_status_code)
5909: THEN
5910: l_header_val_rec.user_status := OE_Id_To_Value.User_Status
5911: ( p_user_status_code => p_header_rec.user_status_code
5912: );
5913: END IF;
5914:

Line 5921: OE_ID_TO_VALUE.End_Customer(

5917: --distributed orders
5918: IF (p_header_rec.end_customer_id IS NOT NULL AND
5919: p_header_rec.end_customer_id <> FND_API.G_MISS_NUM)
5920: THEN
5921: OE_ID_TO_VALUE.End_Customer(
5922: p_end_customer_id => p_header_rec.end_customer_id
5923: ,x_end_customer_name => l_header_val_rec.end_customer_name
5924: ,x_end_customer_number => l_header_val_rec.end_customer_number);
5925: END IF;

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

5927: IF (p_header_rec.end_customer_contact_id IS NOT NULL AND
5928: p_header_rec.end_customer_contact_id <> FND_API.G_MISS_NUM)
5929: THEN
5930: l_header_val_rec.end_customer_contact :=
5931: OE_ID_TO_VALUE.end_customer_Contact(p_end_customer_contact_id => p_header_rec.end_customer_contact_id);
5932: END IF;
5933:
5934: IF (p_header_rec.end_customer_site_use_id IS NOT NULL AND
5935: p_header_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM)

Line 5937: OE_ID_TO_VALUE.end_customer_site_use(

5933:
5934: IF (p_header_rec.end_customer_site_use_id IS NOT NULL AND
5935: p_header_rec.end_customer_site_use_id <> FND_API.G_MISS_NUM)
5936: THEN
5937: OE_ID_TO_VALUE.end_customer_site_use(
5938: p_end_customer_site_use_id => p_header_rec.end_customer_site_use_id
5939: ,x_end_customer_address1 => l_header_val_rec.end_customer_site_address1
5940: ,x_end_customer_address2 => l_header_val_rec.end_customer_site_address2
5941: ,x_end_customer_address3 => l_header_val_rec.end_customer_site_address3

Line 5965: l_header_val_rec.ib_owner_dsp := OE_Id_To_Value.ib_owner

5961: p_header_rec.ib_owner <> FND_API.G_MISS_CHAR) AND
5962: NOT OE_GLOBALS.Equal(p_header_rec.ib_owner,
5963: p_old_header_rec.ib_owner)
5964: THEN
5965: l_header_val_rec.ib_owner_dsp := OE_Id_To_Value.ib_owner
5966: ( p_ib_owner => p_header_rec.ib_owner
5967: );
5968: END IF;
5969:

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

5971: p_header_rec.ib_current_location <> FND_API.G_MISS_CHAR) AND
5972: NOT OE_GLOBALS.Equal(p_header_rec.ib_current_location,
5973: p_old_header_rec.ib_current_location)
5974: THEN
5975: l_header_val_rec.ib_current_location_dsp := OE_Id_To_Value.ib_current_location(
5976: p_ib_current_location=>p_header_rec.ib_current_location
5977: );
5978: END IF;
5979:

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

5981: p_header_rec.ib_installed_at_location <> FND_API.G_MISS_CHAR) AND
5982: NOT OE_GLOBALS.Equal(p_header_rec.ib_installed_at_location,
5983: p_old_header_rec.ib_installed_at_location)
5984: THEN
5985: l_header_val_rec.ib_installed_at_location_dsp := OE_Id_To_Value.ib_installed_at_location(
5986: p_ib_installed_at_location=>p_header_rec.ib_installed_at_location
5987: );
5988: END IF;
5989:

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

9487:
9488: IF OE_MSG_PUB.Check_Msg_Level(OE_MSG_PUB.G_MSG_LVL_SUCCESS)
9489: THEN
9490:
9491: fnd_message.set_name('ONT','OE_ID_TO_VALUE_ERROR');
9492: FND_MESSAGE.SET_TOKEN('ATTRIBUTE','get_customer_details');
9493: OE_MSG_PUB.Add;
9494:
9495: END IF;