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_PKG dependencies on PA_SPREAD_CURVES_B

Line 7: This api locks the row in Pa_Spread_Curves_B before updating

3:
4: g_module_name VARCHAR2(100) := 'pa.plsql.pa_fp_spread_curves_pkg';
5:
6: /*==================================================================
7: This api locks the row in Pa_Spread_Curves_B before updating
8: ==================================================================*/
9:
10: procedure LOCK_ROW (
11: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,

Line 11: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,

7: This api locks the row in Pa_Spread_Curves_B before updating
8: ==================================================================*/
9:
10: procedure LOCK_ROW (
11: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
12: p_RECORD_VERSION_NUMBER IN pa_spread_curves_b.RECORD_VERSION_NUMBER%TYPE
13: ) is
14:
15: cursor c is

Line 12: p_RECORD_VERSION_NUMBER IN pa_spread_curves_b.RECORD_VERSION_NUMBER%TYPE

8: ==================================================================*/
9:
10: procedure LOCK_ROW (
11: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,
12: p_RECORD_VERSION_NUMBER IN pa_spread_curves_b.RECORD_VERSION_NUMBER%TYPE
13: ) is
14:
15: cursor c is
16: select RECORD_VERSION_NUMBER

Line 17: from PA_SPREAD_CURVES_B

13: ) is
14:
15: cursor c is
16: select RECORD_VERSION_NUMBER
17: from PA_SPREAD_CURVES_B
18: where SPREAD_CURVE_ID = p_spread_curve_id
19: for update of spread_curve_id nowait;
20:
21: recinfo c%rowtype;

Line 46: p_spread_curve_id in Pa_spread_curves_b.spread_curve_id%TYPE

42:
43: end LOCK_ROW;
44:
45: procedure DELETE_ROW (
46: p_spread_curve_id in Pa_spread_curves_b.spread_curve_id%TYPE
47: ) is
48: begin
49: delete from PA_SPREAD_CURVES_TL
50: where spread_curve_id = p_spread_curve_id;

Line 56: delete from PA_SPREAD_CURVES_B

52: if (sql%notfound) then
53: raise no_data_found;
54: end if;
55:
56: delete from PA_SPREAD_CURVES_B
57: where spread_curve_id = p_spread_curve_id;
58:
59: if (sql%notfound) then
60: raise no_data_found;

Line 67: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,

