<xsd:schema elementFormDefault="qualified" targetNamespace="http://xmlns.oracle.com/apps/cdm/foundation/parties/contactPointService/"
     xmlns:ns0="http://xmlns.oracle.com/adf/svc/types/" xmlns:ns1="http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/"
     xmlns:ns2="http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/contactPoint/"
     xmlns:sdo="commonj.sdo" xmlns:sdoJava="commonj.sdo/java" xmlns:sdoXML="commonj.sdo/xml"
     xmlns="http://xmlns.oracle.com/apps/cdm/foundation/parties/contactPointService/" xmlns:xsd="http://www.w3.org/2001/XMLSchema">
    <xsd:annotation>
        <xsd:documentation xmlns:oer="http://xmlns.oracle.com/oer">
            <name>Trading Community Phone</name>
            <description>A phone number associated with a trading community member. For
                example, the phone number for Oracle Corporation is 650-506-6000.</description>
            <oer:category name="lba">
                <value>CdmTop-Customer Data Management</value>
                <value>CdmTop-Customer Data Management : FoundationTop-Foundation</value>
                <value>CdmTop-Customer Data Management : FoundationTop-Foundation :
                    FoundationParties-Parties</value>
            </oer:category>
            <oer:attributes>
                <oer:attribute description="Unique identifier for a contact point. System generated from a sequence. Primary Key."
                     name="ContactPointId"/>
                <oer:attribute description="Contact point type, such as phone or e-mail. Valid value from COMMUNICATION_TYPE lookup type."
                     name="ContactPointType"/>
                <oer:attribute description="Lookup: contact_point_status. Typically values: active, inactive, delete. It is validated against AR lookup type REGISTRY_STATUS. Default value is A."
                     name="Status"/>
                <oer:attribute description="Table that stores the owner of the contact point" name="OwnerTableName"/>
                <oer:attribute description="Foreign key to OWNER_TABLE_NAME identifies the owner of the contact point"
                     name="OwnerTableId"/>
                <oer:attribute description="Indicates if this is the primary contact point of this contact point type for referenced party, site, or location. Y for primary contact, N for all others."
                     name="PrimaryFlag"/>
                <oer:attribute description="Identifier for this record from foreign or legacy system."
                     name="OrigSystemReference"/>
                <oer:attribute description="Who column: indicates the date and time of the last update of the row."
                     name="LastUpdateDate"/>
                <oer:attribute description="Who column: indicates the user who last updated the row."
                     name="LastUpdatedBy"/>
                <oer:attribute description="Who column: indicates the date and time of the creation of the row."
                     name="CreationDate"/>
                <oer:attribute description="Who column: indicates the user who created the row." name="CreatedBy"/>
                <oer:attribute description="Who column: indicates the session login associated to the user who last updated the row."
                     name="LastUpdateLogin"/>
                <oer:attribute description="Enterprise Service Scheduler: indicates the request ID of the job that created or last updated the row."
                     name="RequestId"/>
                <oer:attribute description="Used to implement optimistic locking. This number is incremented every time that the row is updated. The number is compared at the start and end of a transaction to detect whether another session has updated the row since it was queried."
                     name="ObjectVersionNumber"/>
                <oer:attribute description="TCA Who column" name="CreatedByModule"/>
                <oer:attribute description="Contact point type, such as business or personal. Uses the CONTACT_POINT_PURPOSE lookup."
                     name="ContactPointPurpose"/>
                <oer:attribute description="Y indicates that this is the primary contact point of the contact point purpose for the party or site. A party or site can have only one contact point with a value of Y."
                     name="PrimaryByPurpose"/>
                <oer:attribute description="Indicates the date from which this entity is active. This date is inclusive. The status of an entity is dependent on this."
                     name="StartDate"/>
                <oer:attribute description="Indicates the date till which this entity is active. This date is inclusive. The status of an entity is dependent on this"
                     name="EndDate"/>
                <oer:attribute description="Column to store the party&apos;s contact point in the context of a relationship"
                     name="RelationshipId"/>
                <oer:attribute description="Usage context of a party&apos;s contact point." name="PartyUsageCode"/>
                <oer:attribute description="Source system name" name="OrigSystem"/>
                <oer:attribute description="The name or code for a calling calendar used with this telephone number. This aatribute is no longer used in Fusion."
                     name="PhoneCallingCalendar"/>
                <oer:attribute description="Date and time of last contact placed to this contact point."
                     name="LastContactDtTime"/>
                <oer:attribute description="The area code within a country code." name="PhoneAreaCode"/>
                <oer:attribute description="International country code for a telephone number. For example, 33 for France."
                     name="PhoneCountryCode"/>
                <oer:attribute description="A telephone number formatted in the local format. The number should not include area code, country code, or extension."
                     name="PhoneNumber"/>
                <oer:attribute description="Additional number addressed after initial connection to an internal telephone system."
                     name="PhoneExtension"/>
                <oer:attribute description="Lookup code for the type of phone line. For example, general, fax, inbound, or outbound."
                     name="PhoneLineType"/>
                <oer:attribute description="Unformatted telephone number" name="RawPhoneNumber"/>
                <oer:attribute description="The PAGER_TYPE_CODE column stores the lookup code for the type of pager. The type of pager determines how the page is received. For example, Tone, Number, Alphanumeric or Two-way alphanumeric."
                     name="PagerTypeCode"/>
                <oer:attribute description="Formatted phone number information." name="FormattedPhoneNumber"/>
                <oer:attribute description="This column stores the concatenation of PHONE_COUNTRY_CODE, PHONE_AREA_CODE, and PHONE_NUMBER in reverse. e.g. If PHONE_COUNTRY_CODE=1, PHONE_AREA_CODE=650 and PHONE_NUMBER=5065747, this column stores 74756050561. This column is used in building an index to search on any combination of the above three columns."
                     name="TransposedPhoneNumber"/>
                <oer:attribute description="Party name associated with the contact point." name="PartyName"/>
                <oer:attribute description="Foreign key to FND_TIMEZONES_B.TIMEZONE_CODE" name="TimezoneCode"/>
                <oer:attribute description="Indicates if this is the primary contact point of this contact irrespective of the Context. Y for primary contact, N for all others."
                     name="OverallPrimaryFlag"/>
                <oer:attribute description="Contact preference associated with the phone number."
                     name="ContactPreference"/>
                <oer:attribute description="Identifier for this record from foreign or legacy system."
                     name="OriginalSystemReference"/>
                <oer:attribute description="Trading Community Phone Additional Information" name="PhoneInformation"/>
            </oer:attributes>
        </xsd:documentation>
    </xsd:annotation>
    <xsd:import namespace="http://xmlns.oracle.com/adf/svc/types/" schemaLocation="BC4JService.xsd"/>
    <xsd:import namespace="http://xmlns.oracle.com/apps/cdm/foundation/parties/partyService/" schemaLocation="OriginalSystemReference.xsd"/>
    <xsd:import namespace="http://xmlns.oracle.com/apps/cdm/foundation/parties/flex/contactPoint/"
         schemaLocation="ContactPointInformation.xsd"/>
    <xsd:import namespace="commonj.sdo/java" schemaLocation="sdoJava.xsd"/>
    <xsd:import namespace="commonj.sdo/xml" schemaLocation="sdoXML.xsd"/>
    <xsd:import namespace="commonj.sdo" schemaLocation="sdoModel.xsd"/>
    <xsd:include schemaLocation="ContactPreference.xsd"/>
    <xsd:complexType name="Phone">
        <xsd:annotation>
            <xsd:appinfo source="http://xmlns.oracle.com/adf/svc/metadata/">
                <key xmlns="http://xmlns.oracle.com/adf/svc/metadata/">
                    <attribute>ContactPointId</attribute>
                </key>
            </xsd:appinfo>
        </xsd:annotation>
        <xsd:sequence>
            <xsd:element minOccurs="0" name="ContactPointId" type="xsd:long" sdoXML:dataType="sdoJava:LongObject"/>
            <xsd:element default="PHONE" minOccurs="0" name="ContactPointType" type="xsd:string"/>
            <xsd:element minOccurs="0" name="Status" type="xsd:string"/>
            <xsd:element default="HZ_PARTIES" minOccurs="0" name="OwnerTableName" type="xsd:string"/>
            <xsd:element minOccurs="0" name="OwnerTableId" type="xsd:long" sdoXML:dataType="sdoJava:LongObject"/>
            <xsd:element minOccurs="0" name="PrimaryFlag" type="xsd:boolean" sdoXML:dataType="sdoJava:BooleanObject"/>
            <xsd:element minOccurs="0" name="OrigSystemReference" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="LastUpdateDate" type="ns0:dateTime-Timestamp"/>
            <xsd:element minOccurs="0" name="LastUpdatedBy" type="xsd:string"/>
            <xsd:element minOccurs="0" name="CreationDate" type="ns0:dateTime-Timestamp"/>
            <xsd:element minOccurs="0" name="CreatedBy" type="xsd:string"/>
            <xsd:element minOccurs="0" name="LastUpdateLogin" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="RequestId" nillable="true" type="xsd:long"/>
            <xsd:element minOccurs="0" name="ObjectVersionNumber" type="xsd:int" sdoXML:dataType="sdoJava:IntObject"/>
            <xsd:element minOccurs="0" name="CreatedByModule" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="ContactPointPurpose" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="PrimaryByPurpose" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="StartDate" type="ns0:date-Date"/>
            <xsd:element minOccurs="0" name="EndDate" type="ns0:date-Date"/>
            <xsd:element minOccurs="0" name="RelationshipId" nillable="true" type="xsd:long"/>
            <xsd:element minOccurs="0" name="PartyUsageCode" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="OrigSystem" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="PhoneCallingCalendar" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="LastContactDtTime" nillable="true" type="ns0:date-Date"/>
            <xsd:element minOccurs="0" name="PhoneAreaCode" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="PhoneCountryCode" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="PhoneNumber" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="PhoneExtension" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="PhoneLineType" type="xsd:string"/>
            <xsd:element minOccurs="0" name="RawPhoneNumber" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="PagerTypeCode" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="FormattedPhoneNumber" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="TransposedPhoneNumber" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="PartyName" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="TimezoneCode" nillable="true" type="xsd:string"/>
            <xsd:element minOccurs="0" name="OverallPrimaryFlag" type="xsd:boolean" sdoXML:dataType="sdoJava:BooleanObject"/>
            <xsd:element maxOccurs="unbounded" minOccurs="0" name="ContactPreference" type="ContactPreference"/>
            <xsd:element maxOccurs="unbounded" minOccurs="0" name="OriginalSystemReference" type="ns1:OriginalSystemReference"/>
            <xsd:element minOccurs="0" name="PhoneInformation" type="ns2:ContactPointInformation" sdoXML:dataType="sdo:DataObject"/>
        </xsd:sequence>
    </xsd:complexType>
    <xsd:element name="phone" type="Phone"/>
</xsd:schema>
