APPS.OE_CUSTOMER_INFO_PVT dependencies on OE_VALUE_TO_ID

Line 2825: x_customer_id := Oe_value_to_id.sold_to_org(

2821: x_customer_id := FND_API.G_MISS_NUM;
2822:
2823: IF p_customer_record.customer_type = 'ORGANIZATION' THEN
2824: IF p_type = 'SOLD_TO' THEN
2825: x_customer_id := Oe_value_to_id.sold_to_org(
2826: p_sold_to_org => p_customer_record.organization_name,
2827: p_customer_number => p_customer_record.customer_number);
2828: ELSE
2829: x_customer_id := Oe_value_to_id.site_customer(

Line 2829: x_customer_id := Oe_value_to_id.site_customer(

2825: x_customer_id := Oe_value_to_id.sold_to_org(
2826: p_sold_to_org => p_customer_record.organization_name,
2827: p_customer_number => p_customer_record.customer_number);
2828: ELSE
2829: x_customer_id := Oe_value_to_id.site_customer(
2830: p_site_customer => p_customer_record.organization_name
2831: , p_site_customer_number => p_customer_record.customer_number
2832: , p_type =>p_type );
2833:

Line 2838: x_customer_id := oe_value_to_id.sold_to_org(

2834:
2835: END IF;
2836: ELSIF p_customer_record.customer_type = 'PERSON' THEN
2837: IF p_type = 'SOLD_TO' THEN
2838: x_customer_id := oe_value_to_id.sold_to_org(
2839: p_sold_to_org => p_customer_record.person_first_name || ' ' ||
2840: p_customer_record.person_last_name,
2841: p_customer_number => p_customer_record.customer_number);
2842: ELSE

Line 2843: x_customer_id := Oe_value_to_id.site_customer(

2839: p_sold_to_org => p_customer_record.person_first_name || ' ' ||
2840: p_customer_record.person_last_name,
2841: p_customer_number => p_customer_record.customer_number);
2842: ELSE
2843: x_customer_id := Oe_value_to_id.site_customer(
2844: p_site_customer => p_customer_record.person_first_name || ' ' ||
2845: p_customer_record.person_last_name
2846: , p_site_customer_number => p_customer_record.customer_number
2847: , p_type => p_type );

Line 2913: x_site_usage_id := Oe_Value_To_Id.Ship_To_Org(

2909:
2910:
2911: IF p_site_usage = 'SHIP_TO' THEN
2912:
2913: x_site_usage_id := Oe_Value_To_Id.Ship_To_Org(
2914: p_ship_to_address1 => p_address_record.address1,
2915: p_ship_to_address2 => p_address_record.address2,
2916: p_ship_to_address3 => p_address_record.address3,
2917: p_ship_to_address4 => p_address_record.address4,

Line 2929: x_site_usage_id := Oe_Value_To_Id.Invoice_To_Org(

2925: p_ship_to_customer_id =>l_site_customer_id);
2926:
2927: ELSIF p_site_usage = 'BILL_TO' Then
2928:
2929: x_site_usage_id := Oe_Value_To_Id.Invoice_To_Org(
2930: p_invoice_to_address1 => p_address_record.address1,
2931: p_invoice_to_address2 => p_address_record.address2,
2932: p_invoice_to_address3 => p_address_record.address3,
2933: p_invoice_to_address4 => p_address_record.address4,

Line 2943: x_site_usage_id := Oe_Value_To_Id.Deliver_To_Org(

2939: p_invoice_to_org => p_address_record.location_number,
2940: p_sold_to_org_id => p_sold_to_org_id,
2941: p_invoice_to_customer_id => l_site_customer_id);
2942: ELSIF p_site_usage = 'DELIVER_TO' THEN
2943: x_site_usage_id := Oe_Value_To_Id.Deliver_To_Org(
2944: p_deliver_to_address1 => p_address_record.address1,
2945: p_deliver_to_address2 => p_address_record.address2,
2946: p_deliver_to_address3 => p_address_record.address3,
2947: p_deliver_to_address4 => p_address_record.address4,

Line 2957: x_site_usage_id := Oe_Value_To_Id.Customer_Location

2953: p_deliver_to_org => p_address_record.location_number,
2954: p_sold_to_org_id => p_sold_to_org_id,
2955: p_deliver_to_customer_id => l_site_customer_id);
2956: ELSE
2957: x_site_usage_id := Oe_Value_To_Id.Customer_Location
2958: ( p_sold_to_location_address1 =>p_address_record.address1
2959: , p_sold_to_location_address2 =>p_address_record.address2
2960: , p_sold_to_location_address3 =>p_address_record.address3
2961: , p_sold_to_location_address4 =>p_address_record.address4

Line 2989: x_site_usage_id := Oe_Value_To_Id.Ship_To_Org(

2985: BEGIN
2986:
2987: IF p_site_usage = 'SHIP_TO' THEN
2988:
2989: x_site_usage_id := Oe_Value_To_Id.Ship_To_Org(
2990: p_ship_to_address1 => p_address_record.address1,
2991: p_ship_to_address2 => p_address_record.address2,
2992: p_ship_to_address3 => p_address_record.address3,
2993: p_ship_to_address4 => p_address_record.address4,

Line 3005: x_site_usage_id := Oe_Value_To_Id.Invoice_To_Org(

3001: p_ship_to_customer_id =>p_site_customer_id);
3002:
3003: ELSIF p_site_usage = 'BILL_TO' Then
3004:
3005: x_site_usage_id := Oe_Value_To_Id.Invoice_To_Org(
3006: p_invoice_to_address1 => p_address_record.address1,
3007: p_invoice_to_address2 => p_address_record.address2,
3008: p_invoice_to_address3 => p_address_record.address3,
3009: p_invoice_to_address4 => p_address_record.address4,

Line 3020: x_site_usage_id := Oe_Value_To_Id.Deliver_To_Org(

3016: p_sold_to_org_id => p_sold_to_org_id,
3017: p_invoice_to_customer_id => p_site_customer_id);
3018: ELSIF p_site_usage = 'DELIVER_TO' THEN
3019:
3020: x_site_usage_id := Oe_Value_To_Id.Deliver_To_Org(
3021: p_deliver_to_address1 => p_address_record.address1,
3022: p_deliver_to_address2 => p_address_record.address2,
3023: p_deliver_to_address3 => p_address_record.address3,
3024: p_deliver_to_address4 => p_address_record.address4,

Line 3034: x_site_usage_id := Oe_Value_To_Id.Customer_Location

3030: p_deliver_to_org => p_address_record.location_number,
3031: p_sold_to_org_id => p_sold_to_org_id,
3032: p_deliver_to_customer_id => p_site_customer_id);
3033: ELSE
3034: x_site_usage_id := Oe_Value_To_Id.Customer_Location
3035: ( p_sold_to_location_address1 =>p_address_record.address1
3036: , p_sold_to_location_address2 =>p_address_record.address2
3037: , p_sold_to_location_address3 =>p_address_record.address3
3038: , p_sold_to_location_address4 =>p_address_record.address4

Line 3810: x_contact_id := Oe_Value_To_Id.Sold_To_Contact(

3806: ||p_contact_record.Person_Name_Suffix)
3807: Into l_contact_name
3808: From Dual;
3809:
3810: x_contact_id := Oe_Value_To_Id.Sold_To_Contact(
3811: p_sold_to_contact => l_contact_name,
3812: p_sold_to_org_id => p_customer_id);
3813:
3814: