The following lines contain the word 'select', 'insert', 'update' or 'delete':
Select 'Y' from pa_resource_assignments
where spread_curve_id = p_spread_curve_id;
before inserting or updating
1. Name - uniqueness.
2. Dates - Start date is entered
end date if entered should be later than start date
3. Amount in buckets should not be less than 0
==================================================================*/
PROCEDURE validate (
p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
p_name IN Pa_spread_curves_tl.name%TYPE,
P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
P_point1 IN Pa_spread_curves_b.point1%TYPE,
P_point2 IN Pa_spread_curves_b.point2%TYPE,
P_point3 IN Pa_spread_curves_b.point3%TYPE,
P_point4 IN Pa_spread_curves_b.point4%TYPE,
P_point5 IN Pa_spread_curves_b.point5%TYPE,
P_point6 IN Pa_spread_curves_b.point6%TYPE,
P_point7 IN Pa_spread_curves_b.point7%TYPE,
P_point8 IN Pa_spread_curves_b.point8%TYPE,
P_point9 IN Pa_spread_curves_b.point9%TYPE,
P_point10 IN Pa_spread_curves_b.point10%TYPE,
x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
X_msg_count OUT NOCOPY number ) --File.Sql.39 bug 4440895
AS
l_any_error_occurred_flag VARCHAR2(1) := NULL;
select 'Y'
into l_exists
from pa_spread_curves_vl
where upper(name) = upper(p_name)
and spread_curve_id <> nvl(p_spread_curve_id,-99)
and rownum < 2;