DBA Data[Home] [Help]

APPS.OKL_CSH_ORDER_SEQ_PUB SQL Statements

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

Line: 15

PROCEDURE insert_order_sequence (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_okl_csh_order_rec        IN okl_csh_order_rec_type
       ,x_okl_csh_order_rec        OUT NOCOPY okl_csh_order_rec_type) IS

i                    NUMBER :=0;
Line: 41

SAVEPOINT csh_order_seq_update_rec;
Line: 58

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.insert_row ');
Line: 61

Okl_Csh_Order_Seq_Pvt.insert_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_okl_csh_order_rec
                         ,lx_okl_csh_order_rec);
Line: 71

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.insert_row ');
Line: 94

      ROLLBACK TO csh_order_seq_update_rec;
Line: 102

      ROLLBACK TO csh_order_seq_update_rec;
Line: 110

      ROLLBACK TO csh_order_seq_update_rec;
Line: 119

END insert_order_sequence;
Line: 125

PROCEDURE insert_order_sequence (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_okl_csh_order_tbl        IN okl_csh_order_tbl_type
       ,x_okl_csh_order_tbl        OUT NOCOPY okl_csh_order_tbl_type) IS

i                    NUMBER :=0;
Line: 149

SAVEPOINT csh_order_seq_update_tbl;
Line: 175

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.insert_row ');
Line: 178

    Okl_Csh_Order_Seq_Pvt.insert_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_okl_csh_order_tbl(i)
                             ,lx_okl_csh_order_tbl(i));
Line: 188

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.insert_row ');
Line: 215

      ROLLBACK TO csh_order_seq_update_tbl;
Line: 223

      ROLLBACK TO csh_order_seq_update_tbl;
Line: 231

      ROLLBACK TO csh_order_seq_update_tbl;
Line: 240

END insert_order_sequence;
Line: 247

PROCEDURE update_order_sequence (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_okl_csh_order_rec        IN okl_csh_order_rec_type
       ,x_okl_csh_order_rec        OUT NOCOPY okl_csh_order_rec_type) IS

i                    NUMBER :=0;
Line: 271

SAVEPOINT csh_order_seq_update_rec;
Line: 290

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.update_row ');
Line: 293

Okl_Csh_Order_Seq_Pvt.update_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_okl_csh_order_rec
                         ,lx_okl_csh_order_rec);
Line: 303

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.update_row ');
Line: 325

      ROLLBACK TO csh_order_seq_update_rec;
Line: 333

      ROLLBACK TO csh_order_seq_update_rec;
Line: 341

      ROLLBACK TO csh_order_seq_update_rec;
Line: 350

END update_order_sequence;
Line: 356

PROCEDURE update_order_sequence (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_okl_csh_order_tbl IN okl_csh_order_tbl_type
                                ,x_okl_csh_order_tbl OUT NOCOPY okl_csh_order_tbl_type
                                ) IS

i                           NUMBER :=0;
Line: 400

    SELECT id
    FROM OKL_STRM_TYP_ALLOCS sta
    WHERE sta.STY_ID  = l_sty_id
    AND   sta.CAT_ID  = l_cat_id
    AND   sta.STREAM_ALLC_TYPE = 'ODD';
Line: 408

    SELECT id
    FROM OKL_STRM_TYP_ALLOCS sta
    WHERE sta.STY_ID  = l_sty_id
    AND   sta.CAT_ID  = l_cat_id
    AND   sta.STREAM_ALLC_TYPE = 'PRO';
Line: 416

    SELECT count(*) COUNT
    FROM OKL_STRM_TYP_ALLOCS sta
    WHERE sta.STY_ID  = l_sty_id
    AND   sta.CAT_ID  = l_cat_id
    AND   sta.STREAM_ALLC_TYPE = 'ODD';
Line: 424

    SELECT count(*) COUNT
    FROM OKL_STRM_TYP_ALLOCS sta
    WHERE sta.STY_ID  = l_sty_id
    AND   sta.CAT_ID  = l_cat_id
    AND   sta.STREAM_ALLC_TYPE = 'PRO'
    AND   sta.ID is not null;
Line: 438

SAVEPOINT csh_order_seq_update_tbl;
Line: 568

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.update_row ');
Line: 571

        Okl_Csh_Order_Seq_Pvt.update_row(
                              l_api_version
                             ,l_init_msg_list
                             ,l_return_status
                             ,l_msg_count
                             ,l_msg_data
                             ,lp_okl_csh_order_upd_tbl
                             ,lx_okl_csh_order_upd_tbl);
Line: 581

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.update_row ');
Line: 602

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.insert_row ');
Line: 605

        Okl_Csh_Order_Seq_Pvt.insert_row(
                                  l_api_version
                                 ,l_init_msg_list
                                 ,l_return_status
                                 ,l_msg_count
                                 ,l_msg_data
                                 ,lp_okl_csh_order_ins_tbl
                                ,lx_okl_csh_order_ins_tbl);
Line: 615

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.insert_row ');
Line: 642

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.delete_row ');
Line: 645

        Okl_Csh_Order_Seq_Pvt.delete_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_okl_csh_order_del_tbl);
Line: 654

        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLPSATB.pls call Okl_Csh_Order_Seq_Pvt.delete_row ');
Line: 674

        Okl_Csh_Order_Seq_Pvt.insert_row(
                                  l_api_version
                                 ,l_init_msg_list
                                 ,l_return_status
                                 ,l_msg_count
                                 ,l_msg_data
                                 ,lp_okl_csh_pro_ins_tbl
                                 ,lx_okl_csh_pro_ins_tbl);
Line: 694

        Okl_Csh_Order_Seq_Pvt.delete_row(
                          l_api_version
                         ,l_init_msg_list
                         ,l_return_status
                         ,l_msg_count
                         ,l_msg_data
                         ,lp_okl_csh_pro_del_tbl);
Line: 724

      ROLLBACK TO csh_order_seq_update_tbl;
Line: 732

      ROLLBACK TO csh_order_seq_update_tbl;
Line: 740

      ROLLBACK TO csh_order_seq_update_tbl;
Line: 749

END update_order_sequence;