eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

PACKAGE: APPS.PA_FP_SPREAD_CURVES_UTILS

Source


1 PACKAGE pa_fp_spread_curves_utils as
2 /* $Header: PAFPSCUS.pls 120.1 2005/08/19 16:30:17 mwasowic noship $ */
3 
4 FUNCTION is_spread_curve_in_use ( p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE ) RETURN VARCHAR2;
5 
6 PROCEDURE validate (
7         p_spread_curve_id       IN              Pa_spread_curves_b.spread_curve_id%TYPE,
8 	p_name                  IN              Pa_spread_curves_tl.name%TYPE,
9 	P_effective_from        IN              Pa_spread_curves_b.effective_Start_date%TYPE,
10 	P_effective_to		IN              Pa_spread_curves_b.effective_end_date%TYPE,
11 	P_point1                IN              Pa_spread_curves_b.point1%TYPE,
12 	P_point2                IN              Pa_spread_curves_b.point2%TYPE,
13 	P_point3                IN              Pa_spread_curves_b.point3%TYPE,
14 	P_point4                IN              Pa_spread_curves_b.point4%TYPE,
15 	P_point5                IN              Pa_spread_curves_b.point5%TYPE,
16 	P_point6                IN              Pa_spread_curves_b.point6%TYPE,
17 	P_point7                IN              Pa_spread_curves_b.point7%TYPE,
18 	P_point8                IN              Pa_spread_curves_b.point8%TYPE,
19 	P_point9                IN              Pa_spread_curves_b.point9%TYPE,
20 	P_point10               IN              Pa_spread_curves_b.point10%TYPE,
21 	x_return_status	        OUT             NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
22 	x_msg_data             OUT             NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
23 	x_msg_count             OUT             NOCOPY number	 ); --File.Sql.39 bug 4440895
24 
25 PROCEDURE validate_name
26     (p_name                         IN     pa_spread_curves_tl.name%TYPE,
27      p_spread_curve_id             IN     pa_spread_curves_tl.spread_curve_id%TYPE,
28      x_return_status                OUT    NOCOPY VARCHAR2, --File.Sql.39 bug 4440895
29      x_msg_count                    OUT    NOCOPY NUMBER, --File.Sql.39 bug 4440895
30      x_msg_data                     OUT    NOCOPY VARCHAR2); --File.Sql.39 bug 4440895
31 
32 PROCEDURE validate_amount_in_buckets(
33 	P_point1                IN        Pa_spread_curves_b.point1%TYPE,
34 	P_point2                IN        Pa_spread_curves_b.point2%TYPE,
35 	P_point3                IN        Pa_spread_curves_b.point3%TYPE,
36 	P_point4                IN        Pa_spread_curves_b.point4%TYPE,
37 	P_point5                IN        Pa_spread_curves_b.point5%TYPE,
38 	P_point6                IN        Pa_spread_curves_b.point6%TYPE,
39 	P_point7                IN        Pa_spread_curves_b.point7%TYPE,
40 	P_point8                IN        Pa_spread_curves_b.point8%TYPE,
41 	P_point9                IN        Pa_spread_curves_b.point9%TYPE,
42 	P_point10               IN        Pa_spread_curves_b.point10%TYPE,
43 	x_return_status         OUT       NOCOPY VARCHAR2,  --File.Sql.39 bug 4440895
44 	x_msg_data             OUT       NOCOPY VARCHAR2,  --File.Sql.39 bug 4440895
45 	x_msg_count             OUT       NOCOPY number); --File.Sql.39 bug 4440895
46 
47 END pa_fp_spread_curves_utils;