APPS.IGS_UC_MV_IMP_DEGSUBJ dependencies on IGS_UC_REF_CODES

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

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

Line 62: FROM igs_uc_ref_codes

58:
59: -- Cursor to check whether the CODE already exists in ref codes table.
60: CURSOR refcodes_cur (p_code igs_uc_ref_codes.code%TYPE) IS
61: SELECT rowid, code
62: FROM igs_uc_ref_codes
63: WHERE code_type = 'DS'
64: AND code = p_code;
65:
66: refcode_types_rec refcode_types_cur%ROWTYPE;

Line 104: igs_uc_ref_codes_pkg.Insert_Row (

100: IF refcodes_cur%NOTFOUND THEN
101: l_rowid := NULL;
102:
103: --Call the TBH of the Reference codes table to insert a new Degree Subject.
104: igs_uc_ref_codes_pkg.Insert_Row (
105: X_ROWID => l_rowid,
106: X_CODE_TYPE => 'DS',
107: X_CODE => degsubj_proc_rec.deg_subj_code,
108: X_CODE_TEXT => degsubj_proc_rec.code_text,

Line 117: igs_uc_ref_codes_pkg.Update_Row (

113:
114: ELSE
115: l_rowid := refcodes_rec.rowid;
116: --Call the TBH of the Reference codes table to update a new Degree Subject.
117: igs_uc_ref_codes_pkg.Update_Row (
118: X_ROWID => l_rowid,
119: X_CODE_TYPE => 'DS',
120: X_CODE => degsubj_proc_rec.deg_subj_code,
121: X_CODE_TEXT => degsubj_proc_rec.code_text,