DBA Data[Home] [Help]

APPS.OE_HEADER_UTIL dependencies on OE_VALUE_TO_ID

Line 6050: p_x_header_rec.accounting_rule_id := OE_Value_To_Id.accounting_rule

6046: END IF;
6047:
6048: ELSE
6049:
6050: p_x_header_rec.accounting_rule_id := OE_Value_To_Id.accounting_rule
6051: ( p_accounting_rule => p_header_val_rec.accounting_rule
6052: );
6053:
6054: IF p_x_header_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN

Line 6080: p_x_header_rec.agreement_id := OE_Value_To_Id.agreement

6076: END IF;
6077:
6078: ELSE
6079:
6080: p_x_header_rec.agreement_id := OE_Value_To_Id.agreement
6081: ( p_agreement => p_header_val_rec.agreement
6082: );
6083:
6084: IF p_x_header_rec.agreement_id = FND_API.G_MISS_NUM THEN

Line 6109: p_x_header_rec.conversion_type_code := OE_Value_To_Id.conversion_type

6105: END IF;
6106:
6107: ELSE
6108:
6109: p_x_header_rec.conversion_type_code := OE_Value_To_Id.conversion_type
6110: ( p_conversion_type => p_header_val_rec.conversion_type
6111: );
6112:
6113: IF p_x_header_rec.conversion_type_code = FND_API.G_MISS_CHAR THEN

Line 6138: p_x_header_rec.fob_point_code := OE_Value_To_Id.fob_point

6134: END IF;
6135:
6136: ELSE
6137:
6138: p_x_header_rec.fob_point_code := OE_Value_To_Id.fob_point
6139: ( p_fob_point => p_header_val_rec.fob_point
6140: );
6141:
6142: IF p_x_header_rec.fob_point_code = FND_API.G_MISS_CHAR THEN

Line 6167: p_x_header_rec.freight_terms_code := OE_Value_To_Id.freight_terms

6163: END IF;
6164:
6165: ELSE
6166:
6167: p_x_header_rec.freight_terms_code := OE_Value_To_Id.freight_terms
6168: ( p_freight_terms => p_header_val_rec.freight_terms
6169: );
6170:
6171: IF p_x_header_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

Line 6195: p_x_header_rec.shipping_method_code := OE_Value_To_Id.ship_method

6191: END IF;
6192:
6193: ELSE
6194:
6195: p_x_header_rec.shipping_method_code := OE_Value_To_Id.ship_method
6196: ( p_ship_method => p_header_val_rec.shipping_method
6197: );
6198:
6199: IF p_x_header_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN

Line 6226: p_x_header_rec.freight_carrier_code := OE_Value_To_Id.freight_carrier

6222: END IF;
6223:
6224: ELSE
6225:
6226: p_x_header_rec.freight_carrier_code := OE_Value_To_Id.freight_carrier
6227: ( p_freight_carrier => p_header_val_rec.freight_carrier
6228: , p_ship_from_org_id => p_x_header_rec.ship_from_org_id
6229: );
6230:

Line 6256: p_x_header_rec.invoicing_rule_id := OE_Value_To_Id.invoicing_rule

6252: END IF;
6253:
6254: ELSE
6255:
6256: p_x_header_rec.invoicing_rule_id := OE_Value_To_Id.invoicing_rule
6257: ( p_invoicing_rule => p_header_val_rec.invoicing_rule
6258: );
6259:
6260: IF p_x_header_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN

Line 6285: p_x_header_rec.order_source_id := OE_Value_To_Id.order_source

6281: END IF;
6282:
6283: ELSE
6284:
6285: p_x_header_rec.order_source_id := OE_Value_To_Id.order_source
6286: ( p_order_source => p_header_val_rec.order_source
6287: );
6288:
6289: IF p_x_header_rec.order_source_id = FND_API.G_MISS_NUM THEN

Line 6314: p_x_header_rec.order_type_id := OE_Value_To_Id.order_type

6310: END IF;
6311:
6312: ELSE
6313:
6314: p_x_header_rec.order_type_id := OE_Value_To_Id.order_type
6315: ( p_order_type => p_header_val_rec.order_type
6316: );
6317:
6318: IF p_x_header_rec.order_type_id = FND_API.G_MISS_NUM THEN

