[Home] [Help]
96:
97: CURSOR c_m_alias_val1 IS
98: SELECT TRUNC(dai.absolute_val)
99: FROM IGS_CA_DA_INST dai,
100: IGS_CA_INST ci,
101: IGS_CA_TYPE ct,
102: IGS_CA_STAT cs
103: WHERE dai.CAL_TYPE = ci.CAL_TYPE AND
104: dai.ci_sequence_number = ci.sequence_number AND
110:
111: CURSOR c_m_alias_val2 IS
112: SELECT TRUNC(dai.absolute_val)
113: FROM IGS_CA_DA_INST dai,
114: IGS_CA_INST ci,
115: IGS_CA_TYPE ct,
116: IGS_CA_STAT cs
117: WHERE dai.CAL_TYPE = ci.CAL_TYPE AND
118: dai.ci_sequence_number = ci.sequence_number AND
127: SELECT 'x'
128: FROM IGS_CA_TYPE ct
129: WHERE ct.S_CAL_CAT = cst_holiday AND
130: EXISTS (SELECT 'x'
131: FROM IGS_CA_INST ci,
132: IGS_CA_STAT cs
133: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
134: ci.CAL_STATUS = cs.CAL_STATUS AND
135: cs.s_cal_status = cst_active AND
252: SELECT TRUNC(dai2.absolute_val)
253: FROM IGS_CA_DA_INST dai1,
254: IGS_CA_DA_INST dai2,
255: IGS_CA_DA_INST_PAIR daip,
256: IGS_CA_INST ci,
257: IGS_CA_TYPE ct,
258: IGS_CA_STAT cs
259: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
260: ct.S_CAL_CAT = cst_holiday AND
275: SELECT TRUNC(dai1.absolute_val)
276: FROM IGS_CA_DA_INST dai1,
277: IGS_CA_DA_INST dai2,
278: IGS_CA_DA_INST_PAIR daip,
279: IGS_CA_INST ci,
280: IGS_CA_TYPE ct,
281: IGS_CA_STAT cs
282: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
283: ct.S_CAL_CAT = cst_holiday AND
299: SELECT 'x'
300: FROM IGS_CA_TYPE ct
301: WHERE ct.S_CAL_CAT = cst_holiday AND
302: EXISTS (SELECT 'x'
303: FROM IGS_CA_INST ci,
304: IGS_CA_STAT cs
305: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
306: ci.CAL_STATUS = cs.CAL_STATUS AND
307: cs.s_cal_status = cst_active AND
336: -- constraint does not require resolving
337: RETURN null;
338: ELSE
339: -- constraint cannot be resolved
340: RETURN ('IGS_CA_INSTBREAK_CONST_UNRSLV');
341: END IF;
342: ELSE
343: IF p_cnstrt_condition = cst_must THEN
344: IF (p_alias_val > v_max_alias_val AND
345: p_cnstrt_resolution >0 ) OR
346: (p_alias_val < v_min_alias_val AND
347: p_cnstrt_resolution <0 ) THEN
348: -- constraint cannot be resolved
349: RETURN ('IGS_CA_INSTBREAK_CONS_UNRSVLD');
350: END IF;
351: END IF;
352: v_tmp_alias_val := p_alias_val;
353: v_tmp_mod_count := p_mod_count;
373: p_cnstrt_resolution >0 ) OR
374: (v_tmp_alias_val < v_min_alias_val AND
375: p_cnstrt_resolution <0 ) THEN
376: -- constraint cannot be resolved
377: RETURN ('IGS_CA_INSTBREAK_CONS_UNRSVLD');
378: END IF;
379: v_changed := TRUE;
380: END IF;
381: END IF;
617: v_min_alias_val DATE DEFAULT NULL;
618: CURSOR c_m_alias_val IS
619: SELECT TRUNC(max(dai.absolute_val)), TRUNC(min(dai.absolute_val))
620: FROM IGS_CA_DA_INST dai,
621: IGS_CA_INST ci,
622: IGS_CA_TYPE ct,
623: IGS_CA_STAT cs
624: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
625: ct.S_CAL_CAT = cst_holiday AND
631: SELECT 'x'
632: FROM IGS_CA_TYPE ct
633: WHERE ct.S_CAL_CAT = cst_holiday AND
634: EXISTS (SELECT 'x'
635: FROM IGS_CA_INST ci,
636: IGS_CA_STAT cs
637: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
638: ci.CAL_STATUS = cs.CAL_STATUS AND
639: cs.s_cal_status = cst_active AND
740: SELECT TRUNC(MAX(dai2.absolute_val)), TRUNC(MIN(dai1.absolute_val))
741: FROM IGS_CA_DA_INST dai1,
742: IGS_CA_DA_INST dai2,
743: IGS_CA_DA_INST_PAIR daip,
744: IGS_CA_INST ci,
745: IGS_CA_TYPE ct,
746: IGS_CA_STAT cs
747: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
748: ct.S_CAL_CAT = cst_holiday AND
762: SELECT 'x'
763: FROM IGS_CA_TYPE ct
764: WHERE ct.S_CAL_CAT = cst_holiday AND
765: EXISTS (SELECT 'x'
766: FROM IGS_CA_INST ci,
767: IGS_CA_STAT cs
768: WHERE ci.CAL_TYPE = ct.CAL_TYPE AND
769: ci.CAL_STATUS = cs.CAL_STATUS AND
770: cs.s_cal_status = cst_active AND
795: -- constraint does not require resolving
796: RETURN null;
797: ELSE
798: -- constraint cannot be resolved
799: RETURN ('IGS_CA_INSTBREAK_CONST_UNRSLV');
800: END IF;
801: ELSE
802: IF p_cnstrt_condition = cst_must THEN
803: IF (p_alias_val > v_max_alias_val AND
804: p_cnstrt_resolution >0 ) OR
805: (p_alias_val < v_min_alias_val AND
806: p_cnstrt_resolution <0 ) THEN
807: -- constraint cannot be resolved
808: RETURN ('IGS_CA_INSTBREAK_CONS_UNRSVLD');
809: END IF;
810: END IF;
811: v_tmp_alias_val := p_alias_val;
812: v_tmp_mod_count := p_mod_count;
832: p_cnstrt_resolution >0 ) OR
833: (v_tmp_alias_val < v_min_alias_val AND
834: p_cnstrt_resolution <0 ) THEN
835: -- constraint cannot be resolved
836: RETURN ('IGS_CA_INSTBREAK_CONS_UNRSVLD');
837: END IF;
838: v_changed := TRUE;
839: END IF;
840: END IF;