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 10: FUNCTION is_spread_curve_in_use ( p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE ) RETURN VARCHAR2;

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,

Line 13: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,

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,

Line 15: P_effective_from IN Pa_spread_curves_b.effective_Start_date%TYPE,

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,

Line 16: P_effective_to IN Pa_spread_curves_b.effective_end_date%TYPE,

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,

Line 17: P_point1 IN Pa_spread_curves_b.point1%TYPE,

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,

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

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

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

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

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

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

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

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

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

Line 39: P_point1 IN Pa_spread_curves_b.point1%TYPE,

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,

Line 40: P_point2 IN Pa_spread_curves_b.point2%TYPE,

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,

Line 41: P_point3 IN Pa_spread_curves_b.point3%TYPE,

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,

Line 42: P_point4 IN Pa_spread_curves_b.point4%TYPE,

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,

Line 43: P_point5 IN Pa_spread_curves_b.point5%TYPE,

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,

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

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

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

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

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