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 (
10 p_spread_curve_id in Pa_spread_curves_b.spread_curve_id%TYPE
11 );
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,
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,
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,
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 );
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,
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,
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 );
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,
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,
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;
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 );
101
102 end PA_FP_SPREAD_CURVES_PKG;