DBA Data[Home] [Help]

APPS.OE_CUSTOMER_INFO_PVT dependencies on OE_OE_INLINE_ADDRESS

Line 1455: /* This procedure will call the wraper procedure oe_oe_inline_address.create_account which

1451: );
1452:
1453: End get_customer_info_ids;
1454:
1455: /* This procedure will call the wraper procedure oe_oe_inline_address.create_account which
1456: inturn calls TCA apis to create a customer account. Email and phone contact points for the party will
1457: also be created if passed*/
1458:
1459: Procedure Create_account (p_header_customer_info_rec IN OE_ORDER_PUB.CUSTOMER_INFO_REC_TYPE,

Line 1542: oe_oe_inline_address.create_account(

1538:
1539: End If;
1540:
1541:
1542: oe_oe_inline_address.create_account(
1543: p_party_number=> l_party_number,
1544: p_organization_name=>l_organization_name,
1545: p_party_type=>l_party_type,
1546: p_party_id=>l_party_id,

Line 1625: oe_oe_inline_address.create_contact_point

1621: END IF;
1622:
1623: IF NVL(l_customer_info_rec.email_address,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR Then
1624:
1625: oe_oe_inline_address.create_contact_point
1626: (
1627: in_contact_point_type => 'EMAIL',
1628: in_owner_table_id => x_party_id,
1629: in_email => l_customer_info_rec.email_address,

Line 1658: oe_oe_inline_address.create_contact_point

1654: END IF;
1655:
1656: IF NVL(l_customer_info_rec.phone_number,FND_API.G_MISS_CHAR) <> FND_API.G_MISS_CHAR Then
1657:
1658: oe_oe_inline_address.create_contact_point
1659: (in_contact_point_type =>'PHONE',
1660: in_owner_table_id=>x_party_id,
1661: in_email=>NULL,
1662: in_phone_area_code =>l_customer_info_rec.phone_area_code,

Line 1734: oe_oe_inline_address.create_cust_relationship( p_cust_acct_id => p_sold_to_customer_id

1730: AND NVL(p_ship_to_customer_id,FND_API.G_MISS_NUM) <> FND_API.G_MISS_NUM
1731: AND p_sold_to_customer_id <> p_ship_to_customer_id
1732: AND NOT check_relation_exists ( p_sold_to_customer_id,p_ship_to_customer_id )
1733: THEN
1734: oe_oe_inline_address.create_cust_relationship( p_cust_acct_id => p_sold_to_customer_id
1735: ,p_related_cust_acct_id => p_ship_to_customer_id
1736: ,p_reciprocal_flag => 'Y'
1737: ,p_created_by_module => G_CREATED_BY_MODULE
1738: ,x_return_status => x_return_status

Line 1761: oe_oe_inline_address.create_cust_relationship( p_cust_acct_id => p_sold_to_customer_id

1757: AND p_sold_to_customer_id <> p_bill_to_customer_id
1758: AND NOT check_relation_exists ( p_sold_to_customer_id,p_bill_to_customer_id )
1759: THEN
1760:
1761: oe_oe_inline_address.create_cust_relationship( p_cust_acct_id => p_sold_to_customer_id
1762: ,p_related_cust_acct_id => p_bill_to_customer_id
1763: ,p_reciprocal_flag => 'Y'
1764: ,p_created_by_module => G_CREATED_BY_MODULE
1765: ,x_return_status => x_return_status

Line 1789: oe_oe_inline_address.create_cust_relationship( p_cust_acct_id => p_sold_to_customer_id

1785: AND NOT check_relation_exists ( p_sold_to_customer_id,p_deliver_to_cust_id )
1786: THEN
1787:
1788:
1789: oe_oe_inline_address.create_cust_relationship( p_cust_acct_id => p_sold_to_customer_id
1790: ,p_related_cust_acct_id => p_deliver_to_cust_id
1791: ,p_reciprocal_flag => 'Y'
1792: ,p_created_by_module => G_CREATED_BY_MODULE
1793: ,x_return_status => x_return_status

Line 1867: oe_oe_inline_address.Create_Location(

1863: IF l_debug_level > 0 then
1864: oe_debug_pub.add('Step 1:Create Location');
1865: end if;
1866:
1867: oe_oe_inline_address.Create_Location(
1868: p_country => p_address_rec.country,
1869: p_address1 => p_address_rec.address1,
1870: p_address2 => p_address_rec.address2,
1871: p_address3 => p_address_rec.address3,

Line 1951: oe_oe_inline_address.Create_Party_Site

1947: ELSE
1948: l_party_site_number := p_address_rec.site_number;
1949: END IF;
1950:
1951: oe_oe_inline_address.Create_Party_Site
1952: (
1953: p_party_id => p_party_id,
1954: p_location_id => x_location_id,
1955: p_party_site_number => l_party_site_number,

Line 2028: oe_oe_inline_address.Create_Account_Site

2024: IF l_debug_level > 0 THEN
2025: oe_debug_pub.add('Step 3:Create Account Site');
2026: END IF;
2027:
2028: oe_oe_inline_address.Create_Account_Site
2029: (
2030: p_cust_account_id => p_cust_account_id,
2031: p_party_site_id => p_party_site_id,
2032: c_Attribute_Category => p_address_rec.attribute_category,

Line 3338: oe_oe_inline_address.create_contact_point

3334: END IF;
3335:
3336:
3337: IF p_customer_rec.email_address IS NOT NULL THEN
3338: oe_oe_inline_address.create_contact_point
3339: (
3340: in_contact_point_type => 'EMAIL',
3341: in_owner_table_id => l_party_id,
3342: in_email => p_customer_rec.email_address,

Line 3364: oe_oe_inline_address.create_contact_point

3360: END IF;
3361:
3362: IF p_customer_rec.phone_number IS NOT NULL Then
3363:
3364: oe_oe_inline_address.create_contact_point
3365: (in_contact_point_type =>'PHONE',
3366: in_owner_table_id=>l_party_id,
3367: in_email=>NULL,
3368: in_phone_area_code =>p_customer_rec.phone_area_code,

Line 3534: oe_oe_inline_address.create_contact(

3530: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3531: RETURN;
3532: END IF;
3533:
3534: oe_oe_inline_address.create_contact(
3535: p_contact_last_name => l_contact_rec.person_last_name,
3536: p_contact_first_name => l_contact_rec.person_first_name,
3537: p_contact_title => l_contact_rec.person_title,
3538: p_email => l_contact_rec.email_address,

Line 3944: oe_oe_inline_address.create_contact_point

3940: END IF;
3941:
3942:
3943: IF p_contact_rec.email_address IS NOT NULL THEN
3944: oe_oe_inline_address.create_contact_point
3945: (
3946: in_contact_point_type => 'EMAIL',
3947: in_owner_table_id => l_rel_party_id,
3948: in_email => p_contact_rec.email_address,

Line 3970: oe_oe_inline_address.create_contact_point

3966: END IF;
3967:
3968: IF p_contact_rec.phone_number IS NOT NULL Then
3969:
3970: oe_oe_inline_address.create_contact_point
3971: (in_contact_point_type =>'PHONE',
3972: in_owner_table_id=>l_rel_party_id,
3973: in_email=>NULL,
3974: in_phone_area_code =>p_contact_rec.phone_area_code,