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_VER_PKG dependencies on IGS_GE_DATE

Line 339: igs_ge_date.igsdate('1900/01/01')) <>

335: -- Validate IGS_PS_COURSE status and expiry date.
336: IF p_inserting OR
337: (p_updating AND
338: ((NVL(old_references.expiry_dt,
339: igs_ge_date.igsdate('1900/01/01')) <>
340: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) OR
341: (old_references.course_status <> new_references.course_status))) THEN
342: IF igs_ps_val_crv.crsp_val_crv_exp_sts (
343: new_references.course_cd,

Line 340: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) OR

336: IF p_inserting OR
337: (p_updating AND
338: ((NVL(old_references.expiry_dt,
339: igs_ge_date.igsdate('1900/01/01')) <>
340: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) OR
341: (old_references.course_status <> new_references.course_status))) THEN
342: IF igs_ps_val_crv.crsp_val_crv_exp_sts (
343: new_references.course_cd,
344: new_references.version_number,

Line 465: IF (NVL(old_references.start_dt, igs_ge_date.igsdate('1900/01/01')) <>

461: FETCH c_get_s_course_status
462: INTO v_s_course_status;
463: IF c_get_s_course_status%FOUND AND
464: (v_s_course_status = cst_inactive) THEN
465: IF (NVL(old_references.start_dt, igs_ge_date.igsdate('1900/01/01')) <>
466: NVL(new_references.start_dt, igs_ge_date.igsdate('1900/01/01'))) OR
467: (NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>
468: NVL(new_references.review_dt, igs_ge_date.igsdate('1900/01/01'))) OR
469: (old_references.title <> new_references.title) OR

Line 466: NVL(new_references.start_dt, igs_ge_date.igsdate('1900/01/01'))) OR

462: INTO v_s_course_status;
463: IF c_get_s_course_status%FOUND AND
464: (v_s_course_status = cst_inactive) THEN
465: IF (NVL(old_references.start_dt, igs_ge_date.igsdate('1900/01/01')) <>
466: NVL(new_references.start_dt, igs_ge_date.igsdate('1900/01/01'))) OR
467: (NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>
468: NVL(new_references.review_dt, igs_ge_date.igsdate('1900/01/01'))) OR
469: (old_references.title <> new_references.title) OR
470: (old_references.short_title <> new_references.short_title) OR

Line 467: (NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>

463: IF c_get_s_course_status%FOUND AND
464: (v_s_course_status = cst_inactive) THEN
465: IF (NVL(old_references.start_dt, igs_ge_date.igsdate('1900/01/01')) <>
466: NVL(new_references.start_dt, igs_ge_date.igsdate('1900/01/01'))) OR
467: (NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>
468: NVL(new_references.review_dt, igs_ge_date.igsdate('1900/01/01'))) OR
469: (old_references.title <> new_references.title) OR
470: (old_references.short_title <> new_references.short_title) OR
471: (old_references.abbreviation <> new_references.abbreviation) OR

Line 468: NVL(new_references.review_dt, igs_ge_date.igsdate('1900/01/01'))) OR

464: (v_s_course_status = cst_inactive) THEN
465: IF (NVL(old_references.start_dt, igs_ge_date.igsdate('1900/01/01')) <>
466: NVL(new_references.start_dt, igs_ge_date.igsdate('1900/01/01'))) OR
467: (NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>
468: NVL(new_references.review_dt, igs_ge_date.igsdate('1900/01/01'))) OR
469: (old_references.title <> new_references.title) OR
470: (old_references.short_title <> new_references.short_title) OR
471: (old_references.abbreviation <> new_references.abbreviation) OR
472: (old_references.supp_exam_permitted_ind <> new_references.supp_exam_permitted_ind) OR

Line 479: (NVL(old_references.responsible_ou_start_dt, igs_ge_date.igsdate('1900/01/01')) <>

475: (old_references.count_intrmsn_in_time_ind <> new_references.count_intrmsn_in_time_ind) OR
476: (old_references.intrmsn_allowed_ind <> new_references.intrmsn_allowed_ind) OR
477: (old_references.course_type <> new_references.course_type) OR
478: (old_references.responsible_org_unit_cd <> new_references.responsible_org_unit_cd) OR
479: (NVL(old_references.responsible_ou_start_dt, igs_ge_date.igsdate('1900/01/01')) <>
480: NVL(new_references.responsible_ou_start_dt, igs_ge_date.igsdate('1900/01/01'))) OR
481: (old_references.govt_special_course_type <>new_references.govt_special_course_type) OR
482: (NVL(old_references.qualification_recency,999999) <>
483: NVL(new_references.qualification_recency,999999)) OR

Line 480: NVL(new_references.responsible_ou_start_dt, igs_ge_date.igsdate('1900/01/01'))) OR

476: (old_references.intrmsn_allowed_ind <> new_references.intrmsn_allowed_ind) OR
477: (old_references.course_type <> new_references.course_type) OR
478: (old_references.responsible_org_unit_cd <> new_references.responsible_org_unit_cd) OR
479: (NVL(old_references.responsible_ou_start_dt, igs_ge_date.igsdate('1900/01/01')) <>
480: NVL(new_references.responsible_ou_start_dt, igs_ge_date.igsdate('1900/01/01'))) OR
481: (old_references.govt_special_course_type <>new_references.govt_special_course_type) OR
482: (NVL(old_references.qualification_recency,999999) <>
483: NVL(new_references.qualification_recency,999999)) OR
484: (NVL(old_references.external_adv_stnd_limit,999999) <>

Line 573: (NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>

569: -- Validate the version dates.
570: IF p_inserting OR
571: (p_updating AND (old_references.start_dt <> new_references.start_dt)) OR
572: (p_updating AND
573: (NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
574: NVL(new_references.end_dt,igs_ge_date.igsdate('1900/01/01')))) OR
575: (p_updating AND
576: (NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
577: NVL(new_references.expiry_dt,igs_ge_date.igsdate('1900/01/01')))) THEN

Line 574: NVL(new_references.end_dt,igs_ge_date.igsdate('1900/01/01')))) OR

570: IF p_inserting OR
571: (p_updating AND (old_references.start_dt <> new_references.start_dt)) OR
572: (p_updating AND
573: (NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
574: NVL(new_references.end_dt,igs_ge_date.igsdate('1900/01/01')))) OR
575: (p_updating AND
576: (NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
577: NVL(new_references.expiry_dt,igs_ge_date.igsdate('1900/01/01')))) THEN
578: /* As part of bug# 1956374 changed the following call from igs_ps_val_crv.crsp_val_ver_dt*/

Line 576: (NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>

572: (p_updating AND
573: (NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
574: NVL(new_references.end_dt,igs_ge_date.igsdate('1900/01/01')))) OR
575: (p_updating AND
576: (NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
577: NVL(new_references.expiry_dt,igs_ge_date.igsdate('1900/01/01')))) THEN
578: /* As part of bug# 1956374 changed the following call from igs_ps_val_crv.crsp_val_ver_dt*/
579: IF igs_ps_val_us.crsp_val_ver_dt (
580: new_references.start_dt,

Line 577: NVL(new_references.expiry_dt,igs_ge_date.igsdate('1900/01/01')))) THEN

573: (NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
574: NVL(new_references.end_dt,igs_ge_date.igsdate('1900/01/01')))) OR
575: (p_updating AND
576: (NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
577: NVL(new_references.expiry_dt,igs_ge_date.igsdate('1900/01/01')))) THEN
578: /* As part of bug# 1956374 changed the following call from igs_ps_val_crv.crsp_val_ver_dt*/
579: IF igs_ps_val_us.crsp_val_ver_dt (
580: new_references.start_dt,
581: new_references.end_dt,

Line 605: (NVL(old_references.responsible_ou_start_dt,igs_ge_date.igsdate('1900/01/01')) <>

601: -- Validate the responsible org IGS_PS_UNIT.
602: IF p_inserting OR
603: (p_updating AND
604: ((old_references.responsible_org_unit_cd <> new_references.responsible_org_unit_cd) OR
605: (NVL(old_references.responsible_ou_start_dt,igs_ge_date.igsdate('1900/01/01')) <>
606: NVL(new_references.responsible_ou_start_dt, igs_ge_date.igsdate('1900/01/01')))))THEN
607: IF igs_ps_val_crv.crsp_val_ou_sys_sts (
608: new_references.responsible_org_unit_cd,
609: new_references.responsible_ou_start_dt,

Line 606: NVL(new_references.responsible_ou_start_dt, igs_ge_date.igsdate('1900/01/01')))))THEN

602: IF p_inserting OR
603: (p_updating AND
604: ((old_references.responsible_org_unit_cd <> new_references.responsible_org_unit_cd) OR
605: (NVL(old_references.responsible_ou_start_dt,igs_ge_date.igsdate('1900/01/01')) <>
606: NVL(new_references.responsible_ou_start_dt, igs_ge_date.igsdate('1900/01/01')))))THEN
607: IF igs_ps_val_crv.crsp_val_ou_sys_sts (
608: new_references.responsible_org_unit_cd,
609: new_references.responsible_ou_start_dt,
610: v_message_name) = FALSE THEN

Line 619: ((NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>

615: END IF;
616: -- Validate IGS_PS_COURSE status and end date combination.
617: IF p_inserting OR
618: (p_updating AND
619: ((NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
620: NVL(new_references.end_dt,igs_ge_date.igsdate('1900/01/01'))) OR
621: (old_references.course_status <> new_references.course_status))) THEN
622: IF igs_ps_val_crv.crsp_val_crv_end_sts(
623: new_references.end_dt,

Line 620: NVL(new_references.end_dt,igs_ge_date.igsdate('1900/01/01'))) OR

616: -- Validate IGS_PS_COURSE status and end date combination.
617: IF p_inserting OR
618: (p_updating AND
619: ((NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
620: NVL(new_references.end_dt,igs_ge_date.igsdate('1900/01/01'))) OR
621: (old_references.course_status <> new_references.course_status))) THEN
622: IF igs_ps_val_crv.crsp_val_crv_end_sts(
623: new_references.end_dt,
624: new_references.course_status,

Line 669: NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>

665: NVL(old_references.num_of_units_before_intrmsn,999999) <>
666: NVL(new_references.num_of_units_before_intrmsn,999999) OR
667: NVL(old_references.min_sbmsn_percentage,999999) <>
668: NVL(new_references.min_sbmsn_percentage,999999) OR
669: NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>
670: NVL(new_references.review_dt,igs_ge_date.igsdate('1900/01/01')) OR
671: NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
672: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) OR
673: NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>

Line 670: NVL(new_references.review_dt,igs_ge_date.igsdate('1900/01/01')) OR

666: NVL(new_references.num_of_units_before_intrmsn,999999) OR
667: NVL(old_references.min_sbmsn_percentage,999999) <>
668: NVL(new_references.min_sbmsn_percentage,999999) OR
669: NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>
670: NVL(new_references.review_dt,igs_ge_date.igsdate('1900/01/01')) OR
671: NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
672: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) OR
673: NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
674: NVL(new_references.end_dt, igs_ge_date.igsdate('1900/01/01')) OR

Line 671: NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>

667: NVL(old_references.min_sbmsn_percentage,999999) <>
668: NVL(new_references.min_sbmsn_percentage,999999) OR
669: NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>
670: NVL(new_references.review_dt,igs_ge_date.igsdate('1900/01/01')) OR
671: NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
672: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) OR
673: NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
674: NVL(new_references.end_dt, igs_ge_date.igsdate('1900/01/01')) OR
675: (NVL(old_references.min_cp_per_calendar,999999) <>

Line 672: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) OR

