APPS.CSI_EXTEND_ATTRIB_VLD_PVT SQL Statements

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

Line: 33

      SELECT  inventory_item_id,
              inv_master_organization_id
      INTO    p_inventory_item_id,
              p_inv_master_org_id
      FROM    csi_item_instances
      WHERE   instance_id = p_instance_id
      AND     ((active_end_date is NULL) OR (TRUNC(active_end_date,'MI') >= TRUNC(SYSDATE,'MI')));--Changed to trunc for bug 9756224

Line: 44

        IF p_event = 'INSERT' THEN
            IF ( p_stack_err_msg = TRUE ) THEN
                 FND_MESSAGE.SET_NAME('CSI','CSI_API_INVALID_INSTANCE_ID');

Line: 51

        ELSIF p_event = 'UPDATE' THEN
            IF ( p_stack_err_msg = TRUE ) THEN
                 FND_MESSAGE.SET_NAME('CSI','CSI_API_EXP_EXT_INST_ID');

Line: 67

/* Function Name :  Val_inst_id_for_update                  */
/*                                                          */
/* Description  :  This function checks if  instance        */
/*                 ids can be updated                       */
/*----------------------------------------------------------*/

FUNCTION Val_inst_id_for_update
                     (  p_instance_id_new   IN      NUMBER
                       ,p_instance_id_old   IN      NUMBER
                       ,p_stack_err_msg     IN      BOOLEAN )
RETURN BOOLEAN
IS
  l_instance_id            NUMBER;

Line: 101

END Val_inst_id_for_update;

Line: 133

      SELECT     attribute_level
                ,master_organization_id
                ,inventory_item_id
                ,item_category_id
                ,instance_id
      INTO       p_attribute_level
                ,p_master_organization_id
                ,p_inventory_item_id
                ,p_item_category_id
                ,p_instance_id
      FROM    csi_i_extended_attribs
      WHERE   attribute_id = p_attribute_id;

Line: 185

     SELECT    attribute_value_id,
               attribute_id,
               instance_id,
               attribute_value,
               active_start_date,
               active_end_date,
               context,
               attribute1,
               attribute2,
               attribute3,
               attribute4,
               attribute5,
               attribute6,
               attribute7,
               attribute8,
               attribute9,
               attribute10,
               attribute11,
               attribute12,
               attribute13,
               attribute14,
               attribute15,
               object_version_number
      INTO     p_ext_attrib_rec.attribute_value_id,
               p_ext_attrib_rec.attribute_id,
               p_ext_attrib_rec.instance_id,
               p_ext_attrib_rec.attribute_value,
               p_ext_attrib_rec.active_start_date,
               p_ext_attrib_rec.active_end_date,
               p_ext_attrib_rec.context,
               p_ext_attrib_rec.attribute1,
               p_ext_attrib_rec.attribute2,
               p_ext_attrib_rec.attribute3,
               p_ext_attrib_rec.attribute4,
               p_ext_attrib_rec.attribute5,
               p_ext_attrib_rec.attribute6,
               p_ext_attrib_rec.attribute7,
               p_ext_attrib_rec.attribute8,
               p_ext_attrib_rec.attribute9,
               p_ext_attrib_rec.attribute10,
               p_ext_attrib_rec.attribute11,
               p_ext_attrib_rec.attribute12,
               p_ext_attrib_rec.attribute13,
               p_ext_attrib_rec.attribute14,
               p_ext_attrib_rec.attribute15,
               p_ext_attrib_rec.object_version_number
      FROM    csi_iea_values
      WHERE   attribute_value_id = p_att_value_id;

Line: 344

      SELECT  '1'
      INTO    l_dummy
      FROM    csi_iea_values
      WHERE   instance_id  = p_instance_id
      AND     attribute_id = p_attribute_id;

Line: 381

      SELECT   active_start_date,
               active_end_date
      FROM csi_item_instances
      WHERE instance_id = p_instance_id;

Line: 457

       SELECT active_start_date,
              active_end_date
       FROM   csi_item_instances
       WHERE  instance_id = p_instance_id;

Line: 484

         SELECT MAX(t.transaction_date)
         INTO   l_transaction_date
         FROM   csi_iea_values_h s,
                csi_transactions t
         WHERE  s.attribute_value_id=p_attr_value_id
         AND    s.transaction_id=t.transaction_id
	 AND    t.transaction_id <> nvl(p_txn_id, -99999);

Line: 598

       SELECT '1'
       INTO  l_dummy
       FROM  mtl_item_categories ic
       WHERE ic.inventory_item_id = p_orig_inv_item_id
       AND   ic.organization_id = p_orig_master_org_id
       AND   ic.category_id = p_item_category_id
       AND   ic.category_set_id = l_category_set_id;

Line: 659

      SELECT  '1'
      INTO    l_attribute_value_id
      FROM    csi_iea_values
      WHERE  attribute_value_id  = p_attribute_value_id ;

Line: 688

      SELECT  csi_iea_values_s.nextval
      INTO    l_attribute_value_id
      FROM    dual;

Line: 715

      SELECT  csi_iea_values_h_s.nextval
      INTO    l_attribute_value_id
      FROM    dual;