[Home] [Help]
PACKAGE: APPS.PA_FP_SPREAD_CURVES_UTILS
Source
1 PACKAGE pa_fp_spread_curves_utils AUTHID CURRENT_USER as
2 /* $Header: PAFPSCUS.pls 120.1.12010000.2 2010/01/28 23:52:17 snizam ship $ */
3
4 -- start of code changes for 9036322
5 TYPE t1 IS TABLE OF pa_resource_assignments.spread_curve_id%TYPE INDEX BY binary_integer;
6 G_curve_id_tbl t1;
7 G_is_first_call VARCHAR2 (1) := 'Y';
8 -- End of code changes for 9036322
9
10 FUNCTION is_spread_curve_in_use ( p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE ) RETURN VARCHAR2;
11
12 PROCEDURE validate (
13 p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
14 p_name IN Pa_spread_curves_tl.name%TYPE,
15 P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,
16 P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,
17 P_point1 IN Pa_spread_curves_b.point1%TYPE,
18 P_point2 IN Pa_spread_curves_b.point2%TYPE,
19 P_point3 IN Pa_spread_curves_b.point3%TYPE,
20 P_point4 IN Pa_spread_curves_b.point4%TYPE,
21 P_point5 IN Pa_spread_curves_b.point5%TYPE,
22 P_point6 IN Pa_spread_curves_b.point6%TYPE,
23 P_point7 IN Pa_spread_curves_b.point7%TYPE,
24 P_point8 IN Pa_spread_curves_b.point8%TYPE,
25 P_point9 IN Pa_spread_curves_b.point9%TYPE,
26 P_point10 IN Pa_spread_curves_b.point10%TYPE,
27 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
28 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29 x_msg_count OUT NOCOPY number ); --File.Sql.39 bug 4440895
30
31 PROCEDURE validate_name
32 (p_name IN pa_spread_curves_tl.name%TYPE,
33 p_spread_curve_id IN pa_spread_curves_tl.spread_curve_id%TYPE,
34 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
35 x_msg_count OUT NOCOPY NUMBER, --File.Sql.39 bug 4440895
36 x_msg_data OUT NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
37
38 PROCEDURE validate_amount_in_buckets(
39 P_point1 IN Pa_spread_curves_b.point1%TYPE,
40 P_point2 IN Pa_spread_curves_b.point2%TYPE,
41 P_point3 IN Pa_spread_curves_b.point3%TYPE,
42 P_point4 IN Pa_spread_curves_b.point4%TYPE,
43 P_point5 IN Pa_spread_curves_b.point5%TYPE,
44 P_point6 IN Pa_spread_curves_b.point6%TYPE,
45 P_point7 IN Pa_spread_curves_b.point7%TYPE,
46 P_point8 IN Pa_spread_curves_b.point8%TYPE,
47 P_point9 IN Pa_spread_curves_b.point9%TYPE,
48 P_point10 IN Pa_spread_curves_b.point10%TYPE,
49 x_return_status OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
50 x_msg_data OUT NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
51 x_msg_count OUT NOCOPY number); --File.Sql.39 bug 4440895
52
53 END pa_fp_spread_curves_utils;