100: -- Procedure Clear_Dependent_Attr
101:
102: PROCEDURE Clear_Dependent_Attr
103: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
104: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
105: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
106: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
107: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Rec_Type
108: );
101:
102: PROCEDURE Clear_Dependent_Attr
103: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
104: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
105: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
106: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
107: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Rec_Type
108: );
109:
102: PROCEDURE Clear_Dependent_Attr
103: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
104: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
105: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
106: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
107: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Rec_Type
108: );
109:
110: -- Procedure Apply_Attribute_Changes
103: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
104: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
105: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
106: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
107: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Rec_Type
108: );
109:
110: -- Procedure Apply_Attribute_Changes
111:
109:
110: -- Procedure Apply_Attribute_Changes
111:
112: PROCEDURE Apply_Attribute_Changes
113: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
114: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
115: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
116: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Rec_Type
117: );
110: -- Procedure Apply_Attribute_Changes
111:
112: PROCEDURE Apply_Attribute_Changes
113: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
114: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
115: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
116: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Rec_Type
117: );
118:
111:
112: PROCEDURE Apply_Attribute_Changes
113: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
114: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
115: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
116: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Rec_Type
117: );
118:
119: -- Function Complete_Record
112: PROCEDURE Apply_Attribute_Changes
113: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
114: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
115: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
116: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Rec_Type
117: );
118:
119: -- Function Complete_Record
120:
118:
119: -- Function Complete_Record
120:
121: FUNCTION Complete_Record
122: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
123: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
124: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
125:
126: -- Function Convert_Miss_To_Null
119: -- Function Complete_Record
120:
121: FUNCTION Complete_Record
122: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
123: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
124: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
125:
126: -- Function Convert_Miss_To_Null
127:
120:
121: FUNCTION Complete_Record
122: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
123: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
124: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
125:
126: -- Function Convert_Miss_To_Null
127:
128: FUNCTION Convert_Miss_To_Null
125:
126: -- Function Convert_Miss_To_Null
127:
128: FUNCTION Convert_Miss_To_Null
129: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
130: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
131:
132: -- Procedure Update_Row
133:
126: -- Function Convert_Miss_To_Null
127:
128: FUNCTION Convert_Miss_To_Null
129: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
130: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
131:
132: -- Procedure Update_Row
133:
134: PROCEDURE Update_Row
131:
132: -- Procedure Update_Row
133:
134: PROCEDURE Update_Row
135: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
136: );
137:
138: -- Procedure Insert_Row
139:
137:
138: -- Procedure Insert_Row
139:
140: PROCEDURE Insert_Row
141: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
142: );
143:
144: -- Procedure Delete_Row
145:
150: -- Function Query_Row
151:
152: FUNCTION Query_Row
153: ( p_list_line_id IN NUMBER
154: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
155:
156: -- Function Query_Rows
157:
158: --
161: ( p_list_line_id IN NUMBER :=
162: FND_API.G_MISS_NUM
163: , p_list_header_id IN NUMBER :=
164: FND_API.G_MISS_NUM
165: ) RETURN QP_Modifiers_PUB.Modifiers_Tbl_Type;
166:
167: -- Procedure lock_Row
168: --
169:
168: --
169:
170: PROCEDURE Lock_Row
171: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
172: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
173: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Rec_Type
174: );
175:
176: -- Function Get_Values
169:
170: PROCEDURE Lock_Row
171: ( x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
172: , p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
173: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.Modifiers_Rec_Type
174: );
175:
176: -- Function Get_Values
177:
175:
176: -- Function Get_Values
177:
178: FUNCTION Get_Values
179: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
180: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
181: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
182: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
183:
176: -- Function Get_Values
177:
178: FUNCTION Get_Values
179: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
180: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
181: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
182: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
183:
184: -- Function Get_Ids
177:
178: FUNCTION Get_Values
179: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
180: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
181: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
182: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
183:
184: -- Function Get_Ids
185:
178: FUNCTION Get_Values
179: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
180: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type :=
181: QP_Modifiers_PUB.G_MISS_MODIFIERS_REC
182: ) RETURN QP_Modifiers_PUB.Modifiers_Val_Rec_Type;
183:
184: -- Function Get_Ids
185:
186: FUNCTION Get_Ids
183:
184: -- Function Get_Ids
185:
186: FUNCTION Get_Ids
187: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
188: , p_MODIFIERS_val_rec IN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
189: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
190:
191:
184: -- Function Get_Ids
185:
186: FUNCTION Get_Ids
187: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
188: , p_MODIFIERS_val_rec IN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
189: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
190:
191:
192:
185:
186: FUNCTION Get_Ids
187: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.Modifiers_Rec_Type
188: , p_MODIFIERS_val_rec IN QP_Modifiers_PUB.Modifiers_Val_Rec_Type
189: ) RETURN QP_Modifiers_PUB.Modifiers_Rec_Type;
190:
191:
192:
193: Procedure Pre_Write_Process
190:
191:
192:
193: Procedure Pre_Write_Process
194: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
195: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
196: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
197: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.MODIFIERS_rec_Type
198: );
191:
192:
193: Procedure Pre_Write_Process
194: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
195: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
196: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
197: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.MODIFIERS_rec_Type
198: );
199: ------------------fix for bug 3756625
192:
193: Procedure Pre_Write_Process
194: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
195: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
196: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
197: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.MODIFIERS_rec_Type
198: );
199: ------------------fix for bug 3756625
200: Procedure Log_Update_Phases_DL
193: Procedure Pre_Write_Process
194: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
195: , p_old_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
196: := QP_Modifiers_PUB.G_MISS_MODIFIERS_rec
197: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.MODIFIERS_rec_Type
198: );
199: ------------------fix for bug 3756625
200: Procedure Log_Update_Phases_DL
201: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
197: , x_MODIFIERS_rec OUT NOCOPY /* file.sql.39 change */ QP_Modifiers_PUB.MODIFIERS_rec_Type
198: );
199: ------------------fix for bug 3756625
200: Procedure Log_Update_Phases_DL
201: ( p_MODIFIERS_rec IN QP_Modifiers_PUB.MODIFIERS_rec_Type
202: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
203:
204: END QP_Modifiers_Util;