The following lines contain the word 'select', 'insert', 'update' or 'delete':
select 'Following Errors Have occured for Order, Order Number '
|| to_char(order_number)
from OE_ORDER_HEADERS
where header_id = p_header_id;
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;
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;
SELECT Sales_Credit_ID
FROM OE_SALES_CREDITS
WHERE HEADER_ID = P_HEADER_ID
AND LINE_ID IS NULL;
l_Header_Scredit_tbl.delete;
l_Old_Header_Scredit_tbl.delete;
l_x_Header_Scredit_tbl(j).operation := OE_GLOBALS.G_OPR_DELETE;
l_x_Header_Scredit_tbl.delete;
l_Old_Header_Scredit_tbl.delete;
l_Header_Scredit_rec.sales_group_updated_flag := g_Header_Multi_Scredit_Tbl(I).sales_group_updated_flag; --5692017
,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;
g_Header_Multi_Scredit_Tbl.delete;
g_Header_Multi_Scredit_Tbl(I).sales_group_updated_flag := p_sales_group_updated_flag; --5692017
,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;
g_Multi_MSG_Tbl.Delete;