APPS.RLM_INBOUND_SV dependencies on RLM_INTERFACE_HEADERS

Line 44: FROM rlm_interface_headers

40: ece_transaction_disabled EXCEPTION;
41:
42: /* CURSOR c_header_cur IS
43: SELECT header_id
44: FROM rlm_interface_headers
45: WHERE request_id = i_run_id;
46: */
47:
48: --

Line 233: FROM rlm_interface_headers

229: ec_debug.pl(3,'request_id',x_request_id);
230: --
231: SELECT count(*)
232: INTO x_count
233: FROM rlm_interface_headers
234: where request_id = x_request_id;
235: --
236: ec_debug.pl(3,'count',x_count);
237: ec_debug.pop('RLM_INBOUND_SV.GetCountInterfaceHeaderId');

Line 276: UPDATE rlm_interface_headers_all

272: ec_debug.pl(0,'EC','ECE_START_UPDATE_HZ_DATES','RUN_ID',p_run_id);
273: ec_debug.push('RLM_INBOUND_SV.UpdateHorizonDates');
274: ec_debug.pl(3,'p_run_id', p_run_id);
275: --
276: UPDATE rlm_interface_headers_all
277: SET sched_horizon_start_date = TRUNC(sched_horizon_start_date),
278: sched_horizon_end_date = TRUNC(sched_horizon_end_date) + 0.99999
279: WHERE header_id IN
280: (SELECT header_id

Line 281: FROM rlm_interface_headers

277: SET sched_horizon_start_date = TRUNC(sched_horizon_start_date),
278: sched_horizon_end_date = TRUNC(sched_horizon_end_date) + 0.99999
279: WHERE header_id IN
280: (SELECT header_id
281: FROM rlm_interface_headers
282: WHERE request_id = p_run_id);
283: --
284: ec_debug.pl(3, 'Number of headers updated', SQL%ROWCOUNT);
285: ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');