eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_CONFIG_UTIL dependencies on OE_ORDER_PUB

Line 33: FUNCTION Config_Exists(p_line_rec IN OE_ORDER_PUB.line_rec_type)

29: G_FREEZE_METHOD VARCHAR2(30) := FND_PROFILE.VALUE('ONT_INCLUDED_ITEM_FREEZE_METHOD');
30: G_COPY_MODEL_DFF VARCHAR2(30) := nvl(FND_PROFILE.VALUE('ONT_COPY_MODEL_DFF'),'N');
31: /* Bug # 5036404 End */
32:
33: FUNCTION Config_Exists(p_line_rec IN OE_ORDER_PUB.line_rec_type)
34: RETURN BOOLEAN;
35:
36: Procedure Complete_Config
37: ( p_top_model_line_id IN NUMBER

Line 42: p_request_rec IN OE_Order_Pub.Request_Rec_Type,

38: , x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
39:
40: Procedure Cascade_Changes
41: ( p_parent_line_id IN NUMBER,
42: p_request_rec IN OE_Order_Pub.Request_Rec_Type,
43: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
44: );
45:
46:

Line 48: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type,

44: );
45:
46:
47: Procedure Change_Configuration
48: ( p_request_rec IN OE_Order_Pub.Request_Rec_Type,
49: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2
50: );
51:
52: Procedure Query_Config_Line

Line 54: ,x_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type);

50: );
51:
52: Procedure Query_Config_Line
53: (p_parent_line_id IN NUMBER
54: ,x_line_rec OUT NOCOPY OE_ORDER_PUB.line_rec_type);
55:
56: FUNCTION Validate_Cfgs_In_Order(p_header_id IN NUMBER)
57: RETURN VARCHAR2;
58:

Line 61: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

