DBA Data[Home] [Help]

APPS.OE_LINE_ADJ_UTIL dependencies on OE_ORDER_PUB

Line 131: ( p_LINE_ADJ_rec IN OE_Order_PUB.LINE_ADJ_Rec_Type

127: FUNCTION G_MISS_OE_AK_LINE_ADJ_REC
128: RETURN OE_AK_LINE_PRCADJS_V%ROWTYPE;
129:
130: PROCEDURE API_Rec_To_Rowtype_Rec
131: ( p_LINE_ADJ_rec IN OE_Order_PUB.LINE_ADJ_Rec_Type
132: , x_rowtype_rec OUT nocopy OE_AK_LINE_PRCADJS_V%ROWTYPE
133: );
134:
135: PROCEDURE Rowtype_Rec_To_API_Rec

Line 137: , x_api_rec IN OUT nocopy OE_Order_PUB.LINE_ADJ_Rec_Type

133: );
134:
135: PROCEDURE Rowtype_Rec_To_API_Rec
136: ( p_record IN OE_AK_LINE_PRCADJS_V%ROWTYPE
137: , x_api_rec IN OUT nocopy OE_Order_PUB.LINE_ADJ_Rec_Type
138: );
139:
140:
141: -- Procedure Clear_Dependent_Attr: Overloaded for VIEW%ROWTYPE parameters

Line 155: , p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type

151: -- Procedure Clear_Dependent_Attr
152:
153: PROCEDURE Clear_Dependent_Attr
154: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
155: , p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
156: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
157: OE_Order_PUB.G_MISS_LINE_ADJ_REC
158: );
159:

Line 156: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=

152:
153: PROCEDURE Clear_Dependent_Attr
154: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
155: , p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
156: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
157: OE_Order_PUB.G_MISS_LINE_ADJ_REC
158: );
159:
160: -- Procedure Apply_Attribute_Changes

Line 157: OE_Order_PUB.G_MISS_LINE_ADJ_REC

153: PROCEDURE Clear_Dependent_Attr
154: ( p_attr_id IN NUMBER := FND_API.G_MISS_NUM
155: , p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
156: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
157: OE_Order_PUB.G_MISS_LINE_ADJ_REC
158: );
159:
160: -- Procedure Apply_Attribute_Changes
161:

Line 163: ( p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type

159:
160: -- Procedure Apply_Attribute_Changes
161:
162: PROCEDURE Apply_Attribute_Changes
163: ( p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
164: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
165: OE_Order_PUB.G_MISS_LINE_ADJ_REC
166: --, x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
167: );

Line 164: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=

160: -- Procedure Apply_Attribute_Changes
161:
162: PROCEDURE Apply_Attribute_Changes
163: ( p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
164: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
165: OE_Order_PUB.G_MISS_LINE_ADJ_REC
166: --, x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
167: );
168:

Line 165: OE_Order_PUB.G_MISS_LINE_ADJ_REC

161:
162: PROCEDURE Apply_Attribute_Changes
163: ( p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
164: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
165: OE_Order_PUB.G_MISS_LINE_ADJ_REC
166: --, x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
167: );
168:
169: -- Procedure Complete_Record

Line 166: --, x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type

162: PROCEDURE Apply_Attribute_Changes
163: ( p_x_Line_Adj_rec IN out nocopy OE_Order_PUB.Line_Adj_Rec_Type
164: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
165: OE_Order_PUB.G_MISS_LINE_ADJ_REC
166: --, x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
167: );
168:
169: -- Procedure Complete_Record
170:

Line 172: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

168:
169: -- Procedure Complete_Record
170:
171: PROCEDURE Complete_Record
172: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
173: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
174: );
175:
176: -- Procedure Convert_Miss_To_Null

Line 173: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type

169: -- Procedure Complete_Record
170:
171: PROCEDURE Complete_Record
172: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
173: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
174: );
175:
176: -- Procedure Convert_Miss_To_Null
177:

Line 179: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

175:
176: -- Procedure Convert_Miss_To_Null
177:
178: PROCEDURE Convert_Miss_To_Null
179: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
180: );
181:
182: -- Procedure Update_Row
183:

Line 185: ( p_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

181:
182: -- Procedure Update_Row
183:
184: PROCEDURE Update_Row
185: ( p_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
186: );
187:
188: -- Procedure Insert_Row
189:

Line 191: ( p_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

187:
188: -- Procedure Insert_Row
189:
190: PROCEDURE Insert_Row
191: ( p_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
192: );
193:
194: -- Procedure Delete_Row
195:

Line 207: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

203: -- Procedure Query_Row
204:
205: PROCEDURE Query_Row
206: ( p_price_adjustment_id IN NUMBER
207: , x_Line_Adj_Rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
208: );
209:
210: -- Procedure Query_Rows
211:

Line 221: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type

217: , p_Header_id IN NUMBER :=
218: FND_API.G_MISS_NUM
219: , p_Line_Level_Header_id IN NUMBER :=
220: FND_API.G_MISS_NUM
221: , x_Line_Adj_Tbl IN OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
222: );
223:
224: -- Procedure lock_Row
225:

Line 229: , p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

225:
226: PROCEDURE Lock_Row
227: ( x_return_status OUT NOCOPY VARCHAR2
228:
229: , p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
230: , p_price_adjustment_id IN NUMBER
231: := FND_API.G_MISS_NUM
232: -- , x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
233: );

Line 232: -- , x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type

228:
229: , p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
230: , p_price_adjustment_id IN NUMBER
231: := FND_API.G_MISS_NUM
232: -- , x_Line_Adj_rec OUT OE_Order_PUB.Line_Adj_Rec_Type
233: );
234:
235: -- Procedure lock_Rows
236: PROCEDURE Lock_Rows

