35: -- Procedure Clear_Dependent_Attr
36:
37: PROCEDURE Clear_Dependent_Attr
38: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
39: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
40: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
41: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
42: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
43: );
36:
37: PROCEDURE Clear_Dependent_Attr
38: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
39: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
40: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
41: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
42: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
43: );
44:
37: PROCEDURE Clear_Dependent_Attr
38: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
39: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
40: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
41: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
42: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
43: );
44:
45: -- Procedure Apply_Attribute_Changes
38: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
39: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
40: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
41: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
42: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
43: );
44:
45: -- Procedure Apply_Attribute_Changes
46:
44:
45: -- Procedure Apply_Attribute_Changes
46:
47: PROCEDURE Apply_Attribute_Changes
48: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
49: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
50: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
51: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
52: );
45: -- Procedure Apply_Attribute_Changes
46:
47: PROCEDURE Apply_Attribute_Changes
48: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
49: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
50: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
51: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
52: );
53:
46:
47: PROCEDURE Apply_Attribute_Changes
48: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
49: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
50: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
51: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
52: );
53:
54: -- Function Complete_Record
47: PROCEDURE Apply_Attribute_Changes
48: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
49: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
50: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
51: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
52: );
53:
54: -- Function Complete_Record
55:
53:
54: -- Function Complete_Record
55:
56: FUNCTION Complete_Record
57: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
58: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
59: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
60:
61: -- Function Convert_Miss_To_Null
54: -- Function Complete_Record
55:
56: FUNCTION Complete_Record
57: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
58: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
59: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
60:
61: -- Function Convert_Miss_To_Null
62:
55:
56: FUNCTION Complete_Record
57: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
58: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
59: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
60:
61: -- Function Convert_Miss_To_Null
62:
63: FUNCTION Convert_Miss_To_Null
60:
61: -- Function Convert_Miss_To_Null
62:
63: FUNCTION Convert_Miss_To_Null
64: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
65: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
66:
67: -- Procedure Update_Row
68:
61: -- Function Convert_Miss_To_Null
62:
63: FUNCTION Convert_Miss_To_Null
64: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
65: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
66:
67: -- Procedure Update_Row
68:
69: PROCEDURE Update_Row
66:
67: -- Procedure Update_Row
68:
69: PROCEDURE Update_Row
70: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
71: );
72:
73: -- Procedure Insert_Row
74:
72:
73: -- Procedure Insert_Row
74:
75: PROCEDURE Insert_Row
76: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
77: );
78:
79: -- Procedure Delete_Row
80:
85: -- Function Query_Row
86:
87: FUNCTION Query_Row
88: ( p_price_formula_id IN NUMBER
89: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
90:
91: -- Procedure lock_Row
92: --
93:
92: --
93:
94: PROCEDURE Lock_Row
95: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
97: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
98: );
99:
100: -- Function Get_Values
93:
94: PROCEDURE Lock_Row
95: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
96: , p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
97: , x_FORMULA_rec OUT NOCOPY /* file.sql.39 change */ QP_Price_Formula_PUB.Formula_Rec_Type
98: );
99:
100: -- Function Get_Values
101:
99:
100: -- Function Get_Values
101:
102: FUNCTION Get_Values
103: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
104: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
105: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
106: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type;
107:
100: -- Function Get_Values
101:
102: FUNCTION Get_Values
103: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
104: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
105: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
106: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type;
107:
108: -- Function Get_Ids
101:
102: FUNCTION Get_Values
103: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
104: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
105: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
106: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type;
107:
108: -- Function Get_Ids
109:
102: FUNCTION Get_Values
103: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
104: , p_old_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type :=
105: QP_Price_Formula_PUB.G_MISS_FORMULA_REC
106: ) RETURN QP_Price_Formula_PUB.Formula_Val_Rec_Type;
107:
108: -- Function Get_Ids
109:
110: FUNCTION Get_Ids
107:
108: -- Function Get_Ids
109:
110: FUNCTION Get_Ids
111: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
112: , p_FORMULA_val_rec IN QP_Price_Formula_PUB.Formula_Val_Rec_Type
113: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
114:
115: END QP_Formula_Util;
108: -- Function Get_Ids
109:
110: FUNCTION Get_Ids
111: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
112: , p_FORMULA_val_rec IN QP_Price_Formula_PUB.Formula_Val_Rec_Type
113: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
114:
115: END QP_Formula_Util;
109:
110: FUNCTION Get_Ids
111: ( p_FORMULA_rec IN QP_Price_Formula_PUB.Formula_Rec_Type
112: , p_FORMULA_val_rec IN QP_Price_Formula_PUB.Formula_Val_Rec_Type
113: ) RETURN QP_Price_Formula_PUB.Formula_Rec_Type;
114:
115: END QP_Formula_Util;