DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE dependencies on OE_ID_TO_VALUE

Line 2492: OE_ID_TO_VALUE.Ordered_Item

2488: := l_x_line_rec.original_ordered_item_id;
2489:
2490: IF x_line_val_rec.x_original_inventory_item_id IS NOT NULL
2491: OR x_line_val_rec.x_original_ordered_item_id IS NOT NULL THEN
2492: OE_ID_TO_VALUE.Ordered_Item
2493: (p_Item_Identifier_type => x_line_val_rec.x_original_item_iden_type
2494: ,p_inventory_item_id => x_line_val_rec.x_original_inventory_item_id
2495: ,p_organization_id => l_organization_id
2496: ,p_ordered_item_id => x_line_val_rec.x_original_ordered_item_id

Line 2504: OE_ID_TO_VALUE.item_identifier

2500: ,x_inventory_item => x_line_val_rec.x_original_inventory_item);
2501:
2502: END IF;
2503: IF x_line_val_rec.x_original_item_iden_type IS NOT NULL THEN
2504: OE_ID_TO_VALUE.item_identifier
2505: (p_Item_Identifier_type => x_line_val_rec.x_original_item_iden_type
2506: ,x_Item_Identifier => x_line_val_rec.x_original_item_type);
2507: END IF;
2508:

