APPS.WIP_SERIAL_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_serials in out nocopy mtl_serial_numbers_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,
      vendor_serial_number,
      vendor_lot_number,
      fm_serial_number,
      to_serial_number,
      serial_prefix,
      error_code error_code,
      group_header_id
    from mtl_serial_numbers_temp
    where transaction_temp_id = c_tmp_id;

Line: 53

      p_serials.last_update_date(i) := serial_rec.last_update_date;

Line: 54

      p_serials.last_updated_by(i) := serial_rec.last_updated_by;

Line: 57

      p_serials.last_update_login(i) := serial_rec.last_update_login;

Line: 61

      p_serials.program_update_date(i) := serial_rec.program_update_date;

Line: 74

      delete from mtl_serial_numbers_temp
      where transaction_temp_id = p_tmp_id;

Line: 77

  end fetch_and_delete;

Line: 79

  procedure fetch_and_delete(
    p_hdr_id  in     number,
    p_serials in out nocopy mtl_serial_numbers_temp_rec) is

    i number := 0;

Line: 86

    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,
      vendor_serial_number,
      vendor_lot_number,
      fm_serial_number,
      to_serial_number,
      serial_prefix,
      error_code error_code,
      group_header_id
    from mtl_serial_numbers_temp
    where group_header_id = c_hdr_id;

Line: 128

      p_serials.last_update_date(i) := serial_rec.last_update_date;

Line: 129

      p_serials.last_updated_by(i) := serial_rec.last_updated_by;

Line: 132

      p_serials.last_update_login(i) := serial_rec.last_update_login;

Line: 136

      p_serials.program_update_date(i) := serial_rec.program_update_date;

Line: 149

      delete from mtl_serial_numbers_temp
      where group_header_id = p_hdr_id;

Line: 152

  end fetch_and_delete;

Line: 154

  procedure insert_rows(
    p_serials in mtl_serial_numbers_temp_rec) is
    i number := 1;

Line: 159

      insert into mtl_serial_numbers_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,
        vendor_serial_number,
        vendor_lot_number,
        fm_serial_number,
        to_serial_number,
        serial_prefix,
        error_code,
        group_header_id
      ) values (
        p_serials.transaction_temp_id(i),
        p_serials.last_update_date(i),
        p_serials.last_updated_by(i),
        p_serials.creation_date(i),
        p_serials.created_by(i),
        p_serials.last_update_login(i),
        p_serials.request_id(i),
        p_serials.program_application_id(i),
        p_serials.program_id(i),
        p_serials.program_update_date(i),
        p_serials.vendor_serial_number(i),
        p_serials.vendor_lot_number(i),
        p_serials.fm_serial_number(i),
        p_serials.to_serial_number(i),
        p_serials.serial_prefix(i),
        p_serials.error_code(i),
        p_serials.group_header_id(i)
      );

Line: 199

  end insert_rows;