1: package PA_FP_SPREAD_CURVES_PKG AUTHID CURRENT_USER as
2: /* $Header: PAFPSCTS.pls 120.1 2005/08/19 16:30:08 mwasowic noship $ */
3:
4: procedure LOCK_ROW (
5: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
6: p_RECORD_VERSION_NUMBER IN pa_spread_curves_b.RECORD_VERSION_NUMBER%TYPE
7: );
8:
9: procedure DELETE_ROW (
2: /* $Header: PAFPSCTS.pls 120.1 2005/08/19 16:30:08 mwasowic noship $ */
3:
4: procedure LOCK_ROW (
5: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
6: p_RECORD_VERSION_NUMBER IN pa_spread_curves_b.RECORD_VERSION_NUMBER%TYPE
7: );
8:
9: procedure DELETE_ROW (
10: p_spread_curve_id in Pa_spread_curves_b.spread_curve_id%TYPE
6: p_RECORD_VERSION_NUMBER IN pa_spread_curves_b.RECORD_VERSION_NUMBER%TYPE
7: );
8:
9: procedure DELETE_ROW (
10: p_spread_curve_id in Pa_spread_curves_b.spread_curve_id%TYPE
11: );
12:
13:
14: Procedure Insert_Row (
12:
13:
14: Procedure Insert_Row (
15: X_Rowid IN OUT NOCOPY Rowid, --File.Sql.39 bug 4440895
16: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
17: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
18: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
19: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
20: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
13:
14: Procedure Insert_Row (
15: X_Rowid IN OUT NOCOPY Rowid, --File.Sql.39 bug 4440895
16: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
17: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
18: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
19: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
20: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
21: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
14: Procedure Insert_Row (
15: X_Rowid IN OUT NOCOPY Rowid, --File.Sql.39 bug 4440895
16: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
17: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
18: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
19: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
20: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
21: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
22: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
17: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
18: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
19: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
20: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
21: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
22: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
23: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
24: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
25: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
18: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
19: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
20: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
21: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
22: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
23: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
24: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
25: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
26: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
19: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
20: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
21: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
22: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
23: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
24: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
25: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
26: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
27: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
20: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
21: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
22: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
23: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
24: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
25: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
26: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
27: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
28: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
21: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
22: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
23: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
24: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
25: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
26: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
27: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
28: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
29: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
22: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
23: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
24: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
25: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
26: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
27: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
28: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
29: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
30: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
23: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
24: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
25: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
26: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
27: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
28: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
29: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
30: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
31: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
24: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
25: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
26: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
27: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
28: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
29: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
30: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
31: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
32: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
25: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
26: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
27: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
28: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
29: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
30: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
31: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
32: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
33: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
26: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
27: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
28: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
29: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
30: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
31: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
32: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
33: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
34: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
27: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
28: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
29: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
30: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
31: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
32: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
33: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
34: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
35: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
28: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
29: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
30: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
31: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
32: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
33: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
34: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
35: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
36: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,
29: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
30: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
31: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
32: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
33: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
34: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
35: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
36: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,
37: X_Created_By IN Pa_Spread_Curves_B.Created_By%Type,
30: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
31: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
32: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
33: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
34: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
35: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
36: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,
37: X_Created_By IN Pa_Spread_Curves_B.Created_By%Type,
38: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
31: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
32: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
33: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
34: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
35: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
36: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,
37: X_Created_By IN Pa_Spread_Curves_B.Created_By%Type,
38: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
39: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
32: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
33: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
34: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
35: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
36: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,
37: X_Created_By IN Pa_Spread_Curves_B.Created_By%Type,
38: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
39: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
40: X_Msg_Data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
33: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
34: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
35: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
36: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,
37: X_Created_By IN Pa_Spread_Curves_B.Created_By%Type,
38: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
39: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
40: X_Msg_Data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
41: X_Msg_Count OUT NOCOPY Number --File.Sql.39 bug 4440895
34: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
35: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
36: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,
37: X_Created_By IN Pa_Spread_Curves_B.Created_By%Type,
38: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
39: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
40: X_Msg_Data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
41: X_Msg_Count OUT NOCOPY Number --File.Sql.39 bug 4440895
42: );
41: X_Msg_Count OUT NOCOPY Number --File.Sql.39 bug 4440895
42: );
43:
44: Procedure Update_Row (
45: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
46: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
47: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
48: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
49: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
42: );
43:
44: Procedure Update_Row (
45: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
46: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
47: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
48: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
49: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
50: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
43:
44: Procedure Update_Row (
45: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
46: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
47: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
48: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
49: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
50: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
51: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
46: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
47: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
48: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
49: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
50: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
51: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
52: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
53: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
54: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
47: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
48: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
49: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
50: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
51: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
52: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
53: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
54: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
55: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
48: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
49: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
50: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
51: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
52: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
53: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
54: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
55: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
56: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
49: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
50: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
51: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
52: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
53: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
54: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
55: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
56: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
57: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
50: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
51: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
52: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
53: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
54: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
55: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
56: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
57: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
58: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
51: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
52: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
53: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
54: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
55: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
56: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
57: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
58: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
59: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
52: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
53: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
54: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
55: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
56: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
57: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
58: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
59: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
60: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
53: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
54: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
55: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
56: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
57: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
58: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
59: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
60: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
61: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
54: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
55: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
56: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
57: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
58: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
59: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
60: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
61: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
62: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
55: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
56: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
57: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
58: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
59: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
60: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
61: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
62: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
63: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
56: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
57: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
58: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
59: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
60: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
61: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
62: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
63: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
64: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
57: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
58: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
59: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
60: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
61: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
62: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
63: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
64: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
65: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
58: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
59: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
60: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
61: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
62: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
63: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
64: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
65: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
66: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
59: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
60: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
61: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
62: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
63: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
64: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
65: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
66: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
67: X_Msg_Data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
60: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
61: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
62: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
63: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
64: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
65: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
66: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
67: X_Msg_Data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
68: X_Msg_Count OUT NOCOPY Number --File.Sql.39 bug 4440895
61: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
62: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
63: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
64: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
65: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
66: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
67: X_Msg_Data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
68: X_Msg_Count OUT NOCOPY Number --File.Sql.39 bug 4440895
69: );
68: X_Msg_Count OUT NOCOPY Number --File.Sql.39 bug 4440895
69: );
70:
71: Procedure Load_Row (
72: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
73: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
74: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
75: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
76: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
69: );
70:
71: Procedure Load_Row (
72: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
73: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
74: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
75: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
76: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
77: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
70:
71: Procedure Load_Row (
72: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
73: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
74: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
75: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
76: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
77: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
78: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
73: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
74: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
75: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
76: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
77: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
78: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
79: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
80: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
81: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
74: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
75: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
76: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
77: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
78: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
79: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
80: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
81: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
82: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
75: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
76: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
77: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
78: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
79: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
80: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
81: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
82: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
83: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
76: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
77: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
78: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
79: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
80: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
81: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
82: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
83: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
84: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
77: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
78: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
79: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
80: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
81: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
82: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
83: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
84: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
85: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
78: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
79: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
80: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
81: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
82: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
83: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
84: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
85: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
86: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
79: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
80: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
81: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
82: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
83: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
84: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
85: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
86: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
87: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
80: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
81: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
82: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
83: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
84: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
85: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
86: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
87: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
88: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
81: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
82: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
83: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
84: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
85: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
86: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
87: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
88: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
89: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
82: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
83: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
84: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
85: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
86: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
87: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
88: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
89: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
90: X_Owner IN Varchar2
83: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
84: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
85: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
86: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
87: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
88: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
89: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
90: X_Owner IN Varchar2
91: );
84: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
85: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
86: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
87: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
88: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
89: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
90: X_Owner IN Varchar2
91: );
92:
85: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
86: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
87: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
88: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
89: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
90: X_Owner IN Varchar2
91: );
92:
93: Procedure Add_Language;
92:
93: Procedure Add_Language;
94:
95: Procedure Translate_Row (
96: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
97: X_Owner IN Varchar2 ,
98: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
99: X_Description IN Pa_Spread_Curves_Tl.Description%Type
100: );