Line 241: , x_Line_Adj_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type

237: ( p_price_adjustment_id IN NUMBER
238: := FND_API.G_MISS_NUM
239: , p_line_id IN NUMBER
240: := FND_API.G_MISS_NUM
241: , x_Line_Adj_tbl OUT NOCOPY OE_Order_PUB.Line_Adj_Tbl_Type
242: , x_return_status OUT NOCOPY VARCHAR2
243:
244: );
245:

Line 250: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type

246:
247: -- Function Get_Values
248:
249: FUNCTION Get_Values
250: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
251: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
252: OE_Order_PUB.G_MISS_LINE_ADJ_REC
253: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type;
254:

Line 251: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=

247: -- Function Get_Values
248:
249: FUNCTION Get_Values
250: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
251: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
252: OE_Order_PUB.G_MISS_LINE_ADJ_REC
253: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type;
254:
255: -- Procedure Get_Ids

Line 252: OE_Order_PUB.G_MISS_LINE_ADJ_REC

248:
249: FUNCTION Get_Values
250: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
251: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
252: OE_Order_PUB.G_MISS_LINE_ADJ_REC
253: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type;
254:
255: -- Procedure Get_Ids
256:

Line 253: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type;

249: FUNCTION Get_Values
250: ( p_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type
251: , p_old_Line_Adj_rec IN OE_Order_PUB.Line_Adj_Rec_Type :=
252: OE_Order_PUB.G_MISS_LINE_ADJ_REC
253: ) RETURN OE_Order_PUB.Line_Adj_Val_Rec_Type;
254:
255: -- Procedure Get_Ids
256:
257: PROCEDURE Get_Ids

Line 258: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type

254:
255: -- Procedure Get_Ids
256:
257: PROCEDURE Get_Ids
258: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
259: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type
260: );
261:
262:

Line 259: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type

255: -- Procedure Get_Ids
256:
257: PROCEDURE Get_Ids
258: ( p_x_Line_Adj_rec IN OUT NOCOPY OE_Order_PUB.Line_Adj_Rec_Type
259: , p_Line_Adj_val_rec IN OE_Order_PUB.Line_Adj_Val_Rec_Type
260: );
261:
262:
263: PROCEDURE Log_Adj_Requests

Line 266: , p_adj_rec IN OE_order_pub.line_adj_rec_type

262:
263: PROCEDURE Log_Adj_Requests
264: ( x_return_status OUT NOCOPY VARCHAR2
265:
266: , p_adj_rec IN OE_order_pub.line_adj_rec_type
267: , p_old_adj_rec IN OE_order_pub.line_Adj_Rec_Type
268: , p_delete_flag IN BOOLEAN DEFAULT FALSE
269: );
270:

Line 267: , p_old_adj_rec IN OE_order_pub.line_Adj_Rec_Type

263: PROCEDURE Log_Adj_Requests
264: ( x_return_status OUT NOCOPY VARCHAR2
265:
266: , p_adj_rec IN OE_order_pub.line_adj_rec_type
267: , p_old_adj_rec IN OE_order_pub.line_Adj_Rec_Type
268: , p_delete_flag IN BOOLEAN DEFAULT FALSE
269: );
270:
271: FUNCTION Convert_Hdr_Adj_To_Line_Adj

Line 272: ( p_header_adj_rec IN OE_Order_PUB.Header_adj_rec_type

268: , p_delete_flag IN BOOLEAN DEFAULT FALSE
269: );
270:
271: FUNCTION Convert_Hdr_Adj_To_Line_Adj
272: ( p_header_adj_rec IN OE_Order_PUB.Header_adj_rec_type
273: )RETURN OE_Order_PUB.Line_Adj_Rec_Type;
274:
275: Procedure copy_adjustment_lines(
276: p_from_line_id number

Line 273: )RETURN OE_Order_PUB.Line_Adj_Rec_Type;

269: );
270:
271: FUNCTION Convert_Hdr_Adj_To_Line_Adj
272: ( p_header_adj_rec IN OE_Order_PUB.Header_adj_rec_type
273: )RETURN OE_Order_PUB.Line_Adj_Rec_Type;
274:
275: Procedure copy_adjustment_lines(
276: p_from_line_id number
277: ,p_to_line_id number

Line 292: ( p_x_line_adj_rec IN OUT NOCOPY OE_ORDER_PUB.line_adj_rec_type,

288:
289: );
290:
291: PROCEDURE Pre_Write_Process
292: ( p_x_line_adj_rec IN OUT NOCOPY OE_ORDER_PUB.line_adj_rec_type,
293:
294: p_old_line_adj_rec IN OE_ORDER_PUB.line_adj_rec_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC);
295:
296:

Line 294: p_old_line_adj_rec IN OE_ORDER_PUB.line_adj_rec_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC);