Line 2519: OE_ID_TO_VALUE.Ship_From_Org(

2515: /* The following IF statement is commented to fix bug#1382357 */
2516: -- IF NVL(l_x_old_line_tbl(1).ship_from_org_id,-1) <>
2517: -- NVL(l_x_line_rec.ship_from_org_id,-1) THEN
2518:
2519: OE_ID_TO_VALUE.Ship_From_Org(
2520: p_ship_from_org_id => l_x_line_rec.ship_from_org_id
2521: ,x_ship_from_address1 => x_line_val_rec.x_ship_from_address1
2522: ,x_ship_from_address2 => x_line_val_rec.x_ship_from_address2
2523: ,x_ship_from_address3 => x_line_val_rec.x_ship_from_address3

Line 2539: := OE_ID_TO_VALUE.Ship_Method(p_ship_method_code => x_line_val_rec.x_shipping_method_code);

2535: x_line_val_rec.x_shipping_method_code
2536: := l_x_line_rec.shipping_method_code;
2537: IF x_line_val_rec.x_shipping_method_code IS NOT NULL THEN
2538: x_line_val_rec.x_shipping_method
2539: := OE_ID_TO_VALUE.Ship_Method(p_ship_method_code => x_line_val_rec.x_shipping_method_code);
2540: END IF;
2541: x_line_val_rec.x_freight_carrier_code
2542: := l_x_line_rec.freight_carrier_code;
2543: IF x_line_val_rec.x_freight_carrier_code IS NOT NULL THEN

Line 2545: := OE_ID_TO_VALUE.Freight_Carrier

2541: x_line_val_rec.x_freight_carrier_code
2542: := l_x_line_rec.freight_carrier_code;
2543: IF x_line_val_rec.x_freight_carrier_code IS NOT NULL THEN
2544: x_line_val_rec.x_freight_carrier
2545: := OE_ID_TO_VALUE.Freight_Carrier
2546: (p_freight_carrier_code =>x_line_val_rec.x_freight_carrier_code,
2547: p_ship_from_org_id =>x_line_val_rec.x_ship_from_org_id);
2548: END IF;
2549: -- End 2806483

Line 2604: := OE_Id_To_Value.Calculate_Price_Flag(x_line_val_rec.x_calculate_price_flag);

2600: x_line_val_rec.x_pricing_quantity := l_x_line_rec.pricing_quantity;
2601: x_line_val_rec.x_pricing_quantity_uom := l_x_line_rec.pricing_quantity_uom;
2602: x_line_val_rec.x_calculate_price_flag := l_x_line_rec.calculate_price_flag;
2603: x_line_val_rec.x_calculate_price_descr
2604: := OE_Id_To_Value.Calculate_Price_Flag(x_line_val_rec.x_calculate_price_flag);
2605: x_line_val_rec.x_price_list_id := l_x_line_rec.price_list_id;
2606: x_line_val_rec.x_price_list := OE_Id_To_Value.Price_List(x_line_val_rec.x_price_list_id);
2607: x_line_val_rec.x_payment_term_id := l_x_line_rec.payment_term_id;
2608: x_line_val_rec.x_payment_term := OE_Id_To_Value.Payment_Term(x_line_val_rec.x_payment_term_id);

Line 2606: x_line_val_rec.x_price_list := OE_Id_To_Value.Price_List(x_line_val_rec.x_price_list_id);

2602: x_line_val_rec.x_calculate_price_flag := l_x_line_rec.calculate_price_flag;
2603: x_line_val_rec.x_calculate_price_descr
2604: := OE_Id_To_Value.Calculate_Price_Flag(x_line_val_rec.x_calculate_price_flag);
2605: x_line_val_rec.x_price_list_id := l_x_line_rec.price_list_id;
2606: x_line_val_rec.x_price_list := OE_Id_To_Value.Price_List(x_line_val_rec.x_price_list_id);
2607: x_line_val_rec.x_payment_term_id := l_x_line_rec.payment_term_id;
2608: x_line_val_rec.x_payment_term := OE_Id_To_Value.Payment_Term(x_line_val_rec.x_payment_term_id);
2609:
2610: x_line_val_rec.x_shipment_priority_code := l_x_line_rec.shipment_priority_code;

Line 2608: x_line_val_rec.x_payment_term := OE_Id_To_Value.Payment_Term(x_line_val_rec.x_payment_term_id);

2604: := OE_Id_To_Value.Calculate_Price_Flag(x_line_val_rec.x_calculate_price_flag);
2605: x_line_val_rec.x_price_list_id := l_x_line_rec.price_list_id;
2606: x_line_val_rec.x_price_list := OE_Id_To_Value.Price_List(x_line_val_rec.x_price_list_id);
2607: x_line_val_rec.x_payment_term_id := l_x_line_rec.payment_term_id;
2608: x_line_val_rec.x_payment_term := OE_Id_To_Value.Payment_Term(x_line_val_rec.x_payment_term_id);
2609:
2610: x_line_val_rec.x_shipment_priority_code := l_x_line_rec.shipment_priority_code;
2611: x_line_val_rec.x_shipment_priority
2612: := OE_Id_To_Value.Shipment_Priority(x_line_val_rec.x_shipment_priority_code);

Line 2612: := OE_Id_To_Value.Shipment_Priority(x_line_val_rec.x_shipment_priority_code);

2608: x_line_val_rec.x_payment_term := OE_Id_To_Value.Payment_Term(x_line_val_rec.x_payment_term_id);
2609:
2610: x_line_val_rec.x_shipment_priority_code := l_x_line_rec.shipment_priority_code;
2611: x_line_val_rec.x_shipment_priority
2612: := OE_Id_To_Value.Shipment_Priority(x_line_val_rec.x_shipment_priority_code);
2613: x_line_val_rec.x_freight_terms_code := l_x_line_rec.freight_terms_code;
2614: x_line_val_rec.x_freight_terms := OE_Id_To_Value.Freight_Terms(x_line_val_rec.x_freight_terms_code);
2615: x_line_val_rec.x_inventory_item_id := l_x_line_rec.inventory_item_id;
2616: x_line_val_rec.x_ordered_item_id := l_x_line_rec.ordered_item_id;

Line 2614: x_line_val_rec.x_freight_terms := OE_Id_To_Value.Freight_Terms(x_line_val_rec.x_freight_terms_code);

2610: x_line_val_rec.x_shipment_priority_code := l_x_line_rec.shipment_priority_code;
2611: x_line_val_rec.x_shipment_priority
2612: := OE_Id_To_Value.Shipment_Priority(x_line_val_rec.x_shipment_priority_code);
2613: x_line_val_rec.x_freight_terms_code := l_x_line_rec.freight_terms_code;
2614: x_line_val_rec.x_freight_terms := OE_Id_To_Value.Freight_Terms(x_line_val_rec.x_freight_terms_code);
2615: x_line_val_rec.x_inventory_item_id := l_x_line_rec.inventory_item_id;
2616: x_line_val_rec.x_ordered_item_id := l_x_line_rec.ordered_item_id;
2617:
2618: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN

Line 4056: x_line_val_rec.tax_group := OE_Id_To_Value.tax_group(

4052: END IF;
4053:
4054: /*IF (p_line_rec.tax_code IS NOT NULL) THEN
4055: BEGIN
4056: x_line_val_rec.tax_group := OE_Id_To_Value.tax_group(
4057: p_tax_code => p_line_rec.tax_code);
4058: EXCEPTION
4059: WHEN OTHERS THEN
4060: NULL;

Line 4066: /*OE_Id_To_Value.Ship_To_Customer_Name

4062: END IF; */
4063:
4064: IF (p_line_rec.ship_to_org_id IS NOT NULL) THEN
4065: BEGIN
4066: /*OE_Id_To_Value.Ship_To_Customer_Name
4067: (
4068: p_ship_to_org_id => p_line_rec.ship_to_org_id,
4069: x_ship_to_customer_name=>x_line_val_rec.ship_to_customer_name
4070: );*/

Line 4087: OE_ID_TO_VALUE.END_CUSTOMER_SITE_USE

4083: END;
4084:
4085: END IF;
4086: IF (p_line_rec.end_customer_site_use_id IS NOT NULL) THEN
4087: OE_ID_TO_VALUE.END_CUSTOMER_SITE_USE
4088: ( p_end_customer_site_use_id => p_line_rec.end_customer_site_use_id,
4089: x_end_customer_address1 => x_line_val_rec.END_CUSTOMER_SITE_ADDRESS1,
4090: x_end_customer_address2 => x_line_val_rec.END_CUSTOMER_SITE_ADDRESS2,
4091: x_end_customer_address3 => x_line_val_rec.END_CUSTOMER_SITE_ADDRESS3,

Line 4103: OE_ID_TO_VALUE.END_CUSTOMER

4099:
4100: END IF;
4101:
4102: IF (p_line_rec.end_customer_id IS NOT NULL) THEN
4103: OE_ID_TO_VALUE.END_CUSTOMER
4104: ( p_end_customer_id => p_line_rec.end_customer_id,
4105: x_end_customer_name => x_line_val_rec.END_CUSTOMER_NAME,
4106: x_end_customer_number => x_line_val_rec.END_CUSTOMER_NUMBER
4107: );

Line 4111: x_line_val_rec.END_CUSTOMER_CONTACT := OE_ID_TO_VALUE.END_CUSTOMER_CONTACT

4107: );
4108: END IF;
4109:
4110: IF (p_line_rec.end_customer_contact_id IS NOT NULL) THEN
4111: x_line_val_rec.END_CUSTOMER_CONTACT := OE_ID_TO_VALUE.END_CUSTOMER_CONTACT
4112: ( p_end_customer_contact_id => p_line_rec.end_customer_contact_id);
4113: END IF;
4114:
4115:

Line 4118: /*OE_Id_To_Value.Invoice_To_Customer_Name

4114:
4115:
4116: IF (p_line_rec.invoice_to_org_id IS NOT NULL) THEN
4117: BEGIN
4118: /*OE_Id_To_Value.Invoice_To_Customer_Name
4119: (
4120: p_invoice_to_org_id => p_line_rec.invoice_to_org_id,
4121: x_invoice_to_customer_name=>x_line_val_rec.invoice_to_customer_name
4122: ); */

Line 4773: OE_ID_TO_VALUE.Ordered_Item

4769: END IF;
4770:
4771: IF p_line_rec.Original_inventory_item_id IS NOT NULL
4772: OR p_line_rec.original_ordered_item_id IS NOT NULL THEN
4773: OE_ID_TO_VALUE.Ordered_Item
4774: (p_Item_Identifier_type => p_line_rec.original_item_identifier_Type
4775: ,p_inventory_item_id => p_line_rec.original_Inventory_Item_Id
4776: ,p_organization_id => l_organization_id
4777: ,p_ordered_item_id => p_line_rec.original_ordered_item_id

Line 4785: OE_ID_TO_VALUE.item_identifier

4781: ,x_inventory_item => x_line_val_rec.original_inventory_item);
4782: END IF;
4783:
4784: IF p_line_rec.Original_item_identifier_Type IS NOT NULL THEN
4785: OE_ID_TO_VALUE.item_identifier
4786: (p_Item_Identifier_type => p_line_rec.Original_item_identifier_Type
4787: ,x_Item_Identifier => x_line_val_rec.Original_item_type);
4788: END IF;
4789:

Line 4791: OE_ID_TO_VALUE.item_relationship_type

4787: ,x_Item_Identifier => x_line_val_rec.Original_item_type);
4788: END IF;
4789:
4790: IF p_line_rec.item_relationship_type IS NOT NULL THEN
4791: OE_ID_TO_VALUE.item_relationship_type
4792: (p_Item_relationship_type => p_line_rec.item_relationship_type
4793: ,x_Item_relationship_type_dsp => x_line_val_rec.item_relationship_type_dsp);
4794: END IF;
4795: --Spagadal

Line 4979: x_line_val_rec.charge_periodicity_dsp:=OE_ID_TO_VALUE.Charge_periodicity(p_line_rec.charge_periodicity_code);

4975: BEGIN
4976:
4977: IF p_line_rec.charge_periodicity_code IS NOT NULL THEN
4978:
4979: x_line_val_rec.charge_periodicity_dsp:=OE_ID_TO_VALUE.Charge_periodicity(p_line_rec.charge_periodicity_code);
4980:
4981: END IF;
4982:
4983: EXCEPTION

Line 4996: OE_ID_TO_VALUE.Get_Contingency_Attributes(

4992:
4993: END IF;
4994: --Customer Acceptance
4995: IF p_line_rec.contingency_id is not null then
4996: OE_ID_TO_VALUE.Get_Contingency_Attributes(
4997: p_contingency_id => p_line_rec.contingency_id
4998: , x_contingency_name => x_line_val_rec.contingency_name
4999: , x_contingency_description => x_line_val_rec.contingency_description
5000: , x_expiration_event_attribute => x_line_val_rec.expiration_event_attribute

Line 5002: x_line_val_rec.revrec_event := OE_ID_TO_VALUE.Revrec_Event(p_line_rec.revrec_event_code);

4998: , x_contingency_name => x_line_val_rec.contingency_name
4999: , x_contingency_description => x_line_val_rec.contingency_description
5000: , x_expiration_event_attribute => x_line_val_rec.expiration_event_attribute
5001: );
5002: x_line_val_rec.revrec_event := OE_ID_TO_VALUE.Revrec_Event(p_line_rec.revrec_event_code);
5003:
5004: END IF;
5005:
5006: IF p_line_rec.accepted_by is not null THEN

Line 5007: x_line_val_rec.accepted_by_dsp := OE_ID_TO_VALUE.Accepted_By(p_line_rec.accepted_by);

5003:
5004: END IF;
5005:
5006: IF p_line_rec.accepted_by is not null THEN
5007: x_line_val_rec.accepted_by_dsp := OE_ID_TO_VALUE.Accepted_By(p_line_rec.accepted_by);
5008: END IF;
5009:
5010:
5011: END POPULATE_CONTROL_FIELDS;