DBA Data[Home] [Help]

APPS.OKL_STREAMS_PUB SQL Statements

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

Line: 608

  PROCEDURE update_streams(

    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_stmv_rec              IN  stmv_rec_type,

    p_selv_tbl              IN  selv_tbl_type,

    x_stmv_rec              OUT NOCOPY stmv_rec_type,

    x_selv_tbl              OUT NOCOPY selv_tbl_type) IS

    l_return_status         VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
Line: 630

    l_api_name              CONSTANT VARCHAR2(30)  := 'update_streams';
Line: 640

    SAVEPOINT update_streams;
Line: 663

    Okl_Streams_Pvt.update_streams(

                         p_api_version   => p_api_version

                        ,p_init_msg_list => p_init_msg_list

                        ,x_return_status => x_return_status

                        ,x_msg_count     => x_msg_count

                        ,x_msg_data      => x_msg_data

                        ,p_stmv_rec      => l_stmv_rec

                        ,p_selv_tbl      => l_selv_tbl

                        ,x_stmv_rec      => x_stmv_rec

                        ,x_selv_tbl      => x_selv_tbl

                        );
Line: 711

      ROLLBACK TO update_streams;
Line: 719

      ROLLBACK TO update_streams;
Line: 726

      FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');
Line: 734

  END update_streams;
Line: 1046

  PROCEDURE update_streams(

     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_stmv_rec                   IN  stmv_rec_type

    ,x_stmv_rec                   OUT NOCOPY stmv_rec_type) IS

    l_return_status               VARCHAR2(1)   := FND_API.G_RET_STS_SUCCESS;
Line: 1064

    l_api_name                    CONSTANT VARCHAR2(30)  := 'update_streams';
Line: 1070

    SAVEPOINT update_streams;
Line: 1091

    Okl_Streams_Pvt.update_streams(

                           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_stmv_rec      => l_stmv_rec

                          ,x_stmv_rec      => x_stmv_rec

                          );
Line: 1134

      ROLLBACK TO update_streams;
Line: 1142

      ROLLBACK TO update_streams;
Line: 1149

      FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');
Line: 1157

  END update_streams;
Line: 1161

  PROCEDURE update_streams(

     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_stmv_tbl                   IN  stmv_tbl_type

    ,x_stmv_tbl                   OUT NOCOPY stmv_tbl_type) IS

    l_return_status               VARCHAR2(1)   := FND_API.G_RET_STS_SUCCESS;
Line: 1179

    l_api_name                    CONSTANT VARCHAR2(30)  := 'update_streams';
Line: 1192

	SAVEPOINT update_streams;
Line: 1214

        update_streams(

                           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_stmv_rec      => l_stmv_tbl(i)

                          ,x_stmv_rec      => x_stmv_tbl(i)

                          );
Line: 1274

      ROLLBACK TO update_streams;
Line: 1282

      ROLLBACK TO update_streams;
Line: 1289

      FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_streams');
Line: 1299

  END update_streams;
Line: 1305

  PROCEDURE delete_streams(

     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_stmv_rec              IN  stmv_rec_type) IS

    i                        NUMBER :=0;
Line: 1323

    l_api_name               CONSTANT VARCHAR2(30)  := 'delete_streams';
Line: 1331

    SAVEPOINT delete_streams;
Line: 1352

    Okl_Streams_Pvt.delete_streams(

                           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_stmv_rec      => l_stmv_rec

                          );
Line: 1395

      ROLLBACK TO delete_streams;
Line: 1403

      ROLLBACK TO delete_streams;
Line: 1410

      FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_streams');
Line: 1418

  END delete_streams;
Line: 1422

  PROCEDURE delete_streams(

     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_stmv_tbl              IN  stmv_tbl_type) IS

    i                        NUMBER :=0;
Line: 1440

    l_api_name               CONSTANT VARCHAR2(30)  := 'delete_streams';
Line: 1451

	SAVEPOINT delete_streams;
Line: 1473

        delete_streams(

                             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_stmv_rec      => l_stmv_tbl(i)

                            );
Line: 1531

      ROLLBACK TO delete_streams;
Line: 1539

      ROLLBACK TO delete_streams;
Line: 1546

      FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_streams');
Line: 1556

  END delete_streams;
Line: 2250

  PROCEDURE update_stream_elements(

     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_selv_rec                       IN  selv_rec_type

    ,x_selv_rec                       OUT NOCOPY selv_rec_type) IS

    l_return_status                   VARCHAR2(1)   := FND_API.G_RET_STS_SUCCESS;
Line: 2268

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_stream_elements';
Line: 2274

    SAVEPOINT update_stream_elements;
Line: 2295

    Okl_Streams_Pvt.update_stream_elements(

                           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_selv_rec      => l_selv_rec

                          ,x_selv_rec      => x_selv_rec

                          );
Line: 2338

      ROLLBACK TO update_stream_elements;
Line: 2346

      ROLLBACK TO update_stream_elements;
Line: 2353

      FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_stream_elements');
Line: 2361

  END update_stream_elements;
Line: 2365

  PROCEDURE update_stream_elements(

     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_selv_tbl                       IN  selv_tbl_type

    ,x_selv_tbl                       OUT NOCOPY selv_tbl_type) IS

    l_return_status                   VARCHAR2(1)   := FND_API.G_RET_STS_SUCCESS;
Line: 2383

    l_api_name                        CONSTANT VARCHAR2(30)  := 'update_stream_elements';
Line: 2394

    SAVEPOINT update_stream_elements;
Line: 2419

        update_stream_elements(

                           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_selv_rec      => l_selv_tbl(i)

                          ,x_selv_rec      => x_selv_tbl(i)

                          );
Line: 2478

      ROLLBACK TO update_stream_elements;
Line: 2486

      ROLLBACK TO update_stream_elements;
Line: 2493

      FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','update_stream_elements');
Line: 2503

  END update_stream_elements;
Line: 2509

  PROCEDURE delete_stream_elements(

     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_selv_rec                       IN  selv_rec_type) IS

    i                                 NUMBER :=0;
Line: 2527

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_stream_elements';
Line: 2533

    SAVEPOINT delete_stream_elements;
Line: 2556

    Okl_Streams_Pvt.delete_stream_elements(

                           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_selv_rec      => l_selv_rec);
Line: 2595

      ROLLBACK TO delete_stream_elements;
Line: 2603

      ROLLBACK TO delete_stream_elements;
Line: 2610

      FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_stream_elements');
Line: 2618

  END delete_stream_elements;
Line: 2622

  PROCEDURE delete_stream_elements(

     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_selv_tbl                       IN  selv_tbl_type) IS



    i                                 NUMBER :=0;
Line: 2642

    l_api_name                        CONSTANT VARCHAR2(30)  := 'delete_stream_elements';
Line: 2651

    SAVEPOINT delete_stream_elements;
Line: 2676

        delete_stream_elements(

                                  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_selv_rec      => l_selv_tbl(i));
Line: 2731

      ROLLBACK TO delete_stream_elements;
Line: 2739

      ROLLBACK TO delete_stream_elements;
Line: 2746

      FND_MSG_PUB.ADD_EXC_MSG('OKL_STREAMS_PUB','delete_stream_elements');
Line: 2754

  END delete_stream_elements;