Oracle8i Application Developer's Guide - XML
Release 3 (8.1.7)

Part Number A86030-01

Library

Solution Area

Contents

Index

Go to previous page Go to beginning of chapter Go to next page

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>

Go to previous page Go to beginning of chapter Go to next page
Oracle
Copyright © 1996-2000, Oracle Corporation.

All Rights Reserved.

Library

Solution Area

Contents

Index