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.ASO_ORDER_FEEDBACK_PUB SQL Statements

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

Line: 107


PROCEDURE UPDATE_NOTICE
(
 p_api_version                   IN  NUMBER,
 p_init_msg_list                 IN  VARCHAR2 := FND_API.G_FALSE,
 p_commit                        IN  VARCHAR2 := FND_API.G_FALSE,
 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,
 p_header_rec                    IN  OE_Order_PUB.Header_Rec_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_REC,
 p_old_header_rec                IN  OE_Order_PUB.Header_Rec_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_REC,
 p_Header_Adj_tbl                IN  OE_Order_PUB.Header_Adj_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
 p_old_Header_Adj_tbl            IN  OE_Order_PUB.Header_Adj_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_ADJ_TBL,
 p_Header_price_Att_tbl          IN  OE_Order_PUB.Header_Price_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
 p_old_Header_Price_Att_tbl      IN  OE_Order_PUB.Header_Price_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL,
 p_Header_Adj_Att_tbl            IN  OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
 p_old_Header_Adj_Att_tbl        IN  OE_Order_PUB.Header_Adj_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL,
 p_Header_Adj_Assoc_tbl          IN  OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
 p_old_Header_Adj_Assoc_tbl      IN  OE_Order_PUB.Header_Adj_Assoc_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL,
 p_Header_Scredit_tbl            IN  OE_Order_PUB.Header_Scredit_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
 p_old_Header_Scredit_tbl        IN  OE_Order_PUB.Header_Scredit_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL,
 p_line_tbl                      IN  OE_Order_PUB.Line_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_TBL,
 p_old_line_tbl                  IN  OE_Order_PUB.Line_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_TBL,
 p_Line_Adj_tbl                  IN  OE_Order_PUB.Line_Adj_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
 p_old_Line_Adj_tbl              IN  OE_Order_PUB.Line_Adj_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_ADJ_TBL,
 p_Line_Price_Att_tbl            IN  OE_Order_PUB.Line_Price_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
 p_old_Line_Price_Att_tbl        IN  OE_Order_PUB.Line_Price_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL,
 p_Line_Adj_Att_tbl              IN  OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
 p_old_Line_Adj_Att_tbl          IN  OE_Order_PUB.Line_Adj_Att_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL,
 p_Line_Adj_Assoc_tbl            IN  OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
 p_old_Line_Adj_Assoc_tbl        IN  OE_Order_PUB.Line_Adj_Assoc_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL,
 p_Line_Scredit_tbl              IN  OE_Order_PUB.Line_Scredit_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
 p_old_Line_Scredit_tbl          IN  OE_Order_PUB.Line_Scredit_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL,
 p_Lot_Serial_tbl                IN  OE_Order_PUB.Lot_Serial_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
 p_old_Lot_Serial_tbl            IN  OE_Order_PUB.Lot_Serial_Tbl_Type :=
                                        OE_Order_PUB.G_MISS_LOT_SERIAL_TBL,
 p_action_request_tbl            IN  OE_Order_PUB.Request_Tbl_Type   :=
                                        OE_Order_PUB.G_MISS_REQUEST_TBL
) IS
	l_api_name		CONSTANT		VARCHAR2(30)	:= 'UPDATE_NOTICE';

Line: 208


	SAVEPOINT	UPDATE_NOTICE_PUB;

Line: 229


	-- UPDATE_NOTICE API specific input parameter validation logic
	-- none

	-- API Body

  -- 3042254
  -- mapping to local variables
  l_header_rec    	             := p_header_rec	            ;

Line: 269


    ASO_ORDER_FEEDBACK_CUHK.Update_Notice_PRE(
      p_header_rec	             => l_header_rec              ,
      p_old_header_rec           => l_old_header_rec          ,
      p_Header_Adj_tbl	         => l_Header_Adj_tbl          ,
      p_old_Header_Adj_tbl       => l_old_Header_Adj_tbl      ,
      p_Header_price_Att_tbl     => l_Header_price_Att_tbl    ,
      p_old_Header_Price_Att_tbl => l_old_Header_Price_Att_tbl,
      p_Header_Adj_Att_tbl       => l_Header_Adj_Att_tbl      ,
      p_old_Header_Adj_Att_tbl   => l_old_Header_Adj_Att_tbl  ,
      p_Header_Adj_Assoc_tbl     => l_Header_Adj_Assoc_tbl    ,
      p_old_Header_Adj_Assoc_tbl => l_old_Header_Adj_Assoc_tbl,
      p_Header_Scredit_tbl       => l_Header_Scredit_tbl      ,
      p_old_Header_Scredit_tbl   => l_old_Header_Scredit_tbl  ,
      p_line_tbl                 => l_line_tbl                ,
      p_old_line_tbl             => l_old_line_tbl            ,
      p_Line_Adj_tbl             => l_Line_Adj_tbl            ,
      p_old_Line_Adj_tbl         => l_old_Line_Adj_tbl        ,
      p_Line_Price_Att_tbl       => l_Line_Price_Att_tbl      ,
      p_old_Line_Price_Att_tbl   => l_old_Line_Price_Att_tbl  ,
      p_Line_Adj_Att_tbl         => l_Line_Adj_Att_tbl        ,
      p_old_Line_Adj_Att_tbl     => l_old_Line_Adj_Att_tbl    ,
      p_Line_Adj_Assoc_tbl       => l_Line_Adj_Assoc_tbl      ,
      p_old_Line_Adj_Assoc_tbl   => l_old_Line_Adj_Assoc_tbl  ,
      p_Line_Scredit_tbl         => l_Line_Scredit_tbl        ,
      p_old_Line_Scredit_tbl     => l_old_Line_Scredit_tbl    ,
      p_Lot_Serial_tbl           => l_Lot_Serial_tbl          ,
      p_old_Lot_Serial_tbl       => l_old_Lot_Serial_tbl      ,
      p_action_request_tbl       => l_action_request_tbl      ,
      x_return_status            =>  x_return_status          ,
      x_msg_count                =>  x_msg_count              ,
      x_msg_data                 =>  x_msg_data
    );

Line: 307


		    FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_CUHK.Update_Notice_PRE', FALSE);

Line: 323


    ASO_ORDER_FEEDBACK_VUHK.Update_Notice_PRE(
      p_header_rec	             => l_header_rec              ,
      p_old_header_rec           => l_old_header_rec          ,
      p_Header_Adj_tbl	         => l_Header_Adj_tbl          ,
      p_old_Header_Adj_tbl       => l_old_Header_Adj_tbl      ,
      p_Header_price_Att_tbl     => l_Header_price_Att_tbl    ,
      p_old_Header_Price_Att_tbl => l_old_Header_Price_Att_tbl,
      p_Header_Adj_Att_tbl       => l_Header_Adj_Att_tbl      ,
      p_old_Header_Adj_Att_tbl   => l_old_Header_Adj_Att_tbl  ,
      p_Header_Adj_Assoc_tbl     => l_Header_Adj_Assoc_tbl    ,
      p_old_Header_Adj_Assoc_tbl => l_old_Header_Adj_Assoc_tbl,
      p_Header_Scredit_tbl       => l_Header_Scredit_tbl      ,
      p_old_Header_Scredit_tbl   => l_old_Header_Scredit_tbl  ,
      p_line_tbl                 => l_line_tbl                ,
      p_old_line_tbl             => l_old_line_tbl            ,
      p_Line_Adj_tbl             => l_Line_Adj_tbl            ,
      p_old_Line_Adj_tbl         => l_old_Line_Adj_tbl        ,
      p_Line_Price_Att_tbl       => l_Line_Price_Att_tbl      ,
      p_old_Line_Price_Att_tbl   => l_old_Line_Price_Att_tbl  ,
      p_Line_Adj_Att_tbl         => l_Line_Adj_Att_tbl        ,
      p_old_Line_Adj_Att_tbl     => l_old_Line_Adj_Att_tbl    ,
      p_Line_Adj_Assoc_tbl       => l_Line_Adj_Assoc_tbl      ,
      p_old_Line_Adj_Assoc_tbl   => l_old_Line_Adj_Assoc_tbl  ,
      p_Line_Scredit_tbl         => l_Line_Scredit_tbl        ,
      p_old_Line_Scredit_tbl     => l_old_Line_Scredit_tbl    ,
      p_Lot_Serial_tbl           => l_Lot_Serial_tbl          ,
      p_old_Lot_Serial_tbl       => l_old_Lot_Serial_tbl      ,
      p_action_request_tbl       => l_action_request_tbl      ,
      x_return_status            =>  x_return_status          ,
      x_msg_count                =>  x_msg_count              ,
      x_msg_data                 =>  x_msg_data
    );

Line: 361


		    FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_VUHK.Update_Notice_PRE', FALSE);

Line: 374


	ASO_ORDER_FEEDBACK_UPDATE_PVT.UPDATE_NOTICE(
      p_api_version                         =>  1.0,
      p_init_msg_list                       =>  FND_API.G_FALSE,
      p_commit                              =>  FND_API.G_FALSE,
      x_return_status                       =>  x_return_status,
      x_msg_count                           =>  x_msg_count,
      x_msg_data                            =>  x_msg_data,
      p_queue_type                          =>  'OF_QUEUE',
      p_header_rec                          =>  p_header_rec,
      p_old_header_rec                      =>  p_old_header_rec,
      p_header_adj_tbl                      =>  p_header_adj_tbl,
      p_old_header_adj_tbl                  =>  p_old_header_adj_tbl,
      p_header_price_att_tbl                =>  p_header_price_att_tbl,
      p_old_header_price_att_tbl            =>  p_old_header_price_att_tbl,
      p_Header_Adj_Att_tbl                  =>  p_Header_Adj_Att_tbl,
      p_old_Header_Adj_Att_tbl              =>  p_old_Header_Adj_Att_tbl,
      p_Header_Adj_Assoc_tbl                =>  p_Header_Adj_Assoc_tbl,
      p_old_Header_Adj_Assoc_tbl            =>  p_old_Header_Adj_Assoc_tbl,
      p_Header_Scredit_tbl                  =>  p_Header_Scredit_tbl,
      p_old_Header_Scredit_tbl              =>  p_old_Header_Scredit_tbl,
      p_line_tbl                            =>  p_line_tbl,
      p_old_line_tbl                        =>  p_old_line_tbl,
      p_Line_Adj_tbl                        =>  p_Line_Adj_tbl,
      p_old_Line_Adj_tbl                    =>  p_old_Line_Adj_tbl,
      p_Line_Price_Att_tbl                  =>  p_Line_Price_Att_tbl,
      p_old_Line_Price_Att_tbl              =>  p_old_Line_Price_Att_tbl,
      p_Line_Adj_Att_tbl                    =>  p_Line_Adj_Att_tbl,
      p_old_Line_Adj_Att_tbl                =>  p_old_Line_Adj_Att_tbl,
      p_Line_Adj_Assoc_tbl                  =>  p_Line_Adj_Assoc_tbl,
      p_old_Line_Adj_Assoc_tbl              =>  p_old_Line_Adj_Assoc_tbl,
      p_Line_Scredit_tbl                    =>  p_Line_Scredit_tbl,
      p_old_Line_Scredit_tbl                =>  p_old_Line_Scredit_tbl,
      p_Lot_Serial_tbl                      =>  p_Lot_Serial_tbl,
      p_old_Lot_Serial_tbl                  =>  p_old_Lot_Serial_tbl,
      p_action_request_tbl                  =>  p_action_request_tbl
 );

Line: 413


    		ROLLBACK TO  UPDATE_NOTICE_PUB;

Line: 423


    ASO_ORDER_FEEDBACK_CUHK.Update_Notice_POST(
      p_header_rec    	         => l_header_rec              ,
      p_old_header_rec           => l_old_header_rec          ,
      p_Header_Adj_tbl	         => l_Header_Adj_tbl          ,
      p_old_Header_Adj_tbl       => l_old_Header_Adj_tbl      ,
      p_Header_price_Att_tbl     => l_Header_price_Att_tbl    ,
      p_old_Header_Price_Att_tbl => l_old_Header_Price_Att_tbl,
      p_Header_Adj_Att_tbl       => l_Header_Adj_Att_tbl      ,
      p_old_Header_Adj_Att_tbl   => l_old_Header_Adj_Att_tbl  ,
      p_Header_Adj_Assoc_tbl     => l_Header_Adj_Assoc_tbl    ,
      p_old_Header_Adj_Assoc_tbl => l_old_Header_Adj_Assoc_tbl,
      p_Header_Scredit_tbl       => l_Header_Scredit_tbl      ,
      p_old_Header_Scredit_tbl   => l_old_Header_Scredit_tbl  ,
      p_line_tbl                 => l_line_tbl                ,
      p_old_line_tbl             => l_old_line_tbl            ,
      p_Line_Adj_tbl             => l_Line_Adj_tbl            ,
      p_old_Line_Adj_tbl         => l_old_Line_Adj_tbl        ,
      p_Line_Price_Att_tbl       => l_Line_Price_Att_tbl      ,
      p_old_Line_Price_Att_tbl   => l_old_Line_Price_Att_tbl  ,
      p_Line_Adj_Att_tbl         => l_Line_Adj_Att_tbl        ,
      p_old_Line_Adj_Att_tbl     => l_old_Line_Adj_Att_tbl    ,
      p_Line_Adj_Assoc_tbl       => l_Line_Adj_Assoc_tbl      ,
      p_old_Line_Adj_Assoc_tbl   => l_old_Line_Adj_Assoc_tbl  ,
      p_Line_Scredit_tbl         => l_Line_Scredit_tbl        ,
      p_old_Line_Scredit_tbl     => l_old_Line_Scredit_tbl    ,
      p_Lot_Serial_tbl           => l_Lot_Serial_tbl          ,
      p_old_Lot_Serial_tbl       => l_old_Lot_Serial_tbl      ,
      p_action_request_tbl       => l_action_request_tbl      ,
      x_return_status            =>  x_return_status          ,
      x_msg_count                =>  x_msg_count              ,
      x_msg_data                 =>  x_msg_data
    );

Line: 461


		    FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_CUHK.Update_Notice_POST', FALSE);

Line: 477


    ASO_ORDER_FEEDBACK_VUHK.Update_Notice_POST(
      p_header_rec    	         => l_header_rec              ,
      p_old_header_rec           => l_old_header_rec          ,
      p_Header_Adj_tbl	         => l_Header_Adj_tbl          ,
      p_old_Header_Adj_tbl       => l_old_Header_Adj_tbl      ,
      p_Header_price_Att_tbl     => l_Header_price_Att_tbl    ,
      p_old_Header_Price_Att_tbl => l_old_Header_Price_Att_tbl,
      p_Header_Adj_Att_tbl       => l_Header_Adj_Att_tbl      ,
      p_old_Header_Adj_Att_tbl   => l_old_Header_Adj_Att_tbl  ,
      p_Header_Adj_Assoc_tbl     => l_Header_Adj_Assoc_tbl    ,
      p_old_Header_Adj_Assoc_tbl => l_old_Header_Adj_Assoc_tbl,
      p_Header_Scredit_tbl       => l_Header_Scredit_tbl      ,
      p_old_Header_Scredit_tbl   => l_old_Header_Scredit_tbl  ,
      p_line_tbl                 => l_line_tbl                ,
      p_old_line_tbl             => l_old_line_tbl            ,
      p_Line_Adj_tbl             => l_Line_Adj_tbl            ,
      p_old_Line_Adj_tbl         => l_old_Line_Adj_tbl        ,
      p_Line_Price_Att_tbl       => l_Line_Price_Att_tbl      ,
      p_old_Line_Price_Att_tbl   => l_old_Line_Price_Att_tbl  ,
      p_Line_Adj_Att_tbl         => l_Line_Adj_Att_tbl        ,
      p_old_Line_Adj_Att_tbl     => l_old_Line_Adj_Att_tbl    ,
      p_Line_Adj_Assoc_tbl       => l_Line_Adj_Assoc_tbl      ,
      p_old_Line_Adj_Assoc_tbl   => l_old_Line_Adj_Assoc_tbl  ,
      p_Line_Scredit_tbl         => l_Line_Scredit_tbl        ,
      p_old_Line_Scredit_tbl     => l_old_Line_Scredit_tbl    ,
      p_Lot_Serial_tbl           => l_Lot_Serial_tbl          ,
      p_old_Lot_Serial_tbl       => l_old_Lot_Serial_tbl      ,
      p_action_request_tbl       => l_action_request_tbl      ,
      x_return_status            =>  x_return_status          ,
      x_msg_count                =>  x_msg_count              ,
      x_msg_data                 =>  x_msg_data
    );

Line: 515


		    FND_MESSAGE.Set_Token('API', 'ASO_ORDER_FEEDBACK_VUHK.Update_Notice_POST', FALSE);

Line: 547


		ROLLBACK TO  UPDATE_NOTICE_PUB;

Line: 554


		ROLLBACK TO  UPDATE_NOTICE_PUB;

Line: 561


		ROLLBACK TO UPDATE_NOTICE_PUB;

Line: 570


END UPDATE_NOTICE;

Line: 1039


	ASO_ORDER_FEEDBACK_UPDATE_PVT.UPDATE_NOTICE(
      p_api_version                         =>  1.0,
      p_init_msg_list                       =>  FND_API.G_FALSE,
      p_commit                              =>  FND_API.G_FALSE,
      x_return_status                       =>  x_return_status,
      x_msg_count                           =>  x_msg_count,
      x_msg_data                            =>  x_msg_data,
      p_app_short_name                      =>  p_app_short_name,
      p_queue_type                          =>  'OF_EXCP_QUEUE',
      p_header_rec                          =>  p_header_rec,
      p_old_header_rec                      =>  p_old_header_rec,
      p_header_adj_tbl                      =>  p_header_adj_tbl,
      p_old_header_adj_tbl                  =>  p_old_header_adj_tbl,
      p_header_price_att_tbl                =>  p_header_price_att_tbl,
      p_old_header_price_att_tbl            =>  p_old_header_price_att_tbl,
      p_Header_Adj_Att_tbl                  =>  p_Header_Adj_Att_tbl,
      p_old_Header_Adj_Att_tbl              =>  p_old_Header_Adj_Att_tbl,
      p_Header_Adj_Assoc_tbl                =>  p_Header_Adj_Assoc_tbl,
      p_old_Header_Adj_Assoc_tbl            =>  p_old_Header_Adj_Assoc_tbl,
      p_Header_Scredit_tbl                  =>  p_Header_Scredit_tbl,
      p_old_Header_Scredit_tbl              =>  p_old_Header_Scredit_tbl,
      p_line_tbl                            =>  p_line_tbl,
      p_old_line_tbl                        =>  p_old_line_tbl,
      p_Line_Adj_tbl                        =>  p_Line_Adj_tbl,
      p_old_Line_Adj_tbl                    =>  p_old_Line_Adj_tbl,
      p_Line_Price_Att_tbl                  =>  p_Line_Price_Att_tbl,
      p_old_Line_Price_Att_tbl              =>  p_old_Line_Price_Att_tbl,
      p_Line_Adj_Att_tbl                    =>  p_Line_Adj_Att_tbl,
      p_old_Line_Adj_Att_tbl                =>  p_old_Line_Adj_Att_tbl,
      p_Line_Adj_Assoc_tbl                  =>  p_Line_Adj_Assoc_tbl,
      p_old_Line_Adj_Assoc_tbl              =>  p_old_Line_Adj_Assoc_tbl,
      p_Line_Scredit_tbl                    =>  p_Line_Scredit_tbl,
      p_old_Line_Scredit_tbl                =>  p_old_Line_Scredit_tbl,
      p_Lot_Serial_tbl                      =>  p_Lot_Serial_tbl,
      p_old_Lot_Serial_tbl                  =>  p_old_Lot_Serial_tbl,
      p_action_request_tbl                  =>  p_action_request_tbl
 );