---------------------- 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