APPS.ZX_TRL_PUB_PKG SQL Statements

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

Line: 12

 | PROCEDURE Manage_TaxLines: It will Create, update, delete and cancel tax   |
 |                            lines and summary  tax lines in the tax         |
 |                            repository                                      |
 * ===========================================================================*/

  PROCEDURE Manage_TaxLines
       (x_return_status      OUT NOCOPY VARCHAR2,
        p_event_class_rec IN            ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

    l_error_buffer                 VARCHAR2(100);

Line: 80

    IF ZX_GLOBAL_STRUCTURES_PKG.g_update_event_process_flag = 'Y' THEN

        /*
         * no longer needed for UPDATE case
         *
         * ZX_TRL_MANAGE_TAX_PKG.Update_Synchronize_Taxlines
         *                   (x_return_status => x_return_status);

Line: 90

      ZX_TRL_MANAGE_TAX_PKG.Delete_Detail_Lines
                            (x_return_status   => x_return_status ,
                             p_event_class_rec => p_event_class_rec);

Line: 99

                 'ZX_TRL_MANAGE_TAX_PKG.Delete_Detail_Lines()');

Line: 140

          ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (
                            p_event_class_rec => p_event_class_rec,
                            x_return_status   => x_return_status);

Line: 149

                     'ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id()');

Line: 161

        ZX_TRL_MANAGE_TAX_PKG.Delete_Summary_Lines
                          (x_return_status   => x_return_status,
                           p_event_class_rec => p_event_class_rec);

Line: 170

                   'ZX_TRL_MANAGE_TAX_PKG.Delete_Summary_Lines()');

Line: 279

      ZX_TRL_MANAGE_TAX_PKG.Delete_Loose_Tax_Distributions
                          (x_return_status   => x_return_status,
                           p_event_class_rec => p_event_class_rec);

Line: 288

                 'ZX_TRL_MANAGE_TAX_PKG.Delete_Loose_Tax_Distributions()');

Line: 356

         * no longer needed for UPDATE case
         *
         * ZX_TRL_MANAGE_TAX_PKG.Update_Synchronize_Taxlines
         *                   (x_return_status => x_return_status);

Line: 363

      ZX_TRL_MANAGE_TAX_PKG.Delete_Detail_Lines
                            (x_return_status   => x_return_status ,
                             p_event_class_rec => p_event_class_rec);

Line: 372

                 'ZX_TRL_MANAGE_TAX_PKG.Delete_Detail_Lines()');

Line: 413

          ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id (
                            p_event_class_rec => p_event_class_rec,
                            x_return_status   => x_return_status);

Line: 422

                     'ZX_TRL_MANAGE_TAX_PKG.update_exist_summary_line_id()');

Line: 434

        ZX_TRL_MANAGE_TAX_PKG.Delete_Summary_Lines
                          (x_return_status   => x_return_status,
                           p_event_class_rec => p_event_class_rec);

Line: 443

                   'ZX_TRL_MANAGE_TAX_PKG.Delete_Summary_Lines()');

Line: 457

        IF p_event_class_rec.tax_event_type_code = 'UPDATE'
          AND p_event_class_rec.retain_summ_tax_line_id_flag = 'N'
        THEN
        -- for update tax event, AP will pass in all the trx lines,
        -- that is, all the tax lines will be in the zx_detail_tax_lines_gt.
        -- so if not retain summary_tax_line_id, it is treated same as
        -- created case.

          ZX_TRL_MANAGE_TAX_PKG.create_summary_lines_crt_evnt (
              p_event_class_rec => p_event_class_rec,
              x_return_status   => x_return_status );

Line: 558

      ZX_TRL_MANAGE_TAX_PKG.Delete_Loose_Tax_Distributions
                          (x_return_status   => x_return_status,
                           p_event_class_rec => p_event_class_rec);

Line: 567

                 'ZX_TRL_MANAGE_TAX_PKG.Delete_Loose_Tax_Distributions()');

Line: 602

 | PROCEDURE Document_Level_Changes: It will Delete / Cancel / Purge tax lines |
 |                                   from the tax repository                   |
 *============================================================================*/

  PROCEDURE Document_Level_Changes
       (x_return_status             OUT NOCOPY VARCHAR2,
        p_event_class_rec        IN     ZX_API_PUB.EVENT_CLASS_REC_TYPE,
        p_tax_hold_released_code IN     ZX_API_PUB.VALIDATION_STATUS_TBL_TYPE) IS

    l_return_status VARCHAR2(1);

Line: 630

    IF (p_event_class_rec.TAX_EVENT_TYPE_CODE = 'DELETE') THEN

      ZX_TRL_MANAGE_TAX_PKG.DELETE_TRANSACTION
                        (x_return_status   => l_return_status    ,
                         p_event_class_rec => p_event_class_rec);

Line: 694

 | PROCEDURE Synchronize_TaxLines : updates transaction information in the tax|
 |                                  repository                                |
 * ===========================================================================*/

  PROCEDURE Synchronize_TaxLines
       (x_return_status    OUT   NOCOPY VARCHAR2) IS

    l_return_status  VARCHAR2(1);

Line: 717

     *ZX_TRL_MANAGE_TAX_PKG.Update_Transaction_Info
     *                  (x_return_status    =>  l_return_status);

Line: 757

 | PROCEDURE Mark_Tax_Lines_Delete  : Marks the tax lines as delete.          |
 * ===========================================================================*/

  PROCEDURE Mark_Tax_Lines_Delete
       (x_return_status           OUT NOCOPY VARCHAR2,
        p_transaction_line_rec IN            ZX_API_PUB.TRANSACTION_LINE_REC_TYPE) IS

    l_return_status VARCHAR2(1);

Line: 772

                     'ZX.PLSQL.ZX_TRL_PUB_PKG.Mark_Tax_Lines_Delete.BEGIN',
                     'ZX_TRL_PUB_PKG: Mark_Tax_Lines_Delete (+)');

