The following lines contain the word 'select', 'insert', 'update' or 'delete':
l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
, x_last_update_date OUT NOCOPY /* file.sql.39 change */ DATE
, x_last_updated_by OUT NOCOPY /* file.sql.39 change */ NUMBER
, x_last_update_login OUT NOCOPY /* file.sql.39 change */ NUMBER
)
IS
l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_UPDATE;
select qp_list_lines_s.nextval into l_Price_LLine_rec.price_list_line_id from dual;
x_last_update_date := l_x_Price_LLine_rec.last_update_date;
x_last_updated_by := l_x_Price_LLine_rec.last_updated_by;
x_last_update_login := l_x_Price_LLine_rec.last_update_login;
PROCEDURE Delete_Row
( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
, x_msg_count OUT NOCOPY /* file.sql.39 change */ NUMBER
, x_msg_data OUT NOCOPY /* file.sql.39 change */ VARCHAR2
, p_price_list_line_id IN NUMBER
)
IS
l_Price_LLine_rec OE_Price_List_PUB.Price_List_Line_Rec_Type;
l_Price_LLine_rec.operation := OE_GLOBALS.G_OPR_DELETE;
, 'Delete_Row'
);
END Delete_Row;
, p_last_updated_by IN NUMBER
, p_last_update_date IN DATE
, p_last_update_login IN NUMBER
, p_list_price IN NUMBER
, p_method_code IN VARCHAR2
, p_price_list_id IN NUMBER
, p_price_list_line_id IN NUMBER
, p_pricing_attribute1 IN VARCHAR2
, p_pricing_attribute10 IN VARCHAR2
, p_pricing_attribute11 IN VARCHAR2
, p_pricing_attribute12 IN VARCHAR2
, p_pricing_attribute13 IN VARCHAR2
, p_pricing_attribute14 IN VARCHAR2
, p_pricing_attribute15 IN VARCHAR2
, p_pricing_attribute2 IN VARCHAR2
, p_pricing_attribute3 IN VARCHAR2
, p_pricing_attribute4 IN VARCHAR2
, p_pricing_attribute5 IN VARCHAR2
, p_pricing_attribute6 IN VARCHAR2
, p_pricing_attribute7 IN VARCHAR2
, p_pricing_attribute8 IN VARCHAR2
, p_pricing_attribute9 IN VARCHAR2
, p_pricing_context IN VARCHAR2
, p_pricing_rule_id IN NUMBER
, p_program_application_id IN NUMBER
, p_program_id IN NUMBER
, p_program_update_date IN DATE
, p_reprice_flag IN VARCHAR2
, p_request_id IN NUMBER
, p_revision IN VARCHAR2
, p_revision_date IN DATE
, p_revision_reason_code IN VARCHAR2
, p_start_date_active IN DATE
, p_unit_code IN VARCHAR2
, p_primary IN VARCHAR2
, p_list_line_type_code IN VARCHAR2
)
IS
l_return_status VARCHAR2(1);
l_Price_LLine_rec.last_updated_by := p_last_updated_by;
l_Price_LLine_rec.last_update_date := p_last_update_date;
l_Price_LLine_rec.last_update_login := p_last_update_login;
l_Price_LLine_rec.program_update_date := p_program_update_date;