APPS.OE_BULK_TAX_UTIL SQL Statements

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

Line: 54

                   SELECT batch_source_id
                     INTO l_invoice_source_id
                     FROM ra_batch_sources
                    WHERE name = l_invoice_source;

Line: 210

 SELECT hsecs INTO l_start_time from v$timer;

Line: 233

 SELECT hsecs INTO l_end_time from v$timer;

Line: 288

 SELECT hsecs INTO l_start_time from v$timer;

Line: 302

              SELECT 'VALID'
              INTO   l_dummy
              FROM   AR_VAT_TAX V
              WHERE  V.TAX_CODE = OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index)
              AND V.SET_OF_BOOKS_ID = l_sob_id
              AND NVL(V.ENABLED_FLAG,'Y')='Y'
              AND NVL(V.TAX_CLASS,'O')='O'
              AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
              AND TRUNC(OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index))
              BETWEEN TRUNC(V.START_DATE) AND
              TRUNC(NVL(V.END_DATE, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index)))
              AND ROWNUM = 1;

Line: 317

              SELECT 'VALID'
              INTO   l_dummy
              FROM   AR_VAT_TAX V,
                     AR_SYSTEM_PARAMETERS P
              WHERE  V.TAX_CODE = OE_Bulk_Order_PVT.G_LINE_REC.tax_code(l_index)
              AND V.SET_OF_BOOKS_ID = P.SET_OF_BOOKS_ID
              AND NVL(V.ENABLED_FLAG,'Y')='Y'
              AND NVL(V.TAX_CLASS,'O')='O'
              AND NVL(V.DISPLAYED_FLAG,'Y')='Y'
              AND TRUNC(OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index))
              BETWEEN TRUNC(V.START_DATE) AND
              TRUNC(NVL(V.END_DATE, OE_Bulk_Order_PVT.G_LINE_REC.tax_date(l_index)))
              AND ROWNUM = 1;

Line: 334

 SELECT hsecs INTO l_end_time from v$timer;

Line: 393

    p_post_insert IN BOOLEAN )
IS
  l_charge_tbl om_tax_util.charge_tbl;

Line: 492

    SELECT location_id
    FROM hr_organization_units
    WHERE organization_id = p_organization_id;

Line: 512

    SELECT
      /* MOAC_SQL_CHANGE */
      s_ship.site_use_id,
      s_ship.cust_acct_site_id,
      acct_site_ship.cust_account_id,
      loc_ship.postal_code,
      party.party_name,
      cust_acct.account_number,
      party.party_id,
      party_site_ship.party_site_id,
      loc_ship.location_id
    FROM HZ_CUST_SITE_USES S_SHIP ,
      HZ_CUST_ACCT_SITES_ALL ACCT_SITE_SHIP,
      HZ_PARTY_SITES PARTY_SITE_SHIP,
      HZ_LOCATIONS LOC_SHIP,
      HZ_PARTIES PARTY,
      HZ_CUST_ACCOUNTS_ALL CUST_ACCT
    WHERE s_ship.site_use_id           = p_site_org_id
    AND s_ship.cust_acct_site_id       = acct_site_ship.cust_acct_site_id
    AND acct_site_ship.cust_account_id = cust_acct.cust_account_id
    AND cust_acct.party_id             = party.party_id
    AND acct_site_ship.party_site_id   = party_site_ship.party_site_id
    AND party_site_ship.location_id    = loc_ship.location_id;

Line: 538

    SELECT *
    FROM ZX_DETAIL_TAX_LINES_GT
    WHERE application_id = l_application_id
    AND entity_code      = l_entity_code_crsr      --'OE_ORDER_HEADERS'
    AND event_class_code = l_event_class_code_crsr --'SALES_TRANSACTION_TAX_QUOTE'
    AND trx_id           = p_header_id ;

Line: 551

    IF p_post_insert THEN
      oe_debug_pub.add( 'Post_insert : TRUE');

Line: 554

      oe_debug_pub.add( 'Post_insert : FALSE');

Line: 664

        SELECT location_id
        INTO l_bill_from_location_id
        FROM HR_ALL_ORGANIZATION_UNITS
        WHERE organization_id = OE_Bulk_Order_PVT.G_HEADER_REC.org_id(l_header_index);

