[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
| This is a part of Concurrent Requeset Set which updates the main table |
| with the data uploaded into the temporary table from flat file by the 1st|
| part of this concurrent request set. |
| |
| HISTORY |
| Who When What |
| rgangara 05-Nov-2002 Create Version as part of Small systems support|
| Enhancement (UCFD02). Bug 2643048 |
| ayedubat 09-DEC-2002 added to TO_NUMBER to err_proc_rec.error_code |
| column as error codes are numeric data. |
| Also added the update row call if record already|
| found for the bug fix: 2700307 |
| pmarada 13-Jun-2003 Removed the igs_uc_refcodetype table references |
| and removed profile references as per the |
| UCFD203-Multiple cycles, bug 2669208 |
| anwest 18-Jan-06 Bug# 4950285 R12 Disable OSS Mandate |
*==============================================================================*/
PROCEDURE imp_error_codes (
errbuf OUT NOCOPY VARCHAR2,
retcode OUT NOCOPY NUMBER
) IS
/*
|| Created By : rgangara
|| Created On : 05-Nov-2002
|| Purpose : This is main Procedure which will transfer the Error Codes data
|| from the temporary table to the main UCAS interface 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 Err_proc_cur IS
SELECT error_code,
code_text
FROM igs_uc_mv_errcd_int;
SELECT lookup_code
FROM igs_lookup_values
WHERE lookup_type = 'IGS_UC_CODE_TYPES'
AND lookup_code = 'EC';
SELECT rowid,
code_type,
code
FROM igs_uc_ref_codes
WHERE code_type = 'EC'
AND code = p_code;
igs_uc_ref_codes_pkg.Insert_Row (
X_ROWID => l_rowid,
X_CODE_TYPE => 'EC',
X_CODE => TO_NUMBER(err_proc_rec.error_code),
X_CODE_TEXT => err_proc_rec.code_text,
X_IMPORTED => 'Y',
X_MODE => 'R' );
igs_uc_ref_codes_pkg.update_row (
X_ROWID => refcodes_rec.rowid,
X_CODE_TYPE => refcodes_rec.code_type,
X_CODE => refcodes_rec.code,
X_CODE_TEXT => err_proc_rec.code_text,
X_IMPORTED => 'Y',
X_MODE => 'R' );