DBA Data[Home] [Help]

APPS.OKL_BKT_PVT SQL Statements

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

Line: 43

    SELECT
            ID,
            IBC_ID,
            VERSION,
            LOSS_RATE,
            OBJECT_VERSION_NUMBER,
            COMMENTS,
            PROGRAM_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_UPDATE_DATE,
            START_DATE,
			END_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Buckets
     WHERE okl_buckets.id       = p_id;
Line: 79

              l_bkt_rec.PROGRAM_UPDATE_DATE,
              l_bkt_rec.START_DATE,
              l_bkt_rec.END_DATE,
              l_bkt_rec.CREATED_BY,
              l_bkt_rec.CREATION_DATE,
              l_bkt_rec.LAST_UPDATED_BY,
              l_bkt_rec.LAST_UPDATE_DATE,
              l_bkt_rec.LAST_UPDATE_LOGIN;
Line: 107

    SELECT
            ID,
            OBJECT_VERSION_NUMBER,
            IBC_ID,
            VERSION,
            COMMENTS,
            LOSS_RATE,
            PROGRAM_ID,
            REQUEST_ID,
            PROGRAM_APPLICATION_ID,
            PROGRAM_UPDATE_DATE,
            START_DATE,
			END_DATE,
            CREATED_BY,
            CREATION_DATE,
            LAST_UPDATED_BY,
            LAST_UPDATE_DATE,
            LAST_UPDATE_LOGIN
      FROM Okl_Buckets_V
     WHERE okl_buckets_v.id     = p_id;
Line: 143

              l_bktv_rec.PROGRAM_UPDATE_DATE,
              l_bktv_rec.START_DATE,
              l_bktv_rec.END_DATE,
              l_bktv_rec.CREATED_BY,
              l_bktv_rec.CREATION_DATE,
              l_bktv_rec.LAST_UPDATED_BY,
              l_bktv_rec.LAST_UPDATE_DATE,
              l_bktv_rec.LAST_UPDATE_LOGIN;
Line: 204

    IF (l_bktv_rec.program_update_date = OKC_API.G_MISS_DATE) THEN
      l_bktv_rec.program_update_date := NULL;
Line: 215

    IF (l_bktv_rec.last_updated_by = Okc_Api.G_MISS_NUM) THEN
      l_bktv_rec.last_updated_by := NULL;
Line: 218

    IF (l_bktv_rec.last_update_date = Okc_Api.G_MISS_DATE) THEN
      l_bktv_rec.last_update_date := NULL;
Line: 221

    IF (l_bktv_rec.last_update_login = Okc_Api.G_MISS_NUM) THEN
      l_bktv_rec.last_update_login := NULL;
Line: 410

	SELECT '1'
	FROM OKX_AGING_BUCKETS_V
	WHERE aging_bucket_line_id = p_ibc_id;
Line: 702

    SELECT 1
    FROM okl_buckets_v
    WHERE  ibc_id = p_ibc_id
    AND    version = p_version
	AND    id <> p_id;
Line: 961

    p_to.program_update_date := p_from.program_update_date;
Line: 966

    p_to.last_updated_by := p_from.last_updated_by;
Line: 967

    p_to.last_update_date := p_from.last_update_date;
Line: 968

    p_to.last_update_login := p_from.last_update_login;
Line: 984

    p_to.program_update_date := p_from.program_update_date;
Line: 989

    p_to.last_updated_by := p_from.last_updated_by;
Line: 990

    p_to.last_update_date := p_from.last_update_date;
Line: 991

    p_to.last_update_login := p_from.last_update_login;
Line: 1153

  Procedure insert_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_bkt_rec                      IN bkt_rec_type,
    x_bkt_rec                      OUT NOCOPY bkt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1162

    l_api_name                     CONSTANT VARCHAR2(30) := 'BUCKETS_insert_row';
Line: 1198

    INSERT INTO OKL_BUCKETS(
        id,
        ibc_id,
        version,
        loss_rate,
        object_version_number,
        comments,
        program_id,
        request_id,
        program_application_id,
        program_update_date,
        start_date,
		end_date,
        created_by,
        creation_date,
        last_updated_by,
        last_update_date,
        last_update_login)
      VALUES (
        l_bkt_rec.id,
        l_bkt_rec.ibc_id,
        l_bkt_rec.version,
        l_bkt_rec.loss_rate,
        l_bkt_rec.object_version_number,
        l_bkt_rec.comments,
        l_bkt_rec.program_id,
        l_bkt_rec.request_id,
        l_bkt_rec.program_application_id,
        l_bkt_rec.program_update_date,
        l_bkt_rec.start_date,
        l_bkt_rec.end_date,
        l_bkt_rec.created_by,
        l_bkt_rec.creation_date,
        l_bkt_rec.last_updated_by,
        l_bkt_rec.last_update_date,
        l_bkt_rec.last_update_login);
