eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_LINE_UTIL dependencies on OE_VALUE_TO_ID

Line 13588: p_x_line_rec.accounting_rule_id := OE_Value_To_Id.accounting_rule

13584: END IF;
13585:
13586: ELSE
13587:
13588: p_x_line_rec.accounting_rule_id := OE_Value_To_Id.accounting_rule
13589: ( p_accounting_rule => p_line_val_rec.accounting_rule
13590: );
13591:
13592: IF p_x_line_rec.accounting_rule_id = FND_API.G_MISS_NUM THEN

Line 13616: p_x_line_rec.agreement_id := OE_Value_To_Id.agreement

13612: END IF;
13613:
13614: ELSE
13615:
13616: p_x_line_rec.agreement_id := OE_Value_To_Id.agreement
13617: ( p_agreement => p_line_val_rec.agreement
13618: );
13619:
13620: IF p_x_line_rec.agreement_id = FND_API.G_MISS_NUM THEN

Line 13644: p_x_line_rec.demand_bucket_type_code := OE_Value_To_Id.demand_bucket_type

13640: END IF;
13641:
13642: ELSE
13643:
13644: p_x_line_rec.demand_bucket_type_code := OE_Value_To_Id.demand_bucket_type
13645: ( p_demand_bucket_type => p_line_val_rec.demand_bucket_type
13646: );
13647:
13648: IF p_x_line_rec.demand_bucket_type_code = FND_API.G_MISS_CHAR THEN

Line 13672: p_x_line_rec.fob_point_code := OE_Value_To_Id.fob_point

13668: END IF;
13669:
13670: ELSE
13671:
13672: p_x_line_rec.fob_point_code := OE_Value_To_Id.fob_point
13673: ( p_fob_point => p_line_val_rec.fob_point
13674: );
13675:
13676: IF p_x_line_rec.fob_point_code = FND_API.G_MISS_CHAR THEN

Line 13700: p_x_line_rec.freight_terms_code := OE_Value_To_Id.freight_terms

13696: END IF;
13697:
13698: ELSE
13699:
13700: p_x_line_rec.freight_terms_code := OE_Value_To_Id.freight_terms
13701: ( p_freight_terms => p_line_val_rec.freight_terms
13702: );
13703:
13704: IF p_x_line_rec.freight_terms_code = FND_API.G_MISS_CHAR THEN

Line 13728: p_x_line_rec.shipping_method_code := OE_Value_To_Id.ship_method

13724: END IF;
13725:
13726: ELSE
13727:
13728: p_x_line_rec.shipping_method_code := OE_Value_To_Id.ship_method
13729: ( p_ship_method => p_line_val_rec.shipping_method
13730: );
13731:
13732: IF p_x_line_rec.shipping_method_code = FND_API.G_MISS_CHAR THEN

Line 13758: p_x_line_rec.freight_carrier_code := OE_Value_To_Id.freight_carrier

13754: END IF;
13755:
13756: ELSE
13757:
13758: p_x_line_rec.freight_carrier_code := OE_Value_To_Id.freight_carrier
13759: ( p_freight_carrier => p_line_val_rec.freight_carrier
13760: , p_ship_from_org_id => p_x_line_rec.ship_from_org_id
13761: );
13762:

Line 13787: p_x_line_rec.intermed_ship_to_contact_id := OE_Value_To_Id.intermed_ship_to_contact

13783: END IF;
13784:
13785: ELSE
13786:
13787: p_x_line_rec.intermed_ship_to_contact_id := OE_Value_To_Id.intermed_ship_to_contact
13788: ( p_intermed_ship_to_contact => p_line_val_rec.intermed_ship_to_contact
13789: , p_intermed_ship_to_org_id => p_x_line_rec.intermed_ship_to_org_id
13790: );
13791:

Line 13822: p_x_line_rec.intermed_ship_to_org_id := OE_Value_To_Id.intermed_ship_to_org

