Installing Upgrading Designing Configuring Deploying Monitoring Administering Troubleshooting Reference JBI Components
Close Print View
Designing: VALIDATE
 

Classic Java CAPS

Developing Java CAPS Projects

Using SOAP Message Handlers

Creating a Runtime Environment

Designing Business Processes in the Sun Business Process Manager

Working with TCP/IP HL7 Collaborations

Developing Sun Master Indexes (Repository)

Developing Sun Master Patient Indexes

Developing OTDs for Application Adapters

Creating SAP BAPI OTDs

SAP BAPI Encoding

Date and Time Stamp Requirements

Installing SAP JCo

Creating BAPI and RFC OTDs

Relaunching BAPI and RFC OTDs

Creating a SAP ALE OTDs Wizard

SAP JCo and SAP IDoc Class Library Installation

SAP Java IDoc Class Library

Creating IDoc OTDs

Exporting the IDOC File from SAP

Saving the IDoc Description File (After 4.6)

Creating Siebel EAI OTDs

Before Creating the OTD

Creating the OTD

Creating COBOL Copybook OTDs

To create COBOL Copybook OTDs

Parsing Copybook Entries

COBOL Copybook OTD

Relaunching OTDs

To Relaunch an Existing OTD

COBOL Copybook OTD Methods

OTD Method Guidelines

Root-level Methods

Non-Root Methods

BPEL Operations

Creating an Oracle Applications OTD

Select Wizard Type

Connect To Database

Select Oracle Applications Module

Specify the OTD Name

Review Selections

Exposed Oracle Applications OTD Nodes

Staging Table Node

COUNT

DELETE

INITIALIZE

MOVE

REQUEST

REQUEST_STATUS

VALIDATE

SWIFT Alliance Gateway Adapter OTD Features

Configuration Node

Generating DTDs from PeopleTools 8.13

Generating and Publishing an XML Test Message

To generate a PeopleSoft XML message

Extracting and Viewing the XML Test Message

To view the XML message

Generating a DTD for the XML File

Creating OTDs

OTD Methods and Business Process Operations

sendMessage() method

Developing OTDs for Communication Adapters

Developing OTDs for Database Adapters

Developing OTDs for Web Server Adapters

Designing with Application Adapters

Designing with Communication Adapters

Designing with Web Server Adapters

SWIFT Integration Projects

Java EE Based Components

Designing with Sun JCA Adapters

About the TCP/IP JCA Adapter

Defining Constants and Variables

Using Database Operations

Developing Sun Master Indexes

Using the JMS JCA Wizard

Using the JAXB Wizard and Code-Seeder Pallete

VALIDATE

Description

This packaged stored procedure is used to perform the pre-validation of data in the Staging Table.

Parameters

Depends upon specific implementation. By default, it contains three input VARCHAR parameters corresponding to:

Requirements

Inside the script package, this stored procedure must have the name VALIDATE.