APPS.JAI_AR_TAX_PROCESSING_PKG SQL Statements

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

Line: 42

      SELECT *
        FROM RA_CUSTOMER_TRX_ALL
       WHERE CUSTOMER_TRX_ID = p_customer_trx_id;

Line: 47

      SELECT *
        FROM RA_CUSTOMER_TRX_LINES_ALL
       WHERE CUSTOMER_TRX_LINE_ID = p_customer_trx_line_id;

Line: 52

      SELECT * FROM JAI_AR_TRXS WHERE CUSTOMER_TRX_ID = p_customer_trx_id;

Line: 55

      SELECT *
        FROM JAI_AR_TRX_LINES
       WHERE CUSTOMER_TRX_LINE_ID = p_customer_trx_line_id;

Line: 60

      SELECT NVL(ja.inclusive_tax_flag, 'N') inclusive_tax_flag
        FROM jai_ap_tds_years ja
       WHERE ja.legal_entity_id = t_ra_customer_trx_rec.org_id
         AND sysdate between ja.start_date and ja.end_date;

Line: 65

      SELECT NVL(organization_id, -1) organization_id
        FROM jai_ar_trxs
       WHERE customer_trx_id = p_customer_trx_id;

Line: 76

      SELECT l.excise_invoice_no
        FROM JAI_AR_TRX_LINES L
       WHERE l.customer_trx_id = pn_customer_trx_id;

Line: 81

      SELECT h.vat_invoice_no
        FROM JAI_AR_TRXS h
       WHERE h.customer_trx_id = pn_customer_trx_id;

Line: 99

          ('INV_DELETE', 'CM_DELETE', 'DM_DELETE') THEN

      lv_action := JAI_CONSTANTS.DELETING;

Line: 107

      JAI_AR_TRX_HEADERS_PKG.DELETE_AR_TRXS(pr_old            => t_jai_ar_trx_rec,
                                            pv_action         => lv_action,
                                            pv_return_code    => lv_return_code,
                                            pv_return_message => lv_return_message);

Line: 117

      FOR c_ra_customer_line IN (SELECT customer_trx_line_id
                                   FROM RA_CUSTOMER_TRX_LINES_ALL rctla
                                  WHERE rctla.customer_trx_id =
                                        p_transaction_rec.trx_id
                                    AND rctla.line_type = 'LINE') LOOP

        OPEN c_jai_ar_trx_lines(c_ra_customer_line.customer_trx_line_id);

Line: 128

        JAI_AR_TRX_LINES_PKG.DELETE_AR_TRX_LINES(pr_old            => t_jai_ar_trx_lines_rec,
                                                 pr_new            => NULL,
                                                 pv_action         => lv_action,
                                                 pv_return_code    => lv_return_code,
                                                 pv_return_message => lv_return_message);

Line: 261

           jai_ar_trx_pkg.update_reference(retcode => lv_return_code,
                                          errbuf => lv_return_message,
                                          pn_customer_trx_id => t_ra_customer_trx_rec.customer_trx_id);

Line: 267

                  lv_debug_info := 'Error occurred when execute jai_ar_trx_pkg.update_reference. Error message: '||lv_return_message;

Line: 275

                  lv_debug_info := 'Successfully executed jai_ar_trx_pkg.update_reference. Return message: '||lv_return_message;

Line: 300

         UPDATE jai_ar_trxs
           SET complete_flag = t_ra_customer_trx_rec.complete_flag
         WHERE customer_trx_id = p_transaction_rec.trx_id;

Line: 310

      lv_action := JAI_CONSTANTS.inserting;

Line: 336

      FOR c_ra_customer_line IN (SELECT customer_trx_line_id
                                   FROM RA_CUSTOMER_TRX_LINES_ALL rctla
                                  WHERE rctla.customer_trx_id =
                                        p_event_class_rec.trx_id
                                    AND rctla.line_type = 'LINE') LOOP
        OPEN c_ra_customer_trx_lines(c_ra_customer_line.customer_trx_line_id);

Line: 371

          ('INV_UPDATE', 'CM_UPDATE', 'DM_UPDATE') THEN
      lv_action := JAI_CONSTANTS.updating;

Line: 385

        JAI_AR_TRX_HEADERS_PKG.UPDATE_TRX_NUMBER(pr_old            => t_jai_ar_trx_rec,
                                                 pr_new            => t_ra_customer_trx_rec,
                                                 pv_action         => lv_action,
                                                 pv_return_code    => lv_return_code,
                                                 pv_return_message => lv_return_message);

Line: 415

      FOR c_ra_customer_line IN (SELECT customer_trx_line_id
                                   FROM RA_CUSTOMER_TRX_LINES_ALL rctla
                                  WHERE rctla.customer_trx_id =
                                        p_event_class_rec.trx_id
                                    AND rctla.line_type = 'LINE') LOOP
        OPEN c_ra_customer_trx_lines(c_ra_customer_line.customer_trx_line_id);

Line: 518

      FOR c_ra_customer_line IN (SELECT customer_trx_line_id
                                   FROM JAI_AR_TRX_LINES
                                  WHERE customer_trx_line_id NOT IN
                                        (SELECT customer_trx_line_id
                                           FROM RA_CUSTOMER_TRX_LINES_ALL rctla
                                          WHERE rctla.customer_trx_id =
                                                p_event_class_rec.trx_id
                                            AND rctla.line_type = 'LINE')
                                    AND customer_trx_id =
                                        p_event_class_rec.trx_id) LOOP
        /*OPEN c_ra_customer_trx_lines(c_ra_customer_line.customer_trx_line_id);

Line: 535

        JAI_AR_TRX_LINES_PKG.DELETE_AR_TRX_LINES(pr_old            => t_jai_ar_trx_lines_rec,
                                                 pr_new            => NULL,
                                                 pv_action         => lv_action,
                                                 pv_return_code    => lv_return_code,
                                                 pv_return_message => lv_return_message);