APPS.JTF_CAL_SHIFT_CONSTRUCTS_PKG dependencies on FND_API

Line 739: AND NVL(x_end_date_time, fnd_api.g_miss_date) >= NVL(dup_rec.end_time, fnd_api.g_miss_date)

735: dup_rec.shift_id = x_shift_id
736: AND (
737: (
738: x_start_date_time <= dup_rec.begin_time
739: AND NVL(x_end_date_time, fnd_api.g_miss_date) >= NVL(dup_rec.end_time, fnd_api.g_miss_date)
740: )
741: OR (x_start_date_time BETWEEN dup_rec.begin_time AND NVL(dup_rec.end_time, fnd_api.g_miss_date))
742: OR (
743: NVL(x_end_date_time, fnd_api.g_miss_date) BETWEEN dup_rec.begin_time

Line 741: OR (x_start_date_time BETWEEN dup_rec.begin_time AND NVL(dup_rec.end_time, fnd_api.g_miss_date))

737: (
738: x_start_date_time <= dup_rec.begin_time
739: AND NVL(x_end_date_time, fnd_api.g_miss_date) >= NVL(dup_rec.end_time, fnd_api.g_miss_date)
740: )
741: OR (x_start_date_time BETWEEN dup_rec.begin_time AND NVL(dup_rec.end_time, fnd_api.g_miss_date))
742: OR (
743: NVL(x_end_date_time, fnd_api.g_miss_date) BETWEEN dup_rec.begin_time
744: AND NVL(dup_rec.end_time, fnd_api.g_miss_date)
745: )

Line 743: NVL(x_end_date_time, fnd_api.g_miss_date) BETWEEN dup_rec.begin_time

739: AND NVL(x_end_date_time, fnd_api.g_miss_date) >= NVL(dup_rec.end_time, fnd_api.g_miss_date)
740: )
741: OR (x_start_date_time BETWEEN dup_rec.begin_time AND NVL(dup_rec.end_time, fnd_api.g_miss_date))
742: OR (
743: NVL(x_end_date_time, fnd_api.g_miss_date) BETWEEN dup_rec.begin_time
744: AND NVL(dup_rec.end_time, fnd_api.g_miss_date)
745: )
746: OR (
747: (x_start_date_time > dup_rec.begin_time)

Line 744: AND NVL(dup_rec.end_time, fnd_api.g_miss_date)

740: )
741: OR (x_start_date_time BETWEEN dup_rec.begin_time AND NVL(dup_rec.end_time, fnd_api.g_miss_date))
742: OR (
743: NVL(x_end_date_time, fnd_api.g_miss_date) BETWEEN dup_rec.begin_time
744: AND NVL(dup_rec.end_time, fnd_api.g_miss_date)
745: )
746: OR (
747: (x_start_date_time > dup_rec.begin_time)
748: AND (NVL(x_end_date_time, fnd_api.g_miss_date) < NVL(dup_rec.end_time, fnd_api.g_miss_date))

Line 748: AND (NVL(x_end_date_time, fnd_api.g_miss_date) < NVL(dup_rec.end_time, fnd_api.g_miss_date))

744: AND NVL(dup_rec.end_time, fnd_api.g_miss_date)
745: )
746: OR (
747: (x_start_date_time > dup_rec.begin_time)
748: AND (NVL(x_end_date_time, fnd_api.g_miss_date) < NVL(dup_rec.end_time, fnd_api.g_miss_date))
749: )
750: )
751: ) THEN
752: l_error := 0;

Line 797: AND NVL(x_end_date_time, fnd_api.g_miss_date) >= NVL(dup_rec.end_time, fnd_api.g_miss_date)

793: AND dup_rec.shift_construct_id <> x_shift_construct_id
794: AND (
795: (
796: x_start_date_time <= dup_rec.begin_time
797: AND NVL(x_end_date_time, fnd_api.g_miss_date) >= NVL(dup_rec.end_time, fnd_api.g_miss_date)
798: )
799: OR (x_start_date_time BETWEEN dup_rec.begin_time AND NVL(dup_rec.end_time, fnd_api.g_miss_date))
800: OR (
801: NVL(x_end_date_time, fnd_api.g_miss_date) BETWEEN dup_rec.begin_time

Line 799: OR (x_start_date_time BETWEEN dup_rec.begin_time AND NVL(dup_rec.end_time, fnd_api.g_miss_date))

795: (
796: x_start_date_time <= dup_rec.begin_time
797: AND NVL(x_end_date_time, fnd_api.g_miss_date) >= NVL(dup_rec.end_time, fnd_api.g_miss_date)
798: )
799: OR (x_start_date_time BETWEEN dup_rec.begin_time AND NVL(dup_rec.end_time, fnd_api.g_miss_date))
800: OR (
801: NVL(x_end_date_time, fnd_api.g_miss_date) BETWEEN dup_rec.begin_time
802: AND NVL(dup_rec.end_time, fnd_api.g_miss_date)
803: )

Line 801: NVL(x_end_date_time, fnd_api.g_miss_date) BETWEEN dup_rec.begin_time

797: AND NVL(x_end_date_time, fnd_api.g_miss_date) >= NVL(dup_rec.end_time, fnd_api.g_miss_date)
798: )
799: OR (x_start_date_time BETWEEN dup_rec.begin_time AND NVL(dup_rec.end_time, fnd_api.g_miss_date))
800: OR (
801: NVL(x_end_date_time, fnd_api.g_miss_date) BETWEEN dup_rec.begin_time
802: AND NVL(dup_rec.end_time, fnd_api.g_miss_date)
803: )
804: OR (
805: (x_start_date_time > dup_rec.begin_time)

Line 802: AND NVL(dup_rec.end_time, fnd_api.g_miss_date)

798: )
799: OR (x_start_date_time BETWEEN dup_rec.begin_time AND NVL(dup_rec.end_time, fnd_api.g_miss_date))
800: OR (
801: NVL(x_end_date_time, fnd_api.g_miss_date) BETWEEN dup_rec.begin_time
802: AND NVL(dup_rec.end_time, fnd_api.g_miss_date)
803: )
804: OR (
805: (x_start_date_time > dup_rec.begin_time)
806: AND (NVL(x_end_date_time, fnd_api.g_miss_date) < NVL(dup_rec.end_time, fnd_api.g_miss_date))

Line 806: AND (NVL(x_end_date_time, fnd_api.g_miss_date) < NVL(dup_rec.end_time, fnd_api.g_miss_date))

802: AND NVL(dup_rec.end_time, fnd_api.g_miss_date)
803: )
804: OR (
805: (x_start_date_time > dup_rec.begin_time)
806: AND (NVL(x_end_date_time, fnd_api.g_miss_date) < NVL(dup_rec.end_time, fnd_api.g_miss_date))
807: )
808: )
809: ) THEN
810: l_error := 0;