Line: 1268

  END insert_row;
Line: 1272

  Procedure insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_bktv_rec                     IN bktv_rec_type,
    x_bktv_rec                     OUT NOCOPY bktv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1282

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_insert_row';
Line: 1298

      l_bktv_rec.LAST_UPDATE_DATE := l_bktv_rec.CREATION_DATE;
Line: 1299

      l_bktv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;
Line: 1300

      l_bktv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 1315

	SELECT DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, Fnd_Global.CONC_REQUEST_ID),
		DECODE(Fnd_Global.PROG_APPL_ID, -1, NULL, Fnd_Global.PROG_APPL_ID),
		DECODE(Fnd_Global.CONC_PROGRAM_ID, -1, NULL, Fnd_Global.CONC_PROGRAM_ID),
		DECODE(Fnd_Global.CONC_REQUEST_ID, -1, NULL, SYSDATE)
	INTO  x_bktv_rec.REQUEST_ID
		,x_bktv_rec.PROGRAM_APPLICATION_ID
		,x_bktv_rec.PROGRAM_ID
		,x_bktv_rec.PROGRAM_UPDATE_DATE
	FROM DUAL;
Line: 1375

    insert_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_bkt_rec,
      lx_bkt_rec
    );
Line: 1423

  END insert_row;
Line: 1427

  Procedure insert_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_bktv_tbl                     IN bktv_tbl_type,
    x_bktv_tbl                     OUT NOCOPY bktv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1437

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
Line: 1447

        insert_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => Okc_Api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_bktv_rec                     => p_bktv_tbl(i),
          x_bktv_rec                     => x_bktv_tbl(i));
Line: 1500

  END insert_row;
Line: 1518

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_BUCKETS
     WHERE ID = p_bkt_rec.id
       AND OBJECT_VERSION_NUMBER = p_bkt_rec.object_version_number
    FOR UPDATE OF OBJECT_VERSION_NUMBER NOWAIT;
Line: 1525

    SELECT OBJECT_VERSION_NUMBER
      FROM OKL_BUCKETS
    WHERE ID = p_bkt_rec.id;
Line: 1566

      Okc_Api.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
Line: 1575

      Okc_Api.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
Line: 1771

  Procedure update_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_bkt_rec                      IN bkt_rec_type,
    x_bkt_rec                      OUT NOCOPY bkt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1780

    l_api_name                     CONSTANT VARCHAR2(30) := 'BUCKETS_update_row';
