DBA Data[Home] [Help]

APPS.RLM_REPLACE_SV dependencies on RLM_DP_SV

Line 164: AND schedule_purpose in (RLM_DP_SV.k_REPLACE, RLM_DP_SV.k_REPLACE_ALL)

160: CURSOR c_eligible_schedule IS
161: SELECT header_id
162: FROM rlm_schedule_headers
163: WHERE schedule_type = x_sched_rec.schedule_type
164: AND schedule_purpose in (RLM_DP_SV.k_REPLACE, RLM_DP_SV.k_REPLACE_ALL)
165: AND schedule_source <> RLM_DP_SV.k_MANUAL
166: -- AND customer_id = x_sched_rec.customer_id
167: AND ece_tp_translator_code = x_sched_rec.ece_tp_translator_code
168: AND ece_tp_location_code_ext = x_sched_rec.ece_tp_location_code_ext

Line 165: AND schedule_source <> RLM_DP_SV.k_MANUAL

161: SELECT header_id
162: FROM rlm_schedule_headers
163: WHERE schedule_type = x_sched_rec.schedule_type
164: AND schedule_purpose in (RLM_DP_SV.k_REPLACE, RLM_DP_SV.k_REPLACE_ALL)
165: AND schedule_source <> RLM_DP_SV.k_MANUAL
166: -- AND customer_id = x_sched_rec.customer_id
167: AND ece_tp_translator_code = x_sched_rec.ece_tp_translator_code
168: AND ece_tp_location_code_ext = x_sched_rec.ece_tp_location_code_ext
169: AND NVL(edi_test_indicator,'P') = NVL(x_sched_rec.edi_test_indicator,'P')