13818:
13819: ELSE
13820:
13821: /*1621182*/
13822: p_x_line_rec.intermed_ship_to_org_id := OE_Value_To_Id.intermed_ship_to_org
13823: ( p_intermed_ship_to_address1 => p_line_val_rec.intermed_ship_to_address1
13824: , p_intermed_ship_to_address2 => p_line_val_rec.intermed_ship_to_address2
13825: , p_intermed_ship_to_address3 => p_line_val_rec.intermed_ship_to_address3
13826: , p_intermed_ship_to_address4 => p_line_val_rec.intermed_ship_to_address4

Line 13861: p_x_line_rec.inventory_item_id := OE_Value_To_Id.inventory_item

13857: END IF;
13858:
13859: ELSE
13860:
13861: p_x_line_rec.inventory_item_id := OE_Value_To_Id.inventory_item
13862: ( p_inventory_item => p_line_val_rec.inventory_item
13863: );
13864:
13865: IF p_x_line_rec.inventory_item_id = FND_API.G_MISS_NUM THEN

Line 13889: p_x_line_rec.invoicing_rule_id := OE_Value_To_Id.invoicing_rule

13885: END IF;
13886:
13887: ELSE
13888:
13889: p_x_line_rec.invoicing_rule_id := OE_Value_To_Id.invoicing_rule
13890: ( p_invoicing_rule => p_line_val_rec.invoicing_rule
13891: );
13892:
13893: IF p_x_line_rec.invoicing_rule_id = FND_API.G_MISS_NUM THEN

Line 13917: p_x_line_rec.item_type_code := OE_Value_To_Id.item_type

13913: END IF;
13914:
13915: ELSE
13916:
13917: p_x_line_rec.item_type_code := OE_Value_To_Id.item_type
13918: ( p_item_type => p_line_val_rec.item_type
13919: );
13920:
13921: IF p_x_line_rec.item_type_code = FND_API.G_MISS_CHAR THEN

Line 13945: p_x_line_rec.line_type_id := OE_Value_To_Id.line_type

13941: END IF;
13942:
13943: ELSE
13944:
13945: p_x_line_rec.line_type_id := OE_Value_To_Id.line_type
13946: ( p_line_type => p_line_val_rec.line_type
13947: );
13948:
13949: IF p_x_line_rec.line_type_id = FND_API.G_MISS_NUM THEN

Line 13973: p_x_line_rec.over_ship_reason_code := OE_Value_To_Id.over_ship_reason

13969: END IF;
13970:
13971: ELSE
13972:
13973: p_x_line_rec.over_ship_reason_code := OE_Value_To_Id.over_ship_reason
13974: ( p_over_ship_reason => p_line_val_rec.over_ship_reason
13975: );
13976:
13977: IF p_x_line_rec.over_ship_reason_code = FND_API.G_MISS_CHAR THEN

Line 14001: p_x_line_rec.payment_term_id := OE_Value_To_Id.payment_term

13997: END IF;
13998:
13999: ELSE
14000:
14001: p_x_line_rec.payment_term_id := OE_Value_To_Id.payment_term
14002: ( p_payment_term => p_line_val_rec.payment_term
14003: );
14004:
14005: IF p_x_line_rec.payment_term_id = FND_API.G_MISS_NUM THEN

Line 14029: p_x_line_rec.price_list_id := OE_Value_To_Id.price_list

14025: END IF;
14026:
14027: ELSE
14028:
14029: p_x_line_rec.price_list_id := OE_Value_To_Id.price_list
14030: ( p_price_list => p_line_val_rec.price_list
14031: );
14032:
14033: IF p_x_line_rec.price_list_id = FND_API.G_MISS_NUM THEN

Line 14057: p_x_line_rec.project_id := OE_Value_To_Id.project

14053: END IF;
14054:
14055: ELSE
14056:
14057: p_x_line_rec.project_id := OE_Value_To_Id.project
14058: ( p_project => p_line_val_rec.project
14059: );
14060:
14061: IF p_x_line_rec.project_id = FND_API.G_MISS_NUM THEN

Line 14085: p_x_line_rec.return_reason_code := OE_Value_To_Id.return_reason

14081: END IF;
14082:
14083: ELSE
14084:
14085: p_x_line_rec.return_reason_code := OE_Value_To_Id.return_reason
14086: ( p_return_reason => p_line_val_rec.return_reason
14087: );
14088:
14089: IF p_x_line_rec.return_reason_code = FND_API.G_MISS_CHAR THEN

Line 14115: p_x_line_rec.rla_schedule_type_code := OE_Value_To_Id.rla_schedule_type

14111: END IF;
14112:
14113: ELSE
14114:
14115: p_x_line_rec.rla_schedule_type_code := OE_Value_To_Id.rla_schedule_type
14116: ( p_rla_schedule_type => p_line_val_rec.rla_schedule_type
14117: );
14118:
14119: IF p_x_line_rec.rla_schedule_type_code = FND_API.G_MISS_CHAR THEN

Line 14143: p_x_line_rec.salesrep_id := OE_Value_To_Id.salesrep

14139: END IF;
14140:
14141: ELSE
14142:
14143: p_x_line_rec.salesrep_id := OE_Value_To_Id.salesrep
14144: ( p_salesrep => p_line_val_rec.salesrep
14145: );
14146:
14147: IF p_x_line_rec.salesrep_id = FND_API.G_MISS_NUM THEN

Line 14171: p_x_line_rec.shipment_priority_code := OE_Value_To_Id.shipment_priority

14167: END IF;
14168:
14169: ELSE
14170:
14171: p_x_line_rec.shipment_priority_code := OE_Value_To_Id.shipment_priority
14172: ( p_shipment_priority => p_line_val_rec.shipment_priority
14173: );
14174:
14175: IF p_x_line_rec.shipment_priority_code = FND_API.G_MISS_CHAR THEN

Line 14204: p_x_line_rec.ship_from_org_id := OE_Value_To_Id.ship_from_org

14200: END IF;
14201:
14202: ELSE
14203:
14204: p_x_line_rec.ship_from_org_id := OE_Value_To_Id.ship_from_org
14205: ( p_ship_from_address1 => p_line_val_rec.ship_from_address1
14206: , p_ship_from_address2 => p_line_val_rec.ship_from_address2
14207: , p_ship_from_address3 => p_line_val_rec.ship_from_address3
14208: , p_ship_from_address4 => p_line_val_rec.ship_from_address4

Line 14237: p_x_line_rec.task_id := OE_Value_To_Id.task

14233: END IF;
14234:
14235: ELSE
14236:
14237: p_x_line_rec.task_id := OE_Value_To_Id.task
14238: ( p_task => p_line_val_rec.task
14239: );
14240:
14241: IF p_x_line_rec.task_id = FND_API.G_MISS_NUM THEN

Line 14265: p_x_line_rec.tax_exempt_flag := OE_Value_To_Id.tax_exempt

14261: END IF;
14262:
14263: ELSE
14264:
14265: p_x_line_rec.tax_exempt_flag := OE_Value_To_Id.tax_exempt
14266: ( p_tax_exempt => p_line_val_rec.tax_exempt
14267: );
14268:
14269: IF p_x_line_rec.tax_exempt_flag = FND_API.G_MISS_CHAR THEN

Line 14293: p_x_line_rec.tax_exempt_reason_code := OE_Value_To_Id.tax_exempt_reason

14289: END IF;
14290:
14291: ELSE
14292:
14293: p_x_line_rec.tax_exempt_reason_code := OE_Value_To_Id.tax_exempt_reason
14294: ( p_tax_exempt_reason => p_line_val_rec.tax_exempt_reason
14295: );
14296:
14297: IF p_x_line_rec.tax_exempt_reason_code = FND_API.G_MISS_CHAR THEN

Line 14321: p_x_line_rec.tax_point_code := OE_Value_To_Id.tax_point

14317: END IF;
14318:
14319: ELSE
14320:
14321: p_x_line_rec.tax_point_code := OE_Value_To_Id.tax_point
14322: ( p_tax_point => p_line_val_rec.tax_point
14323: );
14324:
14325: IF p_x_line_rec.tax_point_code = FND_API.G_MISS_CHAR THEN

Line 14350: p_x_line_rec.veh_cus_item_cum_key_id := OE_Value_To_Id.veh_cus_item_cum_key

14346: END IF;
14347:
14348: ELSE
14349:
14350: p_x_line_rec.veh_cus_item_cum_key_id := OE_Value_To_Id.veh_cus_item_cum_key
14351: ( p_veh_cus_item_cum_key => p_line_val_rec.veh_cus_item_cum_key
14352: );
14353:
14354: IF p_x_line_rec.veh_cus_item_cum_key_id = FND_API.G_MISS_NUM THEN

Line 14385: p_x_line_rec.invoice_to_customer_id:=OE_Value_To_Id.site_customer

14381: END IF;
14382:
14383: ELSE
14384: IF p_x_line_rec.invoice_to_org_id = FND_API.G_MISS_NUM THEN -- bug 4231603
14385: p_x_line_rec.invoice_to_customer_id:=OE_Value_To_Id.site_customer
14386: ( p_site_customer => p_line_val_rec.invoice_to_customer_name_oi
14387: ,p_site_customer_number=> p_line_val_rec.invoice_to_customer_number_oi
14388: ,p_type =>'INVOICE_TO'
14389: );

Line 14421: p_x_line_rec.ship_to_customer_id:=OE_Value_To_Id.site_customer

14417: END IF;
14418:
14419: ELSE
14420: IF p_x_line_rec.ship_to_org_id = FND_API.G_MISS_NUM THEN --4231603
14421: p_x_line_rec.ship_to_customer_id:=OE_Value_To_Id.site_customer
14422: ( p_site_customer => p_line_val_rec.ship_to_customer_name_oi
14423: ,p_site_customer_number=> p_line_val_rec.ship_to_customer_number_oi
14424: ,p_type =>'SHIP_TO'
14425: );

Line 14458: p_x_line_rec.deliver_to_customer_id:=OE_Value_To_Id.site_customer

14454: END IF;
14455:
14456: ELSE
14457: IF p_x_line_rec.deliver_to_org_id = FND_API.G_MISS_NUM THEN -- 4231603
14458: p_x_line_rec.deliver_to_customer_id:=OE_Value_To_Id.site_customer
14459: ( p_site_customer => p_line_val_rec.ship_to_customer_name_oi
14460: ,p_site_customer_number=> p_line_val_rec.ship_to_customer_number_oi
14461: ,p_type =>'DELIVER_TO'
14462: );

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

14476: -------------------------------------------------------------------
14477:
14478: -- Retrieve the sold_to_org_id if not passed on the line record. This
14479: -- will be needed by the value_to_id functions for related fields.
14480: -- For e.g. oe_value_to_id.ship_to_org_id requires sold_to_org_id
14481:
14482: IF p_x_line_rec.sold_to_org_id = FND_API.G_MISS_NUM
14483: THEN
14484:

Line 14532: p_x_line_rec.deliver_to_org_id := OE_Value_To_Id.deliver_to_org

14528:
14529: ELSE
14530:
14531: /*1621182*/
14532: p_x_line_rec.deliver_to_org_id := OE_Value_To_Id.deliver_to_org
14533: ( p_deliver_to_address1 => p_line_val_rec.deliver_to_address1
14534: , p_deliver_to_address2 => p_line_val_rec.deliver_to_address2
14535: , p_deliver_to_address3 => p_line_val_rec.deliver_to_address3
14536: , p_deliver_to_address4 => p_line_val_rec.deliver_to_address4

Line 14578: p_x_line_rec.invoice_to_org_id := OE_Value_To_Id.invoice_to_org

14574:
14575: ELSE
14576:
14577: /*1621182*/
14578: p_x_line_rec.invoice_to_org_id := OE_Value_To_Id.invoice_to_org
14579: ( p_invoice_to_address1 => p_line_val_rec.invoice_to_address1
14580: , p_invoice_to_address2 => p_line_val_rec.invoice_to_address2
14581: , p_invoice_to_address3 => p_line_val_rec.invoice_to_address3
14582: , p_invoice_to_address4 => p_line_val_rec.invoice_to_address4

Line 14624: p_x_line_rec.ship_to_org_id := OE_Value_To_Id.ship_to_org

14620:
14621: ELSE
14622:
14623: /*1621182*/
14624: p_x_line_rec.ship_to_org_id := OE_Value_To_Id.ship_to_org
14625: ( p_ship_to_address1 => p_line_val_rec.ship_to_address1
14626: , p_ship_to_address2 => p_line_val_rec.ship_to_address2
14627: , p_ship_to_address3 => p_line_val_rec.ship_to_address3
14628: , p_ship_to_address4 => p_line_val_rec.ship_to_address4

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

14646: END IF;
14647:
14648: -- Retrieve the org_ids if not passed on the line record. These
14649: -- IDs will be needed by the value_to_id functions for CONTACT fields.
14650: -- For e.g. oe_value_to_id.ship_to_contact_id requires ship_to_org_id
14651:
14652: -- bug 3487597, added clause for line_id
14653:
14654: IF p_x_line_rec.operation = OE_GLOBALS.G_OPR_UPDATE

Line 14703: p_x_line_rec.deliver_to_contact_id := OE_Value_To_Id.deliver_to_contact

14699: END IF;
14700:
14701: ELSE
14702:
14703: p_x_line_rec.deliver_to_contact_id := OE_Value_To_Id.deliver_to_contact
14704: ( p_deliver_to_contact => p_line_val_rec.deliver_to_contact
14705: , p_deliver_to_org_id => l_deliver_to_org_id
14706: );
14707:

Line 14733: p_x_line_rec.invoice_to_contact_id := OE_Value_To_Id.invoice_to_contact

14729: END IF;
14730:
14731: ELSE
14732:
14733: p_x_line_rec.invoice_to_contact_id := OE_Value_To_Id.invoice_to_contact
14734: ( p_invoice_to_contact => p_line_val_rec.invoice_to_contact
14735: , p_invoice_to_org_id => l_invoice_to_org_id
14736: );
14737:

Line 14763: p_x_line_rec.ship_to_contact_id := OE_Value_To_Id.ship_to_contact

14759: END IF;
14760:
14761: ELSE
14762:
14763: p_x_line_rec.ship_to_contact_id := OE_Value_To_Id.ship_to_contact
14764: ( p_ship_to_contact => p_line_val_rec.ship_to_contact
14765: , p_ship_to_org_id => l_ship_to_org_id
14766: );
14767:

Line 14793: p_x_line_rec.commitment_id := OE_Value_To_Id.commitment

14789: END IF;
14790:
14791: ELSE
14792:
14793: p_x_line_rec.commitment_id := OE_Value_To_Id.commitment
14794: ( p_commitment => p_line_val_rec.commitment
14795: );
14796:
14797: IF p_x_line_rec.commitment_id = FND_API.G_MISS_NUM THEN

Line 14823: p_x_line_rec.end_customer_id:=OE_Value_To_Id.end_customer

14819: END IF;
14820:
14821: ELSE
14822: IF p_x_line_rec.end_customer_site_use_id = FND_API.G_MISS_NUM THEN -- 4231603
14823: p_x_line_rec.end_customer_id:=OE_Value_To_Id.end_customer
14824: ( p_end_customer => p_line_val_rec.end_customer_name
14825: ,p_end_customer_number=> p_line_val_rec.end_customer_number
14826: );
14827:

Line 14854: p_x_line_rec.end_customer_contact_id := OE_Value_To_Id.end_customer_contact

14850: END IF;
14851:
14852: ELSE
14853: oe_debug_pub.add('before calling aend customer contact value to id');
14854: p_x_line_rec.end_customer_contact_id := OE_Value_To_Id.end_customer_contact
14855: ( p_end_customer_contact => p_line_val_rec.end_customer_contact
14856: ,p_end_customer_id =>p_x_line_rec.end_customer_id
14857: );
14858: oe_debug_pub.add('End customer contact id is '||p_x_line_rec.end_customer_contact_id);

Line 14894: p_x_line_rec.end_customer_site_use_id := OE_Value_To_Id.end_customer_site

14890: END IF;
14891:
14892: ELSE
14893: oe_debug_pub.add('Before calling End custoemr site use value to id');
14894: p_x_line_rec.end_customer_site_use_id := OE_Value_To_Id.end_customer_site
14895: ( p_end_customer_site_address1 => p_line_val_rec.end_customer_site_address1
14896: , p_end_customer_site_address2 => p_line_val_rec.end_customer_site_address2
14897: , p_end_customer_site_address3 => p_line_val_rec.end_customer_site_address3
14898: , p_end_customer_site_address4 => p_line_val_rec.end_customer_site_address4

Line 14936: p_x_line_rec.ib_owner:=OE_Value_To_Id.ib_owner

14932: END IF;
14933:
14934: ELSE
14935:
14936: p_x_line_rec.ib_owner:=OE_Value_To_Id.ib_owner
14937: ( p_ib_owner => p_line_val_rec.ib_owner_dsp
14938: );
14939:
14940: IF p_x_line_rec.ib_owner = FND_API.G_MISS_CHAR THEN

Line 14963: p_x_line_rec.ib_installed_at_location:=OE_Value_To_Id.ib_installed_at_location

14959: END IF;
14960:
14961: ELSE
14962:
14963: p_x_line_rec.ib_installed_at_location:=OE_Value_To_Id.ib_installed_at_location
14964: ( p_ib_installed_at_location => p_line_val_rec.ib_installed_at_location_dsp
14965: );
14966:
14967: IF p_x_line_rec.ib_installed_at_location = FND_API.G_MISS_CHAR THEN

Line 14990: p_x_line_rec.ib_current_location:=OE_Value_To_Id.ib_current_location

14986: END IF;
14987:
14988: ELSE
14989:
14990: p_x_line_rec.ib_current_location:=OE_Value_To_Id.ib_current_location
14991: ( p_ib_current_location => p_line_val_rec.ib_current_location_dsp
14992: );
14993:
14994: IF p_x_line_rec.ib_current_location = FND_API.G_MISS_CHAR THEN