APPS.OE_OE_FORM_LINE_PAYMENT SQL Statements

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

Line: 109

        select header_id into l_header_id
        from oe_order_lines_all
        where line_id = p_line_id;

Line: 509

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

Line: 1094

, x_last_update_date OUT NOCOPY DATE
, x_last_updated_by OUT NOCOPY NUMBER
, x_last_update_login OUT NOCOPY NUMBER
,   x_program_id                    OUT NOCOPY NUMBER
,   x_program_application_id        OUT NOCOPY NUMBER
,   x_program_update_date           OUT NOCOPY DATE
,   x_request_id                    OUT NOCOPY NUMBER
, x_lock_control OUT NOCOPY NUMBER
)
IS
l_x_old_Line_Payment_tbl      OE_Order_PUB.Line_PAYMENT_Tbl_Type;

Line: 1158

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

Line: 1187

    x_last_update_date             := l_x_Line_Payment_tbl(1).last_update_date;

Line: 1188

    x_last_updated_by              := l_x_Line_Payment_tbl(1).last_updated_by;

Line: 1189

    x_last_update_login            := l_x_Line_Payment_tbl(1).last_update_login;

Line: 1273

PROCEDURE Delete_Row
( x_return_status OUT NOCOPY VARCHAR2
, x_msg_count OUT NOCOPY NUMBER
, x_msg_data OUT NOCOPY VARCHAR2
, p_payment_number               IN  NUMBER
, p_line_id                      IN  NUMBER
, p_header_id                    IN  NUMBER
)
IS
l_control_rec                 OE_GLOBALS.Control_Rec_Type;

Line: 1293

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

Line: 1328

    l_x_Line_Payment_tbl(1).operation := OE_GLOBALS.G_OPR_DELETE;

Line: 1371

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

Line: 1412

            ,   'Delete_Row'
            );

Line: 1423

END Delete_Row;