Line: 779

    ZX_TRL_MANAGE_TAX_PKG.Mark_Detail_Tax_Lines_Delete
                      (x_return_status        => l_return_status ,
                       p_transaction_line_rec => p_transaction_line_rec);

Line: 792

                     'ZX.PLSQL.ZX_TRL_PUB_PKG.Mark_Tax_Lines_Delete.END',
                     'ZX_TRL_PUB_PKG.Mark_Tax_Lines_Delete (-)'||x_return_status);

Line: 801

                       'ZX.PLSQL.ZX_TRL_PUB_PKG.Mark_Tax_Lines_Delete',
                       'Return Status = ' || x_return_status);

Line: 811

                       'ZX.PLSQL.ZX_TRL_PUB_PKG.Mark_Tax_Lines_Delete',
                        l_error_buffer);

Line: 815

  END Mark_Tax_Lines_Delete;

Line: 818

 | PROCEDURE Manage_TaxDistributions: It will create, update, delete tax      |
 |                                    distributions lines and update tax lines|
 |                                    and summary tax lines in the            |
 |                                    tax repository.                         |
 |============================================================================*/

  PROCEDURE Manage_TaxDistributions
       (x_return_status      OUT NOCOPY VARCHAR2,
        p_event_class_rec IN            ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

    l_return_status  VARCHAR2(1);

Line: 871

      ZX_TRL_MANAGE_TAX_PKG.Delete_dist_Marked_For_Delete
                          (x_return_status   => l_return_status ,
                           p_event_class_rec => p_event_class_rec);

Line: 888

        ZX_TRL_MANAGE_TAX_PKG.Update_Taxline_Rec_Nrec_amt
                            (x_return_status   => l_return_status ,
                             p_event_class_rec => p_event_class_rec);

Line: 900

      ZX_TRL_MANAGE_TAX_PKG.delete_tax_distributions(
                           x_return_status   => l_return_status,
                           p_event_class_rec => p_event_class_rec);

Line: 911

        ZX_TRL_MANAGE_TAX_PKG.update_taxline_rec_nrec_amt(
                             x_return_status   => l_return_status,
                             p_event_class_rec => p_event_class_rec);

Line: 971

    ZX_TRL_MANAGE_TAX_PKG.Update_Freeze_Flag
                      (x_return_status         =>      x_return_status,
                       p_event_class_rec       =>      p_event_class_rec);

Line: 1003

 | PROCEDURE Update_Taxlines: This recording service is used to update tax    |
 |                            lines (ZX_LINES) with changed status for given  |
 |                            transaction line distributions.                 |
 |============================================================================*/
  PROCEDURE Update_Taxlines
       (x_return_status      OUT NOCOPY VARCHAR2,
        p_event_class_rec IN            ZX_API_PUB.EVENT_CLASS_REC_TYPE) IS

    l_error_buffer  VARCHAR2(100);

Line: 1018

                     'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Taxlines.BEGIN',
                     'ZX_TRL_PUB_PKG: Update_Taxlines (+)');

