APPS.IGS_EN_SUA_LGCY_PUB dependencies on IGS_PS_UNIT_VER

Line 476: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (

472: g_sua_status := 'INVALID';
473: END IF ;
474:
475: -- Foreign Key Validation - Check if Unit Code / Version exists.
476: IF NOT igs_ps_unit_ver_pkg.get_pk_for_validation (
477: x_unit_cd => p_sua_dtls_rec.unit_cd,
478: x_version_number => NVL ( p_sua_dtls_rec.version_number,p_unit_version_number)) THEN
479:
480: FND_MESSAGE.SET_NAME( 'IGS' , 'IGS_PS_UNITCODE_UNITVER_NE');

Line 1157: l_auditable_ind igs_ps_unit_ver.auditable_ind%TYPE := NULL ;

1153: FROM igs_ps_usec_ref
1154: WHERE uoo_id = p_uoo_id;
1155:
1156: l_sua_chg_alwd igs_ps_usec_ref.subtitle_modifiable_flag%TYPE;
1157: l_auditable_ind igs_ps_unit_ver.auditable_ind%TYPE := NULL ;
1158: l_version_number igs_as_grd_sch_grade.version_number%TYPE := 0 ;
1159: l_program_attempt_status igs_en_stdnt_ps_att.course_attempt_status%TYPE ;
1160: l_prgm_discontinued_dt igs_en_stdnt_ps_att.discontinued_dt%TYPE := NULL ;
1161: