APPS.IGS_PS_GEN_008 dependencies on IGS_EN_UNIT_SET_NOTE

Line 154: FROM IGS_EN_UNIT_SET_NOTE usn

150: -- i.e. must be copied manually
151: CURSOR c_usn IS
152: SELECT usn.reference_number,
153: usn.crs_note_type
154: FROM IGS_EN_UNIT_SET_NOTE usn
155: WHERE usn.unit_set_cd = p_old_unit_set_cd AND
156: usn.version_number = p_old_version_number AND
157: EXISTS (
158: SELECT 'x'

Line 173: IGS_EN_UNIT_SET_NOTE_PKG.Insert_Row(

169: v_new_ref_no := v_new_ref_number;
170: END IF;
171: BEGIN
172: x_rowid := NULL;
173: IGS_EN_UNIT_SET_NOTE_PKG.Insert_Row(
174: X_ROWID => x_rowid,
175: X_UNIT_SET_CD => p_new_unit_set_cd,
176: X_VERSION_NUMBER => p_new_version_number,
177: X_REFERENCE_NUMBER => v_new_ref_no,

Line 574: -- Check if the IGS_EN_UNIT_SET_NOTE record exists for the old IGS_PS_UNIT

570: -- indicates that the exception is user defined
571: -- one of the validation routines within the system).
572: -- If not within this range, it will be raised by
573: -- standard exception handling.
574: -- Check if the IGS_EN_UNIT_SET_NOTE record exists for the old IGS_PS_UNIT
575: -- code and version number. If so, create the new record
576: -- with the substituted values.
577: crspl_unit_set_note;
578: --- Check if the IGS_EN_UNITSETPSTYPE record exists for