Line 6343: p_x_header_rec.payment_term_id := OE_Value_To_Id.payment_term

6339: END IF;
6340:
6341: ELSE
6342:
6343: p_x_header_rec.payment_term_id := OE_Value_To_Id.payment_term
6344: ( p_payment_term => p_header_val_rec.payment_term
6345: );
6346:
6347: IF p_x_header_rec.payment_term_id = FND_API.G_MISS_NUM THEN

Line 6372: p_x_header_rec.price_list_id := OE_Value_To_Id.price_list

6368: END IF;
6369:
6370: ELSE
6371:
6372: p_x_header_rec.price_list_id := OE_Value_To_Id.price_list
6373: ( p_price_list => p_header_val_rec.price_list
6374: );
6375:
6376: IF p_x_header_rec.price_list_id = FND_API.G_MISS_NUM THEN

Line 6401: p_x_header_rec.return_reason_code := OE_Value_To_Id.return_reason

6397: END IF;
6398:
6399: ELSE
6400:
6401: p_x_header_rec.return_reason_code := OE_Value_To_Id.return_reason
6402: ( p_return_reason => p_header_val_rec.return_reason
6403: );
6404:
6405: IF p_x_header_rec.return_reason_code = FND_API.G_MISS_CHAR THEN

Line 6430: p_x_header_rec.salesrep_id := OE_Value_To_Id.salesrep

6426: END IF;
6427:
6428: ELSE
6429:
6430: p_x_header_rec.salesrep_id := OE_Value_To_Id.salesrep
6431: ( p_salesrep => p_header_val_rec.salesrep
6432: );
6433: IF p_x_header_rec.salesrep_id = FND_API.G_MISS_NUM THEN
6434: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;

Line 6459: p_x_header_rec.sales_channel_code := OE_Value_To_Id.sales_channel

6455: END IF;
6456:
6457: ELSE
6458:
6459: p_x_header_rec.sales_channel_code := OE_Value_To_Id.sales_channel
6460: ( p_sales_channel => p_header_val_rec.sales_channel
6461: );
6462: IF p_x_header_rec.sales_channel_code = FND_API.G_MISS_CHAR THEN
6463: p_x_header_rec.return_status := FND_API.G_RET_STS_ERROR;

Line 6488: p_x_header_rec.shipment_priority_code := OE_Value_To_Id.shipment_priority

6484: END IF;
6485:
6486: ELSE
6487:
6488: p_x_header_rec.shipment_priority_code := OE_Value_To_Id.shipment_priority
6489: ( p_shipment_priority => p_header_val_rec.shipment_priority
6490: );
6491:
6492: IF p_x_header_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN

Line 6522: p_x_header_rec.ship_from_org_id := OE_Value_To_Id.ship_from_org

