DBA Data[Home] [Help]

APPS.IGS_RE_VAL_SCH dependencies on IGS_GE_DATE

Line 78: v_high_dt := IGS_GE_DATE.IGSDATE('9999/01/01');

74: sch.start_dt <> p_start_dt;
75: BEGIN
76: p_message_name := NULL;
77: -- set_v_high_dt
78: v_high_dt := IGS_GE_DATE.IGSDATE('9999/01/01');
79: -- set v_end_dt to v_high_dt when p_end_dt is null
80: v_end_dt := NVL(p_end_dt, v_high_dt);
81: FOR v_sch_rec IN c_sch LOOP
82: -- check that the current date is between an existing date range.