APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_CRFCODE_INTS

Line 6: g_error_code igs_uc_crfcode_ints.error_code%TYPE;

2: /* $Header: IGSUC67B.pls 120.2 2006/08/21 06:15:58 jbaber noship $ */
3:
4: g_success_rec_cnt NUMBER;
5: g_error_rec_cnt NUMBER;
6: g_error_code igs_uc_crfcode_ints.error_code%TYPE;
7:
8:
9: PROCEDURE process_cvrefcodes IS
10: /******************************************************************

Line 24: FROM igs_uc_crfcode_ints

20: SELECT rowid,
21: code_type,
22: code,
23: code_text
24: FROM igs_uc_crfcode_ints
25: WHERE record_status = 'N';
26:
27: CURSOR chk_code_type_cur (p_code igs_uc_crfcode_ints.code%TYPE) IS
28: SELECT 'X'

Line 27: CURSOR chk_code_type_cur (p_code igs_uc_crfcode_ints.code%TYPE) IS

23: code_text
24: FROM igs_uc_crfcode_ints
25: WHERE record_status = 'N';
26:
27: CURSOR chk_code_type_cur (p_code igs_uc_crfcode_ints.code%TYPE) IS
28: SELECT 'X'
29: FROM igs_lookup_values
30: WHERE lookup_type = 'IGS_UC_CODE_TYPES'
31: AND lookup_code = p_code

Line 166: UPDATE igs_uc_crfcode_ints

162:
163: -- update the interface table rec - record_status if successfully processed or Error Code if any error encountered
164: -- while processing the record.
165: IF g_error_code IS NOT NULL THEN
166: UPDATE igs_uc_crfcode_ints
167: SET error_code = g_error_code
168: WHERE rowid = new_crfcode_rec.rowid;
169:
170: -- log error message/meaning.

Line 176: UPDATE igs_uc_crfcode_ints

172: -- update error count
173: g_error_rec_cnt := g_error_rec_cnt + 1;
174:
175: ELSE
176: UPDATE igs_uc_crfcode_ints
177: SET record_status = 'D',
178: error_code = NULL
179: WHERE rowid = new_crfcode_rec.rowid;
180: