eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_ORDER_PUB SQL Statements

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

Line: 97


    l_record.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 98


    l_record.last_update_date                := FND_API.G_MISS_DATE;

Line: 99


    l_record.last_update_login               := FND_API.G_MISS_NUM;

Line: 116


    l_record.program_update_date             := FND_API.G_MISS_DATE;

Line: 297


    l_record.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 298


    l_record.last_update_date                := FND_API.G_MISS_DATE;

Line: 299


    l_record.last_update_login               := FND_API.G_MISS_NUM;

Line: 305


    l_record.program_update_date             := FND_API.G_MISS_DATE;

Line: 319


    l_record.updated_flag	  	 	:= FND_API.G_MISS_CHAR;

Line: 320


    l_record.update_allowed	  	 	:= FND_API.G_MISS_CHAR;

Line: 397


	l_record.last_update_date		:=	FND_API.G_MISS_DATE;

Line: 398


	l_record.last_updated_by		:=	FND_API.G_MISS_NUM;

Line: 399


	l_record.last_update_login		:=	FND_API.G_MISS_NUM;

Line: 402


	l_record.program_update_date		:=	FND_API.G_MISS_DATE;

Line: 548


   l_record.last_update_date            :=	FND_API.G_MISS_DATE;

Line: 549


   l_record.last_updated_by            	:=	FND_API.G_MISS_NUM;

Line: 550


   l_record.last_update_login      	:=	FND_API.G_MISS_NUM;

Line: 553


   l_record.program_update_date    	:=	FND_API.G_MISS_DATE;

Line: 584


   l_record.last_update_date            :=   FND_API.G_MISS_DATE;

Line: 585


   l_record.last_updated_by            	:=   FND_API.G_MISS_NUM;

Line: 586


   l_record.last_update_login          	:=   FND_API.G_MISS_NUM;

Line: 589


   l_record.program_update_date         :=   FND_API.G_MISS_DATE;

Line: 625


    l_record.dw_update_advice_flag           := FND_API.G_MISS_CHAR;

Line: 627


    l_record.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 628


    l_record.last_update_date                := FND_API.G_MISS_DATE;

Line: 629


    l_record.last_update_login               := FND_API.G_MISS_NUM;

Line: 635


    l_record.wh_update_date                  := FND_API.G_MISS_DATE;

Line: 684


    l_record.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 685


    l_record.last_update_date                := FND_API.G_MISS_DATE;

Line: 686


    l_record.last_update_login               := FND_API.G_MISS_NUM;

Line: 692


    l_record.program_update_date             := FND_API.G_MISS_DATE;

Line: 707


    l_record.updated_flag                    := FND_API.G_MISS_CHAR;

Line: 708


    l_record.update_allowed                  := FND_API.G_MISS_CHAR;

Line: 787


    l_record.last_update_date				:=	FND_API.G_MISS_DATE;

Line: 788


    l_record.last_updated_by				:=	FND_API.G_MISS_NUM;

Line: 789


    l_record.last_update_login			:=	FND_API.G_MISS_NUM;

Line: 792


    l_record.program_update_date			:=	FND_API.G_MISS_DATE;

Line: 938


    l_record.last_update_date       	     :=   FND_API.G_MISS_DATE;

Line: 939


    l_record.last_updated_by        	     :=   FND_API.G_MISS_NUM;

Line: 940


    l_record.last_update_login      	    	:=   FND_API.G_MISS_NUM;

Line: 943


    l_record.program_update_date    	 	:=   FND_API.G_MISS_DATE;

Line: 974


   l_record.last_update_date       	      	:=   FND_API.G_MISS_DATE;

Line: 975


   l_record.last_updated_by        	    	:=   FND_API.G_MISS_NUM;

Line: 976


   l_record.last_update_login      	    	:=   FND_API.G_MISS_NUM;

Line: 979


   l_record.program_update_date    	     		:=   FND_API.G_MISS_DATE;

Line: 1015


    l_record.dw_update_advice_flag           := FND_API.G_MISS_CHAR;

Line: 1017


    l_record.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 1018


    l_record.last_update_date                := FND_API.G_MISS_DATE;

Line: 1019


    l_record.last_update_login               := FND_API.G_MISS_NUM;

Line: 1025


    l_record.wh_update_date                  := FND_API.G_MISS_DATE;

Line: 1065


    l_record.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 1066


    l_record.last_update_date                := FND_API.G_MISS_DATE;

