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_CSH_ORDER_SEQ_PVT SQL Statements

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

Line: 13


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

---------------------------
-- DECLARE Local Variables
---------------------------

    l_api_version        NUMBER          := 1.0;

Line: 60


    SELECT max(sta.SEQUENCE_NUMBER) MAXSEQ
    FROM OKL_BPD_CSH_ORDER_UV sta
    WHERE sta.SEQUENCE_NUMBER <= l_sequence_number
------------------------------------------------------------------------------------
    AND   sta.ORG_ID = OKL_CONTEXT.get_okc_org_id   --dkagrawa changed for MOAC  -- multi org compliant
------------------------------------------------------------------------------------
    ORDER BY SEQUENCE_NUMBER;

Line: 70


    SELECT count(*) COUNT
    FROM OKL_BPD_CSH_ORDER_UV sta
--------------------------------------------------------------------------------------
    WHERE   sta.ORG_ID = OKL_CONTEXT.get_okc_org_id;   --dkagrawa changed for MOAC -- multi org compliant

Line: 79


   SELECT count(*) COUNT
   FROM OKL_BPD_CSH_ORDER_UV sta
   WHERE sta.SEQUENCE_NUMBER <= l_sequence_number
--------------------------------------------------------------------------------------
   AND   sta.ORG_ID = OKL_CONTEXT.get_okc_org_id;   --dkagrawa changed for MOAC -- multi org compliant

Line: 90


   SELECT SEQUENCE_NUMBER, ID
          ,STY_ID, CAT_ID, OBJECT_VERSION_NUMBER
          ,CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE
          ,LAST_UPDATE_LOGIN
   FROM OKL_STRM_TYP_ALLOCS
   WHERE SEQUENCE_NUMBER > l_sequence_number
--------------------------------------------------------------------------------------
   AND CAT_ID = l_cat_id; -- multi org compliant

Line: 103


   SELECT count(*) COUNT
   FROM OKL_BPD_CSH_ORDER_UV sta
   WHERE SEQUENCE_NUMBER > l_sequence_number
--------------------------------------------------------------------------------------
   AND   sta.ORG_ID = OKL_CONTEXT.get_okc_org_id;   --dkagrawa changed for MOAC -- multi org compliant

Line: 126


    l_stav_rec.last_updated_by       :=  l_okl_csh_order_rec.last_updated_by;

Line: 127


    l_stav_rec.last_update_date      :=  l_okl_csh_order_rec.last_update_date;

Line: 128


    l_stav_rec.last_update_login     :=  l_okl_csh_order_rec.last_update_login;

Line: 190


    l_stav_tbl(i).LAST_UPDATED_BY           := c_csh_ordr_seqgreat_rec.LAST_UPDATED_BY;

Line: 191


    l_stav_tbl(i).LAST_UPDATE_DATE          := c_csh_ordr_seqgreat_rec.LAST_UPDATE_DATE;

Line: 192


    l_stav_tbl(i).LAST_UPDATE_LOGIN         := c_csh_ordr_seqgreat_rec.LAST_UPDATE_LOGIN;

Line: 209


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 212


        okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
                                                        ,l_init_msg_list
                                                        ,l_return_status
                                                        ,l_msg_count
                                                        ,l_msg_data
                                                        ,l_stav_tbl
                                                        ,x_stav_tbl
                                                        );

Line: 222


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 234


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');

Line: 237


    okl_strm_typ_allocs_pub.insert_strm_typ_allocs(l_api_version
                                                    ,l_init_msg_list
                                                    ,l_return_status
                                                    ,l_msg_count
                                                    ,l_msg_data
                                                    ,l_stav_rec
                                                    ,x_stav_rec
                                                    );

Line: 247


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');

Line: 267


    l_msg_data := 'Problems with External Delete';

Line: 270


    END insert_row;

Line: 277


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

---------------------------
-- DECLARE Local Variables
---------------------------

    l_api_version        NUMBER          := 1.0;