Line: 1838

      IF (x_bkt_rec.program_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_bkt_rec.program_update_date := l_bkt_rec.program_update_date;
Line: 1858

      IF (x_bkt_rec.last_updated_by = Okc_Api.G_MISS_NUM)
      THEN
        x_bkt_rec.last_updated_by := l_bkt_rec.last_updated_by;
Line: 1862

      IF (x_bkt_rec.last_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_bkt_rec.last_update_date := l_bkt_rec.last_update_date;
Line: 1866

      IF (x_bkt_rec.last_update_login = Okc_Api.G_MISS_NUM)
      THEN
        x_bkt_rec.last_update_login := l_bkt_rec.last_update_login;
Line: 1910

    UPDATE  OKL_BUCKETS
    SET IBC_ID = l_def_bkt_rec.ibc_id,
        VERSION = l_def_bkt_rec.version,
        LOSS_RATE = l_def_bkt_rec.loss_rate,
        OBJECT_VERSION_NUMBER = l_def_bkt_rec.object_version_number,
        COMMENTS = l_def_bkt_rec.comments,
        PROGRAM_ID = l_def_bkt_rec.program_id,
        REQUEST_ID = l_def_bkt_rec.request_id,
        PROGRAM_APPLICATION_ID = l_def_bkt_rec.program_application_id,
        PROGRAM_UPDATE_DATE = l_def_bkt_rec.program_update_date,
        START_DATE = l_def_bkt_rec.start_date,
        END_DATE = l_def_bkt_rec.end_date,
        CREATED_BY = l_def_bkt_rec.created_by,
        CREATION_DATE = l_def_bkt_rec.creation_date,
        LAST_UPDATED_BY = l_def_bkt_rec.last_updated_by,
        LAST_UPDATE_DATE = l_def_bkt_rec.last_update_date,
        LAST_UPDATE_LOGIN = l_def_bkt_rec.last_update_login
    WHERE ID = l_def_bkt_rec.id;
Line: 1962

  END update_row;
Line: 1966

  Procedure update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_bktv_rec                     IN bktv_rec_type,
    x_bktv_rec                     OUT NOCOPY bktv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 1976

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_update_row';
Line: 1990

      l_bktv_rec.LAST_UPDATE_DATE := SYSDATE;
Line: 1991

      l_bktv_rec.LAST_UPDATED_BY := Fnd_Global.User_Id;
Line: 1992

      l_bktv_rec.LAST_UPDATE_LOGIN := Fnd_Global.LOGIN_ID;
Line: 2048

      IF (x_bktv_rec.program_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_bktv_rec.program_update_date := l_bktv_rec.program_update_date;
Line: 2068

      IF (x_bktv_rec.last_updated_by = Okc_Api.G_MISS_NUM)
      THEN
        x_bktv_rec.last_updated_by := l_bktv_rec.last_updated_by;
Line: 2072

      IF (x_bktv_rec.last_update_date = Okc_Api.G_MISS_DATE)
      THEN
        x_bktv_rec.last_update_date := l_bktv_rec.last_update_date;
Line: 2076

      IF (x_bktv_rec.last_update_login = Okc_Api.G_MISS_NUM)
      THEN
        x_bktv_rec.last_update_login := l_bktv_rec.last_update_login;
Line: 2095

      SELECT  NVL(DECODE(FND_GLOBAL.conc_request_id, -1, NULL, fnd_global.conc_request_id) ,p_bktv_rec.REQUEST_ID)
    ,NVL(DECODE(fnd_global.prog_appl_id, -1, NULL, fnd_global.prog_appl_id) ,p_bktv_rec.PROGRAM_APPLICATION_ID)
    ,NVL(DECODE(fnd_global.conc_program_id, -1, NULL, fnd_global.conc_program_id)  ,p_bktv_rec.PROGRAM_ID)
    ,DECODE(DECODE(fnd_global.conc_request_id, -1, NULL, SYSDATE) ,NULL, p_bktv_rec.PROGRAM_UPDATE_DATE,SYSDATE)
        INTO x_bktv_rec.REQUEST_ID
    ,x_bktv_rec.PROGRAM_APPLICATION_ID
    ,x_bktv_rec.PROGRAM_ID
    ,x_bktv_rec.PROGRAM_UPDATE_DATE
    FROM DUAL;
Line: 2162

    update_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_bkt_rec,
      lx_bkt_rec
    );
Line: 2209

  END update_row;
Line: 2213

  Procedure update_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_bktv_tbl                     IN bktv_tbl_type,
    x_bktv_tbl                     OUT NOCOPY bktv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2223

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
Line: 2233

        update_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => Okc_Api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_bktv_rec                     => p_bktv_tbl(i),
          x_bktv_rec                     => x_bktv_tbl(i));
Line: 2286

  END update_row;
Line: 2294

  Procedure delete_row(
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_bkt_rec                      IN bkt_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2302

    l_api_name                     CONSTANT VARCHAR2(30) := 'BUCKETS_delete_row';
Line: 2316

    DELETE FROM OKL_BUCKETS
     WHERE ID = l_bkt_rec.id;
Line: 2351

  END delete_row;
Line: 2355

  Procedure delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_bktv_rec                     IN bktv_rec_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2364

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_delete_row';
Line: 2388

    delete_row(
      p_init_msg_list,
      x_return_status,
      x_msg_count,
      x_msg_data,
      l_bkt_rec
    );
Line: 2432

  END delete_row;
Line: 2436

  Procedure delete_row(
    p_api_version                  IN NUMBER,
    p_init_msg_list                IN VARCHAR2 DEFAULT Okc_Api.G_FALSE,
    x_return_status                OUT NOCOPY VARCHAR2,
    x_msg_count                    OUT NOCOPY NUMBER,
    x_msg_data                     OUT NOCOPY VARCHAR2,
    p_bktv_tbl                     IN bktv_tbl_type) IS

    l_api_version                 CONSTANT NUMBER := 1;
Line: 2445

    l_api_name                     CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
Line: 2455

        delete_row (
          p_api_version                  => p_api_version,
          p_init_msg_list                => Okc_Api.G_FALSE,
          x_return_status                => x_return_status,
          x_msg_count                    => x_msg_count,
          x_msg_data                     => x_msg_data,
          p_bktv_rec                     => p_bktv_tbl(i));
Line: 2507

  END delete_row;