APPS.OE_OE_FORM_LINE_PATTR SQL Statements

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

Line: 1717

		   l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 1732

       l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line: 2740

, 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

,   p_called_from_pattr             IN  VARCHAR2 DEFAULT 'N'
)
IS
l_Line_Price_Att_Rec		OE_Order_PUB.Line_Price_Att_Rec_Type;

Line: 2835

	 l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 2841

      l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 2912

		x_last_update_date     := l_x_Line_Price_Att_Rec.last_update_date;

Line: 2913

		x_last_updated_by      := l_x_Line_Price_Att_Rec.last_updated_by;

Line: 2914

		x_last_update_login    := l_x_Line_Price_Att_Rec.last_update_login;

Line: 2917

    		x_program_update_date  := l_x_Line_Price_Att_rec.program_update_date;

Line: 2974

PROCEDURE Delete_Row
( x_return_status OUT NOCOPY VARCHAR2

, x_msg_count OUT NOCOPY NUMBER

, x_msg_data OUT NOCOPY VARCHAR2

,   p_order_price_attrib_id         IN  NUMBER
)
IS
l_Line_Price_Att_Rec	OE_Order_PUB.Line_Price_Att_Rec_Type;

Line: 3022

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

Line: 3053

	     l_x_Line_Price_Att_Rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line: 3146

END Delete_Row;

Line: 3270

            select 'Y' into l_pattr_exists from dual
            where exists ( select 'Y' from oe_order_price_attribs
                           where order_price_attrib_id = p_order_price_attrib_id );

Line: 3739

		   l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 3754

       l_x_Line_Price_Att_rec.operation := OE_GLOBALS.G_OPR_DELETE;