668: NVL(new_references.min_sbmsn_percentage,999999) OR
669: NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>
670: NVL(new_references.review_dt,igs_ge_date.igsdate('1900/01/01')) OR
671: NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
672: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) OR
673: NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
674: NVL(new_references.end_dt, igs_ge_date.igsdate('1900/01/01')) OR
675: (NVL(old_references.min_cp_per_calendar,999999) <>
676: NVL(new_references.min_cp_per_calendar,999999)) OR

Line 673: NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>

669: NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>
670: NVL(new_references.review_dt,igs_ge_date.igsdate('1900/01/01')) OR
671: NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
672: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) OR
673: NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
674: NVL(new_references.end_dt, igs_ge_date.igsdate('1900/01/01')) OR
675: (NVL(old_references.min_cp_per_calendar,999999) <>
676: NVL(new_references.min_cp_per_calendar,999999)) OR
677: (NVL(old_references.approval_date, igs_ge_date.igsdate('1900/01/01')) <>

Line 674: NVL(new_references.end_dt, igs_ge_date.igsdate('1900/01/01')) OR

670: NVL(new_references.review_dt,igs_ge_date.igsdate('1900/01/01')) OR
671: NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
672: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) OR
673: NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
674: NVL(new_references.end_dt, igs_ge_date.igsdate('1900/01/01')) OR
675: (NVL(old_references.min_cp_per_calendar,999999) <>
676: NVL(new_references.min_cp_per_calendar,999999)) OR
677: (NVL(old_references.approval_date, igs_ge_date.igsdate('1900/01/01')) <>
678: NVL(new_references.approval_date,igs_ge_date.igsdate('1900/01/01'))) OR

