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: 301


    l_record.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 302


    l_record.last_update_date                := FND_API.G_MISS_DATE;

Line: 303


    l_record.last_update_login               := FND_API.G_MISS_NUM;

Line: 309


    l_record.program_update_date             := FND_API.G_MISS_DATE;

Line: 323


    l_record.updated_flag	  	 	:= FND_API.G_MISS_CHAR;

Line: 324


    l_record.update_allowed	  	 	:= FND_API.G_MISS_CHAR;

Line: 402


	l_record.last_update_date		:=	FND_API.G_MISS_DATE;

Line: 403


	l_record.last_updated_by		:=	FND_API.G_MISS_NUM;

Line: 404


	l_record.last_update_login		:=	FND_API.G_MISS_NUM;

Line: 407


	l_record.program_update_date		:=	FND_API.G_MISS_DATE;

Line: 553


   l_record.last_update_date            :=	FND_API.G_MISS_DATE;

Line: 554


   l_record.last_updated_by            	:=	FND_API.G_MISS_NUM;

Line: 555


   l_record.last_update_login      	:=	FND_API.G_MISS_NUM;

Line: 558


   l_record.program_update_date    	:=	FND_API.G_MISS_DATE;

Line: 589


   l_record.last_update_date            :=   FND_API.G_MISS_DATE;

Line: 590


   l_record.last_updated_by            	:=   FND_API.G_MISS_NUM;

Line: 591


   l_record.last_update_login          	:=   FND_API.G_MISS_NUM;

Line: 594


   l_record.program_update_date         :=   FND_API.G_MISS_DATE;

Line: 630


    l_record.dw_update_advice_flag           := FND_API.G_MISS_CHAR;

Line: 632


    l_record.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 633


    l_record.last_update_date                := FND_API.G_MISS_DATE;

Line: 634


    l_record.last_update_login               := FND_API.G_MISS_NUM;

Line: 640


    l_record.wh_update_date                  := FND_API.G_MISS_DATE;

Line: 689


    l_record.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 690


    l_record.last_update_date                := FND_API.G_MISS_DATE;

Line: 691


    l_record.last_update_login               := FND_API.G_MISS_NUM;

Line: 697


    l_record.program_update_date             := FND_API.G_MISS_DATE;

Line: 712


    l_record.updated_flag                    := FND_API.G_MISS_CHAR;

Line: 713


    l_record.update_allowed                  := FND_API.G_MISS_CHAR;

Line: 792


    l_record.last_update_date				:=	FND_API.G_MISS_DATE;

Line: 793


    l_record.last_updated_by				:=	FND_API.G_MISS_NUM;

Line: 794


    l_record.last_update_login			:=	FND_API.G_MISS_NUM;

Line: 797


    l_record.program_update_date			:=	FND_API.G_MISS_DATE;

Line: 943


    l_record.last_update_date       	     :=   FND_API.G_MISS_DATE;

Line: 944


    l_record.last_updated_by        	     :=   FND_API.G_MISS_NUM;

Line: 945


    l_record.last_update_login      	    	:=   FND_API.G_MISS_NUM;

Line: 948


    l_record.program_update_date    	 	:=   FND_API.G_MISS_DATE;

Line: 979


   l_record.last_update_date       	      	:=   FND_API.G_MISS_DATE;

Line: 980


   l_record.last_updated_by        	    	:=   FND_API.G_MISS_NUM;

Line: 981


   l_record.last_update_login      	    	:=   FND_API.G_MISS_NUM;

Line: 984


   l_record.program_update_date    	     		:=   FND_API.G_MISS_DATE;

Line: 1020


    l_record.dw_update_advice_flag           := FND_API.G_MISS_CHAR;

Line: 1022


    l_record.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 1023


    l_record.last_update_date                := FND_API.G_MISS_DATE;

Line: 1024


    l_record.last_update_login               := FND_API.G_MISS_NUM;

Line: 1030


    l_record.wh_update_date                  := FND_API.G_MISS_DATE;

Line: 1070


    l_record.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 1071


    l_record.last_update_date                := FND_API.G_MISS_DATE;

Line: 1072


    l_record.last_update_login               := FND_API.G_MISS_NUM;

Line: 1389


    l_record.last_update_date                := FND_API.G_MISS_DATE;

Line: 1390


    l_record.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 1391


    l_record.last_update_login               := FND_API.G_MISS_NUM;

Line: 1395


    l_record.program_update_date             := FND_API.G_MISS_DATE;

Line: 1455


              l_record.LAST_UPDATED_BY                := FND_API.G_MISS_NUM;

Line: 1456


              l_record.LAST_UPDATE_DATE               := FND_API.G_MISS_DATE;

Line: 1457


              l_record.LAST_UPDATE_LOGIN              := FND_API.G_MISS_NUM;

Line: 1468


              l_record.PROGRAM_UPDATE_DATE            := FND_API.G_MISS_DATE;

Line: 1523


              l_record.LAST_UPDATED_BY                := FND_API.G_MISS_NUM;

Line: 1524


              l_record.LAST_UPDATE_DATE               := FND_API.G_MISS_DATE;

Line: 1525


              l_record.LAST_UPDATE_LOGIN              := FND_API.G_MISS_NUM;

Line: 1535


              l_record.PROGRAM_UPDATE_DATE            := FND_API.G_MISS_DATE;

Line: 2529


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

Line: 2623


		   or x_line_out_tbl(i).operation = OE_GLOBALS.G_OPR_INSERT)
	       AND NVL(x_line_out_tbl(i).subscription_enable_flag,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
				x_line_out_tbl(i).subscription_enable_flag := 'N';

Line: 2892


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: 2905


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

Line: 2997


    l_header_rec.operation := OE_GLOBALS.G_OPR_DELETE;

Line: 3064


            ,   'Delete_Order'
            );

Line: 3076


END Delete_Order;

Line: 3080


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: 3092


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

Line: 3187


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

Line: 3266


END Delete_Line;

Line: 3269


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: 3375


    l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;     -- Bug 8340976

Line: 3460


            ,   'Update Header'
            );

Line: 3471


END update_header;

Line: 3473


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: 3488


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

Line: 3590


    l_line_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 3659


            ,   'Update_Line'
            );

Line: 3670


END update_Line;

Line: 4139


			   or l_line_tbl(i).operation = OE_GLOBALS.G_OPR_INSERT)
			   AND NVL(l_line_tbl(i).subscription_enable_flag,FND_API.G_MISS_CHAR) = FND_API.G_MISS_CHAR THEN
					l_line_tbl(i).subscription_enable_flag := 'N';

Line: 5398


    G_MISS_LINE_REC.auto_selected_quantity          := FND_API.G_MISS_NUM;

Line: 5515


    G_MISS_LINE_REC.last_updated_by                 := FND_API.G_MISS_NUM;

Line: 5516


    G_MISS_LINE_REC.last_update_date                := FND_API.G_MISS_DATE;

Line: 5517


    G_MISS_LINE_REC.last_update_login               := FND_API.G_MISS_NUM;

Line: 5560


    G_MISS_LINE_REC.program_update_date             := FND_API.G_MISS_DATE;