DBA Data[Home] [Help]

APPS.QP_QUALIFIERS_UTIL dependencies on QP_QUALIFIER_RULES_PUB

Line 56: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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

Line 57: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=

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:

Line 58: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC

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

Line 59: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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:

Line 65: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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

Line 66: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=

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:

Line 67: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC

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

Line 68: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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:

Line 74: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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

Line 75: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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:

Line 76: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

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

Line 81: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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:

Line 82: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

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

Line 87: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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:

Line 93: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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

Line 100: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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

Line 149: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type;

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

Line 160: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Tbl_Type;

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:

Line 167: , p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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

Line 168: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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:

Line 174: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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:

Line 175: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type :=

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

Line 176: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC

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:

Line 177: ) RETURN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type;

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

Line 182: ( p_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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

Line 183: , p_QUALIFIERS_val_rec IN QP_Qualifier_Rules_PUB.Qualifiers_Val_Rec_Type

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

Line 184: ) RETURN 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 :=

Line 187: ( 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 :=
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: );

Line 188: , p_old_QUALIFIERS_rec IN QP_Qualifier_Rules_PUB.Qualifiers_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: );
192:

Line 189: QP_Qualifier_Rules_PUB.G_MISS_QUALIFIERS_REC

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;

Line 190: , x_QUALIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Qualifier_Rules_PUB.Qualifiers_Rec_Type

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;