DBA Data[Home] [Help]

APPS.OE_OE_FORM_LINE dependencies on OE_ID_TO_VALUE

Line 2556: OE_ID_TO_VALUE.Ordered_Item

2552: := l_x_line_rec.original_ordered_item_id;
2553:
2554: IF x_line_val_rec.x_original_inventory_item_id IS NOT NULL
2555: OR x_line_val_rec.x_original_ordered_item_id IS NOT NULL THEN
2556: OE_ID_TO_VALUE.Ordered_Item
2557: (p_Item_Identifier_type => x_line_val_rec.x_original_item_iden_type
2558: ,p_inventory_item_id => x_line_val_rec.x_original_inventory_item_id
2559: ,p_organization_id => l_organization_id
2560: ,p_ordered_item_id => x_line_val_rec.x_original_ordered_item_id

Line 2568: OE_ID_TO_VALUE.item_identifier

2564: ,x_inventory_item => x_line_val_rec.x_original_inventory_item);
2565:
2566: END IF;
2567: IF x_line_val_rec.x_original_item_iden_type IS NOT NULL THEN
2568: OE_ID_TO_VALUE.item_identifier
2569: (p_Item_Identifier_type => x_line_val_rec.x_original_item_iden_type
2570: ,x_Item_Identifier => x_line_val_rec.x_original_item_type);
2571: END IF;
2572:

Line 2583: OE_ID_TO_VALUE.Ship_From_Org(

2579: /* The following IF statement is commented to fix bug#1382357 */
2580: -- IF NVL(l_x_old_line_tbl(1).ship_from_org_id,-1) <>
2581: -- NVL(l_x_line_rec.ship_from_org_id,-1) THEN
2582:
2583: OE_ID_TO_VALUE.Ship_From_Org(
2584: p_ship_from_org_id => l_x_line_rec.ship_from_org_id
2585: ,x_ship_from_address1 => x_line_val_rec.x_ship_from_address1
2586: ,x_ship_from_address2 => x_line_val_rec.x_ship_from_address2
2587: ,x_ship_from_address3 => x_line_val_rec.x_ship_from_address3

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

2599: x_line_val_rec.x_shipping_method_code
2600: := l_x_line_rec.shipping_method_code;
2601: IF x_line_val_rec.x_shipping_method_code IS NOT NULL THEN
2602: x_line_val_rec.x_shipping_method
2603: := OE_ID_TO_VALUE.Ship_Method(p_ship_method_code => x_line_val_rec.x_shipping_method_code);
2604: END IF;
2605: x_line_val_rec.x_freight_carrier_code
2606: := l_x_line_rec.freight_carrier_code;
2607: IF x_line_val_rec.x_freight_carrier_code IS NOT NULL THEN

Line 2609: := OE_ID_TO_VALUE.Freight_Carrier

2605: x_line_val_rec.x_freight_carrier_code
2606: := l_x_line_rec.freight_carrier_code;
2607: IF x_line_val_rec.x_freight_carrier_code IS NOT NULL THEN
2608: x_line_val_rec.x_freight_carrier
2609: := OE_ID_TO_VALUE.Freight_Carrier
2610: (p_freight_carrier_code =>x_line_val_rec.x_freight_carrier_code,
2611: p_ship_from_org_id =>x_line_val_rec.x_ship_from_org_id);
2612: END IF;
2613: -- End 2806483

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

2664: x_line_val_rec.x_pricing_quantity := l_x_line_rec.pricing_quantity;
2665: x_line_val_rec.x_pricing_quantity_uom := l_x_line_rec.pricing_quantity_uom;
2666: x_line_val_rec.x_calculate_price_flag := l_x_line_rec.calculate_price_flag;
2667: x_line_val_rec.x_calculate_price_descr
2668: := OE_Id_To_Value.Calculate_Price_Flag(x_line_val_rec.x_calculate_price_flag);
2669: x_line_val_rec.x_price_list_id := l_x_line_rec.price_list_id;
2670: x_line_val_rec.x_price_list := OE_Id_To_Value.Price_List(x_line_val_rec.x_price_list_id);
2671: x_line_val_rec.x_payment_term_id := l_x_line_rec.payment_term_id;
2672: x_line_val_rec.x_payment_term := OE_Id_To_Value.Payment_Term(x_line_val_rec.x_payment_term_id);

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

2666: x_line_val_rec.x_calculate_price_flag := l_x_line_rec.calculate_price_flag;
2667: x_line_val_rec.x_calculate_price_descr
2668: := OE_Id_To_Value.Calculate_Price_Flag(x_line_val_rec.x_calculate_price_flag);
2669: x_line_val_rec.x_price_list_id := l_x_line_rec.price_list_id;
2670: x_line_val_rec.x_price_list := OE_Id_To_Value.Price_List(x_line_val_rec.x_price_list_id);
2671: x_line_val_rec.x_payment_term_id := l_x_line_rec.payment_term_id;
2672: x_line_val_rec.x_payment_term := OE_Id_To_Value.Payment_Term(x_line_val_rec.x_payment_term_id);
2673:
2674: x_line_val_rec.x_shipment_priority_code := l_x_line_rec.shipment_priority_code;

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

2668: := OE_Id_To_Value.Calculate_Price_Flag(x_line_val_rec.x_calculate_price_flag);
2669: x_line_val_rec.x_price_list_id := l_x_line_rec.price_list_id;
2670: x_line_val_rec.x_price_list := OE_Id_To_Value.Price_List(x_line_val_rec.x_price_list_id);
2671: x_line_val_rec.x_payment_term_id := l_x_line_rec.payment_term_id;
2672: x_line_val_rec.x_payment_term := OE_Id_To_Value.Payment_Term(x_line_val_rec.x_payment_term_id);
2673:
2674: x_line_val_rec.x_shipment_priority_code := l_x_line_rec.shipment_priority_code;
2675: x_line_val_rec.x_shipment_priority
2676: := OE_Id_To_Value.Shipment_Priority(x_line_val_rec.x_shipment_priority_code);

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

2672: x_line_val_rec.x_payment_term := OE_Id_To_Value.Payment_Term(x_line_val_rec.x_payment_term_id);
2673:
2674: x_line_val_rec.x_shipment_priority_code := l_x_line_rec.shipment_priority_code;
2675: x_line_val_rec.x_shipment_priority
2676: := OE_Id_To_Value.Shipment_Priority(x_line_val_rec.x_shipment_priority_code);
2677: x_line_val_rec.x_freight_terms_code := l_x_line_rec.freight_terms_code;
2678: x_line_val_rec.x_freight_terms := OE_Id_To_Value.Freight_Terms(x_line_val_rec.x_freight_terms_code);
2679: x_line_val_rec.x_inventory_item_id := l_x_line_rec.inventory_item_id;
2680: x_line_val_rec.x_ordered_item_id := l_x_line_rec.ordered_item_id;

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

2674: x_line_val_rec.x_shipment_priority_code := l_x_line_rec.shipment_priority_code;
2675: x_line_val_rec.x_shipment_priority
2676: := OE_Id_To_Value.Shipment_Priority(x_line_val_rec.x_shipment_priority_code);
2677: x_line_val_rec.x_freight_terms_code := l_x_line_rec.freight_terms_code;
2678: x_line_val_rec.x_freight_terms := OE_Id_To_Value.Freight_Terms(x_line_val_rec.x_freight_terms_code);
2679: x_line_val_rec.x_inventory_item_id := l_x_line_rec.inventory_item_id;
2680: x_line_val_rec.x_ordered_item_id := l_x_line_rec.ordered_item_id;
2681:
2682: IF OE_GLOBALS.G_DEFER_PRICING='N' THEN

Line 3493: x_line_val_rec.service_bill_profile := OE_Id_To_Value.Billing_Profile(p_line_rec.service_bill_profile_id);

3489: IF p_line_rec.service_bill_profile_id IS NOT NULL THEN
3490: IF l_debug_level > 0 THEN
3491: oe_debug_pub.add('SK OEXFLINB.pls 110 '||p_line_rec.service_bill_profile_id);
3492: END IF;
3493: x_line_val_rec.service_bill_profile := OE_Id_To_Value.Billing_Profile(p_line_rec.service_bill_profile_id);
3494: END IF;
3495: IF p_line_rec.service_cov_template_id IS NOT NULL THEN
3496: IF l_debug_level > 0 THEN
3497: oe_debug_pub.add('SK OEXFLINB.pls 111 '||p_line_rec.service_cov_template_id);

Line 3499: x_line_val_rec.service_cov_template := OE_Id_To_Value.Coverage_Template(p_line_rec.service_cov_template_id);

3495: IF p_line_rec.service_cov_template_id IS NOT NULL THEN
3496: IF l_debug_level > 0 THEN
3497: oe_debug_pub.add('SK OEXFLINB.pls 111 '||p_line_rec.service_cov_template_id);
3498: END IF;
3499: x_line_val_rec.service_cov_template := OE_Id_To_Value.Coverage_Template(p_line_rec.service_cov_template_id);
3500: END IF;
3501: IF p_line_rec.service_subs_template_id IS NOT NULL THEN
3502: IF l_debug_level > 0 THEN
3503: oe_debug_pub.add('SK OEXFLINB.pls 112 '||p_line_rec.service_subs_template_id);

Line 3505: x_line_val_rec.service_subs_template := OE_Id_To_Value.Subscription_Template(p_line_rec.service_subs_template_id);

3501: IF p_line_rec.service_subs_template_id IS NOT NULL THEN
3502: IF l_debug_level > 0 THEN
3503: oe_debug_pub.add('SK OEXFLINB.pls 112 '||p_line_rec.service_subs_template_id);
3504: END IF;
3505: x_line_val_rec.service_subs_template := OE_Id_To_Value.Subscription_Template(p_line_rec.service_subs_template_id);
3506: END IF;
3507: IF p_line_rec.service_bill_option_code IS NOT NULL THEN
3508: IF l_debug_level > 0 THEN
3509: oe_debug_pub.add('SK OEXFLINB.pls 114 '||p_line_rec.service_bill_option_code);

Line 3511: x_line_val_rec.service_bill_option := OE_Id_To_Value.Billing_Option(p_line_rec.service_bill_option_code);

3507: IF p_line_rec.service_bill_option_code IS NOT NULL THEN
3508: IF l_debug_level > 0 THEN
3509: oe_debug_pub.add('SK OEXFLINB.pls 114 '||p_line_rec.service_bill_option_code);
3510: END IF;
3511: x_line_val_rec.service_bill_option := OE_Id_To_Value.Billing_Option(p_line_rec.service_bill_option_code);
3512: END IF;
3513: -- sol_ord_er #16014165 end
3514: -- Populate Project Number and Task Number
3515: IF p_line_rec.project_id is not Null then

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

4321: END IF;
4322:
4323: /*IF (p_line_rec.tax_code IS NOT NULL) THEN
4324: BEGIN
4325: x_line_val_rec.tax_group := OE_Id_To_Value.tax_group(
4326: p_tax_code => p_line_rec.tax_code);
4327: EXCEPTION
4328: WHEN OTHERS THEN
4329: NULL;

Line 4335: /*OE_Id_To_Value.Ship_To_Customer_Name

4331: END IF; */
4332:
4333: IF (p_line_rec.ship_to_org_id IS NOT NULL) THEN
4334: BEGIN
4335: /*OE_Id_To_Value.Ship_To_Customer_Name
4336: (
4337: p_ship_to_org_id => p_line_rec.ship_to_org_id,
4338: x_ship_to_customer_name=>x_line_val_rec.ship_to_customer_name
4339: );*/

Line 4356: OE_ID_TO_VALUE.END_CUSTOMER_SITE_USE

4352: END;
4353:
4354: END IF;
4355: IF (p_line_rec.end_customer_site_use_id IS NOT NULL) THEN
4356: OE_ID_TO_VALUE.END_CUSTOMER_SITE_USE
4357: ( p_end_customer_site_use_id => p_line_rec.end_customer_site_use_id,
4358: x_end_customer_address1 => x_line_val_rec.END_CUSTOMER_SITE_ADDRESS1,
4359: x_end_customer_address2 => x_line_val_rec.END_CUSTOMER_SITE_ADDRESS2,
4360: x_end_customer_address3 => x_line_val_rec.END_CUSTOMER_SITE_ADDRESS3,

Line 4372: OE_ID_TO_VALUE.END_CUSTOMER

4368:
4369: END IF;
4370:
4371: IF (p_line_rec.end_customer_id IS NOT NULL) THEN
4372: OE_ID_TO_VALUE.END_CUSTOMER
4373: ( p_end_customer_id => p_line_rec.end_customer_id,
4374: x_end_customer_name => x_line_val_rec.END_CUSTOMER_NAME,
4375: x_end_customer_number => x_line_val_rec.END_CUSTOMER_NUMBER
4376: );

Line 4380: x_line_val_rec.END_CUSTOMER_CONTACT := OE_ID_TO_VALUE.END_CUSTOMER_CONTACT

4376: );
4377: END IF;
4378:
4379: IF (p_line_rec.end_customer_contact_id IS NOT NULL) THEN
4380: x_line_val_rec.END_CUSTOMER_CONTACT := OE_ID_TO_VALUE.END_CUSTOMER_CONTACT
4381: ( p_end_customer_contact_id => p_line_rec.end_customer_contact_id);
4382: END IF;
4383:
4384:

Line 4387: /*OE_Id_To_Value.Invoice_To_Customer_Name

4383:
4384:
4385: IF (p_line_rec.invoice_to_org_id IS NOT NULL) THEN
4386: BEGIN
4387: /*OE_Id_To_Value.Invoice_To_Customer_Name
4388: (
4389: p_invoice_to_org_id => p_line_rec.invoice_to_org_id,
4390: x_invoice_to_customer_name=>x_line_val_rec.invoice_to_customer_name
4391: ); */

Line 5051: OE_ID_TO_VALUE.Ordered_Item

5047: END IF;
5048:
5049: IF p_line_rec.Original_inventory_item_id IS NOT NULL
5050: OR p_line_rec.original_ordered_item_id IS NOT NULL THEN
5051: OE_ID_TO_VALUE.Ordered_Item
5052: (p_Item_Identifier_type => p_line_rec.original_item_identifier_Type
5053: ,p_inventory_item_id => p_line_rec.original_Inventory_Item_Id
5054: ,p_organization_id => l_organization_id
5055: ,p_ordered_item_id => p_line_rec.original_ordered_item_id

Line 5063: OE_ID_TO_VALUE.item_identifier

5059: ,x_inventory_item => x_line_val_rec.original_inventory_item);
5060: END IF;
5061:
5062: IF p_line_rec.Original_item_identifier_Type IS NOT NULL THEN
5063: OE_ID_TO_VALUE.item_identifier
5064: (p_Item_Identifier_type => p_line_rec.Original_item_identifier_Type
5065: ,x_Item_Identifier => x_line_val_rec.Original_item_type);
5066: END IF;
5067:

Line 5069: OE_ID_TO_VALUE.item_relationship_type

5065: ,x_Item_Identifier => x_line_val_rec.Original_item_type);
5066: END IF;
5067:
5068: IF p_line_rec.item_relationship_type IS NOT NULL THEN
5069: OE_ID_TO_VALUE.item_relationship_type
5070: (p_Item_relationship_type => p_line_rec.item_relationship_type
5071: ,x_Item_relationship_type_dsp => x_line_val_rec.item_relationship_type_dsp);
5072: END IF;
5073: --Spagadal

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

5253: BEGIN
5254:
5255: IF p_line_rec.charge_periodicity_code IS NOT NULL THEN
5256:
5257: x_line_val_rec.charge_periodicity_dsp:=OE_ID_TO_VALUE.Charge_periodicity(p_line_rec.charge_periodicity_code);
5258:
5259: END IF;
5260:
5261: EXCEPTION

Line 5274: OE_ID_TO_VALUE.Get_Contingency_Attributes(

5270:
5271: END IF;
5272: --Customer Acceptance
5273: IF p_line_rec.contingency_id is not null then
5274: OE_ID_TO_VALUE.Get_Contingency_Attributes(
5275: p_contingency_id => p_line_rec.contingency_id
5276: , x_contingency_name => x_line_val_rec.contingency_name
5277: , x_contingency_description => x_line_val_rec.contingency_description
5278: , x_expiration_event_attribute => x_line_val_rec.expiration_event_attribute

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

5276: , x_contingency_name => x_line_val_rec.contingency_name
5277: , x_contingency_description => x_line_val_rec.contingency_description
5278: , x_expiration_event_attribute => x_line_val_rec.expiration_event_attribute
5279: );
5280: x_line_val_rec.revrec_event := OE_ID_TO_VALUE.Revrec_Event(p_line_rec.revrec_event_code);
5281:
5282: END IF;
5283:
5284: IF p_line_rec.accepted_by is not null THEN

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

5281:
5282: END IF;
5283:
5284: IF p_line_rec.accepted_by is not null THEN
5285: x_line_val_rec.accepted_by_dsp := OE_ID_TO_VALUE.Accepted_By(p_line_rec.accepted_by);
5286: END IF;
5287:
5288:
5289: END POPULATE_CONTROL_FIELDS;