APPS.RLM_INBOUND_SV SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 43

     SELECT   header_id
     FROM     rlm_interface_headers
     WHERE    request_id = i_run_id;

Line: 77

   SELECT map_type
   INTO i_map_type
   FROM ece_mappings
   WHERE map_id = p_map_id
   AND enabled ='Y';

Line: 108

   ec_utils.g_stack.DELETE;

Line: 122

   UpdateHorizonDates(p_run_id => i_run_id);

Line: 231

  SELECT count(*)
  INTO   x_count
  FROM   rlm_interface_headers
  where  request_id = x_request_id;

Line: 265

        PROCEDURE NAME: UpdateHorizonDates

===========================================================================*/

PROCEDURE UpdateHorizonDates(p_run_id IN NUMBER) IS
BEGIN
  --
  ec_debug.pl(0,'EC','ECE_START_UPDATE_HZ_DATES','RUN_ID',p_run_id);

Line: 273

  ec_debug.push('RLM_INBOUND_SV.UpdateHorizonDates');

Line: 276

  UPDATE rlm_interface_headers_all
  SET sched_horizon_start_date = TRUNC(sched_horizon_start_date),
      sched_horizon_end_date   = TRUNC(sched_horizon_end_date) + 0.99999
  WHERE header_id IN
        (SELECT header_id
         FROM rlm_interface_headers
         WHERE request_id = p_run_id);

Line: 284

  ec_debug.pl(3, 'Number of headers updated', SQL%ROWCOUNT);

Line: 285

  ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');

Line: 286

  ec_debug.pl(0,'EC','ECE_END_UPDATE_HZ_DATES', 'p_run_id', p_run_id);

Line: 294

   ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');

Line: 299

               'RLM_INBOUND_SV.UpdateHorizonDates');

Line: 301

   ec_debug.pop('RLM_INBOUND_SV.UpdateHorizonDates');

Line: 304

END UpdateHorizonDates;