APPS.OE_OE_MULTI_HEADER_SCREDIT SQL Statements

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

Line: 52

       select 'Following Errors Have occured for Order, Order Number '
             || to_char(order_number)
       from OE_ORDER_HEADERS
       where header_id = p_header_id;

Line: 142

       SELECT Sales_Credit_ID
       FROM OE_SALES_CREDITS SC,
		  OE_SALES_CREDIT_TYPES SCT
       WHERE HEADER_ID = P_HEADER_ID
	  AND SCT.SALES_CREDIT_TYPE_ID = SC.SALES_CREDIT_TYPE_ID
       AND   SCT.QUOTA_FLAG  = 'Y'
       AND LINE_ID IS NULL;

Line: 150

       SELECT Sales_Credit_ID
       FROM OE_SALES_CREDITS SC,
		  OE_SALES_CREDIT_TYPES SCT
       WHERE HEADER_ID = P_HEADER_ID
	  AND SCT.SALES_CREDIT_TYPE_ID = SC.SALES_CREDIT_TYPE_ID
       AND   SCT.QUOTA_FLAG  = 'N'
       AND LINE_ID IS NULL;

Line: 158

       SELECT Sales_Credit_ID
       FROM OE_SALES_CREDITS
       WHERE HEADER_ID = P_HEADER_ID
       AND LINE_ID IS NULL;

Line: 171

   l_Header_Scredit_tbl.delete;

Line: 172

   l_Old_Header_Scredit_tbl.delete;

Line: 264

       l_x_Header_Scredit_tbl(j).operation := OE_GLOBALS.G_OPR_DELETE;

Line: 308

   l_x_Header_Scredit_tbl.delete;

Line: 309

   l_Old_Header_Scredit_tbl.delete;

Line: 356

    l_Header_Scredit_rec.sales_group_updated_flag := g_Header_Multi_Scredit_Tbl(I).sales_group_updated_flag;  --5692017

Line: 463

  ,p_sales_group_updated_flag IN Varchar2  --5692017
,p_return_status OUT NOCOPY Varchar2

,p_msg_count OUT NOCOPY NUMBER

,p_msg_data OUT NOCOPY Varchar2

  ) IS
I number;

Line: 481

       g_Header_Multi_Scredit_Tbl.delete;

Line: 507

    g_Header_Multi_Scredit_Tbl(I).sales_group_updated_flag := p_sales_group_updated_flag;   --5692017

Line: 561

    ,p_header_id_list          IN  Oe_Globals.Selected_Record_Tbl  --MOAC PI
    ,p_replace_credit_type     IN  Varchar2
,p_Return_Status OUT NOCOPY Varchar2

,p_msg_count OUT NOCOPY NUMBER

,p_msg_data OUT NOCOPY Varchar2

   ) IS
l_x_header_id                  number;

Line: 585

  g_Multi_MSG_Tbl.Delete;