APPS.IGS_UC_PROC_REFERENCE_DATA dependencies on IGS_UC_REF_CODES

Line 35: CURSOR old_rfcode_cur(p_code igs_uc_ref_codes.code%TYPE, p_type igs_uc_ref_codes.code_type%TYPE) IS

31: AND lookup_code = p_code
32: AND enabled_flag = 'Y'
33: AND NVL(closed_ind, 'N') = 'N';
34:
35: CURSOR old_rfcode_cur(p_code igs_uc_ref_codes.code%TYPE, p_type igs_uc_ref_codes.code_type%TYPE) IS
36: SELECT rfc.rowid
37: FROM igs_uc_ref_codes rfc
38: WHERE code_type = p_type
39: AND code = p_code ;

Line 37: FROM igs_uc_ref_codes rfc

33: AND NVL(closed_ind, 'N') = 'N';
34:
35: CURSOR old_rfcode_cur(p_code igs_uc_ref_codes.code%TYPE, p_type igs_uc_ref_codes.code_type%TYPE) IS
36: SELECT rfc.rowid
37: FROM igs_uc_ref_codes rfc
38: WHERE code_type = p_type
39: AND code = p_code ;
40:
41: old_rfcode_rec old_rfcode_cur%ROWTYPE ;

Line 102: igs_uc_ref_codes_pkg.insert_row --IGSXI26B.pls

98:
99: IF l_rowid IS NULL THEN
100: BEGIN
101: --Insert a new record
102: igs_uc_ref_codes_pkg.insert_row --IGSXI26B.pls
103: (
104: x_rowid => l_rowid
105: ,x_code_type => new_crfcode_rec.code_type
106: ,x_code => new_crfcode_rec.code

Line 120: igs_uc_ref_codes_pkg.update_row --IGSXI26B.pls

116: END;
117:
118: ELSE /* Update the record */
119: BEGIN
120: igs_uc_ref_codes_pkg.update_row --IGSXI26B.pls
121: (
122: x_rowid => l_rowid
123: ,x_code_type => new_crfcode_rec.code_type
124: ,x_code => new_crfcode_rec.code