DBA Data[Home] [Help]

APPS.OKC_ASSENT_PUB SQL Statements

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

Line: 24

    l_astv_rec.last_updated_by       := p_astv_rec1.last_updated_by;
Line: 25

    l_astv_rec.last_update_date      := p_astv_rec1.last_update_date;
Line: 26

    l_astv_rec.last_update_login     := p_astv_rec1.last_update_login;
Line: 58

    l_stsv_rec.last_updated_by       := p_stsv_rec1.last_updated_by;
Line: 59

    l_stsv_rec.last_update_date      := p_stsv_rec1.last_update_date;
Line: 60

    l_stsv_rec.last_update_login     := p_stsv_rec1.last_update_login;
Line: 213

  PROCEDURE update_assent(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_astv_rec                     IN  astv_rec_type,
     x_astv_rec                     OUT NOCOPY astv_rec_type) IS
     l_api_name      CONSTANT VARCHAR2(30) := 'update_assent';
Line: 246

     OKC_ASSENT_PVT.update_assent(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         l_astv_rec,
                         x_astv_rec);
Line: 296

  END update_assent;
Line: 301

  PROCEDURE update_assent(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_astv_tbl                     IN  astv_tbl_type,
     x_astv_tbl                     OUT NOCOPY astv_tbl_type) IS
     l_api_name      CONSTANT VARCHAR2(30) := 'update_assent';
Line: 318

       update_assent(
                         p_api_version         => p_api_version,
                         p_init_msg_list       => p_init_msg_list,
                         x_return_status       => l_return_status,
                         x_msg_count           => x_msg_count,
                         x_msg_data            => x_msg_data,
                         p_astv_rec            => p_astv_tbl(i),
                         x_astv_rec            => x_astv_tbl(i));
Line: 350

  END update_assent;
Line: 355

  PROCEDURE delete_assent(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_astv_rec                     IN  astv_rec_type) IS
     l_api_name      CONSTANT VARCHAR2(30) := 'delete_assent';
Line: 387

     OKC_ASSENT_PVT.delete_assent(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_astv_rec);
Line: 435

  END delete_assent;
Line: 440

  PROCEDURE delete_assent(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_astv_tbl                     IN astv_tbl_type) IS
     l_api_name      CONSTANT VARCHAR2(30) := 'delete_assent';
Line: 456

       delete_assent(
                         p_api_version         => p_api_version,
                         p_init_msg_list       => p_init_msg_list,
                         x_return_status       => l_return_status,
                         x_msg_count           => x_msg_count,
                         x_msg_data            => x_msg_data,
                         p_astv_rec            => p_astv_tbl(i));
Line: 487

  END delete_assent;
Line: 808

  PROCEDURE update_status(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_stsv_rec                     IN stsv_rec_type,
     x_stsv_rec                     OUT NOCOPY stsv_rec_type) IS
     l_api_name      CONSTANT VARCHAR2(30) := 'update_status';
Line: 841

     OKC_ASSENT_PVT.update_status(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         l_stsv_rec,
                         x_stsv_rec);
Line: 890

  END update_status;
Line: 895

  PROCEDURE update_status(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_stsv_tbl                     IN  stsv_tbl_type,
     x_stsv_tbl                     OUT NOCOPY stsv_tbl_type) IS
     l_api_name      CONSTANT VARCHAR2(30) := 'update_status';
Line: 912

       update_status(
                         p_api_version         => p_api_version,
                         p_init_msg_list       => p_init_msg_list,
                         x_return_status       => l_return_status,
                         x_msg_count           => x_msg_count,
                         x_msg_data            => x_msg_data,
                         p_stsv_rec            => p_stsv_tbl(i),
                         x_stsv_rec            => x_stsv_tbl(i));
Line: 944

  END update_status;
Line: 949

  PROCEDURE delete_status(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_stsv_rec                     IN stsv_rec_type) IS
     l_api_name      CONSTANT VARCHAR2(30) := 'delete_status';
Line: 981

     OKC_ASSENT_PVT.delete_status(
                         p_api_version,
                         p_init_msg_list,
                         x_return_status,
                         x_msg_count,
                         x_msg_data,
                         p_stsv_rec);
Line: 1028

  END delete_status;
Line: 1033

  PROCEDURE delete_status(
     p_api_version                  IN NUMBER,
     p_init_msg_list                IN VARCHAR2 ,
     x_return_status                OUT NOCOPY VARCHAR2,
     x_msg_count                    OUT NOCOPY NUMBER,
     x_msg_data                     OUT NOCOPY VARCHAR2,
     p_stsv_tbl                     IN  stsv_tbl_type) IS
     l_api_name      CONSTANT VARCHAR2(30) := 'delete_status';
Line: 1049

       delete_status(
                         p_api_version         => p_api_version,
                         p_init_msg_list       => p_init_msg_list,
                         x_return_status       => l_return_status,
                         x_msg_count           => x_msg_count,
                         x_msg_data            => x_msg_data,
                         p_stsv_rec            => p_stsv_tbl(i));
Line: 1080

  END delete_status;