Line: 1067


    l_record.last_update_login               := FND_API.G_MISS_NUM;

Line: 1384


    l_record.last_update_date                := FND_API.G_MISS_DATE;

Line: 1385


    l_record.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 1386


    l_record.last_update_login               := FND_API.G_MISS_NUM;

Line: 1390


    l_record.program_update_date             := FND_API.G_MISS_DATE;

Line: 1450


              l_record.LAST_UPDATED_BY                := FND_API.G_MISS_NUM;

Line: 1451


              l_record.LAST_UPDATE_DATE               := FND_API.G_MISS_DATE;

Line: 1452


              l_record.LAST_UPDATE_LOGIN              := FND_API.G_MISS_NUM;

Line: 1462


              l_record.PROGRAM_UPDATE_DATE            := FND_API.G_MISS_DATE;

Line: 1513


              l_record.LAST_UPDATED_BY                := FND_API.G_MISS_NUM;

Line: 1514


              l_record.LAST_UPDATE_DATE               := FND_API.G_MISS_DATE;

Line: 1515


              l_record.LAST_UPDATE_LOGIN              := FND_API.G_MISS_NUM;

Line: 1525


              l_record.PROGRAM_UPDATE_DATE            := FND_API.G_MISS_DATE;

Line: 2407


l_api_name                      CONSTANT VARCHAR2(30) := 'Update Line';

Line: 2757


PROCEDURE Delete_Order
(
    p_header_id                      NUMBER
, p_org_id                        IN  NUMBER := NULL  --MOAC
,   p_operating_unit                IN  VARCHAR2 := NULL -- MOAC

,   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
)IS
l_header_rec                OE_ORDER_PUB.Header_Rec_Type;

Line: 2770


l_api_name         CONSTANT VARCHAR2(30) := 'Delete Order';

Line: 2862


    l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line: 2929


            ,   'Delete_Order'
            );

Line: 2941


END Delete_Order;

Line: 2945


PROCEDURE Delete_Line
(
    p_line_id                       NUMBER
, p_org_id                        IN  NUMBER := NULL  --MOAC
,   p_operating_unit                IN  VARCHAR2 := NULL -- MOAC

,   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
)IS
l_line_tbl                  OE_ORDER_PUB.Line_tbl_Type;

Line: 2957


l_api_name         CONSTANT VARCHAR2(30) := 'Update Line';

Line: 3052


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

Line: 3131


END Delete_Line;

Line: 3134


PROCEDURE update_header
(
    p_header_id                    IN  NUMBER
, p_org_id                        IN  NUMBER := NULL  --MOAC
,   p_operating_unit                IN  VARCHAR2 := NULL -- MOAC
,   p_header_val_rec               IN  Header_val_Rec_Type :=
                                        G_MISS_HEADER_VAL_REC

,   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
)IS
l_header_rec                OE_ORDER_PUB.Header_Rec_Type;

Line: 3254


    l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 3321


            ,   'Update Header'
            );

Line: 3332


END update_header;

Line: 3334


PROCEDURE Update_Line
(
    p_line_id                      IN  NUMBER
,   p_line_val_rec                 IN  Line_Val_rec_Type :=
                                        G_MISS_LINE_VAL_REC
, p_org_id                        IN  NUMBER := NULL  --MOAC
,   p_operating_unit                IN  VARCHAR2 := NULL -- MOAC

,   x_return_status                 OUT NOCOPY /* file.sql.39 change */ VARCHAR2
,   x_msg_count                     OUT NOCOPY /* file.sql.39 change */ NUMBER
,   x_msg_data                      OUT NOCOPY /* file.sql.39 change */ VARCHAR2
)IS
l_line_rec                 OE_ORDER_PUB.Line_rec_Type;

Line: 3349


l_api_name         CONSTANT VARCHAR2(30) := 'Update Line';

Line: 3451


    l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 3520


            ,   'Update_Line'
            );

Line: 3531


END update_Line;

Line: 5187


    G_MISS_LINE_REC.auto_selected_quantity          := FND_API.G_MISS_NUM;

Line: 5304


    G_MISS_LINE_REC.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 5305


    G_MISS_LINE_REC.last_update_date                := FND_API.G_MISS_DATE;

Line: 5306


    G_MISS_LINE_REC.last_update_login               := FND_API.G_MISS_NUM;

Line: 5349


    G_MISS_LINE_REC.program_update_date             := FND_API.G_MISS_DATE;