APPS.RLM_VALIDATEDEMAND_SV dependencies on RLM_SCHEDULE_HEADERS

Line 3147: FROM rlm_schedule_headers

3143: schedule_purpose,
3144: DECODE(schedule_purpose, 'ADD', 1, 'CONFIRMATION', 2, 'ORIGINAL', 3, 'REPLACE', 4,
3145: 'REPLACE_ALL', 5, 'CANCELLATION', 6, 'CHANGE', 7, 'DELETE', 8),
3146: creation_date
3147: FROM rlm_schedule_headers
3148: WHERE ece_tp_translator_code = x_header_rec.ece_tp_translator_code
3149: AND ece_tp_location_code_ext = x_header_rec.ece_tp_location_code_ext
3150: AND schedule_type = x_header_rec.schedule_type
3151: AND interface_header_id <> x_header_rec.header_id

Line 3183: -- Bug 4995267: Query rlm_schedule_headers table for schedules. Then, compare each attribute

3179: ELSIF (x_header_rec.schedule_source <> 'MANUAL' ) THEN
3180: --{
3181: --
3182: --
3183: -- Bug 4995267: Query rlm_schedule_headers table for schedules. Then, compare each attribute
3184: -- (one-by-one) according to the ORDER BY clause (RLMDPWPB). If at any point of
3185: -- attribute comparison, we find a schedule whose attributes are greater than the one
3186: -- currently being processed, DSP should stop indicating that the processing is out of order.
3187: --