290:
291: PROCEDURE Pre_Write_Process
292: ( p_x_line_adj_rec IN OUT NOCOPY OE_ORDER_PUB.line_adj_rec_type,
293:
294: p_old_line_adj_rec IN OE_ORDER_PUB.line_adj_rec_type := OE_ORDER_PUB.G_MISS_LINE_ADJ_REC);
295:
296:
297: Procedure Delete_Prg_Lines(p_line_id In Number, p_operation In Varchar2);
298:

Line 299: Procedure Check_Canceled_PRG(p_old_line_rec in Oe_Order_Pub.line_rec_type,

295:
296:
297: Procedure Delete_Prg_Lines(p_line_id In Number, p_operation In Varchar2);
298:
299: Procedure Check_Canceled_PRG(p_old_line_rec in Oe_Order_Pub.line_rec_type,
300: p_new_line_rec in Oe_Order_Pub.line_rec_type);
301:
302: Procedure Process_Pricing(p_x_new_line_rec in out nocopy Oe_Order_Pub.line_rec_type,
303: p_old_line_rec in Oe_Order_Pub.line_rec_type,

Line 300: p_new_line_rec in Oe_Order_Pub.line_rec_type);

296:
297: Procedure Delete_Prg_Lines(p_line_id In Number, p_operation In Varchar2);
298:
299: Procedure Check_Canceled_PRG(p_old_line_rec in Oe_Order_Pub.line_rec_type,
300: p_new_line_rec in Oe_Order_Pub.line_rec_type);
301:
302: Procedure Process_Pricing(p_x_new_line_rec in out nocopy Oe_Order_Pub.line_rec_type,
303: p_old_line_rec in Oe_Order_Pub.line_rec_type,
304: p_no_price_flag in Boolean);

Line 302: Procedure Process_Pricing(p_x_new_line_rec in out nocopy Oe_Order_Pub.line_rec_type,

298:
299: Procedure Check_Canceled_PRG(p_old_line_rec in Oe_Order_Pub.line_rec_type,
300: p_new_line_rec in Oe_Order_Pub.line_rec_type);
301:
302: Procedure Process_Pricing(p_x_new_line_rec in out nocopy Oe_Order_Pub.line_rec_type,
303: p_old_line_rec in Oe_Order_Pub.line_rec_type,
304: p_no_price_flag in Boolean);
305:
306: Procedure Delete_Changed_Lines_Tbl;

Line 303: p_old_line_rec in Oe_Order_Pub.line_rec_type,

299: Procedure Check_Canceled_PRG(p_old_line_rec in Oe_Order_Pub.line_rec_type,
300: p_new_line_rec in Oe_Order_Pub.line_rec_type);
301:
302: Procedure Process_Pricing(p_x_new_line_rec in out nocopy Oe_Order_Pub.line_rec_type,
303: p_old_line_rec in Oe_Order_Pub.line_rec_type,
304: p_no_price_flag in Boolean);
305:
306: Procedure Delete_Changed_Lines_Tbl;
307:

Line 316: Procedure Change_adj_for_uom_change(p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

312: Procedure Get_Service_Lines(p_header_id IN NUMBER,
313: x_line_id_tbl OUT NOCOPY OE_ORDER_ADJ_PVT.Index_TBl_Type);
314:
315: /* Added the following procedure to fix the bug 2917690 */
316: Procedure Change_adj_for_uom_change(p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
317: ) ;
318:
319: Function has_service_lines(p_header_id IN NUMBER) Return Boolean;
320:

Line 338: Function Is_Pricing_Related_Change(p_new_line_rec In Oe_Order_Pub.Line_Rec_Type,

334: G_BINARY_LIMIT CONSTANT NUMBER := OE_GLOBALS.G_BINARY_LIMIT; -- Added for bug 8631297
335: Procedure Set_PRG_Cache(p_header_id IN NUMBER);
336: Function Is_PRG_LINE(p_line_id IN NUMBER) RETURN BOOLEAN;
337: Procedure Reset_PRG_Cache;
338: Function Is_Pricing_Related_Change(p_new_line_rec In Oe_Order_Pub.Line_Rec_Type,
339: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type) Return Boolean;
340: END OE_Line_Adj_Util;

Line 339: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type) Return Boolean;

335: Procedure Set_PRG_Cache(p_header_id IN NUMBER);
336: Function Is_PRG_LINE(p_line_id IN NUMBER) RETURN BOOLEAN;
337: Procedure Reset_PRG_Cache;
338: Function Is_Pricing_Related_Change(p_new_line_rec In Oe_Order_Pub.Line_Rec_Type,
339: p_old_line_rec In Oe_Order_Pub.Line_Rec_Type) Return Boolean;
340: END OE_Line_Adj_Util;