Line: 333


   SELECT SEQUENCE_NUMBER, ID
   FROM OKL_STRM_TYP_ALLOCS
   --FROM OKL_BPD_CSH_ORDER_UV
   WHERE STREAM_ALLC_TYPE = 'ODD'
------------------------------
   AND CAT_ID = l_cat_id
------------------------------
   order by SEQUENCE_NUMBER;

Line: 361


    l_stav_rec.last_updated_by       :=  l_okl_csh_order_rec.last_updated_by;

Line: 362


    l_stav_rec.last_update_date      :=  l_okl_csh_order_rec.last_update_date;

Line: 363


    l_stav_rec.last_update_login     :=  l_okl_csh_order_rec.last_update_login;

Line: 385


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');

Line: 388


    okl_strm_typ_allocs_pub.insert_strm_typ_allocs(l_api_version
                                                    ,l_init_msg_list
                                                    ,l_return_status
                                                    ,l_msg_count
                                                    ,l_msg_data
                                                    ,l_stav_tbl
                                                    ,x_stav_tbl
                                                    );

Line: 398


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.insert_strm_typ_allocs ');

Line: 429


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 432


        okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
                                                        ,l_init_msg_list
                                                        ,l_return_status
                                                        ,l_msg_count
                                                        ,l_msg_data
                                                        ,l1_stav_tbl
                                                        ,x_stav_tbl
                                                        );

Line: 442


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 466


        l_msg_data := 'Problems with External Delete';

Line: 469


END insert_row;

Line: 475


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

---------------------------
-- DECLARE Local Variables
---------------------------

    l_api_version        NUMBER          := 1.0;

Line: 525


    SELECT max(sta.SEQUENCE_NUMBER) MAXSEQ
    FROM OKL_STRM_TYP_ALLOCS sta
    WHERE sta.SEQUENCE_NUMBER <= l_sequence_number
    AND  ID <> l_id
---------------------------------------------------------------------------
    AND CAT_ID = l_cat_id -- multi org compliant
---------------------------------------------------------------------------
    ORDER BY SEQUENCE_NUMBER;

Line: 538


    SELECT count(*) COUNT
    FROM OKL_STRM_TYP_ALLOCS
---------------------------------------------------------------------------
    WHERE CAT_ID = l_cat_id; -- multi org compliant

Line: 546


   SELECT SEQUENCE_NUMBER, ID
   FROM OKL_STRM_TYP_ALLOCS
   WHERE SEQUENCE_NUMBER <= l_sequence_number
   AND  ID <> l_id
---------------------------------------------------------------------------
   AND CAT_ID = l_cat_id -- multi org compliant
---------------------------------------------------------------------------
   ORDER BY SEQUENCE_NUMBER;

Line: 557


   SELECT count(*) COUNT
   FROM OKL_STRM_TYP_ALLOCS sta
   WHERE sta.SEQUENCE_NUMBER <= l_sequence_number
   AND  ID <> l_id
---------------------------------------------------------------------------
   AND CAT_ID = l_cat_id; -- multi org compliant

Line: 568


   SELECT SEQUENCE_NUMBER, ID
   FROM OKL_STRM_TYP_ALLOCS
   WHERE SEQUENCE_NUMBER > l_sequence_number
   AND  ID <> l_id
---------------------------------------------------------------------------
   AND CAT_ID = l_cat_id; -- multi org compliant

Line: 579


   SELECT count(*) COUNT
   FROM OKL_STRM_TYP_ALLOCS
   WHERE SEQUENCE_NUMBER > l_sequence_number
   AND  ID <> l_id
---------------------------------------------------------------------------
   AND CAT_ID = l_cat_id; -- multi org compliant

Line: 636


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 639


    okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
                                                    ,l_init_msg_list
                                                    ,l_return_status
                                                    ,l_msg_count
                                                    ,l_msg_data
                                                    ,l_stav_tbl
                                                    ,x_stav_tbl
                                                    );

