APPS.INV_LOT_ATTR_PUB SQL Statements

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

Line: 31

SELECT  grade_code
FROM  mtl_grades
WHERE  Grade_code = p_grade_code;

Line: 36

SELECT  grade_control_flag
FROM  mtl_system_items
WHERE inventory_item_id = p_inventory_item_id
AND  organization_id   = p_org_id;

Line: 330

   SELECT  action_code
   FROM  mtl_actions
   WHERE  action_code = p_expiration_action_code
   AND  NVL(disable_flag,'N') = 'N';

Line: 337

SELECT  shelf_life_code
FROM  mtl_system_items
WHERE inventory_item_id = p_inventory_item_id
AND  organization_id   = p_org_id;

Line: 418

    SELECT MTR.REASON_ID
    FROM MTL_TRANSACTION_REASONS MTR
    WHERE MTR.REASON_ID = p_reason_id
    AND NVL(MTR.DISABLE_DATE, SYSDATE + 1) > SYSDATE;

Line: 425

    SELECT MTR.REASON_ID
    FROM MTL_TRANSACTION_REASONS MTR
    WHERE MTR.REASON_NAME = p_reason_code
    AND NVL(MTR.DISABLE_DATE, SYSDATE + 1) > SYSDATE;

Line: 509

   SELECT  lookup_code
     FROM  mfg_lookups
    WHERE  lookup_type = 'MTL_LOT_ORIGINATION_TYPE'
      AND  lookup_code = p_origination_type;

Line: 587

   SELECT  *
     FROM  mtl_lot_numbers
    WHERE  lot_number        = p_lot_number
      AND  inventory_item_id = p_inventory_item_id
      AND  organization_id   = p_org_id;

Line: 595

    SELECT  p_child_lot_flag
    FROM  mtl_system_items
	WHERE inventory_item_id = p_inventory_item_id
	AND  organization_id   = p_org_id;

Line: 713

, p_last_updated_by       IN              NUMBER
, p_last_update_date      IN              DATE
, p_last_update_login     IN              NUMBER
, p_request_id            IN              NUMBER
, p_program_application_id IN             NUMBER
, p_program_id            IN              NUMBER
, p_program_update_date   IN              DATE
, x_return_status         OUT NOCOPY      VARCHAR2
, x_msg_count             OUT NOCOPY      NUMBER
, x_msg_data              OUT NOCOPY      VARCHAR2
 ) IS

l_return_status        VARCHAR2(2);

Line: 729

l_qty_tbl              MTL_LOT_UOM_CONV_PUB.quantity_update_rec_type;

Line: 743

   , p_quantity_updates 	=> 'F'
   , p_update_type 			=> p_action_type
   );

Line: 772

  l_conv_rec.last_updated_by 		:= p_last_updated_by ;

Line: 773

  l_conv_rec.last_update_date 		:= p_last_update_date;

Line: 775

  l_conv_rec.last_update_login 		:= p_last_update_login;

Line: 779

  l_conv_rec.program_update_date 	:= p_program_update_date;

Line: 784

     Insert/update conversion record.
   ==================================*/


  MTL_LOT_UOM_CONV_PUB.create_lot_uom_conversion
  ( p_api_version           => 1.0
  , p_init_msg_list         => FND_API.G_TRUE
  , p_commit                => FND_API.G_FALSE
  , p_validation_level      => FND_API.G_VALID_LEVEL_NONE
  , p_action_type           => l_action_type
  , p_update_type_indicator => '5'
  , p_reason_id             => NULL
  , p_batch_id              => NULL
  , p_process_data          => FND_API.G_TRUE
  , p_lot_uom_conv_rec      => l_conv_rec
  , p_qty_update_tbl        => l_qty_tbl
  , x_return_status         => l_return_status
  , x_msg_count            => l_msg_count
  , x_msg_data              => l_msg_data
  , x_sequence              =>  l_sequence);