APPS.EGO_DUMMY_SUBSCR_PKG SQL Statements

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

Line: 24

      INSERT INTO EVENT_SUBSCRIPTION(
        event_name,
        event_key,
        pname_value,
        dt)
      VALUES(
        p_event.getEventName(),
        p_event.GetEventKey(),
        l_name_val,
        sysdate);

Line: 35

      INSERT INTO EVENT_SUBSCRIPTION(
        event_name,
        event_key,
        pNAME_value,
        error_msg,
        dt)
      VALUES (
        p_event.getEventName(),
        p_event.GetEventKey(),
        null,
        'Parameter list is empty',
        sysdate);

Line: 52

    INSERT INTO EVENT_SUBSCRIPTION(
      event_name,
      event_key,
      pname_value,
      error_msg,
      dt)
    VALUES (
      p_event.getEventName(),
      p_event.GetEventKey(),
      null,
      'Unexpected Error: '||l_error,
      sysdate);