Line: 1022

    ZX_TRL_MANAGE_TAX_PKG.Update_Item_Dist_Changed_Flag
                      (x_return_status   => x_return_status,
                       p_event_class_rec => p_event_class_rec);

Line: 1028

                     'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Taxlines.END',
                     'ZX_TRL_PUB_PKG: Update_Taxlines (-)'||x_return_status);

Line: 1037

                       'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Taxlines',
                       'Return Status = ' || x_return_status);

Line: 1047

                       'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Taxlines',
                        l_error_buffer);

Line: 1050

  END Update_Taxlines;

Line: 1096

  PROCEDURE Update_GL_Date
       (p_gl_date       IN            DATE,
        x_return_status    OUT NOCOPY VARCHAR2) IS

    l_error_buffer  VARCHAR2(100);

Line: 1107

                     'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_GL_Date.BEGIN',
                     'ZX_TRL_PUB_PKG: Update_GL_Date (+)');

Line: 1111

    ZX_TRL_MANAGE_TAX_PKG.Update_GL_Date (p_gl_date, x_return_status);

Line: 1116

                     'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_GL_Date.END',
                     'ZX_TRL_PUB_PKG: Update_GL_Date (-)'||x_return_status);

Line: 1125

                       'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_GL_Date',
                       'Return Status = ' || x_return_status);

Line: 1135

                       'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_GL_Date',
                        l_error_buffer);

Line: 1139

  END Update_GL_Date;

Line: 1141

  PROCEDURE Update_Exchange_Rate
       (p_event_class_rec         IN            ZX_API_PUB.EVENT_CLASS_REC_TYPE,
        x_return_status              OUT NOCOPY VARCHAR2) IS

    l_error_buffer  VARCHAR2(100);

Line: 1152

                     'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Exchange_Rate.BEGIN',
                     'ZX_TRL_PUB_PKG: Update_Exchange_Rate (+)');

Line: 1156

    ZX_TRL_MANAGE_TAX_PKG.Update_Exchange_Rate (p_event_class_rec,
                                                  x_return_status);

Line: 1162

                     'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Exchange_Rate.END',
                     'ZX_TRL_PUB_PKG: Update_Exchange_Rate (-)'||x_return_status);

Line: 1171

                       'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Exchange_Rate',
                       'Return Status = ' || x_return_status);

Line: 1181

                       'ZX.PLSQL.ZX_TRL_PUB_PKG.Update_Exchange_Rate',
                        l_error_buffer);

Line: 1185

  END Update_Exchange_Rate;

Line: 1196

PROCEDURE delete_tax_lines_and_dists
(
    p_application_id       IN           NUMBER,
    p_entity_code          IN           VARCHAR2,
    p_event_class_code     IN           VARCHAR2,
    p_trx_id               IN           NUMBER,
    p_trx_line_id          IN           NUMBER,
    p_trx_level_type       IN           VARCHAR2,
    x_return_status        OUT NOCOPY   VARCHAR2
) IS

 CURSOR c_get_summary_flags IS
   SELECT summarization_flag,
          retain_summ_tax_line_id_flag
     FROM zx_evnt_cls_mappings
    WHERE event_class_code = p_event_class_code
      AND application_id   = p_application_id
      AND entity_code      = p_entity_code;

