APPS.ZX_EVENT_CLASSES_PKG SQL Statements

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

Line: 10

PROCEDURE insert_row (
  x_tax_event_class_code IN VARCHAR2,
  x_normal_sign_flag     IN VARCHAR2,
  x_intrcmp_tx_cls_code  IN VARCHAR2,
  x_creation_date        IN DATE,
  x_created_by           IN NUMBER,
  x_last_update_date     IN DATE,
  x_last_updated_by      IN NUMBER,
  x_last_update_login    IN NUMBER,
  x_tax_event_class_name IN VARCHAR2
) is

  CURSOR C IS SELECT rowid FROM zx_event_classes_b
    WHERE tax_event_class_code = x_tax_event_class_code;

Line: 30

                    'Insert_Row (+)');

Line: 35

                    'ZX_EVENT_CLASSES_PKG.Insert_Row',
                    'Insert into ZX_EVENT_CLASSES_B (+)');

Line: 39

   INSERT INTO zx_event_classes_b  (
     tax_event_class_code ,
     normal_sign_flag ,
     asc_intrcmp_tx_evnt_cls_code,
     creation_date ,
     created_by,
     last_update_date,
     last_updated_by,
     last_update_login )
   VALUES (
     x_tax_event_class_code ,
     x_normal_sign_flag ,
     x_intrcmp_tx_cls_code,
     x_creation_date,
     x_created_by,
     x_last_update_date,
     x_last_updated_by,
     x_last_update_login
   );

Line: 59

   INSERT INTO zx_event_classes_tl (
     tax_event_class_code,
     tax_event_class_name,
     creation_date,
     created_by,
     last_update_date,
     last_updated_by,
     last_update_login,
     language,
     source_lang
    )
    SELECT
      x_tax_event_class_code,
      x_tax_event_class_name,
      x_creation_date,
      x_created_by,
      x_last_update_date,
      x_last_updated_by,
      x_last_update_login,
      l.language_code,
      userenv('lang')
    FROM fnd_languages l
    WHERE l.installed_flag IN ('I', 'B')
    AND NOT EXISTS
      (SELECT null
       FROM zx_event_classes_tl cls
       WHERE cls.tax_event_class_code = x_tax_event_class_code
         AND cls.language = l.language_code);

Line: 98

                     'ZX_EVENT_CLASSES_PKG.Insert_Row',
                     'Insert into ZX_EVENT_CLASSES_B (-)');

Line: 101

END insert_row;

Line: 108

  x_last_update_date     IN VARCHAR2,
  x_custom_mode          IN VARCHAR2) IS

  f_luby number;

Line: 126

    f_ludate := nvl(to_date(x_last_update_date,'DD/MM/YYYY'),sysdate);

Line: 129

      SELECT decode (last_updated_by,1,1,0), last_update_date
      INTO db_luby, db_ludate
      FROM  zx_event_classes_tl
      WHERE tax_event_class_code = x_tax_event_class_code
        AND language = userenv('LANG');

Line: 137

          UPDATE zx_event_classes_tl SET
            tax_event_class_name = x_tax_event_class_name,
            last_update_date     = f_ludate,
            last_updated_by      = f_luby,
            last_update_login    = 0,
            source_lang          = userenv ('LANG')
          WHERE userenv('LANG') IN (language,source_lang)
             AND tax_event_class_code = x_tax_event_class_code;

Line: 155

                     'Insert into ZX_EVENT_CLASSES_TL (-)');

Line: 165

  x_last_update_date     in VARCHAR2,
  x_tax_event_class_name in VARCHAR2,
  x_custom_mode          in VARCHAR2) is

  row_id varchar2(64);

Line: 184

    f_ludate := nvl(to_date(x_last_update_date,'DD/MM/YYYY'),sysdate);

Line: 187

       SELECT decode (LAST_UPDATED_BY,1,1,0), LAST_UPDATE_DATE
       INTO db_luby, db_ludate
       FROM zx_event_classes_b
       WHERE tax_event_class_code = x_tax_event_class_code;

Line: 197

         UPDATE zx_event_classes_b
          SET normal_sign_flag = x_normal_sign_flag ,
              asc_intrcmp_tx_evnt_cls_code = x_intrcmp_tx_cls_code,
              last_update_date = f_ludate,
              last_updated_by = f_luby,
              last_update_login = 0
          where TAX_EVENT_CLASS_CODE = x_tax_event_class_code;

Line: 207

            insert_row (
              x_tax_event_class_code => x_tax_event_class_code ,
              x_normal_sign_flag     => x_normal_sign_flag ,
              x_intrcmp_tx_cls_code  => x_intrcmp_tx_cls_code,
              x_creation_date        => f_ludate,
              x_created_by           => f_luby,
              x_last_update_date     => f_ludate,
              x_last_updated_by      => f_luby,
              x_last_update_login    => 0,
              x_tax_event_class_name => x_tax_event_class_name);

Line: 229

  DELETE FROM zx_event_classes_tl T
  WHERE NOT EXISTS
    (SELECT null
    FROM ZX_EVENT_CLASSES_B B
    WHERE B.tax_event_class_code = T.tax_event_class_code
    );

Line: 236

  UPDATE ZX_EVENT_CLASSES_TL T SET (
      TAX_EVENT_CLASS_NAME
    ) = (select
      B.TAX_EVENT_CLASS_NAME
    from ZX_EVENT_CLASSES_TL B
    where B.TAX_EVENT_CLASS_CODE = T.TAX_EVENT_CLASS_CODE
    and B.LANGUAGE = T.SOURCE_LANG)
  where (
      T.TAX_EVENT_CLASS_CODE,
      T.LANGUAGE
  ) in (select
      SUBT.TAX_EVENT_CLASS_CODE,
      SUBT.LANGUAGE
    from ZX_EVENT_CLASSES_TL SUBB, ZX_EVENT_CLASSES_TL SUBT
    where SUBB.TAX_EVENT_CLASS_CODE = SUBT.TAX_EVENT_CLASS_CODE
    and SUBB.LANGUAGE = SUBT.SOURCE_LANG
    and (SUBB.TAX_EVENT_CLASS_NAME <> SUBT.TAX_EVENT_CLASS_NAME
  ));

Line: 255

  insert into ZX_EVENT_CLASSES_TL (
    TAX_EVENT_CLASS_CODE,
    TAX_EVENT_CLASS_NAME,
    CREATION_DATE,
    CREATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_LOGIN,
    LANGUAGE,
    SOURCE_LANG
  ) select /*+ ORDERED */
    B.TAX_EVENT_CLASS_CODE,
    B.TAX_EVENT_CLASS_NAME,
    B.CREATION_DATE,
    B.CREATED_BY,
    B.LAST_UPDATE_DATE,
    B.LAST_UPDATED_BY,
    B.LAST_UPDATE_LOGIN,
    L.LANGUAGE_CODE,
    B.SOURCE_LANG
  from ZX_EVENT_CLASSES_TL B, FND_LANGUAGES L
  where L.INSTALLED_FLAG in ('I', 'B')
  and B.LANGUAGE = userenv('LANG')
  and not exists
    (select NULL
    from ZX_EVENT_CLASSES_TL T
    where T.TAX_EVENT_CLASS_CODE = B.TAX_EVENT_CLASS_CODE
    and T.LANGUAGE = L.LANGUAGE_CODE);