6518: END IF;
6519:
6520: ELSE
6521:
6522: p_x_header_rec.ship_from_org_id := OE_Value_To_Id.ship_from_org
6523: ( p_ship_from_address1 => p_header_val_rec.ship_from_address1
6524: , p_ship_from_address2 => p_header_val_rec.ship_from_address2
6525: , p_ship_from_address3 => p_header_val_rec.ship_from_address3
6526: , p_ship_from_address4 => p_header_val_rec.ship_from_address4

Line 6556: p_x_header_rec.tax_exempt_flag := OE_Value_To_Id.tax_exempt

6552: END IF;
6553:
6554: ELSE
6555:
6556: p_x_header_rec.tax_exempt_flag := OE_Value_To_Id.tax_exempt
6557: ( p_tax_exempt => p_header_val_rec.tax_exempt
6558: );
6559:
6560: IF p_x_header_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN

Line 6585: p_x_header_rec.tax_exempt_reason_code := OE_Value_To_Id.tax_exempt_reason

6581: END IF;
6582:
6583: ELSE
6584:
6585: p_x_header_rec.tax_exempt_reason_code := OE_Value_To_Id.tax_exempt_reason
6586: ( p_tax_exempt_reason => p_header_val_rec.tax_exempt_reason
6587: );
6588:
6589: IF p_x_header_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN

Line 6614: p_x_header_rec.tax_point_code := OE_Value_To_Id.tax_point

6610: END IF;
6611:
6612: ELSE
6613:
6614: p_x_header_rec.tax_point_code := OE_Value_To_Id.tax_point
6615: ( p_tax_point => p_header_val_rec.tax_point
6616: );
6617:
6618: IF p_x_header_rec.tax_point_code = FND_API.G_MISS_CHAR THEN

Line 6643: p_x_header_rec.payment_type_code := OE_Value_To_Id.payment_type

6639: END IF;
6640:
6641: ELSE
6642:
6643: p_x_header_rec.payment_type_code := OE_Value_To_Id.payment_type
6644: ( p_payment_type => p_header_val_rec.payment_type
6645: );
6646:
6647: IF p_x_header_rec.payment_type_code = FND_API.G_MISS_CHAR THEN

Line 6672: p_x_header_rec.credit_card_code := OE_Value_To_Id.credit_card

6668: END IF;
6669:
6670: ELSE
6671:
6672: p_x_header_rec.credit_card_code := OE_Value_To_Id.credit_card
6673: ( p_credit_card => p_header_val_rec.credit_card
6674: );
6675:
6676: IF p_x_header_rec.credit_card_code = FND_API.G_MISS_CHAR THEN

Line 6708: p_x_header_rec.invoice_to_customer_id:=OE_Value_To_Id.site_customer

6704: END IF;
6705:
6706: ELSE
6707: IF p_x_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM then -- 4231603
6708: p_x_header_rec.invoice_to_customer_id:=OE_Value_To_Id.site_customer
6709: ( p_site_customer => p_header_val_rec.invoice_to_customer_name_oi
6710: ,p_site_customer_number=> p_header_val_rec.invoice_to_customer_number_oi
6711: ,p_type =>'INVOICE_TO'
6712: );

Line 6744: p_x_header_rec.ship_to_customer_id:=OE_Value_To_Id.site_customer

6740: END IF;
6741:
6742: ELSE
6743: IF p_x_header_rec.ship_to_org_id = FND_API.G_MISS_NUM then -- 4231603
6744: p_x_header_rec.ship_to_customer_id:=OE_Value_To_Id.site_customer
6745: ( p_site_customer => p_header_val_rec.ship_to_customer_name_oi
6746: ,p_site_customer_number=> p_header_val_rec.ship_to_customer_number_oi
6747: ,p_type =>'SHIP_TO'
6748: );

Line 6781: p_x_header_rec.deliver_to_customer_id:=OE_Value_To_Id.site_customer

6777: END IF;
6778:
6779: ELSE
6780: IF p_x_header_rec.deliver_to_org_id = FND_API.G_MISS_NUM then -- 4231603
6781: p_x_header_rec.deliver_to_customer_id:=OE_Value_To_Id.site_customer
6782: ( p_site_customer => p_header_val_rec.ship_to_customer_name_oi
6783: ,p_site_customer_number=> p_header_val_rec.ship_to_customer_number_oi
6784: ,p_type =>'DELIVER_TO'
6785: );

Line 6818: p_x_header_rec.sold_to_org_id := OE_Value_To_Id.sold_to_org

6814: END IF;
6815:
6816: ELSE
6817:
6818: p_x_header_rec.sold_to_org_id := OE_Value_To_Id.sold_to_org
6819: ( p_sold_to_org => p_header_val_rec.sold_to_org
6820: , p_customer_number => p_header_val_rec.customer_number
6821: );
6822:

Line 6833: -- For e.g. oe_value_to_id.ship_to_org_id requires sold_to_org_id

6829: END IF;
6830:
6831: -- Retrieve the sold_to_org_id if not passed on the header record. This
6832: -- will be needed by the value_to_id functions for related fields.
6833: -- For e.g. oe_value_to_id.ship_to_org_id requires sold_to_org_id
6834:
6835: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
6836: AND p_x_header_rec.sold_to_org_id = FND_API.G_MISS_NUM
6837: THEN

Line 6867: p_x_header_rec.sold_to_contact_id := OE_Value_To_Id.sold_to_contact

6863: END IF;
6864:
6865: ELSE
6866:
6867: p_x_header_rec.sold_to_contact_id := OE_Value_To_Id.sold_to_contact
6868: ( p_sold_to_contact => p_header_val_rec.sold_to_contact
6869: , p_sold_to_org_id => l_sold_to_org_id
6870: );
6871:

Line 6902: p_x_header_rec.deliver_to_org_id := OE_Value_To_Id.deliver_to_org

6898: END IF;
6899:
6900: ELSE
6901: /*1621182*/
6902: p_x_header_rec.deliver_to_org_id := OE_Value_To_Id.deliver_to_org
6903: ( p_deliver_to_address1 => p_header_val_rec.deliver_to_address1
6904: , p_deliver_to_address2 => p_header_val_rec.deliver_to_address2
6905: , p_deliver_to_address3 => p_header_val_rec.deliver_to_address3
6906: , p_deliver_to_address4 => p_header_val_rec.deliver_to_address4

Line 6948: p_x_header_rec.invoice_to_org_id := OE_Value_To_Id.invoice_to_org

6944: END IF;
6945:
6946: ELSE
6947: /*1621182*/
6948: p_x_header_rec.invoice_to_org_id := OE_Value_To_Id.invoice_to_org
6949: ( p_invoice_to_address1 => p_header_val_rec.invoice_to_address1
6950: , p_invoice_to_address2 => p_header_val_rec.invoice_to_address2
6951: , p_invoice_to_address3 => p_header_val_rec.invoice_to_address3
6952: , p_invoice_to_address4 => p_header_val_rec.invoice_to_address4

Line 6994: p_x_header_rec.ship_to_org_id := OE_Value_To_Id.ship_to_org

6990: END IF;
6991:
6992: ELSE
6993: /*1621182*/
6994: p_x_header_rec.ship_to_org_id := OE_Value_To_Id.ship_to_org
6995: ( p_ship_to_address1 => p_header_val_rec.ship_to_address1
6996: , p_ship_to_address2 => p_header_val_rec.ship_to_address2
6997: , p_ship_to_address3 => p_header_val_rec.ship_to_address3
6998: , p_ship_to_address4 => p_header_val_rec.ship_to_address4

Line 7040: p_x_header_rec.sold_to_site_use_id := OE_Value_To_Id.Customer_Location

7036:
7037: END IF;
7038:
7039: ELSE
7040: p_x_header_rec.sold_to_site_use_id := OE_Value_To_Id.Customer_Location
7041: ( p_sold_to_location_address1 => p_header_val_rec.sold_to_location_address1
7042: , p_sold_to_location_address2 => p_header_val_rec.sold_to_location_address2
7043: , p_sold_to_location_address3 => p_header_val_rec.sold_to_location_address3
7044: , p_sold_to_location_address4 => p_header_val_rec.sold_to_location_address4

Line 7067: -- For e.g. oe_value_to_id.ship_to_contact_id requires ship_to_org_id

7063: -- QUOTING changes
7064:
7065: -- Retrieve the org_ids if not passed on the header record. These
7066: -- IDs will be needed by the value_to_id functions for CONTACT fields.
7067: -- For e.g. oe_value_to_id.ship_to_contact_id requires ship_to_org_id
7068:
7069: IF p_x_header_rec.operation = OE_GLOBALS.G_OPR_UPDATE
7070: AND ( p_x_header_rec.ship_to_org_id = FND_API.G_MISS_NUM
7071: OR p_x_header_rec.invoice_to_org_id = FND_API.G_MISS_NUM

Line 7117: p_x_header_rec.deliver_to_contact_id := OE_Value_To_Id.deliver_to_contact

7113: END IF;
7114:
7115: ELSE
7116:
7117: p_x_header_rec.deliver_to_contact_id := OE_Value_To_Id.deliver_to_contact
7118: ( p_deliver_to_contact => p_header_val_rec.deliver_to_contact
7119: , p_deliver_to_org_id => l_deliver_to_org_id
7120: );
7121:

Line 7147: p_x_header_rec.invoice_to_contact_id := OE_Value_To_Id.invoice_to_contact

7143: END IF;
7144:
7145: ELSE
7146:
7147: p_x_header_rec.invoice_to_contact_id := OE_Value_To_Id.invoice_to_contact
7148: ( p_invoice_to_contact => p_header_val_rec.invoice_to_contact
7149: , p_invoice_to_org_id => l_invoice_to_org_id
7150: );
7151:

Line 7177: p_x_header_rec.ship_to_contact_id := OE_Value_To_Id.ship_to_contact

7173: END IF;
7174:
7175: ELSE
7176:
7177: p_x_header_rec.ship_to_contact_id := OE_Value_To_Id.ship_to_contact
7178: ( p_ship_to_contact => p_header_val_rec.ship_to_contact
7179: , p_ship_to_org_id => l_ship_to_org_id
7180: );
7181:

Line 7209: p_x_header_rec.end_customer_id:=OE_Value_To_Id.end_customer

7205: END IF;
7206:
7207: ELSE
7208: IF p_x_header_rec.end_customer_site_use_id = FND_API.G_MISS_NUM THEN -- 4231603
7209: p_x_header_rec.end_customer_id:=OE_Value_To_Id.end_customer
7210: ( p_end_customer => p_header_val_rec.end_customer_name
7211: ,p_end_customer_number=> p_header_val_rec.end_customer_number
7212: );
7213:

Line 7240: p_x_header_rec.end_customer_contact_id := OE_Value_To_Id.end_customer_contact

7236: END IF;
7237:
7238: ELSE
7239: oe_debug_pub.add('before calling aend customer contact value to id');
7240: p_x_header_rec.end_customer_contact_id := OE_Value_To_Id.end_customer_contact
7241: ( p_end_customer_contact => p_header_val_rec.end_customer_contact
7242: ,p_end_customer_id =>p_x_header_rec.end_customer_id
7243: );
7244: oe_debug_pub.add('End customer contact id is '||p_x_header_rec.end_customer_contact_id);

Line 7280: p_x_header_rec.end_customer_site_use_id := OE_Value_To_Id.end_customer_site

7276: END IF;
7277:
7278: ELSE
7279: oe_debug_pub.add('Before calling End custoemr site use value to id');
7280: p_x_header_rec.end_customer_site_use_id := OE_Value_To_Id.end_customer_site
7281: ( p_end_customer_site_address1 => p_header_val_rec.end_customer_site_address1
7282: , p_end_customer_site_address2 => p_header_val_rec.end_customer_site_address2
7283: , p_end_customer_site_address3 => p_header_val_rec.end_customer_site_address3
7284: , p_end_customer_site_address4 => p_header_val_rec.end_customer_site_address4

Line 7323: p_x_header_rec.ib_owner:=OE_Value_To_Id.ib_owner

7319: END IF;
7320:
7321: ELSE
7322:
7323: p_x_header_rec.ib_owner:=OE_Value_To_Id.ib_owner
7324: ( p_ib_owner => p_header_val_rec.ib_owner_dsp
7325: );
7326:
7327: oe_Debug_pub.add('ib owner id is '||p_x_header_rec.ib_owner);

Line 7352: p_x_header_rec.ib_installed_at_location:=OE_Value_To_Id.ib_installed_at_location

7348: END IF;
7349:
7350: ELSE
7351:
7352: p_x_header_rec.ib_installed_at_location:=OE_Value_To_Id.ib_installed_at_location
7353: ( p_ib_installed_at_location => p_header_val_rec.ib_installed_at_location_dsp
7354: );
7355: oe_Debug_pub.add('installed at location'||p_x_header_rec.ib_installed_at_location);
7356:

Line 7380: p_x_header_rec.ib_current_location:=OE_Value_To_Id.ib_current_location

7376: END IF;
7377:
7378: ELSE
7379:
7380: p_x_header_rec.ib_current_location:=OE_Value_To_Id.ib_current_location
7381: ( p_ib_current_location => p_header_val_rec.ib_current_location_dsp
7382: );
7383:
7384: IF p_x_header_rec.ib_current_location = FND_API.G_MISS_CHAR THEN