63:
64:
65: Procedure Insert_Row (
66: X_Rowid IN OUT NOCOPY Rowid, --File.Sql.39 bug 4440895
67: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
68: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
69: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
70: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
71: X_Description IN Pa_Spread_Curves_Tl.Description%Type,

Line 68: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,

64:
65: Procedure Insert_Row (
66: X_Rowid IN OUT NOCOPY Rowid, --File.Sql.39 bug 4440895
67: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
68: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
69: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
70: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
71: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
72: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,

Line 69: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,

65: Procedure Insert_Row (
66: X_Rowid IN OUT NOCOPY Rowid, --File.Sql.39 bug 4440895
67: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
68: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
69: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
70: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
71: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
72: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
73: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,

Line 72: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,

68: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
69: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
70: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
71: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
72: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
73: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
74: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
75: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
76: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,

Line 73: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,

69: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
70: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
71: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
72: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
73: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
74: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
75: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
76: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
77: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,

Line 74: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,

70: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
71: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
72: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
73: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
74: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
75: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
76: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
77: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
78: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,

Line 75: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,

71: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
72: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
73: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
74: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
75: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
76: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
77: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
78: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
79: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,

Line 76: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,

72: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
73: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
74: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
75: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
76: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
77: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
78: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
79: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
80: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,

Line 77: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,

73: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
74: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
75: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
76: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
77: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
78: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
79: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
80: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
81: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,

Line 78: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,

74: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
75: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
76: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
77: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
78: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
79: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
80: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
81: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
82: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,

Line 79: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,

75: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
76: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
77: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
78: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
79: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
80: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
81: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
82: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
83: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,

Line 80: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,

76: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
77: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
78: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
79: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
80: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
81: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
82: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
83: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
84: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,

Line 81: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,

77: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
78: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
79: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
80: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
81: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
82: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
83: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
84: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
85: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,

Line 82: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,

78: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
79: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
80: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
81: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
82: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
83: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
84: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
85: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
86: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,

Line 83: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,

79: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
80: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
81: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
82: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
83: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
84: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
85: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
86: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
87: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,

Line 84: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,

80: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
81: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
82: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
83: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
84: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
85: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
86: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
87: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,
88: X_Created_By IN Pa_Spread_Curves_B.Created_By%Type,

Line 85: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,

81: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
82: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
83: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
84: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
85: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
86: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
87: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,
88: X_Created_By IN Pa_Spread_Curves_B.Created_By%Type,
89: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,

Line 86: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,

82: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
83: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
84: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
85: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
86: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
87: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,
88: X_Created_By IN Pa_Spread_Curves_B.Created_By%Type,
89: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
90: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895

Line 87: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,

83: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
84: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
85: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
86: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
87: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,
88: X_Created_By IN Pa_Spread_Curves_B.Created_By%Type,
89: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
90: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
91: X_Msg_Data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895

Line 88: X_Created_By IN Pa_Spread_Curves_B.Created_By%Type,

84: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
85: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
86: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
87: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,
88: X_Created_By IN Pa_Spread_Curves_B.Created_By%Type,
89: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
90: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
91: X_Msg_Data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
92: X_Msg_Count OUT NOCOPY Number --File.Sql.39 bug 4440895

Line 89: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,

85: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
86: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
87: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%Type,
88: X_Created_By IN Pa_Spread_Curves_B.Created_By%Type,
89: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
90: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
91: X_Msg_Data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
92: X_Msg_Count OUT NOCOPY Number --File.Sql.39 bug 4440895
93: )is

Line 95: l_spread_curve_id pa_spread_curves_b.SPREAD_CURVE_ID%type;

91: X_Msg_Data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
92: X_Msg_Count OUT NOCOPY Number --File.Sql.39 bug 4440895
93: )is
94:
95: l_spread_curve_id pa_spread_curves_b.SPREAD_CURVE_ID%type;
96:
97: cursor C is select ROWID from pa_spread_curves_b
98: where SPREAD_CURVE_ID = l_spread_curve_id;
99:

Line 97: cursor C is select ROWID from pa_spread_curves_b

93: )is
94:
95: l_spread_curve_id pa_spread_curves_b.SPREAD_CURVE_ID%type;
96:
97: cursor C is select ROWID from pa_spread_curves_b
98: where SPREAD_CURVE_ID = l_spread_curve_id;
99:
100: l_return_status VARCHAR2(1) := NULL;
101: l_msg_count NUMBER := 0;

Line 123: pa_debug.g_err_stage:= 'Inserting record in Pa_Spread_Curves_B'||to_char(l_spread_Curve_id);

119: into l_spread_curve_id
120: from dual;
121:
122: IF l_debug_mode = 'Y' THEN
123: pa_debug.g_err_stage:= 'Inserting record in Pa_Spread_Curves_B'||to_char(l_spread_Curve_id);
124: pa_debug.write(g_module_name,pa_debug.g_err_stage,
125: pa_fp_constants_pkg.g_debug_level3);
126: END IF;
127:

Line 128: INSERT INTO Pa_Spread_Curves_B

