APPS.IGS_PS_UNIT_LGCY_PKG dependencies on IGS_PS_UNIT_STAT

Line 893: IF (NOT igs_ps_unit_stat_pkg.get_pk_for_validation(p_unit_ver_rec.unit_status)) THEN

889: END IF;
890:
891:
892: --Fk validations
893: IF (NOT igs_ps_unit_stat_pkg.get_pk_for_validation(p_unit_ver_rec.unit_status)) THEN
894: igs_ps_validate_lgcy_pkg.set_msg('IGS_PS_LGCY_REC_NOT_EXISTS','UNIT_STATUS','LEGACY_TOKENS',FALSE);
895: p_unit_ver_rec.status:='E';
896: END IF;
897:

Line 2291: CURSOR c_unit_status (cp_c_unit_status IN igs_ps_unit_stat.unit_status%TYPE) IS

2287: Change History (in reverse chronological order)
2288: Who When What
2289: ********************************************************************************************* */
2290:
2291: CURSOR c_unit_status (cp_c_unit_status IN igs_ps_unit_stat.unit_status%TYPE) IS
2292: SELECT s_unit_status
2293: FROM igs_ps_unit_stat
2294: WHERE unit_status = cp_c_unit_status;
2295:

Line 2293: FROM igs_ps_unit_stat

2289: ********************************************************************************************* */
2290:
2291: CURSOR c_unit_status (cp_c_unit_status IN igs_ps_unit_stat.unit_status%TYPE) IS
2292: SELECT s_unit_status
2293: FROM igs_ps_unit_stat
2294: WHERE unit_status = cp_c_unit_status;
2295:
2296: rec_unit_status c_unit_status%ROWTYPE;
2297: l_c_message VARCHAR2(30);