57: RETURN VARCHAR2;
58:
59: PROCEDURE Validate_Configuration
60: (p_model_line_id IN NUMBER,
61: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
62: := OE_Order_Pub.G_MISS_REQUEST_TBL,
63: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
64: := OE_Order_Pub.G_MISS_REQUEST_TBL,
65: p_validate_flag IN VARCHAR2 := 'Y',

Line 62: := OE_Order_Pub.G_MISS_REQUEST_TBL,

58:
59: PROCEDURE Validate_Configuration
60: (p_model_line_id IN NUMBER,
61: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
62: := OE_Order_Pub.G_MISS_REQUEST_TBL,
63: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
64: := OE_Order_Pub.G_MISS_REQUEST_TBL,
65: p_validate_flag IN VARCHAR2 := 'Y',
66: p_complete_flag IN VARCHAR2 := 'Y',

Line 63: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

59: PROCEDURE Validate_Configuration
60: (p_model_line_id IN NUMBER,
61: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
62: := OE_Order_Pub.G_MISS_REQUEST_TBL,
63: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
64: := OE_Order_Pub.G_MISS_REQUEST_TBL,
65: p_validate_flag IN VARCHAR2 := 'Y',
66: p_complete_flag IN VARCHAR2 := 'Y',
67: p_caller IN VARCHAR2 := '',

Line 64: := OE_Order_Pub.G_MISS_REQUEST_TBL,

60: (p_model_line_id IN NUMBER,
61: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
62: := OE_Order_Pub.G_MISS_REQUEST_TBL,
63: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
64: := OE_Order_Pub.G_MISS_REQUEST_TBL,
65: p_validate_flag IN VARCHAR2 := 'Y',
66: p_complete_flag IN VARCHAR2 := 'Y',
67: p_caller IN VARCHAR2 := '',
68: x_valid_config OUT NOCOPY /* file.sql.39 change */ VARCHAR2,

Line 94: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);

90: Procedure Query_Options
91: (p_top_model_line_id IN NUMBER
92: ,p_send_cancel_lines IN VARCHAR2 := 'N'
93: ,p_source_type IN VARCHAR2 := ''
94: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);
95:
96: Procedure Query_ATO_Options
97: (p_ato_line_id IN NUMBER
98: ,p_send_cancel_lines IN VARCHAR2 := 'N'

Line 100: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);

96: Procedure Query_ATO_Options
97: (p_ato_line_id IN NUMBER
98: ,p_send_cancel_lines IN VARCHAR2 := 'N'
99: ,p_source_type IN VARCHAR2 := ''
100: ,x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);
101:
102: FUNCTION Freeze_Inc_Items_for_Order(p_header_id IN NUMBER)
103: RETURN VARCHAR2;
104:

Line 109: (p_line_rec IN OE_ORDER_PUB.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC,

105: FUNCTION Freeze_Included_Items(p_line_id IN NUMBER)
106: RETURN VARCHAR2;
107:
108: FUNCTION Process_Included_Items
109: (p_line_rec IN OE_ORDER_PUB.line_rec_type := OE_ORDER_PUB.G_MISS_LINE_REC,
110: p_line_id IN NUMBER := FND_API.G_MISS_NUM,
111: p_freeze IN BOOLEAN,
112: p_process_requests IN BOOLEAN DEFAULT FALSE)
113: RETURN VARCHAR2;

Line 121: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);

117: , p_header_id IN NUMBER := FND_API.G_MISS_NUM
118: , p_top_model_line_id IN NUMBER := FND_API.G_MISS_NUM
119: , p_send_cancel_lines IN VARCHAR2 := 'N'
120: , p_source_type IN VARCHAR2 := ''
121: , x_line_tbl OUT NOCOPY OE_ORDER_PUB.line_tbl_type);
122:
123:
124: Procedure Explode
125: ( p_validation_org IN NUMBER

Line 157: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

153:
154: FUNCTION Is_ATO_Model
155: (p_line_id IN NUMBER
156: := FND_API.G_MISS_NUM ,
157: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
158: := OE_ORDER_PUB.G_MISS_LINE_REC)
159: RETURN BOOLEAN;
160:
161: FUNCTION Is_PTO_Model

Line 158: := OE_ORDER_PUB.G_MISS_LINE_REC)

154: FUNCTION Is_ATO_Model
155: (p_line_id IN NUMBER
156: := FND_API.G_MISS_NUM ,
157: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
158: := OE_ORDER_PUB.G_MISS_LINE_REC)
159: RETURN BOOLEAN;
160:
161: FUNCTION Is_PTO_Model
162: (p_line_id IN NUMBER

Line 164: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

160:
161: FUNCTION Is_PTO_Model
162: (p_line_id IN NUMBER
163: := FND_API.G_MISS_NUM ,
164: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
165: := OE_ORDER_PUB.G_MISS_LINE_REC)
166: RETURN BOOLEAN;
167:
168: FUNCTION Is_Included_Option

Line 165: := OE_ORDER_PUB.G_MISS_LINE_REC)

161: FUNCTION Is_PTO_Model
162: (p_line_id IN NUMBER
163: := FND_API.G_MISS_NUM ,
164: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
165: := OE_ORDER_PUB.G_MISS_LINE_REC)
166: RETURN BOOLEAN;
167:
168: FUNCTION Is_Included_Option
169: (p_line_id IN NUMBER

Line 171: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

167:
168: FUNCTION Is_Included_Option
169: (p_line_id IN NUMBER
170: := FND_API.G_MISS_NUM ,
171: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
172: := OE_ORDER_PUB.G_MISS_LINE_REC)
173: RETURN BOOLEAN;
174:
175: FUNCTION Is_Config_Item

Line 172: := OE_ORDER_PUB.G_MISS_LINE_REC)

168: FUNCTION Is_Included_Option
169: (p_line_id IN NUMBER
170: := FND_API.G_MISS_NUM ,
171: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
172: := OE_ORDER_PUB.G_MISS_LINE_REC)
173: RETURN BOOLEAN;
174:
175: FUNCTION Is_Config_Item
176: (p_line_id IN NUMBER

Line 178: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

174:
175: FUNCTION Is_Config_Item
176: (p_line_id IN NUMBER
177: := FND_API.G_MISS_NUM ,
178: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
179: := OE_ORDER_PUB.G_MISS_LINE_REC)
180: RETURN BOOLEAN;
181:
182: FUNCTION Is_ATO_Option

Line 179: := OE_ORDER_PUB.G_MISS_LINE_REC)

175: FUNCTION Is_Config_Item
176: (p_line_id IN NUMBER
177: := FND_API.G_MISS_NUM ,
178: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
179: := OE_ORDER_PUB.G_MISS_LINE_REC)
180: RETURN BOOLEAN;
181:
182: FUNCTION Is_ATO_Option
183: (p_line_id IN NUMBER

Line 185: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

181:
182: FUNCTION Is_ATO_Option
183: (p_line_id IN NUMBER
184: := FND_API.G_MISS_NUM ,
185: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
186: := OE_ORDER_PUB.G_MISS_LINE_REC)
187: RETURN BOOLEAN;
188:
189: FUNCTION Is_PTO_Option

Line 186: := OE_ORDER_PUB.G_MISS_LINE_REC)

182: FUNCTION Is_ATO_Option
183: (p_line_id IN NUMBER
184: := FND_API.G_MISS_NUM ,
185: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
186: := OE_ORDER_PUB.G_MISS_LINE_REC)
187: RETURN BOOLEAN;
188:
189: FUNCTION Is_PTO_Option
190: (p_line_id IN NUMBER

Line 192: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

188:
189: FUNCTION Is_PTO_Option
190: (p_line_id IN NUMBER
191: := FND_API.G_MISS_NUM ,
192: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
193: := OE_ORDER_PUB.G_MISS_LINE_REC)
194: RETURN BOOLEAN;
195:
196: FUNCTION Is_ATO_Class

Line 193: := OE_ORDER_PUB.G_MISS_LINE_REC)

189: FUNCTION Is_PTO_Option
190: (p_line_id IN NUMBER
191: := FND_API.G_MISS_NUM ,
192: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
193: := OE_ORDER_PUB.G_MISS_LINE_REC)
194: RETURN BOOLEAN;
195:
196: FUNCTION Is_ATO_Class
197: (p_line_id IN NUMBER

Line 199: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

195:
196: FUNCTION Is_ATO_Class
197: (p_line_id IN NUMBER
198: := FND_API.G_MISS_NUM ,
199: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
200: := OE_ORDER_PUB.G_MISS_LINE_REC)
201: RETURN BOOLEAN;
202:
203: FUNCTION Is_PTO_Class

Line 200: := OE_ORDER_PUB.G_MISS_LINE_REC)

196: FUNCTION Is_ATO_Class
197: (p_line_id IN NUMBER
198: := FND_API.G_MISS_NUM ,
199: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
200: := OE_ORDER_PUB.G_MISS_LINE_REC)
201: RETURN BOOLEAN;
202:
203: FUNCTION Is_PTO_Class
204: (p_line_id IN NUMBER

Line 206: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

202:
203: FUNCTION Is_PTO_Class
204: (p_line_id IN NUMBER
205: := FND_API.G_MISS_NUM ,
206: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
207: := OE_ORDER_PUB.G_MISS_LINE_REC)
208: RETURN BOOLEAN;
209:
210: FUNCTION Is_ATO_Subconfig

Line 207: := OE_ORDER_PUB.G_MISS_LINE_REC)

203: FUNCTION Is_PTO_Class
204: (p_line_id IN NUMBER
205: := FND_API.G_MISS_NUM ,
206: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
207: := OE_ORDER_PUB.G_MISS_LINE_REC)
208: RETURN BOOLEAN;
209:
210: FUNCTION Is_ATO_Subconfig
211: (p_line_id IN NUMBER

Line 213: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

209:
210: FUNCTION Is_ATO_Subconfig
211: (p_line_id IN NUMBER
212: := FND_API.G_MISS_NUM ,
213: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
214: := OE_ORDER_PUB.G_MISS_LINE_REC)
215: RETURN BOOLEAN;
216:
217: FUNCTION Is_Kit

Line 214: := OE_ORDER_PUB.G_MISS_LINE_REC)

210: FUNCTION Is_ATO_Subconfig
211: (p_line_id IN NUMBER
212: := FND_API.G_MISS_NUM ,
213: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
214: := OE_ORDER_PUB.G_MISS_LINE_REC)
215: RETURN BOOLEAN;
216:
217: FUNCTION Is_Kit
218: (p_line_id IN NUMBER

Line 220: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

216:
217: FUNCTION Is_Kit
218: (p_line_id IN NUMBER
219: := FND_API.G_MISS_NUM ,
220: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
221: := OE_ORDER_PUB.G_MISS_LINE_REC)
222: RETURN BOOLEAN;
223:
224: FUNCTION Is_ATO_Item

Line 221: := OE_ORDER_PUB.G_MISS_LINE_REC)

217: FUNCTION Is_Kit
218: (p_line_id IN NUMBER
219: := FND_API.G_MISS_NUM ,
220: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
221: := OE_ORDER_PUB.G_MISS_LINE_REC)
222: RETURN BOOLEAN;
223:
224: FUNCTION Is_ATO_Item
225: (p_line_id IN NUMBER

Line 227: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE

223:
224: FUNCTION Is_ATO_Item
225: (p_line_id IN NUMBER
226: := FND_API.G_MISS_NUM ,
227: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
228: := OE_ORDER_PUB.G_MISS_LINE_REC)
229: RETURN BOOLEAN;
230:
231: PROCEDURE Part_of_Configuration

Line 228: := OE_ORDER_PUB.G_MISS_LINE_REC)

224: FUNCTION Is_ATO_Item
225: (p_line_id IN NUMBER
226: := FND_API.G_MISS_NUM ,
227: p_line_rec IN OE_Order_PUB.LINE_REC_TYPE
228: := OE_ORDER_PUB.G_MISS_LINE_REC)
229: RETURN BOOLEAN;
230:
231: PROCEDURE Part_of_Configuration
232: ( p_application_id IN NUMBER,

Line 273: ,p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

269: ( p_model_line_id IN NUMBER
270: ,p_model_component IN VARCHAR2
271: ,p_x_options_tbl IN OUT NOCOPY
272: Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
273: ,p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
274: := OE_Order_Pub.G_MISS_REQUEST_TBL
275: ,p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
276: := OE_Order_Pub.G_MISS_REQUEST_TBL
277: ,p_ui_flag IN VARCHAR2 := 'N'

Line 274: := OE_Order_Pub.G_MISS_REQUEST_TBL

270: ,p_model_component IN VARCHAR2
271: ,p_x_options_tbl IN OUT NOCOPY
272: Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
273: ,p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
274: := OE_Order_Pub.G_MISS_REQUEST_TBL
275: ,p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
276: := OE_Order_Pub.G_MISS_REQUEST_TBL
277: ,p_ui_flag IN VARCHAR2 := 'N'
278: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);

Line 275: ,p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

271: ,p_x_options_tbl IN OUT NOCOPY
272: Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
273: ,p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
274: := OE_Order_Pub.G_MISS_REQUEST_TBL
275: ,p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
276: := OE_Order_Pub.G_MISS_REQUEST_TBL
277: ,p_ui_flag IN VARCHAR2 := 'N'
278: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
279:

Line 276: := OE_Order_Pub.G_MISS_REQUEST_TBL

272: Oe_Process_Options_Pvt.Selected_Options_Tbl_Type
273: ,p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
274: := OE_Order_Pub.G_MISS_REQUEST_TBL
275: ,p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
276: := OE_Order_Pub.G_MISS_REQUEST_TBL
277: ,p_ui_flag IN VARCHAR2 := 'N'
278: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
279:
280: PROCEDURE Notify_CTO

Line 282: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type

278: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
279:
280: PROCEDURE Notify_CTO
281: ( p_ato_line_id IN NUMBER
282: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
283: := OE_Order_Pub.G_MISS_REQUEST_REC
284: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
285: := OE_Order_Pub.G_MISS_REQUEST_TBL
286: ,p_split_tbl IN OE_Order_PUB.request_tbl_type

Line 283: := OE_Order_Pub.G_MISS_REQUEST_REC

279:
280: PROCEDURE Notify_CTO
281: ( p_ato_line_id IN NUMBER
282: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
283: := OE_Order_Pub.G_MISS_REQUEST_REC
284: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
285: := OE_Order_Pub.G_MISS_REQUEST_TBL
286: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
287: := OE_Order_Pub.G_MISS_REQUEST_TBL

Line 284: ,p_request_tbl IN OE_Order_PUB.request_tbl_type

280: PROCEDURE Notify_CTO
281: ( p_ato_line_id IN NUMBER
282: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
283: := OE_Order_Pub.G_MISS_REQUEST_REC
284: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
285: := OE_Order_Pub.G_MISS_REQUEST_TBL
286: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
287: := OE_Order_Pub.G_MISS_REQUEST_TBL
288: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type

Line 285: := OE_Order_Pub.G_MISS_REQUEST_TBL

281: ( p_ato_line_id IN NUMBER
282: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
283: := OE_Order_Pub.G_MISS_REQUEST_REC
284: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
285: := OE_Order_Pub.G_MISS_REQUEST_TBL
286: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
287: := OE_Order_Pub.G_MISS_REQUEST_TBL
288: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
289: := OE_Order_Pub.G_MISS_REQUEST_TBL

Line 286: ,p_split_tbl IN OE_Order_PUB.request_tbl_type

282: ,p_request_rec IN OE_Order_Pub.Request_Rec_Type
283: := OE_Order_Pub.G_MISS_REQUEST_REC
284: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
285: := OE_Order_Pub.G_MISS_REQUEST_TBL
286: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
287: := OE_Order_Pub.G_MISS_REQUEST_TBL
288: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
289: := OE_Order_Pub.G_MISS_REQUEST_TBL
290: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );

Line 287: := OE_Order_Pub.G_MISS_REQUEST_TBL

283: := OE_Order_Pub.G_MISS_REQUEST_REC
284: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
285: := OE_Order_Pub.G_MISS_REQUEST_TBL
286: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
287: := OE_Order_Pub.G_MISS_REQUEST_TBL
288: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
289: := OE_Order_Pub.G_MISS_REQUEST_TBL
290: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
291:

Line 288: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type

284: ,p_request_tbl IN OE_Order_PUB.request_tbl_type
285: := OE_Order_Pub.G_MISS_REQUEST_TBL
286: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
287: := OE_Order_Pub.G_MISS_REQUEST_TBL
288: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
289: := OE_Order_Pub.G_MISS_REQUEST_TBL
290: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
291:
292:

Line 289: := OE_Order_Pub.G_MISS_REQUEST_TBL

285: := OE_Order_Pub.G_MISS_REQUEST_TBL
286: ,p_split_tbl IN OE_Order_PUB.request_tbl_type
287: := OE_Order_Pub.G_MISS_REQUEST_TBL
288: ,p_decimal_tbl IN OE_Order_PUB.request_tbl_type
289: := OE_Order_Pub.G_MISS_REQUEST_TBL
290: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
291:
292:
293: PROCEDURE Decimal_Ratio_Check

Line 300: ( p_parent_line_rec IN OE_Order_Pub.Line_Rec_Type

296: ,p_ratio IN NUMBER);
297:
298:
299: PROCEDURE Default_Child_Line
300: ( p_parent_line_rec IN OE_Order_Pub.Line_Rec_Type
301: ,p_x_child_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
302: ,p_direct_save IN BOOLEAN := FALSE
303: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
304:

Line 301: ,p_x_child_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type

297:
298:
299: PROCEDURE Default_Child_Line
300: ( p_parent_line_rec IN OE_Order_Pub.Line_Rec_Type
301: ,p_x_child_line_rec IN OUT NOCOPY OE_Order_Pub.Line_Rec_Type
302: ,p_direct_save IN BOOLEAN := FALSE
303: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
304:
305:

Line 338: ( p_model_line_rec IN OE_Order_Pub.Line_Rec_Type := null

334: ,x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2);
335:
336:
337: PROCEDURE Get_Config_Effective_Date
338: ( p_model_line_rec IN OE_Order_Pub.Line_Rec_Type := null
339: ,p_model_line_id IN NUMBER := null
340: ,x_old_behavior OUT NOCOPY VARCHAR2
341: ,x_config_effective_date OUT NOCOPY DATE
342: ,x_frozen_model_bill OUT NOCOPY VARCHAR2);

Line 351: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type

347: x_xml_hdr OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );
348:
349: PROCEDURE Send_input_xml
350: ( p_model_line_id IN NUMBER ,
351: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
352: := OE_Order_Pub.G_MISS_REQUEST_TBL,
353: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
354: := OE_Order_Pub.G_MISS_REQUEST_TBL,
355: p_model_qty IN NUMBER,

Line 352: := OE_Order_Pub.G_MISS_REQUEST_TBL,

348:
349: PROCEDURE Send_input_xml
350: ( p_model_line_id IN NUMBER ,
351: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
352: := OE_Order_Pub.G_MISS_REQUEST_TBL,
353: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
354: := OE_Order_Pub.G_MISS_REQUEST_TBL,
355: p_model_qty IN NUMBER,
356: p_xml_hdr IN VARCHAR2 := NULL,

Line 353: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type

349: PROCEDURE Send_input_xml
350: ( p_model_line_id IN NUMBER ,
351: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
352: := OE_Order_Pub.G_MISS_REQUEST_TBL,
353: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
354: := OE_Order_Pub.G_MISS_REQUEST_TBL,
355: p_model_qty IN NUMBER,
356: p_xml_hdr IN VARCHAR2 := NULL,
357: x_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,

Line 354: := OE_Order_Pub.G_MISS_REQUEST_TBL,

350: ( p_model_line_id IN NUMBER ,
351: p_deleted_options_tbl IN OE_Order_PUB.request_tbl_type
352: := OE_Order_Pub.G_MISS_REQUEST_TBL,
353: p_updated_options_tbl IN OE_Order_PUB.request_tbl_type
354: := OE_Order_Pub.G_MISS_REQUEST_TBL,
355: p_model_qty IN NUMBER,
356: p_xml_hdr IN VARCHAR2 := NULL,
357: x_out_xml_msg OUT NOCOPY /* file.sql.39 change */ LONG ,
358: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2 );