[Home] [Help]
38: SMADATHI 25-MAY-2001 removed foreign key references to IGS_PS_USEC_RPT_FMLY as per DLD (Enhancement Bug No. 1775394). Also added validation for Curriculum Id*/
39: -- rgangara 03-May-2001 added two Columns ss_enrol_ind and ivr_enrol_ind as per DLD Unit Section Enrollment Info.
40: -- cdcruz 31-Jan-2002 added Two new columns anon_unit_grading_ind/anon_assess_grading_ind added to base table
41: -- as per DLD Anonymous Grading Bug 2198374
42: -- smvk 16-Dec-2002 Function Call IGS_PS_VAL_US.crsp_val_ver_dt,IGS_PS_VAL_UV.crsp_val_uv_pnt_ovrd and IGS_PS_VAL_UV.crsp_val_uv_unit_sts
43: -- are modified with additional parameter value 'FALSE'. for Bug # 2696207
44: -- smvk 19-Dec-2002 Removed the OWNER_ORG_UNIT_CD checking for upper case
45: -- from check_constraints procedure. Bug # 2487149
46: -- smaddali 21-jan-04 Modified procedure Check_Child_Existance , to remove cursor c_hesa and call igs_he_st_unt_vs_all_pkg.get_fk_igs_ps_unit_ver_all
696: (p_updating AND
697: NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
698: NVL(new_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
699: -- As part of the bug# 1956374 changed to the below call from IGS_PS_VAL_UV.crsp_val_ver_dt (
700: IF IGS_PS_VAL_US.crsp_val_ver_dt (
701: new_references.start_dt,
702: new_references.end_dt,
703: new_references.expiry_dt,v_message_name,FALSE) = FALSE THEN
704: Fnd_Message.Set_Name('IGS',v_message_name);