APPS.OE_OE_FORM_CANCEL_LINE SQL Statements

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

Line: 30

    ,p_record_ids           IN OE_GLOBALS.Selected_Record_Tbl -- MOAC
    ,p_cancel_to_quantity   IN NUMBER
    ,p_cancellation_comments IN VARCHAR2
    ,p_reason_code          IN VARCHAR2
    ,p_cancellation_type    IN VARCHAR2
    ,p_mc_err_handling_flag IN NUMBER := FND_API.G_MISS_NUM
,x_msg_count OUT NOCOPY NUMBER

,x_msg_data OUT NOCOPY VARCHAR2

,x_return_status OUT NOCOPY VARCHAR2

,x_error_count OUT NOCOPY NUMBER

) IS
l_line_rec            OE_ORDER_PUB.line_rec_type;

Line: 67

l_record_ids          OE_GLOBALS.Selected_Record_Tbl := p_record_ids ;

Line: 74

select opa1.line_id
from   oe_price_adjustments opa1,
       oe_price_adjustments opa2,
       oe_price_adj_assocs opaa
where  opa1.list_line_type_code = 'PRG'
and    opa1.price_adjustment_id = opaa.price_adjustment_id
and    opa2.price_adjustment_id = opaa.rltd_price_adj_id
and    opa2.line_id             = c_line_id;

Line: 161

				l_line_tbl.delete;

Line: 163

				l_old_line_tbl.delete;

Line: 258

            oe_debug_pub.add(  'SKIP , PARENT OF THIS SERVICE LINE IS SELECTED FOR CANCELLATION' ) ;

Line: 307

    l_line_tbl(l_tblcount).operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 417

    ,p_record_ids           IN OE_GLOBALS.Selected_Record_Tbl -- MOAC
    ,p_cancellation_comments IN VARCHAR2
    ,p_reason_code          IN VARCHAR2
    ,p_mc_err_handling_flag IN NUMBER := FND_API.G_MISS_NUM
,x_msg_count OUT NOCOPY NUMBER

,x_msg_data OUT NOCOPY VARCHAR2

,x_return_status OUT NOCOPY VARCHAR2

,x_error_count OUT NOCOPY NUMBER

) IS
l_header_rec                OE_ORDER_PUB.Header_Rec_Type;

Line: 442

l_record_ids  OE_GLOBALS.Selected_Record_Tbl := p_record_ids ;

Line: 455

 l_header_rec.operation := OE_GLOBALS.G_OPR_NONE;   --OE.G_OPR_UPDATE;

Line: 535

 l_header_rec.operation := OE_GLOBALS.G_OPR_UPDATE;

Line: 690

                  p_record_ids IN OE_GLOBALS.Selected_Record_Tbl, --MOAC
x_return_status OUT NOCOPY VARCHAR2,

                    p_cancellation_comments IN VARCHAR2,
                    p_reason_code          IN VARCHAR2,
x_msg_count OUT NOCOPY NUMBER,

x_msg_data OUT NOCOPY VARCHAR2)IS

l_header_rec OE_ORDER_PUB.header_rec_type :=
		oe_order_pub.g_miss_header_rec;

Line: 706

l_record_ids  OE_GLOBALS.Selected_Record_Tbl := p_record_ids ;