APPS.INV_STANDALONE_SYNC_PUB SQL Statements

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

Line: 22

    FUNCTION Update_RC_Extracted(
             p_api_version        IN         NUMBER
           , p_init_msg_list      IN         VARCHAR2  := FND_API.G_FALSE
           , p_commit             IN         VARCHAR2  := FND_API.G_FALSE
           , x_return_status      OUT NOCOPY VARCHAR2
           , x_msg_count          OUT NOCOPY NUMBER
           , x_msg_data           OUT NOCOPY VARCHAR2
           , p_start_date         IN         VARCHAR2
           , p_end_date           IN         VARCHAR2
           , p_category           IN         VARCHAR2 DEFAULT NULL
           , p_warehouse          IN         VARCHAR2
           , p_document_num       IN         VARCHAR2 DEFAULT NULL
           , p_receipt_num        IN         VARCHAR2
           , p_inventory_item     IN         VARCHAR2 DEFAULT NULL
           , p_rc_extracted       IN         VARCHAR2
           , p_transaction_id     IN         NUMBER   DEFAULT NULL
          ) RETURN VARCHAR2 IS

          l_api_version     CONSTANT NUMBER        :=  1.0;

Line: 41

          l_api_name        CONSTANT VARCHAR2(30)  :=  'Update_RC_Extracted';

Line: 65

          print_debug('In Update_RC_Extracted');

Line: 68

              print_debug('In Update_RC_Extracted');

Line: 91

          UPDATE rcv_transactions
          SET    receipt_confirmation_extracted = l_RC_Extracted
          WHERE  transaction_id  IN
                  (SELECT transaction_id
                   FROM   rcv_receipt_confirmation_v
                   WHERE  creation_date BETWEEN l_from_date AND l_to_date
                   AND    category = nvl(l_category, category)
                   AND    warehouse = l_warehouse
                   AND    item = nvl(l_inventory_item, item)
                   AND    document_number = nvl(l_document_num, document_number)
                   AND    receipt = l_receipt_num
                   AND    transaction_id = nvl(l_transaction_id, transaction_id)
                   AND    RC_Extracted IS NULL);

Line: 106

              print_debug('Updated ' || SQL%ROWCOUNT || ' rows.');

Line: 123

              print_debug('API Version Incompatible in the call to Update_RC_Extracted' );

Line: 138

              print_debug('Error in Update_RC_Extracted' );

Line: 142

    END Update_RC_Extracted;

Line: 196

              SELECT organization_id
              INTO   l_organization_id
              FROM   org_organization_definitions
              WHERE  organization_name = p_organization_name;

Line: 217

              SELECT inventory_item_id
              INTO   l_inventory_item_id
              FROM   mtl_system_items_kfv
              WHERE  organization_id       = l_organization_id
              AND    concatenated_segments = p_inventory_item;

Line: 239

              SELECT transaction_type_id
              INTO   l_transaction_type_id
              FROM   mtl_transaction_types
              WHERE  transaction_type_name = p_transaction_type;

Line: 386

        stmt :=    'SELECT  * '
                || ' FROM   MTL_ADJUSTMENT_TXN_SYNC_V '
                || ' WHERE  organization_id       = :org '
                || ' AND    Category              = :category '
                || ' AND    Creation_Date      BETWEEN :fr_date AND :to_date ';

Line: 486

        UPDATE mtl_material_transactions
        SET    transaction_extracted = l_extract_flag
        WHERE  transaction_id        = t_txn_id(i);

Line: 494

        l_txn_detail.DELETE;

Line: 495

        t_txn_id.DELETE;

Line: 505

          l_txn_detail.DELETE;

Line: 514

          l_txn_detail.DELETE;

Line: 527

          l_txn_detail.DELETE;