Line 677: (NVL(old_references.approval_date, igs_ge_date.igsdate('1900/01/01')) <>

673: NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
674: NVL(new_references.end_dt, igs_ge_date.igsdate('1900/01/01')) OR
675: (NVL(old_references.min_cp_per_calendar,999999) <>
676: NVL(new_references.min_cp_per_calendar,999999)) OR
677: (NVL(old_references.approval_date, igs_ge_date.igsdate('1900/01/01')) <>
678: NVL(new_references.approval_date,igs_ge_date.igsdate('1900/01/01'))) OR
679: (NVL(old_references.external_approval_date, igs_ge_date.igsdate('1900/01/01')) <>
680: NVL(new_references.external_approval_date, igs_ge_date.igsdate('1900/01/01'))) OR
681: (old_references.federal_financial_aid <> new_references.federal_financial_aid) OR

Line 678: NVL(new_references.approval_date,igs_ge_date.igsdate('1900/01/01'))) OR

674: NVL(new_references.end_dt, igs_ge_date.igsdate('1900/01/01')) OR
675: (NVL(old_references.min_cp_per_calendar,999999) <>
676: NVL(new_references.min_cp_per_calendar,999999)) OR
677: (NVL(old_references.approval_date, igs_ge_date.igsdate('1900/01/01')) <>
678: NVL(new_references.approval_date,igs_ge_date.igsdate('1900/01/01'))) OR
679: (NVL(old_references.external_approval_date, igs_ge_date.igsdate('1900/01/01')) <>
680: NVL(new_references.external_approval_date, igs_ge_date.igsdate('1900/01/01'))) OR
681: (old_references.federal_financial_aid <> new_references.federal_financial_aid) OR
682: (old_references.institutional_financial_aid <> new_references.institutional_financial_aid) OR

Line 679: (NVL(old_references.external_approval_date, igs_ge_date.igsdate('1900/01/01')) <>

675: (NVL(old_references.min_cp_per_calendar,999999) <>
676: NVL(new_references.min_cp_per_calendar,999999)) OR
677: (NVL(old_references.approval_date, igs_ge_date.igsdate('1900/01/01')) <>
678: NVL(new_references.approval_date,igs_ge_date.igsdate('1900/01/01'))) OR
679: (NVL(old_references.external_approval_date, igs_ge_date.igsdate('1900/01/01')) <>
680: NVL(new_references.external_approval_date, igs_ge_date.igsdate('1900/01/01'))) OR
681: (old_references.federal_financial_aid <> new_references.federal_financial_aid) OR
682: (old_references.institutional_financial_aid <> new_references.institutional_financial_aid) OR
683: (NVL(old_references.max_cp_per_teaching_period,999999) <>

Line 680: NVL(new_references.external_approval_date, igs_ge_date.igsdate('1900/01/01'))) OR

676: NVL(new_references.min_cp_per_calendar,999999)) OR
677: (NVL(old_references.approval_date, igs_ge_date.igsdate('1900/01/01')) <>
678: NVL(new_references.approval_date,igs_ge_date.igsdate('1900/01/01'))) OR
679: (NVL(old_references.external_approval_date, igs_ge_date.igsdate('1900/01/01')) <>
680: NVL(new_references.external_approval_date, igs_ge_date.igsdate('1900/01/01'))) OR
681: (old_references.federal_financial_aid <> new_references.federal_financial_aid) OR
682: (old_references.institutional_financial_aid <> new_references.institutional_financial_aid) OR
683: (NVL(old_references.max_cp_per_teaching_period,999999) <>
684: NVL(new_references.max_cp_per_teaching_period,999999)) OR

