APPS.OE_DBI_UTIL SQL Statements

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

Line: 5

Procedure Update_DBI_Log
( x_return_status OUT NOCOPY VARCHAR2

) IS

l_header_id               NUMBER;

Line: 18

l_last_update_date        DATE;

Line: 19

l_last_update_date_old    DATE;

Line: 20

l_header_last_update_date DATE;

Line: 24

select line_id, header_id, l_header_last_update_date, 'N'
from oe_order_lines_all
where header_id = p_header_id;

Line: 43

  last_update_date T_DATE := T_DATE(),
  rec_exists_flag  T_V1 := T_V1()
);

Line: 53

       oe_debug_pub.add(  'ENTERING UPDATE_DBI API' , 1 ) ;

Line: 83

       l_header_last_update_date := oe_order_util.g_header_rec.last_update_date;

Line: 101

       IF  oe_order_util.g_header_scredit_tbl(I).last_update_date IS NULL THEN
           l_header_last_update_date :=
                   oe_order_util.g_old_header_scredit_tbl(I).last_update_date;

Line: 105

           l_header_last_update_date :=
                   oe_order_util.g_header_scredit_tbl(I).last_update_date;

Line: 109

           oe_debug_pub.add(  'LAST UPDATE DATE OLD=' || l_header_last_update_date ) ;

Line: 124

       l_header_last_update_date := oe_order_util.g_header_adj_tbl(I).last_update_date;

Line: 127

           oe_debug_pub.add(  'LAST UPDATE DATE OLD=' || l_header_last_update_date ) ;

Line: 142

               l_dbi_rec.last_update_date,
               l_dbi_rec.rec_exists_flag;

Line: 167

        l_dbi_rec.last_update_date.EXTEND(oe_order_util.g_line_tbl.COUNT);

Line: 188

            IF oe_order_util.g_line_tbl(I).last_update_date IS NULL THEN
                l_dbi_rec.last_update_date(j) :=
                          oe_order_util.g_old_line_tbl(I).last_update_date;

Line: 192

                l_dbi_rec.last_update_date(j) :=
                          oe_order_util.g_line_tbl(I).last_update_date;

Line: 198

              oe_debug_pub.add(  'LAST UPDATE DATE=' || l_dbi_rec.last_update_date(j) ) ;

Line: 230

              l_dbi_rec.last_update_date.EXTEND;

Line: 240

              IF oe_order_util.g_line_scredit_tbl(I).last_update_date IS NULL
              THEN
                  l_dbi_rec.last_update_date(j) :=
                       oe_order_util.g_old_line_scredit_tbl(I).last_update_date;

Line: 245

                  l_dbi_rec.last_update_date(j) :=
                       oe_order_util.g_line_scredit_tbl(I).last_update_date;

Line: 251

                oe_debug_pub.add(  'LAST UPDATE DATE=' || l_dbi_rec.last_update_date(J) ) ;

Line: 285

              l_dbi_rec.last_update_date.EXTEND;

Line: 295

              IF oe_order_util.g_line_adj_tbl(I).last_update_date IS NULL
              THEN
                  l_dbi_rec.last_update_date(J) :=
                       oe_order_util.g_old_line_adj_tbl(I).last_update_date;

Line: 300

                  l_dbi_rec.last_update_date(J) :=
                       oe_order_util.g_line_adj_tbl(I).last_update_date;

Line: 306

                oe_debug_pub.add(  'LAST UPDATE DATE=' || l_dbi_rec.last_update_date(J) ) ;

Line: 333

           SELECT 'Y'
           INTO l_dbi_rec.rec_exists_flag(i)
           FROM ONT_DBI_CHANGE_LOG
           ---  WHERE header_id = l_header_id  bug 7319732 ,7347663
           WHERE header_id=l_dbi_rec.header_id(i) ---bug 7319732 ,7347663
           AND line_id = l_dbi_rec.line_id(i)
           AND set_of_books_id = l_set_of_books_id
           AND currency_code   = l_currency_code
           FOR UPDATE;

Line: 361

           l_dbi_create_rec.last_update_date.EXTEND;

Line: 363

           l_dbi_create_rec.last_update_date(j) := l_dbi_rec.last_update_date(i);

Line: 379

          oe_debug_pub.add('Inserting new records ' || l_dbi_create_rec.line_id.COUNT );

Line: 382

          INSERT INTO  ONT_DBI_CHANGE_LOG
          (HEADER_ID
          ,LINE_ID
          ,SET_OF_BOOKS_ID
          ,CURRENCY_CODE
          ,LAST_UPDATE_DATE
          )
          VALUES
         (l_dbi_create_rec.header_id(i)
         ,l_dbi_create_rec.line_id(i)
         ,l_set_of_books_id
         ,l_currency_code
         ,l_dbi_create_rec.last_update_date(i)
         );

Line: 405

       UPDATE ONT_DBI_CHANGE_LOG
       SET LAST_UPDATE_DATE = SYSDATE
       --WHERE HEADER_ID       = l_header_id
       WHERE HEADER_ID = l_dbi_rec.header_id(i) --bug 7319732,7347663
       AND   LINE_ID         = l_dbi_rec.line_id(i)
       AND   SET_OF_BOOKS_ID = l_set_of_books_id
       AND   CURRENCY_CODE   = l_currency_code
       AND  l_dbi_rec.rec_exists_flag(i) = 'Y';

Line: 425

            oe_debug_pub.add(  'In Others of Update_DBI_Log' , 1 ) ;

Line: 432

            ,'Update_DBI_log');

Line: 437

END Update_DBI_Log;