Line: 649


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 694


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 697


    okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
                                                    ,l_init_msg_list
                                                    ,l_return_status
                                                    ,l_msg_count
                                                    ,l_msg_data
                                                    ,l_stav_tbl
                                                    ,x_stav_tbl
                                                    );

Line: 707


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 721


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 724


    okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
                                                    ,l_init_msg_list
                                                    ,l_return_status
                                                    ,l_msg_count
                                                    ,l_msg_data
                                                    ,l_stav_rec
                                                    ,x_stav_rec
                                                    );

Line: 734


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 754


        l_msg_data := 'Problems with External Insert';

Line: 757


  END update_row;

Line: 764


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

---------------------------
-- DECLARE Local Variables
---------------------------

    l_api_version        NUMBER          := 1.0;

Line: 815


  SELECT   SEQUENCE_NUMBER, ID
  FROM     OKL_STRM_TYP_ALLOCS
  WHERE    CAT_ID = l_cat_id
  ORDER BY SEQUENCE_NUMBER;

Line: 849


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 852


    okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
                                                    ,l_init_msg_list
                                                    ,l_return_status
                                                    ,l_msg_count
                                                    ,l_msg_data
                                                    ,l_stav_tbl
                                                    ,x_stav_tbl
                                                    );

Line: 862


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 890


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 893


    okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
                                                    ,l_init_msg_list
                                                    ,l_return_status
                                                    ,l_msg_count
                                                    ,l_msg_data
                                                    ,l_stav_tbl
                                                    ,x_stav_tbl
                                                    );

Line: 903


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 920


        l_msg_data := 'Problems with External Delete';

Line: 923


  END update_row;

Line: 929


  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_okl_csh_order_rec        IN okl_csh_order_rec_type
                        ) IS

---------------------------
-- DECLARE Local Variables
---------------------------

    l_api_version        NUMBER          := 1.0;

Line: 970


   SELECT ID, SEQUENCE_NUMBER
   FROM OKL_STRM_TYP_ALLOCS
   WHERE STREAM_ALLC_TYPE = 'ODD'
   AND CAT_ID = l_cat_id
   ORDER BY SEQUENCE_NUMBER;

Line: 978


  SELECT count(*) COUNT
  FROM OKL_STRM_TYP_ALLOCS
  WHERE ID = l_csh_ordr_id
  AND CAT_ID = l_cat_id;

Line: 1004


        okl_strm_typ_allocs_pub.delete_strm_typ_allocs(l_api_version
                                                    ,l_init_msg_list
                                                    ,l_return_status
                                                    ,l_msg_count
                                                    ,l_msg_data
                                                    ,l_stav_rec
                                                    );

Line: 1041


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 1044


        okl_strm_typ_allocs_pub.update_strm_typ_allocs(l_api_version
                                                        ,l_init_msg_list
                                                        ,l_return_status
                                                        ,l_msg_count
                                                        ,l_msg_data
                                                        ,l_stav_tbl
                                                        ,x_stav_tbl
                                                        );

Line: 1054


        OKL_DEBUG_PUB.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRSATB.pls call okl_strm_typ_allocs_pub.update_strm_typ_allocs ');

Line: 1076


        l_msg_data := 'Problems with External Insert';

Line: 1079


  END delete_row;

Line: 1085


  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_okl_csh_order_tbl          IN okl_csh_order_tbl_type
                        ) IS

---------------------------
-- DECLARE Local Variables
---------------------------

    l_api_version        NUMBER          := 1.0;

Line: 1129


SAVEPOINT csh_order_seq_delete_tbl;

Line: 1150


        delete_row(
              l_api_version
             ,l_init_msg_list
             ,l_return_status
             ,l_msg_count
             ,l_msg_data
             ,lp_okl_csh_order_tbl(i));

Line: 1189


        l_msg_data := 'Problems with External Delete';

Line: 1192


  END delete_row;