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.

APPS.PA_FP_SPREAD_CURVES_UTILS dependencies on PA_SPREAD_CURVES_B

Line 4: FUNCTION is_spread_curve_in_use ( p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE ) RETURN VARCHAR2;

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,

Line 7: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,

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,

Line 9: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,

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,

Line 10: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,

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,

Line 11: P_point1 IN Pa_spread_curves_b.point1%TYPE,

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,

Line 12: P_point2 IN Pa_spread_curves_b.point2%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,

Line 13: P_point3 IN Pa_spread_curves_b.point3%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,

Line 14: P_point4 IN Pa_spread_curves_b.point4%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,

Line 15: P_point5 IN Pa_spread_curves_b.point5%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,

Line 16: P_point6 IN Pa_spread_curves_b.point6%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,

Line 17: P_point7 IN Pa_spread_curves_b.point7%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

Line 18: P_point8 IN Pa_spread_curves_b.point8%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

Line 19: P_point9 IN Pa_spread_curves_b.point9%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

Line 20: P_point10 IN Pa_spread_curves_b.point10%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:

Line 33: P_point1 IN Pa_spread_curves_b.point1%TYPE,

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,

Line 34: P_point2 IN Pa_spread_curves_b.point2%TYPE,

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,

Line 35: P_point3 IN Pa_spread_curves_b.point3%TYPE,

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,

Line 36: P_point4 IN Pa_spread_curves_b.point4%TYPE,

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,

Line 37: P_point5 IN Pa_spread_curves_b.point5%TYPE,

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,

Line 38: P_point6 IN Pa_spread_curves_b.point6%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,

Line 39: P_point7 IN Pa_spread_curves_b.point7%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

Line 40: P_point8 IN Pa_spread_curves_b.point8%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

Line 41: P_point9 IN Pa_spread_curves_b.point9%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

Line 42: P_point10 IN Pa_spread_curves_b.point10%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: