DBA Data[Home] [Help]

APPS.OE_ORDER_UTIL SQL Statements

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

Line: 31

	SELECT AK.ATTRIBUTE_LABEL_LONG
	INTO l_attribute_name
	FROM AK_ATTRIBUTES_VL AK
	WHERE ak.attribute_code = upper(p_attribute_code)
	  AND ak.attribute_application_id = 660;
Line: 59

	SELECT header_id
	FROM OE_ORDER_HEADERS
	WHERE HEADER_ID = p_header_id
	FOR UPDATE NOWAIT;
Line: 64

	SELECT line_id
	FROM OE_ORDER_LINES
	WHERE HEADER_ID = p_header_id
	FOR UPDATE NOWAIT;
Line: 69

	SELECT price_adjustment_id
	FROM OE_PRICE_ADJUSTMENTS
	WHERE HEADER_ID = p_header_id
	FOR UPDATE NOWAIT;
Line: 74

	SELECT sales_credit_id
	FROM OE_SALES_CREDITS
	WHERE HEADER_ID = p_header_id
	FOR UPDATE NOWAIT;
Line: 149

PROCEDURE Update_Global_Picture
(
   p_Upd_New_Rec_If_Exists   IN BOOLEAN := TRUE
,  p_Header_Rec              IN OE_Order_Pub.Header_Rec_Type := NULL
,  p_Line_Rec                IN OE_Order_Pub.Line_Rec_Type := NULL
,  p_Hdr_Scr_Rec             IN OE_Order_Pub.Header_Scredit_Rec_Type :=  NULL
,  p_Hdr_Adj_Rec             IN OE_Order_Pub.Header_Adj_Rec_Type :=  NULL
,  p_Line_Adj_Rec            IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
,  p_Line_Scr_Rec            IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
,  p_Lot_Serial_Rec          IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
,  p_old_Header_Rec          IN OE_Order_Pub.Header_Rec_Type := NULL
,  p_old_Line_Rec            IN OE_Order_Pub.Line_Rec_Type := NULL
,  p_old_Hdr_Scr_Rec         IN OE_Order_Pub.Header_Scredit_Rec_Type := NULL
,  p_old_Hdr_Adj_Rec         IN OE_Order_Pub.Header_Adj_Rec_Type := NULL
,  p_old_Line_Adj_Rec        IN OE_Order_Pub.Line_Adj_Rec_Type := NULL
,  p_old_Line_Scr_Rec        IN OE_Order_Pub.Line_Scredit_Rec_Type := NULL
,  p_old_Lot_Serial_Rec      IN OE_Order_Pub.Lot_Serial_Rec_Type := NULL
,  p_header_id               IN NUMBER := NULL
,  p_line_id                 IN NUMBER := NULL
,  p_hdr_scr_id              IN NUMBER := NULL
,  p_line_scr_id             IN NUMBER := NULL
,  p_hdr_adj_id              IN NUMBER := NULL
,  p_line_adj_id             IN NUMBER := NULL
,  p_lot_serial_id           IN NUMBER := NULL
, x_index OUT NOCOPY NUMBER

, x_return_status OUT NOCOPY VARCHAR2)


IS
  l_ind    		PLS_INTEGER;
Line: 202

      oe_debug_pub.add(  'ENTERING OE_ORDER_UTIL.UPDATE_GLOBAL_PICTURE' , 1 ) ;
Line: 264

                            oe_debug_pub.add(  'JPN: OLD HEADER GLOBAL PIC UPDATED' ) ;
Line: 271

                              oe_debug_pub.add(  'JPN: OLD HEADER GLOBAL PIC UPDATED AFTER QUERY' ) ;
Line: 277

                 oe_debug_pub.add(  'JPN: OLD HEADER GLOBAL PIC UPDATED IN THIS LOOP' ) ;
Line: 287

       /* Update the record in the new global table */
       IF l_debug_level  > 0 THEN
         oe_debug_pub.add(  'INSIDE LOOP P_UPD_NEW_REC' ) ;
