Oracle8i Application Developer's Guide - XML Release 3 (8.1.7) Part Number A86030-01 |
Library | Service | Contents | Index

B2B: How iProcurement Uses XML to Offer Multiple Catalog Products to Users, 7 of 16

## DTD: Item Information

Table 10-3 lists the DTD's ITEM information fields.

Table 10-3 DTD ITEM> Information

#####

Field | Required | COMMENT
Owner | Optional if the action is Delete; Required for other actions | Associates an item with a specific category.
Name/Value - Name | Required | Associates an item with a descriptor. The following base descriptor names are seeded by Oracle iProcurement and can be used when adding items: Description UOM Sup Part Num Mfg Part Num Sup Name Mfg Name Price // What about Long Description and Picture? Not seeded by Oracle but certainly handled specially by Requisite in the user interface
Name/Value - Value | Required | Associated value for the specified descriptor name.

Data items can be added to a category, deleted, and modified. All data items must be placed between the <DATA></DATA> tag. The identity feature (specifying a <NAME> and/or <KEY>) allows the wholesale change of values by effectively wildcarding updates. The update example below provides a method to change all items with a manufacturer Bic to Bic, Inc.

### iProcurement Example 5: DTD ITEM -- Adding Items Using <ITEM ACTION"ADD">

This is an example of adding items to the iProcurement DTD using <ITEM ACTION="ADD"> marker.

    <DATA>
       <ITEM ACTION="ADD">
    <OWNER>
    <NAME>Pens</NAME>
    </OWNER>
    <NAMEVALUE>
    <NAME>Mfg Name</NAME>
    <VALUE>Bic</VALUE>
    </NAMEVALUE>
    <NAMEVALUE>
    <NAME>Barrel Color</NAME>
    <VALUE>Blue</VALUE>
    </NAMEVALUE>
       </ITEM>

       <ITEM ACTION="ADD">
    <OWNER>
    <NAME>Pencils</NAME>
    </OWNER>
    <NAMEVALUE>
    <NAME>Mfg Name</NAME>
    <VALUE>Bic</VALUE>
    </NAMEVALUE>
       </ITEM>
    </DATA>

### iProcurement Example 6: DTD ITEM -- Deleting Items Using <ITEM ACTION="DELETE">

This is an example of deleting items from the iProcurement DTD using <ITEM ACTION="DELETE"> marker.

    <DATA>
       <ITEM ACTION="DELETE">
    <OWNER>
    <NAME>Pens</NAME>
    </OWNER>
    <NAMEVALUE>
    <NAME>Mfg Name</NAME>
    <VALUE>Bic</VALUE>
    </NAMEVALUE>   <!- -removes all items by Bic mfg from Pens - ->
    <NAMEVALUE>
    <NAME>Barrel Color</NAME>
    <VALUE>Blue</VALUE>
    </NAMEVALUE>
       </ITEM>
    </DATA>

### iProcurement Example 7: DTD ITEM -- Updating Items Using <ITEM ACTION="UPDATE")

This is an example of updating items from the iProcurement DTD using <ITEM ACTION="UPDATE"> marker.

When updating and item, the owner tag is optional. This allows for updates of multiple items with a specific value.

    <DATA>
       <-- Updating Item by Item -->
       <ITEM ACTION="UPDATE">
       <OWNER>
       <NAME>Pens</NAME>
       </OWNER>
        <NAMEVALUE>
          <NAME>Mfg Name</NAME>
          <VALUE>Bic </VALUE>
        </NAMEVALUE>
        <NAMEVALUE>
          <NAME>Barrel Color</NAME>
          <VALUE>Blue</VALUE>
        </NAMEVALUE>
        <UPDATE>
        <NAMEVALUE>
          <NAME>Mfg Name</NAME>
          <VALUE>Bic Inc.</VALUE>
        </NAMEVALUE>
        <NAMEVALUE>
          <NAME>Barrel Color</NAME>
          <VALUE>Red</VALUE>
        </NAMEVALUE>
        </UPDATE>
       </ITEM>
       <--   This section below updates items with Mfg Name= Bic -->
       <ITEM ACTION="UPDATE">
        <NAMEVALUE>
          <NAME>Mfg Name</NAME>
          <VALUE>Bic </VALUE>
        </NAMEVALUE>
       </ITEM>
    </DATA>

| Copyright © 1996-2000, Oracle Corporation. All Rights Reserved. |
Library | Service | Contents | Index