Line: 725

            SELECT
              /* MOAC_SQL_CHANGE */
              NVL(cust_type.subsequent_trx_type_id, cust_type.cust_trx_type_id)
            INTO l_cust_trx_type_id
            FROM ra_cust_trx_types_all cust_type,
              ra_customer_trx cust_trx
            WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
            AND cust_type.org_id             = cust_trx.org_id
            AND cust_trx.customer_trx_id     = l_commitment_id;

Line: 759

        SELECT c.minimum_accountable_unit,
          c.precision
        INTO l_minimum_accountable_unit,
          l_precision
        FROM fnd_currencies c
        WHERE c.currency_code = l_currency_code;

Line: 774

            SELECT location_id
            INTO l_ship_from_location_id
            FROM hr_all_organization_units hu
            WHERE hu.organization_id = OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index);

Line: 891

            SELECT
              /* MOAC_SQL_CHANGE */
              NVL(cust_type.subsequent_trx_type_id, cust_type.cust_trx_type_id)
            INTO l_cust_trx_type_id
            FROM ra_cust_trx_types_all cust_type,
              ra_customer_trx cust_trx
            WHERE cust_type.cust_trx_type_id = cust_trx.cust_trx_type_id
            AND cust_type.org_id             = cust_trx.org_id
            AND cust_trx.customer_trx_id     = l_commitment_id;

Line: 925

        SELECT c.minimum_accountable_unit,
          c.precision
        INTO l_minimum_accountable_unit,
          l_precision
        FROM fnd_currencies c
        WHERE c.currency_code = l_currency_code;

Line: 940

            SELECT location_id
            INTO l_ship_from_location_id
            FROM hr_all_organization_units hu
            WHERE hu.organization_id = OE_Bulk_Order_PVT.G_LINE_REC.ship_from_org_id(Entity_info_tbl(i).line_index);

Line: 1061

          SELECT NVL (ot.cust_trx_type_id, 0)
          INTO l_cust_trx_type_id
          FROM oe_order_types_v ot,
            oe_order_headers_all oh
          WHERE ot.order_type_id = oh.order_type_id
          AND oh.header_id       = OE_Bulk_Order_PVT.G_header_REC.header_id(Entity_info_tbl(i).header_index);

Line: 1078

        SELECT c.minimum_accountable_unit,
          c.precision
        INTO l_minimum_accountable_unit,
          l_precision
        FROM fnd_currencies c
        WHERE c.currency_code = l_currency_code;

Line: 1093

            SELECT location_id
            INTO l_ship_from_location_id
            FROM hr_all_organization_units hu
            WHERE hu.organization_id = OE_Bulk_Order_PVT.G_Header_REC.ship_from_org_id(Entity_info_tbl(i).header_index);

Line: 1448

      zx_global_structures_pkg.trx_line_dist_tbl.INSERT_UPDATE_FLAG(i)             := NULL;

Line: 1512

  SELECT hsecs INTO l_start_time FROM v$timer;

Line: 1527

  SELECT hsecs INTO l_end_time FROM v$timer;

Line: 1627

    Insert_Tax_Records(p_post_insert => p_post_insert);

Line: 1629

  G_LINE_ADJ_REC.PRICE_ADJUSTMENT_ID.delete;

Line: 1630

  G_LINE_ADJ_REC.CREATED_BY.delete;

Line: 1631

  G_LINE_ADJ_REC.CREATION_DATE.delete;

Line: 1632

  G_LINE_ADJ_REC.LAST_UPDATE_DATE.delete;

Line: 1633

  G_LINE_ADJ_REC.LAST_UPDATED_BY.delete;

Line: 1634

  G_LINE_ADJ_REC.HEADER_ID.delete;

Line: 1635

  G_LINE_ADJ_REC.LINE_ID.delete;

Line: 1636

  G_LINE_ADJ_REC.TAX_CODE.delete;

Line: 1637

  G_LINE_ADJ_REC.OPERAND.delete;

Line: 1638

  G_LINE_ADJ_REC.ADJUSTED_AMOUNT.delete;

Line: 1639

  G_LINE_ADJ_REC.AUTOMATIC_FLAG.delete;

Line: 1640

  G_LINE_ADJ_REC.LIST_LINE_TYPE_CODE.delete;

Line: 1641

  G_LINE_ADJ_REC.ARITHMETIC_OPERATOR.delete;

