eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_BCT_PVT SQL Statements

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

Line: 31


  SELECT
    USER_ID,
    ORG_ID,
    BATCH_NUMBER,
    PROCESSING_SRL_NUMBER,
    KHR_ID,
    PROGRAM_NAME,
    PROG_SHORT_NAME,
    CONC_REQ_ID,
    PROGRESS_STATUS,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    ACTIVE_FLAG
  FROM OKL_BOOK_CONTROLLER_TRX
  WHERE OKL_BOOK_CONTROLLER_TRX.BATCH_NUMBER = p_batch_number
  AND OKL_BOOK_CONTROLLER_TRX.PROCESSING_SRL_NUMBER = p_srl_number;

Line: 69


    l_bct_rec.LAST_UPDATED_BY,
    l_bct_rec.LAST_UPDATE_DATE,
    l_bct_rec.LAST_UPDATE_LOGIN,
    l_bct_rec.ACTIVE_FLAG;

Line: 127


  IF (l_bct_rec.LAST_UPDATED_BY=OKL_API.G_MISS_NUM) THEN
    l_bct_rec.LAST_UPDATED_BY:=NULL;

Line: 130


  IF (l_bct_rec.LAST_UPDATE_DATE=OKL_API.G_MISS_DATE) THEN
    l_bct_rec.LAST_UPDATE_DATE:=NULL;

Line: 133


  IF (l_bct_rec.LAST_UPDATE_LOGIN=OKL_API.G_MISS_NUM) THEN
    l_bct_rec.LAST_UPDATE_LOGIN:=NULL;

Line: 693


PROCEDURE insert_row(
     p_api_version     IN NUMBER ,
     p_init_msg_list   IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
     x_return_status   OUT NOCOPY VARCHAR2,
     x_msg_count       OUT NOCOPY NUMBER,
     x_msg_data        OUT NOCOPY VARCHAR2,
     p_bct_rec         IN okl_bct_rec,
     x_bct_rec         OUT NOCOPY okl_bct_rec)IS

  l_api_version     CONSTANT NUMBER:=1;

Line: 703


  l_api_name        CONSTANT VARCHAR2(30):='insert_row';

Line: 715


    l_bct_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 716


    l_bct_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 717


    l_bct_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 772


  INSERT INTO OKL_BOOK_CONTROLLER_TRX(
    USER_ID,
    ORG_ID,
    BATCH_NUMBER,
    PROCESSING_SRL_NUMBER,
    KHR_ID,
    PROGRAM_NAME,
    PROG_SHORT_NAME,
    CONC_REQ_ID,
    PROGRESS_STATUS,
    CREATED_BY,
    CREATION_DATE,
    LAST_UPDATED_BY,
    LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN,
    ACTIVE_FLAG)
  VALUES(
    l_def_bct_rec.USER_ID,
    l_def_bct_rec.ORG_ID,
    l_def_bct_rec.BATCH_NUMBER,
    l_def_bct_rec.PROCESSING_SRL_NUMBER,
    l_def_bct_rec.KHR_ID,
    l_def_bct_rec.PROGRAM_NAME,
    l_def_bct_rec.PROG_SHORT_NAME,
    l_def_bct_rec.CONC_REQ_ID,
    l_def_bct_rec.PROGRESS_STATUS,
    l_def_bct_rec.CREATED_BY,
    l_def_bct_rec.CREATION_DATE,
    l_def_bct_rec.LAST_UPDATED_BY,
    l_def_bct_rec.LAST_UPDATE_DATE,
    l_def_bct_rec.LAST_UPDATE_LOGIN,
    l_def_bct_rec.ACTIVE_FLAG);

Line: 840


END insert_row;

Line: 844


PROCEDURE insert_row(
     p_api_version     IN NUMBER ,
     p_init_msg_list   IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
     x_return_status   OUT NOCOPY VARCHAR2,
     x_msg_count       OUT NOCOPY NUMBER,
     x_msg_data        OUT NOCOPY VARCHAR2,
     p_bct_tbl         IN okl_bct_tbl,
     x_bct_tbl         OUT NOCOPY okl_bct_tbl)IS

  l_api_version     CONSTANT NUMBER:=1;

Line: 854


  l_api_name        CONSTANT VARCHAR2(30):='insert_row_tbl';

Line: 864


      insert_row(p_api_version   => p_api_version,
                 p_init_msg_list => OKL_API.G_FALSE,
                 x_return_status => x_return_status,
                 x_msg_count     => x_msg_count,
                 x_msg_data      => x_msg_data,
                 p_bct_rec       => p_bct_tbl(i),
                 x_bct_rec       => x_bct_tbl(i));

Line: 915


END insert_row;

Line: 919


PROCEDURE update_row(
     p_api_version     IN NUMBER ,
     p_init_msg_list   IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
     x_return_status   OUT NOCOPY VARCHAR2,
     x_msg_count       OUT NOCOPY NUMBER,
     x_msg_data        OUT NOCOPY VARCHAR2,
     p_bct_rec         IN okl_bct_rec,
     x_bct_rec         OUT NOCOPY okl_bct_rec)IS

  l_api_version     CONSTANT NUMBER:=1;

Line: 929


  l_api_name        CONSTANT VARCHAR2(30):='update_row';

Line: 939


    l_bct_rec.LAST_UPDATE_DATE := SYSDATE;

