DBA Data[Home] [Help]

APPS.OE_OE_FORM_HEADER_PATTR SQL Statements

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

Line: 1451

		       oe_debug_pub.add(  'IT IS AN UPDATE ' , 1 ) ;
Line: 1453

		   l_x_Header_Price_Att_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
Line: 2454

, 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_Header_Price_Att_rec		OE_Order_PUB.Header_Price_Att_Rec_Type;
Line: 2546

			 l_x_Header_Price_Att_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
Line: 2613

		x_last_update_date     := l_x_Header_Price_Att_rec.last_update_date;
Line: 2614

		x_last_updated_by      := l_x_Header_Price_Att_rec.last_updated_by;
Line: 2615

		x_last_update_login    := l_x_Header_Price_Att_rec.last_update_login;
Line: 2618

    		x_program_update_date  := l_x_Header_Price_Att_rec.program_update_date;
Line: 2675

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_Header_Price_Att_rec	OE_Order_PUB.Header_Price_Att_Rec_Type;
Line: 2723

	       oe_debug_pub.add(  'ENTERING OE_OE_FORM_HEADER_PATTR.DELETE_ROW' , 1 ) ;
Line: 2754

		l_x_Header_Price_Att_rec.operation := OE_GLOBALS.G_OPR_DELETE;
Line: 2846

END Delete_Row;
Line: 3766

		       oe_debug_pub.add(  'IT IS AN UPDATE ' , 1 ) ;
Line: 3768

		   l_x_Header_Price_Att_rec.operation := OE_GLOBALS.G_OPR_UPDATE;