APPS.OE_OE_HTML_LINE SQL Statements

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

Line: 397

        x_line_tbl(1).operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 532

PROCEDURE Delete_Row
( x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
,   p_line_id                       IN  NUMBER
, p_change_reason_code            IN  VARCHAR2 Default Null
, p_change_comments               IN  VARCHAR2 Default Null
)
IS
l_x_line_rec                    OE_Order_PUB.Line_Rec_Type;

Line: 550

    SAVEPOINT LINE_DELETE;

Line: 552

        oe_debug_pub.add(  'ENTERING Oe_Oe_Html_Line.DELETE_ROW' , 1 ) ;

Line: 578

    l_x_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line: 623

        oe_debug_pub.add(  'EXITING Oe_Oe_Html_Line.DELETE_ROW' , 1 ) ;

Line: 629

       ROLLBACK TO SAVEPOINT Line_Delete;

Line: 642

       ROLLBACK TO SAVEPOINT Line_Delete;

Line: 656

       ROLLBACK TO SAVEPOINT Line_Delete;

Line: 666

            ,   'Delete_Row'
            );

Line: 677

END Delete_Row;

Line: 822

    OE_DELAYED_REQUESTS_PVT.Delete_Reqs_for_Deleted_Entity(
                         p_entity_code  => OE_GLOBALS.G_ENTITY_LINE
                         ,p_entity_id    => p_line_id
                         ,x_return_status => l_return_status);

Line: 831

     l_new_line_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line: 835

      OE_ORDER_UTIL.Update_Global_Picture(p_Upd_New_Rec_If_Exists => True,
                    p_line_rec => l_new_line_rec,
                    p_line_id => p_line_id,
                    p_old_line_rec => l_old_line_rec,
                    x_index => l_index,
                    x_return_status => l_return_status);