52: -- Procedure Clear_Dependent_Attr
53:
54: PROCEDURE Clear_Dependent_Attr
55: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
56: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
57: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
58: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
59: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
60: );
53:
54: PROCEDURE Clear_Dependent_Attr
55: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
56: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
57: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
58: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
59: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
60: );
61:
54: PROCEDURE Clear_Dependent_Attr
55: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
56: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
57: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
58: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
59: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
60: );
61:
62: -- Procedure Apply_Attribute_Changes
55: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
56: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
57: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
58: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
59: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
60: );
61:
62: -- Procedure Apply_Attribute_Changes
63:
61:
62: -- Procedure Apply_Attribute_Changes
63:
64: PROCEDURE Apply_Attribute_Changes
65: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
66: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
67: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
68: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
69: );
62: -- Procedure Apply_Attribute_Changes
63:
64: PROCEDURE Apply_Attribute_Changes
65: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
66: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
67: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
68: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
69: );
70:
63:
64: PROCEDURE Apply_Attribute_Changes
65: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
66: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
67: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
68: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
69: );
70:
71: -- Function Complete_Record
64: PROCEDURE Apply_Attribute_Changes
65: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
66: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
67: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
68: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
69: );
70:
71: -- Function Complete_Record
72:
70:
71: -- Function Complete_Record
72:
73: FUNCTION Complete_Record
74: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
75: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
76: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
77:
78: -- Function Convert_Miss_To_Null
71: -- Function Complete_Record
72:
73: FUNCTION Complete_Record
74: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
75: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
76: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
77:
78: -- Function Convert_Miss_To_Null
79:
72:
73: FUNCTION Complete_Record
74: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
75: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
76: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
77:
78: -- Function Convert_Miss_To_Null
79:
80: FUNCTION Convert_Miss_To_Null
77:
78: -- Function Convert_Miss_To_Null
79:
80: FUNCTION Convert_Miss_To_Null
81: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
82: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
83:
84: -- Procedure Update_Row
85:
78: -- Function Convert_Miss_To_Null
79:
80: FUNCTION Convert_Miss_To_Null
81: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
82: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
83:
84: -- Procedure Update_Row
85:
86: PROCEDURE Update_Row
83:
84: -- Procedure Update_Row
85:
86: PROCEDURE Update_Row
87: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
88: );
89:
90: -- Procedure Update_coupon_Row Added for bug 7315016
91:
89:
90: -- Procedure Update_coupon_Row Added for bug 7315016
91:
92: PROCEDURE Update_coupon_Row
93: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
94: );
95:
96:
97: -- Procedure Insert_Row
96:
97: -- Procedure Insert_Row
98:
99: PROCEDURE Insert_Row
100: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
101: );
102:
103: --This procedure will be used by HTML Qualifier UI
104: --to insert qualifiers into dummy table for updates
145: -- Function Query_Row
146:
147: FUNCTION Query_Row
148: ( p_qualifier_id IN NUMBER
149: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
150:
151: -- Function Query_Rows
152:
153: --
156: ( p_qualifier_id IN NUMBER :=
157: FND_API.G_MISS_NUM
158: , p_qualifier_rule_id IN NUMBER :=
159: FND_API.G_MISS_NUM
160: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;
161:
162: -- Procedure lock_Row
163: --
164:
163: --
164:
165: PROCEDURE Lock_Row
166: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
167: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
168: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
169: );
170:
171: -- Function Get_Values
164:
165: PROCEDURE Lock_Row
166: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
167: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
168: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
169: );
170:
171: -- Function Get_Values
172:
170:
171: -- Function Get_Values
172:
173: FUNCTION Get_Values
174: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
175: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
176: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
177: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
178:
171: -- Function Get_Values
172:
173: FUNCTION Get_Values
174: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
175: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
176: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
177: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
178:
179: -- Function Get_Ids
172:
173: FUNCTION Get_Values
174: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
175: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
176: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
177: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
178:
179: -- Function Get_Ids
180:
173: FUNCTION Get_Values
174: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
175: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
176: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
177: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;
178:
179: -- Function Get_Ids
180:
181: FUNCTION Get_Ids
178:
179: -- Function Get_Ids
180:
181: FUNCTION Get_Ids
182: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
183: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
184: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
185:
186: Procedure Pre_Write_Process
179: -- Function Get_Ids
180:
181: FUNCTION Get_Ids
182: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
183: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
184: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
185:
186: Procedure Pre_Write_Process
187: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
180:
181: FUNCTION Get_Ids
182: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
183: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
184: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
185:
186: Procedure Pre_Write_Process
187: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
188: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
183: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type
184: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
185:
186: Procedure Pre_Write_Process
187: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
188: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
189: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
190: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
191: );
184: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;
185:
186: Procedure Pre_Write_Process
187: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
188: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
189: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
190: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
191: );
192:
185:
186: Procedure Pre_Write_Process
187: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
188: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
189: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
190: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
191: );
192:
193: END QP_Qualifiers_Util;
186: Procedure Pre_Write_Process
187: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
188: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=
189: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC
190: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type
191: );
192:
193: END QP_Qualifiers_Util;