DBA Data[Home] [Help]

APPS.PA_FP_SPREAD_CURVES_PKG dependencies on PA_SPREAD_CURVES_B

Line 5: p_spread_curve_id IN Pa_spread_curves_b.spread_curve_id%TYPE,

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 (

Line 6: p_RECORD_VERSION_NUMBER IN pa_spread_curves_b.RECORD_VERSION_NUMBER%TYPE

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

Line 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 (

Line 16: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,

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,

Line 17: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%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,

Line 18: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%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,

Line 21: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_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,

Line 22: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%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,

Line 23: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%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,

Line 24: X_Point1 IN Pa_Spread_Curves_B.Point1%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,

Line 25: X_Point2 IN Pa_Spread_Curves_B.Point2%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,

Line 26: X_Point3 IN Pa_Spread_Curves_B.Point3%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,

Line 27: X_Point4 IN Pa_Spread_Curves_B.Point4%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,

Line 28: X_Point5 IN Pa_Spread_Curves_B.Point5%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,

Line 29: X_Point6 IN Pa_Spread_Curves_B.Point6%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,

Line 30: X_Point7 IN Pa_Spread_Curves_B.Point7%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,

Line 31: X_Point8 IN Pa_Spread_Curves_B.Point8%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,

Line 32: X_Point9 IN Pa_Spread_Curves_B.Point9%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,

Line 33: X_Point10 IN Pa_Spread_Curves_B.Point10%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,

Line 34: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%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,

Line 35: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%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

Line 36: X_Creation_Date IN Pa_Spread_Curves_B.Creation_Date%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

Line 37: X_Created_By IN Pa_Spread_Curves_B.Created_By%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

Line 38: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%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: );

Line 45: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,

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,

Line 46: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%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,

Line 47: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%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,

Line 50: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_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,

Line 51: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%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,

Line 52: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%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,

Line 53: X_Point1 IN Pa_Spread_Curves_B.Point1%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,

Line 54: X_Point2 IN Pa_Spread_Curves_B.Point2%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,

Line 55: X_Point3 IN Pa_Spread_Curves_B.Point3%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,

Line 56: X_Point4 IN Pa_Spread_Curves_B.Point4%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,

Line 57: X_Point5 IN Pa_Spread_Curves_B.Point5%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,

Line 58: X_Point6 IN Pa_Spread_Curves_B.Point6%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,

Line 59: X_Point7 IN Pa_Spread_Curves_B.Point7%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,

Line 60: X_Point8 IN Pa_Spread_Curves_B.Point8%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,

Line 61: X_Point9 IN Pa_Spread_Curves_B.Point9%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,

Line 62: X_Point10 IN Pa_Spread_Curves_B.Point10%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

Line 63: X_Last_Update_Date IN Pa_Spread_Curves_B.Last_Update_Date%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

Line 64: X_Last_Updated_By IN Pa_Spread_Curves_B.Last_Updated_By%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

Line 65: X_Last_Update_Login IN Pa_Spread_Curves_B.Last_Update_Login%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: );

Line 72: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,

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,

Line 73: X_Spread_Curve_Code IN Pa_Spread_Curves_B.Spread_Curve_Code%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,

Line 74: X_Record_Version_Number IN Pa_Spread_Curves_B.Record_Version_Number%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,

Line 77: X_Effective_Start_Date IN Pa_Spread_Curves_B.Effective_Start_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,

Line 78: X_Effective_End_Date IN Pa_Spread_Curves_B.Effective_End_Date%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,

Line 79: X_Rounding_Factor_Code IN Pa_Spread_Curves_B.Rounding_Factor_Code%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,

Line 80: X_Point1 IN Pa_Spread_Curves_B.Point1%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,

Line 81: X_Point2 IN Pa_Spread_Curves_B.Point2%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,

Line 82: X_Point3 IN Pa_Spread_Curves_B.Point3%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,

Line 83: X_Point4 IN Pa_Spread_Curves_B.Point4%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,

Line 84: X_Point5 IN Pa_Spread_Curves_B.Point5%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,

Line 85: X_Point6 IN Pa_Spread_Curves_B.Point6%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,

Line 86: X_Point7 IN Pa_Spread_Curves_B.Point7%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

Line 87: X_Point8 IN Pa_Spread_Curves_B.Point8%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: );

Line 88: X_Point9 IN Pa_Spread_Curves_B.Point9%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:

Line 89: X_Point10 IN Pa_Spread_Curves_B.Point10%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;

Line 96: X_Spread_Curve_Id IN Pa_Spread_Curves_B.Spread_Curve_Id%Type,

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: );