APPS.OE_OE_MULTI_LINE_SCREDIT SQL Statements

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

Line: 52

       select 'Following Errors Have occured for Line, (Line,Shipment) '
             || to_char(line_number) || ',' || to_char(shipment_number)
       from OE_ORDER_LineS
       where Line_id = p_Line_id;

Line: 126

       SELECT Sales_Credit_ID
       FROM OE_SALES_CREDITS SC,
	  OE_SALES_CREDIT_TYPES SCT
       WHERE Line_ID = P_Line_ID
	  AND SC.SALES_CREDIT_TYPE_id = SCT.SALES_CREDIT_TYPE_id
       AND   sct.QUOTA_FLAG  = 'Y';

Line: 133

       SELECT Sales_Credit_ID
       FROM OE_SALES_CREDITS SC,
	  OE_SALES_CREDIT_TYPES SCT
       WHERE Line_ID = P_Line_ID
	  AND SC.SALES_CREDIT_TYPE_id = SCT.SALES_CREDIT_TYPE_id
       AND   SCT.QUOTA_FLAG  = 'N';

Line: 140

       SELECT Sales_Credit_ID
       FROM OE_SALES_CREDITS
       WHERE Line_ID = P_Line_ID;

Line: 152

   l_x_Line_Scredit_tbl.delete;

Line: 153

   l_Old_Line_Scredit_tbl.delete;

Line: 244

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

Line: 287

   l_x_Line_Scredit_tbl.delete;

Line: 288

   l_Old_Line_Scredit_tbl.delete;

Line: 335

    l_Line_Scredit_rec.Sales_Group_updated_flag := g_Line_Multi_Scredit_Tbl(I).Sales_Group_updated_flag;  --5692017

Line: 344

oe_debug_pub.add('Sales_Group_updated_flag:'||l_Line_Scredit_rec.Sales_Group_updated_flag);  --5692017

Line: 377

oe_debug_pub.add('after process order: sales_group_flag'||l_x_Line_Scredit_tbl(1).sales_group_updated_flag);  --5692017

Line: 446

  ,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: 464

       g_Line_Multi_Scredit_Tbl.delete;

Line: 490

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

Line: 544

    ,p_Line_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_Line_id                  number;

Line: 567

  g_Multi_MSG_Tbl.Delete;