APPS.WIP_LOT_TEMP_CLEANUP SQL Statements

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

Line: 4

  procedure fetch_and_delete(
    p_tmp_id in     number,
    p_lots   in out nocopy mtl_transaction_lots_temp_rec) is

    i number := 0;

Line: 11

    select
      transaction_temp_id,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      last_update_login,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      transaction_quantity,
      primary_quantity,
      lot_number,
      lot_expiration_date,
      error_code,
      serial_transaction_temp_id,
      group_header_id
    from mtl_transaction_lots_temp
    where transaction_temp_id = c_tmp_id;

Line: 53

      p_lots.last_update_date(i) := lot_rec.last_update_date;

Line: 54

      p_lots.last_updated_by(i) := lot_rec.last_updated_by;

Line: 57

      p_lots.last_update_login(i) := lot_rec.last_update_login;

Line: 61

      p_lots.program_update_date(i) := lot_rec.program_update_date;

Line: 74

      delete from mtl_transaction_lots_temp
      where transaction_temp_id = p_tmp_id;

Line: 77

  end fetch_and_delete;

Line: 80

  procedure fetch_and_delete(
    p_hdr_id in     number,
    p_lots   in out nocopy mtl_transaction_lots_temp_rec) is

    i number := 0;

Line: 87

    select
      transaction_temp_id,
      last_update_date,
      last_updated_by,
      creation_date,
      created_by,
      last_update_login,
      request_id,
      program_application_id,
      program_id,
      program_update_date,
      transaction_quantity,
      primary_quantity,
      lot_number,
      lot_expiration_date,
      error_code,
      serial_transaction_temp_id,
      group_header_id
    from mtl_transaction_lots_temp
    where group_header_id = c_hdr_id;

Line: 129

      p_lots.last_update_date(i) := lot_rec.last_update_date;

Line: 130

      p_lots.last_updated_by(i) := lot_rec.last_updated_by;

Line: 133

      p_lots.last_update_login(i) := lot_rec.last_update_login;

Line: 137

      p_lots.program_update_date(i) := lot_rec.program_update_date;

Line: 150

      delete from mtl_transaction_lots_temp
      where group_header_id = p_hdr_id;

Line: 153

  end fetch_and_delete;

Line: 155

  procedure insert_rows(
    p_lots in mtl_transaction_lots_temp_rec) is
    i number := 1;

Line: 160

      insert into mtl_transaction_lots_temp (
        transaction_temp_id,
        last_update_date,
        last_updated_by,
        creation_date,
        created_by,
        last_update_login,
        request_id,
        program_application_id,
        program_id,
        program_update_date,
        transaction_quantity,
        primary_quantity,
        lot_number,
        lot_expiration_date,
        error_code,
        serial_transaction_temp_id,
        group_header_id
      ) values (
        p_lots.transaction_temp_id(i),
        p_lots.last_update_date(i),
        p_lots.last_updated_by(i),
        p_lots.creation_date(i),
        p_lots.created_by(i),
        p_lots.last_update_login(i),
        p_lots.request_id(i),
        p_lots.program_application_id(i),
        p_lots.program_id(i),
        p_lots.program_update_date(i),
        p_lots.transaction_quantity(i),
        p_lots.primary_quantity(i),
        p_lots.lot_number(i),
        p_lots.lot_expiration_date(i),
        p_lots.error_code(i),
        p_lots.serial_transaction_temp_id(i),
        p_lots.group_header_id(i)
      );

Line: 200

  end insert_rows;