Line: 1225

                   'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists.BEGIN',
                   'ZX_TRL_PUB_PKG: delete_tax_lines_and_dists (+)');

Line: 1231

  DELETE FROM zx_rec_nrec_dist
        WHERE application_id     = p_application_id
          AND entity_code        = p_entity_code
          AND event_class_code   = p_event_class_code
          AND trx_id             = p_trx_id
          AND trx_line_id        = p_trx_line_id
          AND trx_level_type     = p_trx_level_type;

Line: 1244

  DELETE FROM zx_lines
        WHERE application_id     = p_application_id
          AND entity_code        = p_entity_code
          AND event_class_code   = p_event_class_code
          AND trx_id             = p_trx_id
          AND trx_line_id        = p_trx_line_id
          AND trx_level_type     = p_trx_level_type;

Line: 1258

    DELETE FROM zx_lines_summary
      WHERE application_id     = p_application_id
        AND entity_code        = p_entity_code
        AND event_class_code   = p_event_class_code
        AND trx_id             = p_trx_id;

Line: 1278

               'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',
               'MRC Lines: Incorrect return_status after calling ' ||
               'ZX_TRL_MANAGE_TAX_PKG.create_summary_from_zx_liness()');

Line: 1282

               'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',
               'RETURN_STATUS = ' || x_return_status);

Line: 1285

               'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists.END',
               'ZX_TRL_PUB_PKG.delete_tax_lines_and_dists(-)');

Line: 1295

                   'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists.END',
                   'ZX_TRL_PUB_PKG: delete_tax_lines_and_dists (-)'||x_return_status);

Line: 1304

                       'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',
                       'Return Status = ' || x_return_status);

Line: 1314

                       'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_lines_and_dists',
                        l_error_buffer);

Line: 1318

END delete_tax_lines_and_dists;

Line: 1329

PROCEDURE delete_tax_dists
(
    p_application_id       IN           NUMBER,
    p_entity_code          IN           VARCHAR2,
    p_event_class_code     IN           VARCHAR2,
    p_trx_id               IN           NUMBER,
    p_trx_line_id          IN           NUMBER,
    p_trx_level_type       IN           VARCHAR2,
    x_return_status        OUT NOCOPY   VARCHAR2
) IS

 l_error_buffer VARCHAR2(100);

Line: 1347

                   'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_dists.BEGIN',
                   'ZX_TRL_PUB_PKG: delete_tax_dists (+)');

Line: 1352

  DELETE FROM zx_rec_nrec_dist
        WHERE application_id     = p_application_id
          AND entity_code        = p_entity_code
          AND event_class_code   = p_event_class_code
          AND trx_id             = p_trx_id
          AND trx_line_id        = p_trx_line_id
          AND trx_level_type     = p_trx_level_type;

Line: 1361

    UPDATE zx_lines
       SET process_for_recovery_flag   = 'Y',  -- DECODE(L.Reporting_Only_Flag, 'N', 'Y', 'N')
           rec_tax_amt                 = NULL,
           rec_tax_amt_tax_curr        = NULL,
           rec_tax_amt_funcl_curr      = NULL,
           nrec_tax_amt                = NULL,
           nrec_tax_amt_tax_curr       = NULL,
           nrec_tax_amt_funcl_curr     = NULL
     WHERE application_id     = p_application_id
       AND entity_code        = p_entity_code
       AND event_class_code   = p_event_class_code
       AND trx_id             = p_trx_id
       AND trx_line_id        = p_trx_line_id
       AND trx_level_type     = p_trx_level_type;

Line: 1379

                   'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_dists.END',
                   'ZX_TRL_PUB_PKG: delete_tax_dists (-)'||x_return_status);

Line: 1388

                       'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_dists',
                       'Return Status = ' || x_return_status);

Line: 1398

                       'ZX.PLSQL.ZX_TRL_PUB_PKG.delete_tax_dists',
                        l_error_buffer);

Line: 1402

END delete_tax_dists;