eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.IGS_PS_UNIT_VER_PKG dependencies on IGS_GE_DATE

Line 607: IF (NVL(old_references.start_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) <>

603: OPEN c_get_s_unit_status;
604: FETCH c_get_s_unit_status
605: INTO v_s_unit_status;
606: IF c_get_s_unit_status%FOUND AND (v_s_unit_status ='INACTIVE') THEN
607: IF (NVL(old_references.start_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) <>
608: (NVL(new_references.start_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))OR
609: (NVL(old_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))<>
610: (NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
611: (old_references.title <> new_references.title) OR

Line 608: (NVL(new_references.start_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))OR

604: FETCH c_get_s_unit_status
605: INTO v_s_unit_status;
606: IF c_get_s_unit_status%FOUND AND (v_s_unit_status ='INACTIVE') THEN
607: IF (NVL(old_references.start_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) <>
608: (NVL(new_references.start_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))OR
609: (NVL(old_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))<>
610: (NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
611: (old_references.title <> new_references.title) OR
612: (old_references.short_title <> new_references.short_title) OR

Line 609: (NVL(old_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))<>

605: INTO v_s_unit_status;
606: IF c_get_s_unit_status%FOUND AND (v_s_unit_status ='INACTIVE') THEN
607: IF (NVL(old_references.start_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) <>
608: (NVL(new_references.start_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))OR
609: (NVL(old_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))<>
610: (NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
611: (old_references.title <> new_references.title) OR
612: (old_references.short_title <> new_references.short_title) OR
613: (old_references.title_override_ind <> new_references.title_override_ind) OR

Line 610: (NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR

606: IF c_get_s_unit_status%FOUND AND (v_s_unit_status ='INACTIVE') THEN
607: IF (NVL(old_references.start_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) <>
608: (NVL(new_references.start_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))OR
609: (NVL(old_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))<>
610: (NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
611: (old_references.title <> new_references.title) OR
612: (old_references.short_title <> new_references.short_title) OR
613: (old_references.title_override_ind <> new_references.title_override_ind) OR
614: (old_references.abbreviation <> new_references.abbreviation) OR

Line 623: (NVL(old_references.owner_ou_start_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>

619: (old_references.award_course_only_ind <> new_references.award_course_only_ind) OR
620: (old_references.research_unit_ind <> new_references.research_unit_ind) OR
621: (old_references.industrial_ind <> new_references.industrial_ind) OR
622: (old_references.owner_org_unit_cd <> new_references.owner_org_unit_cd) OR
623: (NVL(old_references.owner_ou_start_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
624: NVL(new_references.owner_ou_start_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
625: (old_references.practical_ind <>new_references.practical_ind) OR
626: (old_references.repeatable_ind <>new_references.repeatable_ind) OR
627: (old_references.assessable_ind <>new_references.assessable_ind) OR

Line 624: NVL(new_references.owner_ou_start_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR

620: (old_references.research_unit_ind <> new_references.research_unit_ind) OR
621: (old_references.industrial_ind <> new_references.industrial_ind) OR
622: (old_references.owner_org_unit_cd <> new_references.owner_org_unit_cd) OR
623: (NVL(old_references.owner_ou_start_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
624: NVL(new_references.owner_ou_start_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
625: (old_references.practical_ind <>new_references.practical_ind) OR
626: (old_references.repeatable_ind <>new_references.repeatable_ind) OR
627: (old_references.assessable_ind <>new_references.assessable_ind) OR
628: (NVL(old_references.enrolled_credit_points,999999) <>

Line 694: (NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))<>

690: IF p_inserting OR
691: (p_updating AND
692: (old_references.start_dt <> new_references.start_dt)) OR
693: (p_updating AND
694: (NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))<>
695: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))) OR
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

Line 695: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))) OR

691: (p_updating AND
692: (old_references.start_dt <> new_references.start_dt)) OR
693: (p_updating AND
694: (NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))<>
695: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))) OR
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 (

Line 697: NVL(old_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

693: (p_updating AND
694: (NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))<>
695: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))) OR
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,

Line 698: NVL(new_references.expiry_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

694: (NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))<>
695: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')))) OR
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,

Line 738: ((NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>

734: END IF;
735: -- Validate IGS_PS_UNIT status and end date combination.
736: IF p_inserting OR
737: (p_updating AND
738: ((NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
739: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
740: (old_references.unit_status <> new_references.unit_status))) THEN
741: IF IGS_PS_VAL_UV.crsp_val_uv_end_sts(
742: new_references.end_dt,

Line 739: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR

735: -- Validate IGS_PS_UNIT status and end date combination.
736: IF p_inserting OR
737: (p_updating AND
738: ((NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
739: NVL(new_references.end_dt, IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
740: (old_references.unit_status <> new_references.unit_status))) THEN
741: IF IGS_PS_VAL_UV.crsp_val_uv_end_sts(
742: new_references.end_dt,
743: new_references.unit_status,v_message_name) = FALSE THEN

Line 839: NVL(old_references.review_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>

835: old_references.repeatable_ind <> new_references.repeatable_ind OR
836: old_references.assessable_ind <> new_references.assessable_ind OR
837: NVL(old_references.unit_int_course_leveL_cd,'null') <>
838: NVL(new_references.unit_int_course_level_cd,'null') OR
839: NVL(old_references.review_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
840: NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
841: NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
842: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
843: NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>

Line 840: NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR

836: old_references.assessable_ind <> new_references.assessable_ind OR
837: NVL(old_references.unit_int_course_leveL_cd,'null') <>
838: NVL(new_references.unit_int_course_level_cd,'null') OR
839: NVL(old_references.review_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
840: NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
841: NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
842: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
843: NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
844: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR

Line 841: NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>

837: NVL(old_references.unit_int_course_leveL_cd,'null') <>
838: NVL(new_references.unit_int_course_level_cd,'null') OR
839: NVL(old_references.review_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
840: NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
841: NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
842: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
843: NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
844: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
845:

Line 842: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR

838: NVL(new_references.unit_int_course_level_cd,'null') OR
839: NVL(old_references.review_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
840: NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
841: NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
842: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
843: NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
844: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
845:
846: --ADded as per DLD Unit Section Enrollment 03-May-01

Line 843: NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>

839: NVL(old_references.review_dt, IGS_GE_DATE.IGSDATE('1900/01/01')) <>
840: NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
841: NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
842: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
843: NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
844: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
845:
846: --ADded as per DLD Unit Section Enrollment 03-May-01
847: NVL(old_references.ss_enrol_ind,'N') <> NVL(new_references.ss_enrol_ind,'N') OR

Line 844: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR

840: NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
841: NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
842: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
843: NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
844: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
845:
846: --ADded as per DLD Unit Section Enrollment 03-May-01
847: NVL(old_references.ss_enrol_ind,'N') <> NVL(new_references.ss_enrol_ind,'N') OR
848: NVL(new_references.ivr_enrol_ind,'N') <> NVL(new_references.ivr_enrol_ind,'N') OR

Line 852: NVL(old_references.approval_date, IGS_GE_DATE.IGSDATE('1900/01/01'))

848: NVL(new_references.ivr_enrol_ind,'N') <> NVL(new_references.ivr_enrol_ind,'N') OR
849: --
850: --Added as per DLD PSP001-US by rbezawad on 24-May-2001
851: NVL(old_references.advance_maximum,999999) <> NVL(new_references.advance_maximum,999999) OR
852: NVL(old_references.approval_date, IGS_GE_DATE.IGSDATE('1900/01/01'))
853: <> NVL(new_references.approval_date,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
854: NVL(old_references.cal_type_enrol_load_cal,'null')
855: <> NVL(new_references.cal_type_enrol_load_cal,'null') OR
856: NVL(old_references.cal_type_offer_load_cal,'null')

Line 853: <> NVL(new_references.approval_date,IGS_GE_DATE.IGSDATE('1900/01/01')) OR

849: --
850: --Added as per DLD PSP001-US by rbezawad on 24-May-2001
851: NVL(old_references.advance_maximum,999999) <> NVL(new_references.advance_maximum,999999) OR
852: NVL(old_references.approval_date, IGS_GE_DATE.IGSDATE('1900/01/01'))
853: <> NVL(new_references.approval_date,IGS_GE_DATE.IGSDATE('1900/01/01')) OR
854: NVL(old_references.cal_type_enrol_load_cal,'null')
855: <> NVL(new_references.cal_type_enrol_load_cal,'null') OR
856: NVL(old_references.cal_type_offer_load_cal,'null')
857: <> NVL(new_references.cal_type_offer_load_cal,'null') OR

Line 931: IF (NVL(old_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))<>

927: NVL(old_references.workload_val_code,'UNSET') <> NVL(new_references.workload_val_code,'UNSET')
928: THEN
929: --
930:
931: IF (NVL(old_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))<>
932: NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
933: v_review_dt := old_references.review_dt;
934: END IF;
935: IF (NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>

Line 932: NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

928: THEN
929: --
930:
931: IF (NVL(old_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))<>
932: NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
933: v_review_dt := old_references.review_dt;
934: END IF;
935: IF (NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
936: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

Line 935: IF (NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>

931: IF (NVL(old_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))<>
932: NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
933: v_review_dt := old_references.review_dt;
934: END IF;
935: IF (NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
936: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
937: v_expiry_dt := old_references.expiry_dt;
938: END IF;
939: IF (NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>

Line 936: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

932: NVL(new_references.review_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
933: v_review_dt := old_references.review_dt;
934: END IF;
935: IF (NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
936: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
937: v_expiry_dt := old_references.expiry_dt;
938: END IF;
939: IF (NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
940: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

Line 939: IF (NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>

935: IF (NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
936: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
937: v_expiry_dt := old_references.expiry_dt;
938: END IF;
939: IF (NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
940: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
941: v_end_dt := old_references.end_dt;
942: END IF;
943: --

Line 940: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN

936: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
937: v_expiry_dt := old_references.expiry_dt;
938: END IF;
939: IF (NVL(old_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
940: NVL(new_references.end_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) THEN
941: v_end_dt := old_references.end_dt;
942: END IF;
943: --
944: IF NVL(old_references.ss_enrol_ind,'N') <> NVL(new_references.ss_enrol_ind,'N') THEN

Line 1010: DECODE( NVL(old_references.approval_date, IGS_GE_DATE.IGSDATE('1900/01/01')),

1006: -- Added by rbezawad as per DLD PSP001-US on 24-May-2001
1007: DECODE( NVL(old_references.advance_maximum,999999),
1008: NVL(new_references.advance_maximum,999999),
1009: NULL, old_references.advance_maximum),
1010: DECODE( NVL(old_references.approval_date, IGS_GE_DATE.IGSDATE('1900/01/01')),
1011: NVL(new_references.approval_date,IGS_GE_DATE.IGSDATE('1900/01/01')) ,
1012: NULL, old_references.approval_date),
1013: DECODE( NVL(old_references.cal_type_enrol_load_cal,'null'),
1014: NVL(new_references.cal_type_enrol_load_cal,'null') ,

Line 1011: NVL(new_references.approval_date,IGS_GE_DATE.IGSDATE('1900/01/01')) ,

1007: DECODE( NVL(old_references.advance_maximum,999999),
1008: NVL(new_references.advance_maximum,999999),
1009: NULL, old_references.advance_maximum),
1010: DECODE( NVL(old_references.approval_date, IGS_GE_DATE.IGSDATE('1900/01/01')),
1011: NVL(new_references.approval_date,IGS_GE_DATE.IGSDATE('1900/01/01')) ,
1012: NULL, old_references.approval_date),
1013: DECODE( NVL(old_references.cal_type_enrol_load_cal,'null'),
1014: NVL(new_references.cal_type_enrol_load_cal,'null') ,
1015: NULL, old_references.cal_type_enrol_load_cal),

Line 1353: ((NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>

1349: cst_active := 'ACTIVE';
1350: -- Validate IGS_PS_UNIT status and expiry date.
1351: IF p_inserting OR
1352: (p_updating AND
1353: ((NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1354: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1355: (old_references.unit_status <> new_references.unit_status))) THEN
1356:
1357: v_rowid_saved:= TRUE;

Line 1354: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR

1350: -- Validate IGS_PS_UNIT status and expiry date.
1351: IF p_inserting OR
1352: (p_updating AND
1353: ((NVL(old_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1354: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1355: (old_references.unit_status <> new_references.unit_status))) THEN
1356:
1357: v_rowid_saved:= TRUE;
1358:

Line 1381: IGS_GE_DATE.IGSDATE('1900/01/01')) <>

1377: -- Validate IGS_PS_UNIT status and expiry date.
1378: IF p_inserting OR
1379: (p_updating AND
1380: ((NVL(old_references.expiry_dt,
1381: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1382: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1383: (old_references.unit_status <> new_references.unit_status))) THEN
1384: IF IGS_PS_VAL_UV.crsp_val_uv_exp_sts (
1385: new_references.unit_cd,

Line 1382: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR

1378: IF p_inserting OR
1379: (p_updating AND
1380: ((NVL(old_references.expiry_dt,
1381: IGS_GE_DATE.IGSDATE('1900/01/01')) <>
1382: NVL(new_references.expiry_dt,IGS_GE_DATE.IGSDATE('1900/01/01'))) OR
1383: (old_references.unit_status <> new_references.unit_status))) THEN
1384: IF IGS_PS_VAL_UV.crsp_val_uv_exp_sts (
1385: new_references.unit_cd,
1386: new_references.version_number,