Line: 1642

  G_LINE_ADJ_REC.TAX_RATE_ID.delete;

Line: 1682

p_adj_rec.LAST_UPDATE_DATE.extend(p_count);

Line: 1683

p_adj_rec.LAST_UPDATED_BY.extend(p_count);

Line: 1713

PROCEDURE Insert_Tax_Records
          (p_post_insert            IN    BOOLEAN
          )
IS
l_start_time             NUMBER;

Line: 1728

SELECT *
FROM oe_price_adjustments
WHERE LIST_LINE_TYPE_CODE = 'FREIGHT_CHARGE'
AND line_id = ORDER_Line_id;

Line: 1748

  oe_debug_pub.add(  'ENTERING OE_BULK_TAX_UTIL.INSERT_TAX_RECORDS' ) ;

Line: 1751

 SELECT hsecs INTO l_start_time from v$timer;

Line: 1757

    DELETE FROM OE_PRICE_ADJUSTMENTS
    where  list_line_type_code = 'TAX'
            and header_ID   = G_LINE_ADJ_REC.header_ID(i);

Line: 1763

	  oe_debug_pub.add(  'Exception in delete existing tax records' ) ;

Line: 1769

                   INSERT INTO OE_PRICE_ADJUSTMENTS
                    (       PRICE_ADJUSTMENT_ID
                    ,       CREATED_BY
                    ,       CREATION_DATE
                    ,       LAST_UPDATE_DATE
                    ,       LAST_UPDATED_BY
                    ,       HEADER_ID
                    ,       LINE_ID
                    ,       TAX_CODE
                    ,       OPERAND
                    ,       adjusted_amount
                    ,       automatic_flag
                    ,       list_line_type_code
                    ,       arithmetic_operator
		                ,       tax_rate_id --bug7685103
                    ,       parent_adjustment_id
		    )
                    VALUES
                    (       oe_price_adjustments_s.nextval
                    ,        FND_GLOBAL.USER_ID
                    ,        SYSDATE
                    ,        SYSDATE
                    ,        FND_GLOBAL.USER_ID
                    ,        G_LINE_ADJ_REC.header_id(i)
                    ,        G_LINE_ADJ_REC.line_id(i)
                    ,        G_LINE_ADJ_REC.tax_code(i)
                    ,        G_LINE_ADJ_REC.operand(i)
                    ,        G_LINE_ADJ_REC.adjusted_amount(i)
                    ,        'N'
                    ,        'TAX'
                    ,        'AMT'
		    ,	     G_LINE_ADJ_REC.tax_rate_id(i) --bug7685103
         ,G_LINE_ADJ_REC.parent_adjustment_id(i)

		    );

Line: 1806

 SELECT hsecs INTO l_end_time from v$timer;

Line: 1808

   FND_FILE.PUT_LINE(FND_FILE.LOG,'Time spent inserting adjustment records is (sec) '||((l_end_time-l_start_time)/100));

Line: 1811

      IF p_post_insert AND G_Tax_Line_Id.COUNT > 0
      THEN

        IF l_debug_level  > 0 THEN
          oe_debug_pub.add(  'post insert mode, so update tax on lines in base table' ) ;

Line: 1820

          UPDATE OE_ORDER_LINES
          SET TAX_VALUE = 0
          WHERE LINE_ID = G_Tax_Line_Id(i);

Line: 1825

          UPDATE OE_ORDER_LINES
          SET TAX_VALUE = TAX_VALUE + G_Tax_Line_Value(i)
          WHERE LINE_ID = G_Tax_Line_Id(i);

Line: 1847

                   SELECT Sum(Nvl(adjusted_amount,0))
                   INTO charge_tax
                   FROM oe_price_adjustments
                   WHERE parent_adjustment_id = j.PRICE_ADJUSTMENT_ID
                   AND list_line_type_code = 'TAX';

Line: 1867

              UPDATE OE_ORDER_LINES
               SET  TAX_VALUE = TAX_VALUE + total_freight_tax ,
                TAX_LINE_VALUE = total_freight_tax
              WHERE LINE_ID = G_LINE_ID(i);

Line: 1883

  oe_debug_pub.add(  'EXITING OE_BULK_TAX_UTIL.INSERT_TAX_RECORDS' ) ;

Line: 1898

    ,'Insert_Tax_Records'
    );

Line: 1902

END Insert_Tax_Records;