APPS.IGS_UC_MV_IMP_ERRCD dependencies on IGS_UC_REF_CODES

Line 64: CURSOR refcodes_cur (p_code igs_uc_ref_codes.code%TYPE) IS

60: WHERE lookup_type = 'IGS_UC_CODE_TYPES'
61: AND lookup_code = 'EC';
62:
63: -- Cursor to check whether the CODE already exists in ref codes table.
64: CURSOR refcodes_cur (p_code igs_uc_ref_codes.code%TYPE) IS
65: SELECT rowid,
66: code_type,
67: code
68: FROM igs_uc_ref_codes

Line 68: FROM igs_uc_ref_codes

64: CURSOR refcodes_cur (p_code igs_uc_ref_codes.code%TYPE) IS
65: SELECT rowid,
66: code_type,
67: code
68: FROM igs_uc_ref_codes
69: WHERE code_type = 'EC'
70: AND code = p_code;
71:
72: refcode_types_rec refcode_types_cur%ROWTYPE;

Line 113: igs_uc_ref_codes_pkg.Insert_Row (

109: IF refcodes_cur%NOTFOUND THEN
110: l_rowid := NULL;
111:
112: --Call the TBH of the main table to insert a new error code.
113: igs_uc_ref_codes_pkg.Insert_Row (
114: X_ROWID => l_rowid,
115: X_CODE_TYPE => 'EC',
116: X_CODE => TO_NUMBER(err_proc_rec.error_code),
117: X_CODE_TEXT => err_proc_rec.code_text,

Line 124: igs_uc_ref_codes_pkg.update_row (

120: l_success_cnt := l_success_cnt + 1;
121:
122: ELSE
123: --Call the TBH of the main table to update the existing error code.
124: igs_uc_ref_codes_pkg.update_row (
125: X_ROWID => refcodes_rec.rowid,
126: X_CODE_TYPE => refcodes_rec.code_type,
127: X_CODE => refcodes_rec.code,
128: X_CODE_TEXT => err_proc_rec.code_text,