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_SPLIT_UTIL dependencies on OE_ORDER_PUB

Line 8: g_qry_out_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;

4: G_min_model NUMBER;
5: G_max_model NUMBER;
6: g_over_shipment boolean := false;
7: g_remnant_only Boolean := FALSE;
8: g_qry_out_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
9:
10: Procedure Create_Line_Set_For_Options(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type ) IS
11: --
12: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 10: Procedure Create_Line_Set_For_Options(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type ) IS

6: g_over_shipment boolean := false;
7: g_remnant_only Boolean := FALSE;
8: g_qry_out_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
9:
10: Procedure Create_Line_Set_For_Options(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.Line_Tbl_Type ) IS
11: --
12: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
13: --
14: BEGIN

Line 48: Procedure Update_Drop_Ship_Source(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type) IS

44: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
45: END Create_Line_Set_For_Options;
46:
47:
48: Procedure Update_Drop_Ship_Source(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type) IS
49: --
50: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
51: --
52: BEGIN

Line 71: Procedure Get_Nonprop_Service_lines(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,

67: END;
68: END LOOP;
69: End Update_Drop_Ship_Source;
70:
71: Procedure Get_Nonprop_Service_lines(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
72: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_Tbl_Type)
73: IS
74: l_ser_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
75: l_ser_line_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_rec;

Line 72: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_Tbl_Type)

68: END LOOP;
69: End Update_Drop_Ship_Source;
70:
71: Procedure Get_Nonprop_Service_lines(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
72: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_Tbl_Type)
73: IS
74: l_ser_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
75: l_ser_line_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_rec;
76: l_line_id NUMBER;

Line 74: l_ser_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;

70:
71: Procedure Get_Nonprop_Service_lines(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
72: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_Tbl_Type)
73: IS
74: l_ser_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
75: l_ser_line_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_rec;
76: l_line_id NUMBER;
77: l_service_count NUMBER := 0;
78: Cursor Sertbl IS

Line 75: l_ser_line_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_rec;

71: Procedure Get_Nonprop_Service_lines(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
72: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_Tbl_Type)
73: IS
74: l_ser_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
75: l_ser_line_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_rec;
76: l_line_id NUMBER;
77: l_service_count NUMBER := 0;
78: Cursor Sertbl IS
79: SELECT ORDERED_QUANTITY

Line 155: FUNCTION Get_Shipment_Number(p_line_rec oe_order_pub.line_rec_type) RETURN NUMBER IS

151:
152: /* This is duplicated here since defaulting goes by g_line_rec%view and
153: has technical dificulties to get the currect shipment number */
154:
155: FUNCTION Get_Shipment_Number(p_line_rec oe_order_pub.line_rec_type) RETURN NUMBER IS
156: l_ship_number NUMBER := NULL;
157: l_config_rec OE_ORDER_PUB.line_rec_type;
158: --
159: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 157: l_config_rec OE_ORDER_PUB.line_rec_type;

153: has technical dificulties to get the currect shipment number */
154:
155: FUNCTION Get_Shipment_Number(p_line_rec oe_order_pub.line_rec_type) RETURN NUMBER IS
156: l_ship_number NUMBER := NULL;
157: l_config_rec OE_ORDER_PUB.line_rec_type;
158: --
159: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
160: --
161: BEGIN

Line 196: FUNCTION Check_Complete_Shipment(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,

192: END IF;
193: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
194: END Get_Shipment_Number;
195:
196: FUNCTION Check_Complete_Shipment(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
197: p_line_id IN number) RETURN VARCHAR2 IS
198: l_line_id number;
199: CURSOR OPTIONTBL IS
200: SELECT ORDERED_QUANTITY

Line 207: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;

203: FROM OE_ORDER_LINES_ALL
204: WHERE TOP_MODEL_LINE_ID = l_line_id
205: AND LINE_ID <> l_line_id
206: AND NVL(SHIPPABLE_FLAG,'N')='Y';
207: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
208: l_exist varchar2(1) := 'N';
209: --
210: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
211: --

Line 246: Procedure Get_Service_lines(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,

242: END IF;
243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END Check_Complete_Shipment;
245:
246: Procedure Get_Service_lines(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
247: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_Tbl_Type,
248: g_split_line_tbl oe_split_util.split_line_tbl) IS
249: l_ser_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
250: l_line_id NUMBER;

Line 247: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_Tbl_Type,

243: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
244: END Check_Complete_Shipment;
245:
246: Procedure Get_Service_lines(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
247: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_Tbl_Type,
248: g_split_line_tbl oe_split_util.split_line_tbl) IS
249: l_ser_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
250: l_line_id NUMBER;
251: l_service_count NUMBER := 1;

Line 249: l_ser_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;

245:
246: Procedure Get_Service_lines(p_line_tbl IN OE_ORDER_PUB.Line_Tbl_Type,
247: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_Tbl_Type,
248: g_split_line_tbl oe_split_util.split_line_tbl) IS
249: l_ser_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
250: l_line_id NUMBER;
251: l_service_count NUMBER := 1;
252: l_ser_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
253: l_query_out_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;

Line 252: l_ser_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;

248: g_split_line_tbl oe_split_util.split_line_tbl) IS
249: l_ser_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
250: l_line_id NUMBER;
251: l_service_count NUMBER := 1;
252: l_ser_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
253: l_query_out_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
254:
255: CURSOR Sertbl IS
256: SELECT ORDERED_QUANTITY

Line 253: l_query_out_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;

249: l_ser_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
250: l_line_id NUMBER;
251: l_service_count NUMBER := 1;
252: l_ser_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
253: l_query_out_rec OE_ORDER_PUB.Line_rec_Type := OE_ORDER_PUB.G_MISS_LINE_REC;
254:
255: CURSOR Sertbl IS
256: SELECT ORDERED_QUANTITY
257: , HEADER_ID

Line 343: Procedure Get_non_Model_Configuration(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,

339: END IF;
340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END Get_Service_lines;
342:
343: Procedure Get_non_Model_Configuration(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
344: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS
345: l_line_id NUMBER;
346: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
347: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;

Line 344: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS

340: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
341: END Get_Service_lines;
342:
343: Procedure Get_non_Model_Configuration(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
344: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS
345: l_line_id NUMBER;
346: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
347: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;
348: l_shippable_tbl OE_ORDER_PUB.line_tbl_type;

Line 346: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;

342:
343: Procedure Get_non_Model_Configuration(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
344: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS
345: l_line_id NUMBER;
346: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
347: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;
348: l_shippable_tbl OE_ORDER_PUB.line_tbl_type;
349: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;
350: l_temp_tbl OE_ORDER_PUB.line_tbl_type;

Line 347: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;

343: Procedure Get_non_Model_Configuration(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
344: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS
345: l_line_id NUMBER;
346: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
347: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;
348: l_shippable_tbl OE_ORDER_PUB.line_tbl_type;
349: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;
350: l_temp_tbl OE_ORDER_PUB.line_tbl_type;
351: l_ratio NUMBER;

Line 348: l_shippable_tbl OE_ORDER_PUB.line_tbl_type;

344: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS
345: l_line_id NUMBER;
346: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
347: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;
348: l_shippable_tbl OE_ORDER_PUB.line_tbl_type;
349: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;
350: l_temp_tbl OE_ORDER_PUB.line_tbl_type;
351: l_ratio NUMBER;
352: l_model_ratio NUMBER;

Line 349: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;

345: l_line_id NUMBER;
346: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
347: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;
348: l_shippable_tbl OE_ORDER_PUB.line_tbl_type;
349: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;
350: l_temp_tbl OE_ORDER_PUB.line_tbl_type;
351: l_ratio NUMBER;
352: l_model_ratio NUMBER;
353: l_line_rec OE_ORDER_PUB.line_rec_type;

Line 350: l_temp_tbl OE_ORDER_PUB.line_tbl_type;

346: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
347: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;
348: l_shippable_tbl OE_ORDER_PUB.line_tbl_type;
349: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;
350: l_temp_tbl OE_ORDER_PUB.line_tbl_type;
351: l_ratio NUMBER;
352: l_model_ratio NUMBER;
353: l_line_rec OE_ORDER_PUB.line_rec_type;
354: l_model_rec OE_ORDER_PUB.line_rec_type;

Line 353: l_line_rec OE_ORDER_PUB.line_rec_type;

349: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;
350: l_temp_tbl OE_ORDER_PUB.line_tbl_type;
351: l_ratio NUMBER;
352: l_model_ratio NUMBER;
353: l_line_rec OE_ORDER_PUB.line_rec_type;
354: l_model_rec OE_ORDER_PUB.line_rec_type;
355: l_option_line OE_ORDER_PUB.line_rec_type;
356: l_parent_line OE_ORDER_PUB.line_rec_type;
357: l_option_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 354: l_model_rec OE_ORDER_PUB.line_rec_type;

350: l_temp_tbl OE_ORDER_PUB.line_tbl_type;
351: l_ratio NUMBER;
352: l_model_ratio NUMBER;
353: l_line_rec OE_ORDER_PUB.line_rec_type;
354: l_model_rec OE_ORDER_PUB.line_rec_type;
355: l_option_line OE_ORDER_PUB.line_rec_type;
356: l_parent_line OE_ORDER_PUB.line_rec_type;
357: l_option_line_tbl OE_ORDER_PUB.line_tbl_type;
358: l_tbl_count NUMBER := 0;

Line 355: l_option_line OE_ORDER_PUB.line_rec_type;

351: l_ratio NUMBER;
352: l_model_ratio NUMBER;
353: l_line_rec OE_ORDER_PUB.line_rec_type;
354: l_model_rec OE_ORDER_PUB.line_rec_type;
355: l_option_line OE_ORDER_PUB.line_rec_type;
356: l_parent_line OE_ORDER_PUB.line_rec_type;
357: l_option_line_tbl OE_ORDER_PUB.line_tbl_type;
358: l_tbl_count NUMBER := 0;
359: l_option_count NUMBER := 0;

Line 356: l_parent_line OE_ORDER_PUB.line_rec_type;

352: l_model_ratio NUMBER;
353: l_line_rec OE_ORDER_PUB.line_rec_type;
354: l_model_rec OE_ORDER_PUB.line_rec_type;
355: l_option_line OE_ORDER_PUB.line_rec_type;
356: l_parent_line OE_ORDER_PUB.line_rec_type;
357: l_option_line_tbl OE_ORDER_PUB.line_tbl_type;
358: l_tbl_count NUMBER := 0;
359: l_option_count NUMBER := 0;
360: l_original_qty NUMBER := 0;

Line 357: l_option_line_tbl OE_ORDER_PUB.line_tbl_type;

353: l_line_rec OE_ORDER_PUB.line_rec_type;
354: l_model_rec OE_ORDER_PUB.line_rec_type;
355: l_option_line OE_ORDER_PUB.line_rec_type;
356: l_parent_line OE_ORDER_PUB.line_rec_type;
357: l_option_line_tbl OE_ORDER_PUB.line_tbl_type;
358: l_tbl_count NUMBER := 0;
359: l_option_count NUMBER := 0;
360: l_original_qty NUMBER := 0;
361: l_min_model NUMBER := 0;

Line 762: Procedure Get_Model_Configuration(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,

758: END IF;
759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: END Get_Non_Model_Configuration;
761:
762: Procedure Get_Model_Configuration(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
763: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS
764: l_line_id number;
765:
766: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;

Line 763: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS

759: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
760: END Get_Non_Model_Configuration;
761:
762: Procedure Get_Model_Configuration(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
763: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS
764: l_line_id number;
765:
766: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
767: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;

Line 766: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;

762: Procedure Get_Model_Configuration(p_line_tbl IN OE_ORDER_PUB.line_tbl_type,
763: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS
764: l_line_id number;
765:
766: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
767: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;
768: l_shippable_tbl OE_ORDER_PUB.line_tbl_type;
769: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;
770: l_temp_tbl OE_ORDER_PUB.line_tbl_type;

Line 767: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;

763: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.line_tbl_type) IS
764: l_line_id number;
765:
766: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
767: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;
768: l_shippable_tbl OE_ORDER_PUB.line_tbl_type;
769: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;
770: l_temp_tbl OE_ORDER_PUB.line_tbl_type;
771: l_ratio number;

Line 768: l_shippable_tbl OE_ORDER_PUB.line_tbl_type;

764: l_line_id number;
765:
766: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
767: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;
768: l_shippable_tbl OE_ORDER_PUB.line_tbl_type;
769: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;
770: l_temp_tbl OE_ORDER_PUB.line_tbl_type;
771: l_ratio number;
772: l_model_ratio number;

Line 769: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;

765:
766: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
767: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;
768: l_shippable_tbl OE_ORDER_PUB.line_tbl_type;
769: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;
770: l_temp_tbl OE_ORDER_PUB.line_tbl_type;
771: l_ratio number;
772: l_model_ratio number;
773: l_line_rec OE_ORDER_PUB.line_rec_type;

Line 770: l_temp_tbl OE_ORDER_PUB.line_tbl_type;

766: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_line_tbl;
767: l_reminant_tbl OE_ORDER_PUB.line_tbl_type;
768: l_shippable_tbl OE_ORDER_PUB.line_tbl_type;
769: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;
770: l_temp_tbl OE_ORDER_PUB.line_tbl_type;
771: l_ratio number;
772: l_model_ratio number;
773: l_line_rec OE_ORDER_PUB.line_rec_type;
774: l_model_rec OE_ORDER_PUB.line_rec_type;

Line 773: l_line_rec OE_ORDER_PUB.line_rec_type;

769: l_shipped_tbl OE_ORDER_PUB.line_tbl_type;
770: l_temp_tbl OE_ORDER_PUB.line_tbl_type;
771: l_ratio number;
772: l_model_ratio number;
773: l_line_rec OE_ORDER_PUB.line_rec_type;
774: l_model_rec OE_ORDER_PUB.line_rec_type;
775: l_option_line OE_ORDER_PUB.line_rec_type;
776: l_parent_line OE_ORDER_PUB.line_rec_type;
777: l_option_line_tbl OE_ORDER_PUB.line_tbl_type;

Line 774: l_model_rec OE_ORDER_PUB.line_rec_type;

770: l_temp_tbl OE_ORDER_PUB.line_tbl_type;
771: l_ratio number;
772: l_model_ratio number;
773: l_line_rec OE_ORDER_PUB.line_rec_type;
774: l_model_rec OE_ORDER_PUB.line_rec_type;
775: l_option_line OE_ORDER_PUB.line_rec_type;
776: l_parent_line OE_ORDER_PUB.line_rec_type;
777: l_option_line_tbl OE_ORDER_PUB.line_tbl_type;
778: l_tbl_count number := 0;

Line 775: l_option_line OE_ORDER_PUB.line_rec_type;

771: l_ratio number;
772: l_model_ratio number;
773: l_line_rec OE_ORDER_PUB.line_rec_type;
774: l_model_rec OE_ORDER_PUB.line_rec_type;
775: l_option_line OE_ORDER_PUB.line_rec_type;
776: l_parent_line OE_ORDER_PUB.line_rec_type;
777: l_option_line_tbl OE_ORDER_PUB.line_tbl_type;
778: l_tbl_count number := 0;
779: l_option_count number := 0;

Line 776: l_parent_line OE_ORDER_PUB.line_rec_type;

772: l_model_ratio number;
773: l_line_rec OE_ORDER_PUB.line_rec_type;
774: l_model_rec OE_ORDER_PUB.line_rec_type;
775: l_option_line OE_ORDER_PUB.line_rec_type;
776: l_parent_line OE_ORDER_PUB.line_rec_type;
777: l_option_line_tbl OE_ORDER_PUB.line_tbl_type;
778: l_tbl_count number := 0;
779: l_option_count number := 0;
780: l_original_qty number := 0;

Line 777: l_option_line_tbl OE_ORDER_PUB.line_tbl_type;

773: l_line_rec OE_ORDER_PUB.line_rec_type;
774: l_model_rec OE_ORDER_PUB.line_rec_type;
775: l_option_line OE_ORDER_PUB.line_rec_type;
776: l_parent_line OE_ORDER_PUB.line_rec_type;
777: l_option_line_tbl OE_ORDER_PUB.line_tbl_type;
778: l_tbl_count number := 0;
779: l_option_count number := 0;
780: l_original_qty number := 0;
781: l_min_model number := 0;

Line 1163: Procedure Cascade_Proportional_Split(p_line_tbl IN OE_ORDER_PUB.Line_tbl_type,

1159: END IF;
1160: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1161: END Get_Model_Configuration;
1162:
1163: Procedure Cascade_Proportional_Split(p_line_tbl IN OE_ORDER_PUB.Line_tbl_type,
1164: Parent_ordered_quantity NUMBER,
1165: p_Index NUMBER,
1166: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_tbl_type,
1167: x_line_adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_adj_tbl_type,

Line 1166: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_tbl_type,

1162:
1163: Procedure Cascade_Proportional_Split(p_line_tbl IN OE_ORDER_PUB.Line_tbl_type,
1164: Parent_ordered_quantity NUMBER,
1165: p_Index NUMBER,
1166: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_tbl_type,
1167: x_line_adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_adj_tbl_type,
1168: x_line_scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_scredit_tbl_type)
1169: IS
1170: l_option_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;

Line 1167: x_line_adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_adj_tbl_type,

1163: Procedure Cascade_Proportional_Split(p_line_tbl IN OE_ORDER_PUB.Line_tbl_type,
1164: Parent_ordered_quantity NUMBER,
1165: p_Index NUMBER,
1166: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_tbl_type,
1167: x_line_adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_adj_tbl_type,
1168: x_line_scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_scredit_tbl_type)
1169: IS
1170: l_option_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1171: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;

Line 1168: x_line_scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_scredit_tbl_type)

1164: Parent_ordered_quantity NUMBER,
1165: p_Index NUMBER,
1166: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_tbl_type,
1167: x_line_adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_adj_tbl_type,
1168: x_line_scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_scredit_tbl_type)
1169: IS
1170: l_option_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1171: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1172: l_line_id NUMBER;

Line 1170: l_option_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;

1166: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_tbl_type,
1167: x_line_adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_adj_tbl_type,
1168: x_line_scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_scredit_tbl_type)
1169: IS
1170: l_option_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1171: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1172: l_line_id NUMBER;
1173: l_top_model_line_id NUMBER;
1174: l_set_id NUMBER;

Line 1171: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;

1167: x_line_adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_adj_tbl_type,
1168: x_line_scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_ORDER_PUB.Line_scredit_tbl_type)
1169: IS
1170: l_option_line_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1171: l_line_out_tbl OE_ORDER_PUB.Line_Tbl_Type := OE_ORDER_PUB.G_MISS_LINE_TBL;
1172: l_line_id NUMBER;
1173: l_top_model_line_id NUMBER;
1174: l_set_id NUMBER;
1175: TYPE optrec_type is RECORD (

Line 1182: l_option_line OE_ORDER_PUB.line_rec_type;

1178: Line_id NUMBER);
1179: optionrec optrec_type;
1180: l_option_count NUMBER := 1;
1181: l_model_ratio NUMBER;
1182: l_option_line OE_ORDER_PUB.line_rec_type;
1183: l_line_adj_tbl OE_Order_Pub.Line_Adj_tbl_type;
1184: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;
1185: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1186: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;

Line 1183: l_line_adj_tbl OE_Order_Pub.Line_Adj_tbl_type;

1179: optionrec optrec_type;
1180: l_option_count NUMBER := 1;
1181: l_model_ratio NUMBER;
1182: l_option_line OE_ORDER_PUB.line_rec_type;
1183: l_line_adj_tbl OE_Order_Pub.Line_Adj_tbl_type;
1184: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;
1185: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1186: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1187: l_adjustment_count NUMBER := 0;

Line 1184: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;

1180: l_option_count NUMBER := 1;
1181: l_model_ratio NUMBER;
1182: l_option_line OE_ORDER_PUB.line_rec_type;
1183: l_line_adj_tbl OE_Order_Pub.Line_Adj_tbl_type;
1184: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;
1185: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1186: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1187: l_adjustment_count NUMBER := 0;
1188: l_scredit_count NUMBER := 0;

Line 1185: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;

1181: l_model_ratio NUMBER;
1182: l_option_line OE_ORDER_PUB.line_rec_type;
1183: l_line_adj_tbl OE_Order_Pub.Line_Adj_tbl_type;
1184: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;
1185: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1186: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1187: l_adjustment_count NUMBER := 0;
1188: l_scredit_count NUMBER := 0;
1189: l_split_line_tbl oe_split_util.split_line_tbl;

Line 1186: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;

1182: l_option_line OE_ORDER_PUB.line_rec_type;
1183: l_line_adj_tbl OE_Order_Pub.Line_Adj_tbl_type;
1184: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;
1185: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1186: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1187: l_adjustment_count NUMBER := 0;
1188: l_scredit_count NUMBER := 0;
1189: l_split_line_tbl oe_split_util.split_line_tbl;
1190: l_split_count NUMBER := 0;

Line 1376: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

1372:
1373: End Cascade_Proportional_Split;
1374:
1375: Procedure Default_Attributes
1376: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
1377: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
1378: )
1379: IS
1380: l_line_rec OE_Order_PUB.Line_Rec_Type := p_x_line_rec;

Line 1377: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

1373: End Cascade_Proportional_Split;
1374:
1375: Procedure Default_Attributes
1376: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
1377: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
1378: )
1379: IS
1380: l_line_rec OE_Order_PUB.Line_Rec_Type := p_x_line_rec;
1381: g_multiple_shipments VARCHAR2(3);

Line 1380: l_line_rec OE_Order_PUB.Line_Rec_Type := p_x_line_rec;

1376: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
1377: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
1378: )
1379: IS
1380: l_line_rec OE_Order_PUB.Line_Rec_Type := p_x_line_rec;
1381: g_multiple_shipments VARCHAR2(3);
1382: l_code_level VARCHAR2(30);
1383: l_shipment_number NUMBER;
1384: --

Line 1578: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type

1574: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1575: END Default_Attributes;
1576:
1577: PROCEDURE Split_Line
1578: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
1579: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
1580: ) IS
1581: --
1582: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 1579: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type

1575: END Default_Attributes;
1576:
1577: PROCEDURE Split_Line
1578: (p_x_line_rec IN OUT NOCOPY OE_Order_PUB.Line_Rec_Type
1579: ,p_old_line_rec IN OE_Order_PUB.Line_Rec_Type
1580: ) IS
1581: --
1582: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
1583: --

Line 1594: Procedure Check_split_Course(p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_type,

1590: END IF;
1591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1592: END Split_Line;
1593:
1594: Procedure Check_split_Course(p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_type,
1595: p_x_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_tbl_type,
1596: p_x_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_scredit_Tbl_type)
1597: IS
1598: l_parent_ordered_quantity NUMBER;

Line 1595: p_x_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_tbl_type,

1591: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1592: END Split_Line;
1593:
1594: Procedure Check_split_Course(p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_type,
1595: p_x_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_tbl_type,
1596: p_x_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_scredit_Tbl_type)
1597: IS
1598: l_parent_ordered_quantity NUMBER;
1599: l_child_quantity NUMBER := 0;

Line 1596: p_x_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_scredit_Tbl_type)

1592: END Split_Line;
1593:
1594: Procedure Check_split_Course(p_x_line_tbl IN OUT NOCOPY OE_Order_Pub.Line_tbl_type,
1595: p_x_line_adj_tbl IN OUT NOCOPY OE_Order_Pub.Line_Adj_tbl_type,
1596: p_x_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_scredit_Tbl_type)
1597: IS
1598: l_parent_ordered_quantity NUMBER;
1599: l_child_quantity NUMBER := 0;
1600: l_line_adj_tbl OE_ORDER_PUB.Line_Adj_tbl_type;

Line 1600: l_line_adj_tbl OE_ORDER_PUB.Line_Adj_tbl_type;

1596: p_x_line_scredit_tbl IN OUT NOCOPY OE_Order_Pub.Line_scredit_Tbl_type)
1597: IS
1598: l_parent_ordered_quantity NUMBER;
1599: l_child_quantity NUMBER := 0;
1600: l_line_adj_tbl OE_ORDER_PUB.Line_Adj_tbl_type;
1601: l_line_tbl OE_Order_Pub.Line_tbl_type;
1602: l_line_out_tbl OE_Order_Pub.Line_tbl_type;
1603: l_line_rec OE_Order_Pub.Line_rec_type;
1604: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;

Line 1601: l_line_tbl OE_Order_Pub.Line_tbl_type;

1597: IS
1598: l_parent_ordered_quantity NUMBER;
1599: l_child_quantity NUMBER := 0;
1600: l_line_adj_tbl OE_ORDER_PUB.Line_Adj_tbl_type;
1601: l_line_tbl OE_Order_Pub.Line_tbl_type;
1602: l_line_out_tbl OE_Order_Pub.Line_tbl_type;
1603: l_line_rec OE_Order_Pub.Line_rec_type;
1604: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;
1605: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;

Line 1602: l_line_out_tbl OE_Order_Pub.Line_tbl_type;

1598: l_parent_ordered_quantity NUMBER;
1599: l_child_quantity NUMBER := 0;
1600: l_line_adj_tbl OE_ORDER_PUB.Line_Adj_tbl_type;
1601: l_line_tbl OE_Order_Pub.Line_tbl_type;
1602: l_line_out_tbl OE_Order_Pub.Line_tbl_type;
1603: l_line_rec OE_Order_Pub.Line_rec_type;
1604: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;
1605: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1606: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;

Line 1603: l_line_rec OE_Order_Pub.Line_rec_type;

1599: l_child_quantity NUMBER := 0;
1600: l_line_adj_tbl OE_ORDER_PUB.Line_Adj_tbl_type;
1601: l_line_tbl OE_Order_Pub.Line_tbl_type;
1602: l_line_out_tbl OE_Order_Pub.Line_tbl_type;
1603: l_line_rec OE_Order_Pub.Line_rec_type;
1604: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;
1605: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1606: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1607: l_adjustment_count NUMBER := 0;

Line 1604: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;

1600: l_line_adj_tbl OE_ORDER_PUB.Line_Adj_tbl_type;
1601: l_line_tbl OE_Order_Pub.Line_tbl_type;
1602: l_line_out_tbl OE_Order_Pub.Line_tbl_type;
1603: l_line_rec OE_Order_Pub.Line_rec_type;
1604: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;
1605: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1606: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1607: l_adjustment_count NUMBER := 0;
1608: l_scredit_count NUMBER := 0;

Line 1605: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;

1601: l_line_tbl OE_Order_Pub.Line_tbl_type;
1602: l_line_out_tbl OE_Order_Pub.Line_tbl_type;
1603: l_line_rec OE_Order_Pub.Line_rec_type;
1604: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;
1605: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1606: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1607: l_adjustment_count NUMBER := 0;
1608: l_scredit_count NUMBER := 0;
1609: l_Split_line_Tbl OE_SPLIT_UTIL.Split_line_Tbl;

Line 1606: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;

1602: l_line_out_tbl OE_Order_Pub.Line_tbl_type;
1603: l_line_rec OE_Order_Pub.Line_rec_type;
1604: l_line_adj_temp_tbl OE_Order_Pub.Line_Adj_tbl_type;
1605: l_line_scredit_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1606: l_line_scredit_temp_tbl OE_Order_Pub.Line_scredit_Tbl_type;
1607: l_adjustment_count NUMBER := 0;
1608: l_scredit_count NUMBER := 0;
1609: l_Split_line_Tbl OE_SPLIT_UTIL.Split_line_Tbl;
1610: l_split_count NUMBER := 0;

Line 1611: l_miss_rec OE_Order_Pub.Line_rec_type := oe_order_pub.g_miss_line_rec;

1607: l_adjustment_count NUMBER := 0;
1608: l_scredit_count NUMBER := 0;
1609: l_Split_line_Tbl OE_SPLIT_UTIL.Split_line_Tbl;
1610: l_split_count NUMBER := 0;
1611: l_miss_rec OE_Order_Pub.Line_rec_type := oe_order_pub.g_miss_line_rec;
1612: l_sch_tbl OE_Order_Pub.Line_tbl_type;
1613: l_sch_count NUMBER := 0;
1614: last_count NUMBER := 0;
1615: l_return_status VARCHAR2(30);

Line 1612: l_sch_tbl OE_Order_Pub.Line_tbl_type;

1608: l_scredit_count NUMBER := 0;
1609: l_Split_line_Tbl OE_SPLIT_UTIL.Split_line_Tbl;
1610: l_split_count NUMBER := 0;
1611: l_miss_rec OE_Order_Pub.Line_rec_type := oe_order_pub.g_miss_line_rec;
1612: l_sch_tbl OE_Order_Pub.Line_tbl_type;
1613: l_sch_count NUMBER := 0;
1614: last_count NUMBER := 0;
1615: l_return_status VARCHAR2(30);
1616: lfirst PLS_INTEGER;

Line 1914: Procedure Cascade_non_proportional_Split(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,

1910: END IF;
1911: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1912: END Check_Split_Course;
1913:
1914: Procedure Cascade_non_proportional_Split(p_x_line_tbl IN OUT NOCOPY OE_ORDER_PUB.line_tbl_type,
1915: x_return_status OUT NOCOPY /* file.sql.39 change */ VARCHAR2) IS
1916: l_line_id NUMBER;
1917: l_control_rec OE_GLOBALS.Control_Rec_Type;
1918: l_api_name CONSTANT VARCHAR2(30) := 'Cascade Non Proportonal splits';

Line 1920: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;

1916: l_line_id NUMBER;
1917: l_control_rec OE_GLOBALS.Control_Rec_Type;
1918: l_api_name CONSTANT VARCHAR2(30) := 'Cascade Non Proportonal splits';
1919: l_return_status VARCHAR2(30);
1920: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1921: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1922: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1923: l_Line_Scredit_temp_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1924: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_x_line_tbl;

Line 1921: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1917: l_control_rec OE_GLOBALS.Control_Rec_Type;
1918: l_api_name CONSTANT VARCHAR2(30) := 'Cascade Non Proportonal splits';
1919: l_return_status VARCHAR2(30);
1920: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1921: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1922: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1923: l_Line_Scredit_temp_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1924: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_x_line_tbl;
1925: l_line_out_tbl OE_ORDER_PUB.line_tbl_type;

Line 1922: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1918: l_api_name CONSTANT VARCHAR2(30) := 'Cascade Non Proportonal splits';
1919: l_return_status VARCHAR2(30);
1920: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1921: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1922: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1923: l_Line_Scredit_temp_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1924: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_x_line_tbl;
1925: l_line_out_tbl OE_ORDER_PUB.line_tbl_type;
1926: l_model_ratio NUMBER;

Line 1923: l_Line_Scredit_temp_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

1919: l_return_status VARCHAR2(30);
1920: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1921: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1922: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1923: l_Line_Scredit_temp_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1924: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_x_line_tbl;
1925: l_line_out_tbl OE_ORDER_PUB.line_tbl_type;
1926: l_model_ratio NUMBER;
1927: l_line_rec OE_ORDER_PUB.line_rec_type;

Line 1924: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_x_line_tbl;

1920: l_old_line_tbl OE_ORDER_PUB.Line_Tbl_Type;
1921: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1922: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1923: l_Line_Scredit_temp_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1924: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_x_line_tbl;
1925: l_line_out_tbl OE_ORDER_PUB.line_tbl_type;
1926: l_model_ratio NUMBER;
1927: l_line_rec OE_ORDER_PUB.line_rec_type;
1928: l_option_line OE_ORDER_PUB.line_rec_type;

Line 1925: l_line_out_tbl OE_ORDER_PUB.line_tbl_type;

1921: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1922: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1923: l_Line_Scredit_temp_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1924: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_x_line_tbl;
1925: l_line_out_tbl OE_ORDER_PUB.line_tbl_type;
1926: l_model_ratio NUMBER;
1927: l_line_rec OE_ORDER_PUB.line_rec_type;
1928: l_option_line OE_ORDER_PUB.line_rec_type;
1929: l_tbl_count NUMBER := 0;

Line 1927: l_line_rec OE_ORDER_PUB.line_rec_type;

1923: l_Line_Scredit_temp_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1924: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_x_line_tbl;
1925: l_line_out_tbl OE_ORDER_PUB.line_tbl_type;
1926: l_model_ratio NUMBER;
1927: l_line_rec OE_ORDER_PUB.line_rec_type;
1928: l_option_line OE_ORDER_PUB.line_rec_type;
1929: l_tbl_count NUMBER := 0;
1930: l_min_model NUMBER := 0;
1931: l_max_ship_model NUMBER := 0;

Line 1928: l_option_line OE_ORDER_PUB.line_rec_type;

1924: l_line_tbl OE_ORDER_PUB.line_tbl_type := p_x_line_tbl;
1925: l_line_out_tbl OE_ORDER_PUB.line_tbl_type;
1926: l_model_ratio NUMBER;
1927: l_line_rec OE_ORDER_PUB.line_rec_type;
1928: l_option_line OE_ORDER_PUB.line_rec_type;
1929: l_tbl_count NUMBER := 0;
1930: l_min_model NUMBER := 0;
1931: l_max_ship_model NUMBER := 0;
1932: l_temp_min_model NUMBER := 0;

Line 2168: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type

2164: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2165: END Cascade_Non_Proportional_Split;
2166:
2167: PROCEDURE Record_line_History
2168: ( p_line_rec IN OE_Order_PUB.Line_Rec_Type
2169: )IS
2170: l_return_status varchar2(30);
2171: --
2172: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2200: Procedure Add_To_Fulfillment_Set(p_line_rec IN oe_order_pub.line_rec_type) IS

2196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2197: End Record_line_History;
2198:
2199:
2200: Procedure Add_To_Fulfillment_Set(p_line_rec IN oe_order_pub.line_rec_type) IS
2201: -- 4925992
2202: l_top_model_line_id NUMBER;
2203: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2204:

Line 2243: l_line_tbl OE_Order_PUB.Line_Tbl_Type;

2239: IS
2240:
2241: -- Cursor Decleration
2242:
2243: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2244: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2245: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2246: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2247: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

Line 2244: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;

2240:
2241: -- Cursor Decleration
2242:
2243: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2244: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2245: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2246: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2247: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2248: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

Line 2245: l_x_header_rec OE_Order_PUB.Header_Rec_Type;

2241: -- Cursor Decleration
2242:
2243: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2244: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2245: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2246: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2247: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2248: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2249: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

Line 2246: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;

2242:
2243: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2244: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2245: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2246: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2247: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2248: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2249: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2250: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

Line 2247: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;

2243: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2244: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2245: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2246: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2247: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2248: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2249: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2250: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2251: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

Line 2248: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;

2244: l_x_line_tbl OE_Order_PUB.Line_Tbl_Type;
2245: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2246: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2247: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2248: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2249: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2250: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2251: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2252: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

Line 2249: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;

2245: l_x_header_rec OE_Order_PUB.Header_Rec_Type;
2246: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2247: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2248: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2249: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2250: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2251: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2252: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2253: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

Line 2250: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;

2246: l_x_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2247: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2248: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2249: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2250: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2251: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2252: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2253: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2254: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

Line 2251: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;

2247: l_x_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2248: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2249: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2250: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2251: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2252: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2253: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2254: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2255: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

Line 2252: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;

2248: l_x_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2249: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2250: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2251: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2252: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2253: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2254: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2255: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2256: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

Line 2253: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;

2249: l_x_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2250: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2251: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2252: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2253: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2254: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2255: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2256: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2257: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

Line 2254: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;

2250: l_x_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
2251: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2252: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2253: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2254: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2255: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2256: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2257: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2258: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

Line 2255: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;

2251: l_x_Lot_Serial_Tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2252: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2253: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2254: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2255: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2256: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2257: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2258: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2259: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

Line 2256: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;

2252: l_x_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
2253: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2254: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2255: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2256: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2257: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2258: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2259: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2260: l_control_rec OE_GLOBALS.Control_Rec_Type;

Line 2257: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;

2253: l_x_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
2254: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2255: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2256: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2257: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2258: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2259: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2260: l_control_rec OE_GLOBALS.Control_Rec_Type;
2261: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;

Line 2258: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;

2254: l_x_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
2255: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2256: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2257: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2258: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2259: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2260: l_control_rec OE_GLOBALS.Control_Rec_Type;
2261: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2262: l_line_conc_rec OE_Split_Util.Split_Line_Rec_Type;

Line 2259: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;

2255: l_x_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
2256: l_x_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
2257: l_x_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
2258: l_x_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2259: l_x_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2260: l_control_rec OE_GLOBALS.Control_Rec_Type;
2261: l_debug_level CONSTANT NUMBER := oe_debug_pub.g_debug_level;
2262: l_line_conc_rec OE_Split_Util.Split_Line_Rec_Type;
2263: l_line_conc_tbl OE_Split_Util.Split_Line_Tbl_Type;

Line 2457: l_line_tbl(i):= OE_ORDER_PUB.G_MISS_LINE_REC;

2453:
2454: IF l_x_line_tbl.count > 0 THEN
2455: l_line_tbl.delete;
2456: FOR i IN l_line_conc_tbl.FIRST .. l_line_conc_tbl.LAST LOOP
2457: l_line_tbl(i):= OE_ORDER_PUB.G_MISS_LINE_REC;
2458: IF l_line_conc_tbl(i).ship_to_org_id IS NOT NULL THEN
2459: IF NVL(l_x_line_tbl(i).ship_to_org_id,-1) <>
2460: NVL(l_line_conc_tbl(i).ship_to_org_id,-1) THEN
2461: l_line_tbl(i).ship_to_org_id := l_line_conc_tbl(i).ship_to_org_id;

Line 2517: l_line_tbl(l_rec_count) := OE_ORDER_PUB.G_MISS_LINE_REC;

2513: l_rec_count := l_line_tbl.last + 1;
2514:
2515: FOR i IN l_x_line_tbl.FIRST .. l_x_line_tbl.LAST LOOP
2516: IF l_x_line_tbl(i).item_type_code = 'SERVICE' THEN
2517: l_line_tbl(l_rec_count) := OE_ORDER_PUB.G_MISS_LINE_REC;
2518: FOR j IN l_x_line_tbl.FIRST .. l_x_line_tbl.LAST LOOP
2519: IF l_x_line_tbl(i).service_reference_line_id = l_x_line_tbl(j).line_id THEN
2520: l_line_id := NVL(l_x_line_tbl(j).top_model_line_id,
2521: l_x_line_tbl(j).line_id);