124: pa_debug.write(g_module_name,pa_debug.g_err_stage,
125: pa_fp_constants_pkg.g_debug_level3);
126: END IF;
127:
128: INSERT INTO Pa_Spread_Curves_B
129: (
130: Spread_Curve_Id ,
131: Spread_Curve_Code ,
132: Record_Version_Number ,

Line 277: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,

273: END Insert_Row;
274:
275:
276: Procedure Update_Row (
277: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
278: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
279: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
280: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
281: X_Description IN Pa_Spread_Curves_Tl.Description%Type,

Line 278: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,

274:
275:
276: Procedure Update_Row (
277: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
278: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
279: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
280: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
281: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
282: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,

Line 279: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,

275:
276: Procedure Update_Row (
277: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
278: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
279: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
280: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
281: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
282: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
283: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,

Line 282: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,

278: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
279: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
280: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
281: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
282: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
283: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
284: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
285: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
286: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,

Line 283: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,

279: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
280: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
281: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
282: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
283: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
284: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
285: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
286: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
287: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,

Line 284: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,

280: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
281: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
282: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
283: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
284: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
285: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
286: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
287: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
288: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,

Line 285: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,

281: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
282: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
283: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
284: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
285: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
286: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
287: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
288: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
289: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,

Line 286: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,

282: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
283: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
284: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
285: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
286: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
287: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
288: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
289: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
290: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,

Line 287: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,

283: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
284: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
285: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
286: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
287: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
288: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
289: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
290: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
291: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,

Line 288: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,

284: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
285: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
286: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
287: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
288: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
289: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
290: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
291: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
292: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,

Line 289: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,

285: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
286: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
287: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
288: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
289: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
290: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
291: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
292: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
293: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,

Line 290: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,

286: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
287: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
288: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
289: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
290: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
291: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
292: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
293: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
294: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,

Line 291: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,

287: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
288: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
289: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
290: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
291: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
292: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
293: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
294: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
295: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,

Line 292: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,

288: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
289: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
290: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
291: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
292: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
293: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
294: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
295: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
296: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,

Line 293: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,

289: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
290: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
291: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
292: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
293: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
294: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
295: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
296: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
297: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,

Line 294: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,

290: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
291: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
292: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
293: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
294: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
295: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
296: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
297: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
298: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895

Line 295: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,

291: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
292: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
293: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
294: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
295: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
296: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
297: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
298: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
299: X_Msg_Data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895

Line 296: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,

292: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
293: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
294: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
295: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
296: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
297: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
298: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
299: X_Msg_Data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
300: X_Msg_Count OUT NOCOPY Number --File.Sql.39 bug 4440895

Line 297: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,

293: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
294: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
295: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%Type,
296: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%Type,
297: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%Type,
298: X_Return_Status OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
299: X_Msg_Data OUT NOCOPY Varchar2, --File.Sql.39 bug 4440895
300: X_Msg_Count OUT NOCOPY Number --File.Sql.39 bug 4440895
301: ) IS

Line 322: pa_debug.g_err_stage:= 'Updating Pa_Spread_Curves_B for'||to_char(X_spread_Curve_id);

318: p_debug_mode => l_debug_mode );
319: END IF;
320:
321: IF l_debug_mode = 'Y' THEN
322: pa_debug.g_err_stage:= 'Updating Pa_Spread_Curves_B for'||to_char(X_spread_Curve_id);
323: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
324: END IF;
325:
326: UPDATE Pa_Spread_Curves_B

Line 326: UPDATE Pa_Spread_Curves_B

322: pa_debug.g_err_stage:= 'Updating Pa_Spread_Curves_B for'||to_char(X_spread_Curve_id);
323: pa_debug.write(g_module_name,pa_debug.g_err_stage,pa_fp_constants_pkg.g_debug_level3);
324: END IF;
325:
326: UPDATE Pa_Spread_Curves_B
327: SET Spread_Curve_Code = X_Spread_Curve_Code,
328: Effective_Start_Date = X_Effective_Start_Date,
329: Effective_End_Date = X_Effective_End_Date,
330: Record_Version_Number = Record_Version_Number + 1,

Line 349: pa_debug.g_err_stage:= 'NDF while updating Pa_Spread_Curves_B'||to_char(X_spread_Curve_id);

345: Where Spread_Curve_Id = X_Spread_Curve_Id;
346:
347: IF (SQL%NOTFOUND) THEN
348: IF l_debug_mode = 'Y' THEN
349: pa_debug.g_err_stage:= 'NDF while updating Pa_Spread_Curves_B'||to_char(X_spread_Curve_id);
350: pa_debug.write(g_module_name,pa_debug.g_err_stage, pa_fp_constants_pkg.g_debug_level5);
351: END IF;
352: RAISE NO_DATA_FOUND;
353: END IF;

Line 426: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,

422: RAISE;
423: END Update_Row;
424:
425: Procedure Load_Row (
426: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
427: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
428: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
429: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
430: X_Description IN Pa_Spread_Curves_Tl.Description%Type,

Line 427: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,

423: END Update_Row;
424:
425: Procedure Load_Row (
426: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
427: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
428: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
429: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
430: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
431: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,

Line 428: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,

424:
425: Procedure Load_Row (
426: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,
427: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
428: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
429: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
430: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
431: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
432: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,

Line 431: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,

427: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%Type,
428: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
429: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
430: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
431: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
432: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
433: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
434: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
435: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,

Line 432: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,

428: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%Type,
429: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
430: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
431: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
432: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
433: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
434: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
435: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
436: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,

Line 433: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,

429: X_Name IN Pa_Spread_Curves_Tl.Name%Type,
430: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
431: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
432: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
433: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
434: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
435: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
436: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
437: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,

Line 434: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,

430: X_Description IN Pa_Spread_Curves_Tl.Description%Type,
431: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
432: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
433: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
434: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
435: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
436: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
437: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
438: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,

Line 435: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,

431: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_Date%Type,
432: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
433: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
434: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
435: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
436: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
437: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
438: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
439: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,

Line 436: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,

432: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%Type,
433: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
434: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
435: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
436: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
437: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
438: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
439: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
440: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,

Line 437: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,

433: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%Type,
434: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
435: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
436: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
437: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
438: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
439: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
440: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
441: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,

Line 438: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,

434: X_Point1 IN Pa_Spread_Curves_B.Point1%Type,
435: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
436: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
437: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
438: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
439: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
440: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
441: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
442: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,

Line 439: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,

435: X_Point2 IN Pa_Spread_Curves_B.Point2%Type,
436: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
437: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
438: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
439: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
440: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
441: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
442: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
443: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,

Line 440: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,

436: X_Point3 IN Pa_Spread_Curves_B.Point3%Type,
437: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
438: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
439: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
440: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
441: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
442: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
443: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
444: X_Owner IN Varchar2

Line 441: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,

437: X_Point4 IN Pa_Spread_Curves_B.Point4%Type,
438: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
439: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
440: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
441: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
442: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
443: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
444: X_Owner IN Varchar2
445: )

Line 442: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,

438: X_Point5 IN Pa_Spread_Curves_B.Point5%Type,
439: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
440: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
441: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
442: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
443: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
444: X_Owner IN Varchar2
445: )
446: IS

Line 443: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,

439: X_Point6 IN Pa_Spread_Curves_B.Point6%Type,
440: X_Point7 IN Pa_Spread_Curves_B.Point7%Type,
441: X_Point8 IN Pa_Spread_Curves_B.Point8%Type,
442: X_Point9 IN Pa_Spread_Curves_B.Point9%Type,
443: X_Point10 IN Pa_Spread_Curves_B.Point10%Type,
444: X_Owner IN Varchar2
445: )
446: IS
447:

Line 552: from PA_SPREAD_CURVES_B B

548:
549: delete from PA_SPREAD_CURVES_TL T
550: where not exists
551: (select NULL
552: from PA_SPREAD_CURVES_B B
553: where B.SPREAD_CURVE_ID = T.SPREAD_CURVE_ID
554: );
555:
556: update PA_SPREAD_CURVES_TL T set (

Line 614: X_SPREAD_CURVE_ID in PA_SPREAD_CURVES_B.SPREAD_CURVE_ID%TYPE,

610: end ADD_LANGUAGE;
611:
612:
613: procedure TRANSLATE_ROW (
614: X_SPREAD_CURVE_ID in PA_SPREAD_CURVES_B.SPREAD_CURVE_ID%TYPE,
615: X_OWNER in VARCHAR2 ,
616: X_NAME in PA_SPREAD_CURVES_TL.NAME%TYPE,
617: X_DESCRIPTION in PA_SPREAD_CURVES_TL.DESCRIPTION%TYPE
618: )is