136:
137:
138: PROCEDURE Query_Row
139: ( p_order_price_attrib_id IN NUMBER
140: , x_Header_Price_Att_Rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
141: );
142:
143: PROCEDURE Query_Rows
144: ( p_order_price_attrib_id IN NUMBER :=
144: ( p_order_price_attrib_id IN NUMBER :=
145: FND_API.G_MISS_NUM
146: , p_header_id IN NUMBER :=
147: FND_API.G_MISS_NUM
148: , x_Header_Price_Att_Tbl IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
149: );
150:
151: PROCEDURE Clear_Dependent_Attr
152: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
149: );
150:
151: PROCEDURE Clear_Dependent_Attr
152: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
153: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
154: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
155: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
156: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
157: );
150:
151: PROCEDURE Clear_Dependent_Attr
152: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
153: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
154: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
155: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
156: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
157: );
158:
151: PROCEDURE Clear_Dependent_Attr
152: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
153: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
154: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
155: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
156: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
157: );
158:
159:
152: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
153: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
154: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
155: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
156: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
157: );
158:
159:
160: -- Procedure Complete_Record
159:
160: -- Procedure Complete_Record
161:
162: PROCEDURE Complete_Record
163: ( p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
164: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
165: );
166:
167:
160: -- Procedure Complete_Record
161:
162: PROCEDURE Complete_Record
163: ( p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
164: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
165: );
166:
167:
168: -- Procedure Convert_Miss_To_Null
167:
168: -- Procedure Convert_Miss_To_Null
169:
170: PROCEDURE Convert_Miss_To_Null
171: ( p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
172: );
173:
174:
175: -- Procedure Apply_Attribute_Changes
174:
175: -- Procedure Apply_Attribute_Changes
176:
177: PROCEDURE Apply_Attribute_Changes
178: ( p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
179: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
180: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
181: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
182: );
175: -- Procedure Apply_Attribute_Changes
176:
177: PROCEDURE Apply_Attribute_Changes
178: ( p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
179: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
180: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
181: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
182: );
183:
176:
177: PROCEDURE Apply_Attribute_Changes
178: ( p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
179: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
180: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
181: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
182: );
183:
184:
177: PROCEDURE Apply_Attribute_Changes
178: ( p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
179: , p_old_Header_Price_Att_rec IN OE_Order_PUB.Header_Price_Att_Rec_Type
180: := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_REC
181: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
182: );
183:
184:
185: PROCEDURE Update_Row
182: );
183:
184:
185: PROCEDURE Update_Row
186: ( p_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
187: );
188:
189:
190: PROCEDURE Delete_Row
193: )
194: ;
195:
196: PROCEDURE Insert_Row
197: ( p_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
198: );
199:
200: PROCEDURE Lock_Row
201: ( x_return_status OUT NOCOPY VARCHAR2
199:
200: PROCEDURE Lock_Row
201: ( x_return_status OUT NOCOPY VARCHAR2
202:
203: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
204: , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
205: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
206: )
207: ;
201: ( x_return_status OUT NOCOPY VARCHAR2
202:
203: , p_x_Header_Price_Att_rec IN OUT NOCOPY OE_Order_PUB.Header_Price_Att_Rec_Type
204: , p_order_price_attrib_id IN NUMBER := FND_API.G_MISS_NUM
205: -- , x_Header_Price_Att_rec OUT OE_Order_PUB.Header_Price_Att_Rec_Type
206: )
207: ;
208:
209: PROCEDURE Lock_Rows
210: ( p_order_price_attrib_id IN NUMBER
211: := FND_API.G_MISS_NUM
212: , p_header_id IN NUMBER
213: := FND_API.G_MISS_NUM
214: , x_Header_Price_Att_tbl OUT NOCOPY OE_Order_PUB.Header_Price_Att_Tbl_Type
215: , x_return_status OUT NOCOPY VARCHAR2
216:
217: );
218: