C and PL/SQL programs that manage the Oracle data loads

---------------------- Forwarded by Robin Rodrigue/HOU/ECT on 11/03/2000
02:13 PM ---------------------------

Enron North America Corp.

From: Frank Hayden @ ENRON 11/03/2000 08:51 AM

To: Robin Rodrigue/HOU/ECT@ECT, Bilal Bajwa/NA/Enron@Enron
cc:
Subject: C and PL/SQL programs that manage the Oracle data loads

---------------------- Forwarded by Frank Hayden/Corp/Enron on 11/03/2000
08:54 AM ---------------------------

From: Frank Hayden 08/26/2000 03:58 PM

To: bilal_bajwa@hotmail.com
cc:

Subject: C and PL/SQL programs that manage the Oracle data loads

---------------------- Forwarded by Frank Hayden/Corp/Enron on 08/26/2000
03:55 PM ---------------------------

Ganapathy Ramesh@ECT
08/26/2000 03:13 PM
To: Frank Hayden/Corp/Enron@Enron
cc:

Subject: C and PL/SQL programs that manage the Oracle data loads

Frank,
Please find enclosed the PL/SQL scripts that are called from the two C
programs below. The ERMS packages handle all of ERMS positions, with specific
handling of Canadian and Intra month positions. The power package handles all
of ENPOWER databases(Australia, Europe and US) and EXPOWER(US only). The
spreadsheet handling is an entirely different process which specifically
handles text files extracted from spreadsheets.

The 'C' programs control the calls to the PL/SQL packages. The ERMS package
also decides on the strip flag for intra month positions.

Regards,
Ramesh