WF Notification API Install
Written by Anil Passi   
Tuesday, 29 January 2008

#Assume apps password is bond77
#Assume Custom schema name is xxschema
#Assume Custom schema password is xxschema
xxdevenv:XXDEV$ load_wf_api.sh bond77 xxschema xxschema
Ensure you have passed SCRIPTNAME appsPassword XX_Schema_login XX_Schema_password
Hit enter if format is correct or else Control C to quit and try again

Connecting to sqlplus -s bes/bes
CREATE TABLE XX_NOTIFICATIONS_API

Table created.


Grant succeeded.

CREATE SEQUENCE XX_NOTIFICATIONS_API_S

Sequence created.


Grant succeeded.

UNIQUE INDEX XX_NOTIFICATIONS_API_U1

Index created.

CREATE TABLE XX_NOTIFICATION_QUERIES

Table created.


Grant succeeded.

CREATE SEQUENCE XX_NOTIFICATION_QUERIES_S

Sequence created.


Grant succeeded.

UNIQUE INDEX XX_NOTIFICATION_QUERIES_U1

Index created.

INDEX XX_NOTIFICATION_QUERIES_N1

Index created.

CREATE TABLE XX_NOTIFICATION_COLUMNS

Table created.


Grant succeeded.

CREATE SEQUENCE XX_NOTIFICATION_COLUMNS_S

Sequence created.


Grant succeeded.

UNIQUE INDEX XX_NOTIFICATION_COLUMNS_U1

Index created.

INDEX XX_NOTIFICATION_COLUMNS_N1

Index created.

Connecting to sqlplus -s apps/m0nk3y5

Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.


Synonym created.

PACKAGE xx_notifications_insert_pkg

Package created.

No errors.
PACKAGE BODY xx_notifications_insert_pkg

Package body created.

No errors.
PACKAGE xx_notifications_api_pkg

Package created.

PACKAGE BODY xx_notifications_api_pkg

Package body created.


Trigger created.

No errors.
Log filename    : L5681566.log


Report filename : O5681566.out
Oracle Workflow Definition Loader 2.6.4.0.

Access level: 100, Mode: FORCE

Uploaded 2 ITEM_TYPE record(s) to database.
Uploaded 38 LOOKUP_TYPE record(s) to database.
Uploaded 5 MESSAGE record(s) to database.
Uploaded 40 ACTIVITY record(s) to database.
Uploaded 0 ROLE record(s) to database.
xxdevenv:XXDEV$

Comments (0)add
You must be logged in to a comment. Please register if you do not have an account yet.

busy