Line 695: IF (NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>

691: NVL(new_references.max_wlst_per_stud,999999) OR
692: NVL(old_references.annual_instruction_time,999999) <>
693: NVL(new_references.annual_instruction_time,999999)
694: THEN
695: IF (NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>
696: NVL(new_references.review_dt,igs_ge_date.igsdate('1900/01/01'))) THEN
697: v_review_dt := old_references.review_dt;
698: END IF;
699: IF (NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>

Line 696: NVL(new_references.review_dt,igs_ge_date.igsdate('1900/01/01'))) THEN

692: NVL(old_references.annual_instruction_time,999999) <>
693: NVL(new_references.annual_instruction_time,999999)
694: THEN
695: IF (NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>
696: NVL(new_references.review_dt,igs_ge_date.igsdate('1900/01/01'))) THEN
697: v_review_dt := old_references.review_dt;
698: END IF;
699: IF (NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
700: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) THEN

Line 699: IF (NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>

695: IF (NVL(old_references.review_dt, igs_ge_date.igsdate('1900/01/01')) <>
696: NVL(new_references.review_dt,igs_ge_date.igsdate('1900/01/01'))) THEN
697: v_review_dt := old_references.review_dt;
698: END IF;
699: IF (NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
700: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) THEN
701: v_expiry_dt := old_references.expiry_dt;
702: END IF;
703: IF (NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>

Line 700: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) THEN

696: NVL(new_references.review_dt,igs_ge_date.igsdate('1900/01/01'))) THEN
697: v_review_dt := old_references.review_dt;
698: END IF;
699: IF (NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
700: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) THEN
701: v_expiry_dt := old_references.expiry_dt;
702: END IF;
703: IF (NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
704: NVL(new_references.end_dt, igs_ge_date.igsdate('1900/01/01'))) THEN

Line 703: IF (NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>

699: IF (NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
700: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) THEN
701: v_expiry_dt := old_references.expiry_dt;
702: END IF;
703: IF (NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
704: NVL(new_references.end_dt, igs_ge_date.igsdate('1900/01/01'))) THEN
705: v_end_dt := old_references.end_dt;
706: END IF;
707: -- Use decode to compare the new and old values, and if they have changed

Line 704: NVL(new_references.end_dt, igs_ge_date.igsdate('1900/01/01'))) THEN

700: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) THEN
701: v_expiry_dt := old_references.expiry_dt;
702: END IF;
703: IF (NVL(old_references.end_dt, igs_ge_date.igsdate('1900/01/01')) <>
704: NVL(new_references.end_dt, igs_ge_date.igsdate('1900/01/01'))) THEN
705: v_end_dt := old_references.end_dt;
706: END IF;
707: -- Use decode to compare the new and old values, and if they have changed
708: -- put the old value in the variable to be passed to the history routine.

Line 968: ((NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>

964:
965: -- Validate IGS_PS_COURSE status and expiry date.
966: IF p_inserting OR
967: (p_updating AND
968: ((NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
969: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) OR
970: (old_references.course_status <> new_references.course_status))) THEN
971: -- Cannot call crsp_val_crv_exp_sts because trigger will be mutating.
972: -- Save the rowid of the current row.

Line 969: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) OR

965: -- Validate IGS_PS_COURSE status and expiry date.
966: IF p_inserting OR
967: (p_updating AND
968: ((NVL(old_references.expiry_dt, igs_ge_date.igsdate('1900/01/01')) <>
969: NVL(new_references.expiry_dt, igs_ge_date.igsdate('1900/01/01'))) OR
970: (old_references.course_status <> new_references.course_status))) THEN
971: -- Cannot call crsp_val_crv_exp_sts because trigger will be mutating.
972: -- Save the rowid of the current row.
973: rowvalmutation(