Line: 940


    l_bct_rec.LAST_UPDATED_BY := FND_GLOBAL.USER_ID;

Line: 941


    l_bct_rec.LAST_UPDATE_LOGIN := FND_GLOBAL.LOGIN_ID;

Line: 994


    IF (x_bct_rec.LAST_UPDATED_BY = OKL_API.G_MISS_NUM) THEN
      x_bct_rec.LAST_UPDATED_BY:=l_bct_rec.LAST_UPDATED_BY;

Line: 997


    IF (x_bct_rec.LAST_UPDATE_DATE = OKL_API.G_MISS_DATE) THEN
      x_bct_rec.LAST_UPDATE_DATE:=l_bct_rec.LAST_UPDATE_DATE;

Line: 1000


    IF (x_bct_rec.LAST_UPDATE_LOGIN = OKL_API.G_MISS_NUM) THEN
      x_bct_rec.LAST_UPDATE_LOGIN:=l_bct_rec.LAST_UPDATE_LOGIN;

Line: 1066


  UPDATE OKL_BOOK_CONTROLLER_TRX
  SET
    USER_ID= l_def_bct_rec.USER_ID,
    ORG_ID= l_def_bct_rec.ORG_ID,
    BATCH_NUMBER= l_def_bct_rec.BATCH_NUMBER,
    PROCESSING_SRL_NUMBER= l_def_bct_rec.PROCESSING_SRL_NUMBER,
    KHR_ID= l_def_bct_rec.KHR_ID,
    PROGRAM_NAME= l_def_bct_rec.PROGRAM_NAME,
    PROG_SHORT_NAME= l_def_bct_rec.PROG_SHORT_NAME,
    CONC_REQ_ID= l_def_bct_rec.CONC_REQ_ID,
    PROGRESS_STATUS= l_def_bct_rec.PROGRESS_STATUS,
    CREATED_BY= l_def_bct_rec.CREATED_BY,
    CREATION_DATE= l_def_bct_rec.CREATION_DATE,
    LAST_UPDATED_BY= l_def_bct_rec.LAST_UPDATED_BY,
    LAST_UPDATE_DATE= l_def_bct_rec.LAST_UPDATE_DATE,
    LAST_UPDATE_LOGIN= l_def_bct_rec.LAST_UPDATE_LOGIN,
    ACTIVE_FLAG= l_def_bct_rec.ACTIVE_FLAG
  WHERE BATCH_NUMBER = l_def_bct_rec.BATCH_NUMBER
  AND PROCESSING_SRL_NUMBER = l_def_bct_rec.PROCESSING_SRL_NUMBER;

Line: 1121


END update_row;

Line: 1125


PROCEDURE update_row(
     p_api_version     IN NUMBER ,
     p_init_msg_list   IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
     x_return_status   OUT NOCOPY VARCHAR2,
     x_msg_count       OUT NOCOPY NUMBER,
     x_msg_data        OUT NOCOPY VARCHAR2,
     p_bct_tbl         IN okl_bct_tbl,
     x_bct_tbl         OUT NOCOPY okl_bct_tbl)IS

  l_api_version     CONSTANT NUMBER:=1;

Line: 1135


  l_api_name        CONSTANT VARCHAR2(30):='update_row_tbl';

Line: 1145


      update_row (p_api_version   => p_api_version,
                  p_init_msg_list => OKL_API.G_FALSE,
                  x_return_status => x_return_status,
                  x_msg_count     => x_msg_count,
                  x_msg_data      => x_msg_data,
                  p_bct_rec       => p_bct_tbl(i),
                  x_bct_rec       => x_bct_tbl(i));

Line: 1195


END update_row;

Line: 1199


PROCEDURE delete_row(
     p_api_version     IN NUMBER ,
     p_init_msg_list   IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
     x_return_status   OUT NOCOPY VARCHAR2,
     x_msg_count       OUT NOCOPY NUMBER,
     x_msg_data        OUT NOCOPY VARCHAR2,
     p_bct_rec         IN okl_bct_rec)IS

  l_api_version    CONSTANT NUMBER:=1;

Line: 1208


  l_api_name       CONSTANT VARCHAR2(30):='delete_row';

Line: 1228


  DELETE FROM OKL_BOOK_CONTROLLER_TRX
  WHERE BATCH_NUMBER=l_bct_rec.batch_number
  AND PROCESSING_SRL_NUMBER = l_bct_rec.processing_srl_number;

Line: 1263


END delete_row;

Line: 1267


PROCEDURE delete_row(
     p_api_version     IN NUMBER ,
     p_init_msg_list   IN VARCHAR2 DEFAULT OKL_API.G_FALSE,
     x_return_status   OUT NOCOPY VARCHAR2,
     x_msg_count       OUT NOCOPY NUMBER,
     x_msg_data        OUT NOCOPY VARCHAR2,
     p_bct_tbl         IN okl_bct_tbl)IS

  l_api_version     CONSTANT NUMBER:=1;

Line: 1276


  l_api_name        CONSTANT VARCHAR2(30):='delete_row_tbl';

Line: 1286


      delete_row(p_api_version   => p_api_version,
                 p_init_msg_list => OKL_API.G_FALSE,
                 x_return_status => x_return_status,
                 x_msg_count     => x_msg_count,
                 x_msg_data      => x_msg_data,
                 p_bct_rec       => p_bct_tbl(i));

Line: 1335


END delete_row;