The following lines contain the word 'select', 'insert', 'update' or 'delete':
| This is a part of Concurrent Requeset Set which updates the Insittutions |
| table with the Institutions data uploaded into the temporary table |
| from flat file by the SQL Ldr part of this concurrent request set |
| |
| HISTORY |
| Who When What |
| rgangara 05-Nov-2002 Create Version as part of Small systems support |
| Enhancement. UCFD02. Enh Bug# 2643048 |
| pmarada 13-jun-2003 Obsoleted the datetimestamp column references from the |
| object, removed the profile references as per UCFD203 |
| Multiple cycle build, bug 2669208 |
| anwest 18-Jan-06 Bug# 4950285 R12 Disable OSS Mandate |
*==============================================================================*/
PROCEDURE Import_Inst_codes (
errbuf OUT NOCOPY VARCHAR2,
retcode OUT NOCOPY NUMBER ,
p_system_code IN VARCHAR2
) IS
/*
|| Created By : rgangara
|| Created On : 05-Nov-2002
|| Purpose : This is main Procedure which will transfer the Institutions data
|| from the temporary table to the UCAS Institutions table.
|| Known limitations, enhancements or remarks :
|| Change History :
|| Who When What
|| anwest 18-JAN-2006 Bug# 4950285 R12 Disable OSS Mandate
|| (reverse chronological order - newest change first)
*/
-- Declare all the local variables, cursors
-- Cursor to pick records from temp table to be processed.
CURSOR inst_int_cur IS
SELECT inst,
inst_code,
inst_name
FROM igs_uc_mv_inst_int;
SELECT rowid ,
inst ,
inst_code ,
inst_name ,
ucas ,
gttr ,
swas ,
nmas ,
imported
FROM igs_uc_com_inst
WHERE inst = p_inst;
fnd_message.set_token('IMPORT', 'INSERTING ');
igs_uc_com_inst_pkg.Insert_Row (
x_rowid => l_rowid,
x_inst => inst_int_rec.inst,
x_inst_code => inst_int_rec.inst_code,
x_inst_name => inst_int_rec.inst_name,
x_ucas => l_ucas,
x_gttr => l_gttr,
x_swas => l_swas,
x_nmas => l_nmas,
x_imported => 'Y',
x_mode => 'R'
);
igs_uc_com_inst_pkg.Update_Row (
x_rowid => l_rowid,
x_inst => instcodes_rec.inst,
x_inst_code => inst_int_rec.inst_code,
x_inst_name => inst_int_rec.inst_name,
x_ucas => l_ucas,
x_gttr => l_gttr,
x_swas => l_swas,
x_nmas => l_nmas,
x_imported => 'Y',
x_mode => 'R'
);