Line: 315

   END IF; -- update flag is set
Line: 355

                     oe_debug_pub.add(  'JPN: OLD HEADER SALES CREDITS GLOBAL PIC UPDATED' ) ;
Line: 361

                  oe_debug_pub.add(  'JPN: OLD HEADER SCREDIT GLOBAL PIC UPDATED AFTER QUERY' ) ;
Line: 382

      /* Update the record in the new global table */
      g_header_scredit_tbl(l_ind) := p_hdr_scr_rec;
Line: 396

   END IF; -- update flag is set
Line: 436

                     oe_debug_pub.add(  'JPN: OLD HEADER ADJ GLOBAL PIC UPDATED' ) ;
Line: 463

      /* Update the record in the new global table */
      g_header_adj_tbl(l_ind) := p_hdr_adj_rec;
Line: 477

   END IF; -- update flag is set
Line: 518

                     oe_debug_pub.add(  'JPN: OLD LINE GLOBAL PIC UPDATED' ) ;
Line: 525

                  oe_debug_pub.add(  'JPN: OLD LINE GLOBAL PIC UPDATED AFTER QUERY' ) ;
Line: 546

      /* Update the record in the new global table */
      g_line_tbl(l_ind) := p_line_rec;
Line: 560

   END IF; -- update flag is set
Line: 599

                     oe_debug_pub.add(  'JPN: OLD LINE SALES CREDITS GLOBAL PIC UPDATED' ) ;
Line: 624

      /* Update the record in the new global table */
      g_line_scredit_tbl(l_ind) := p_line_scr_rec;
Line: 638

   END IF; -- update flag is set
Line: 679

                     oe_debug_pub.add(  'JPN: OLD LINE ADJ GLOBAL PIC UPDATED' ) ;
Line: 703

      /* Update the record in the new global table */
      g_line_adj_tbl(l_ind) := p_line_adj_rec;
Line: 717

   END IF; -- update flag is set
Line: 758

                     oe_debug_pub.add(  'JPN: OLD LOT SERIAL GLOBAL PIC UPDATED' ) ;
Line: 771

      /* Update the record in the new global table */
      g_lot_serial_tbl(l_ind) := p_lot_serial_rec;
Line: 776

   END IF; -- update flag is set
Line: 789

      oe_debug_pub.add(  'EXITING OE_ORDER_UTIL.UPDATE_GLOBAL_PICTURE' , 1 ) ;
Line: 802

	    ,'Update_Global_picture');
Line: 806

END Update_Global_Picture;
Line: 1037

      G_line_tbl.DELETE;
Line: 1038

      G_old_line_tbl.DELETE;
Line: 1039

      G_Header_Scredit_tbl.DELETE;
Line: 1040

      G_Old_Header_Scredit_tbl.DELETE;
Line: 1041

      G_Old_Line_Scredit_tbl.DELETE;
Line: 1042

      G_Line_Scredit_tbl.DELETE;
Line: 1043

      G_old_Header_Adj_tbl.DELETE;
Line: 1044

      G_Header_Adj_tbl.DELETE;
Line: 1045

      G_old_Line_Adj_tbl.DELETE;
Line: 1046

      G_Line_Adj_tbl.DELETE;
Line: 1047

      G_old_Lot_Serial_tbl.DELETE;
Line: 1048

      G_Lot_Serial_tbl.DELETE;
Line: 1348

   SELECT TRANSACTIONAL_CURR_CODE
   INTO   l_currency_code
   FROM   OE_ORDER_HEADERS
   WHERE  HEADER_ID=p_header_id;
Line: 1353

   SELECT /*MOAC_SQL_CHANGES*/ OH.TRANSACTIONAL_CURR_CODE
   INTO   l_currency_code
   FROM   OE_ORDER_HEADERS OH, OE_ORDER_LINES_ALL OL
   WHERE  OH.HEADER_ID=OL.HEADER_ID
   AND    OL.LINE_ID=p_line_id;