[Home] [Help]
16:
17:
18: PROCEDURE Initialize_OM_rec_types
19: (
20: px_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
21: px_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
22: p_line_tbl_count IN NUMBER
23: )
24: IS
17:
18: PROCEDURE Initialize_OM_rec_types
19: (
20: px_header_rec IN OUT NOCOPY OE_Order_PUB.Header_Rec_Type,
21: px_line_tbl IN OUT NOCOPY OE_Order_PUB.Line_Tbl_Type,
22: p_line_tbl_count IN NUMBER
23: )
24: IS
25: BEGIN
23: )
24: IS
25: BEGIN
26:
27: px_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
28: FOR i in 1..p_line_tbl_count LOOP
29: px_line_tbl(i) := OE_Order_PUB.G_MISS_LINE_REC;
30: END LOOP;
31:
25: BEGIN
26:
27: px_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
28: FOR i in 1..p_line_tbl_count LOOP
29: px_line_tbl(i) := OE_Order_PUB.G_MISS_LINE_REC;
30: END LOOP;
31:
32: /* the following record types are exact replicas of OM record types
33: and are initialized to G_MISS values in aso_order_int.
31:
32: /* the following record types are exact replicas of OM record types
33: and are initialized to G_MISS values in aso_order_int.
34:
35: px_Header_Scredit_tbl := OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
36: px_Line_Scredit_tbl := OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
37: px_Lot_Serial_tbl := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
38: */
39:
32: /* the following record types are exact replicas of OM record types
33: and are initialized to G_MISS values in aso_order_int.
34:
35: px_Header_Scredit_tbl := OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
36: px_Line_Scredit_tbl := OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
37: px_Lot_Serial_tbl := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
38: */
39:
40: END Initialize_OM_rec_types;
33: and are initialized to G_MISS values in aso_order_int.
34:
35: px_Header_Scredit_tbl := OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
36: px_Line_Scredit_tbl := OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
37: px_Lot_Serial_tbl := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
38: */
39:
40: END Initialize_OM_rec_types;
41:
1028: RAISE FND_API.G_EXC_ERROR;
1029: END IF;
1030:
1031:
1032: OE_ORDER_PUB.Delete_Order
1033: (
1034: p_header_id => p_order_header_id
1035: , x_return_status => x_return_status
1036: , x_msg_count => x_msg_count
1113:
1114:
1115:
1116:
1117: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
1118: OE_Order_PUB.G_MISS_REQUEST_TBL;
1119: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1120:
1121: l_control_rec OE_GLOBALS.Control_Rec_Type;
1114:
1115:
1116:
1117: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
1118: OE_Order_PUB.G_MISS_REQUEST_TBL;
1119: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1120:
1121: l_control_rec OE_GLOBALS.Control_Rec_Type;
1122: l_return_status VARCHAR2(1);
1119: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1120:
1121: l_control_rec OE_GLOBALS.Control_Rec_Type;
1122: l_return_status VARCHAR2(1);
1123: l_header_rec OE_Order_PUB.Header_Rec_Type;
1124: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1125: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1126: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1127: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1120:
1121: l_control_rec OE_GLOBALS.Control_Rec_Type;
1122: l_return_status VARCHAR2(1);
1123: l_header_rec OE_Order_PUB.Header_Rec_Type;
1124: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1125: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1126: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1127: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1128: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1121: l_control_rec OE_GLOBALS.Control_Rec_Type;
1122: l_return_status VARCHAR2(1);
1123: l_header_rec OE_Order_PUB.Header_Rec_Type;
1124: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1125: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1126: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1127: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1128: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1129: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1122: l_return_status VARCHAR2(1);
1123: l_header_rec OE_Order_PUB.Header_Rec_Type;
1124: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1125: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1126: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1127: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1128: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1129: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1130: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1123: l_header_rec OE_Order_PUB.Header_Rec_Type;
1124: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1125: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1126: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1127: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1128: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1129: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1130: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1131: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1124: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1125: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1126: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1127: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1128: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1129: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1130: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1131: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1132: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1125: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1126: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1127: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1128: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1129: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1130: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1131: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1132: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1133: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1126: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1127: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1128: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1129: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1130: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1131: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1132: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1133: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1134: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1127: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1128: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1129: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1130: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1131: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1132: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1133: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1134: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1135: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1128: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1129: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1130: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1131: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1132: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1133: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1134: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1135: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1136: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1129: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1130: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1131: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1132: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1133: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1134: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1135: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1136: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1130: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1131: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1132: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1133: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1134: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1135: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1136: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1138: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1131: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1132: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1133: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1134: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1135: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1136: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1138: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1139: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1132: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1133: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1134: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1135: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1136: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1138: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1139: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1140: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1133: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1134: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1135: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1136: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1138: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1139: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1140: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1141: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1134: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1135: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1136: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1138: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1139: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1140: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1141: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1142: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1135: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1136: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1138: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1139: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1140: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1141: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1142: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1143: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1136: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1137: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1138: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1139: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1140: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1141: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1142: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1143: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1144: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1137: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1138: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1139: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1140: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1141: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1142: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1143: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1144: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1145: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1138: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1139: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1140: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1141: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1142: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1143: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1144: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1145: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1146: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1139: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1140: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1141: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1142: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1143: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1144: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1145: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1146: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1147: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1140: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1141: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1142: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1143: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1144: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1145: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1146: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1147: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1148: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1141: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1142: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1143: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1144: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1145: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1146: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1147: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1148: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1149: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1142: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1143: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1144: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1145: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1146: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1147: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1148: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1149: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1150:
1143: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1144: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1145: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1146: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1147: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1148: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1149: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1150:
1151:
1144: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1145: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1146: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1147: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1148: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1149: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1150:
1151:
1152: l_return_values varchar2(50);
1145: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1146: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1147: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1148: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1149: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1150:
1151:
1152: l_return_values varchar2(50);
1153: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1149: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1150:
1151:
1152: l_return_values varchar2(50);
1153: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1154: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1155: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1156: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1157: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1150:
1151:
1152: l_return_values varchar2(50);
1153: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1154: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1155: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1156: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1157: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1158: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1151:
1152: l_return_values varchar2(50);
1153: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1154: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1155: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1156: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1157: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1158: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1152: l_return_values varchar2(50);
1153: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1154: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1155: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1156: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1157: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1158: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1160: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1153: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1154: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1155: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1156: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1157: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1158: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1160: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1161: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1154: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1155: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1156: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1157: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1158: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1160: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1161: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1162: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1155: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1156: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1157: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1158: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1160: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1161: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1162: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1163: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1156: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1157: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1158: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1160: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1161: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1162: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1163: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1164: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1157: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1158: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1160: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1161: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1162: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1163: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1164: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1165: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1158: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1160: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1161: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1162: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1163: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1164: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1165: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1166: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1159: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1160: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1161: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1162: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1163: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1164: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1165: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1166: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1167: l_msg_count number;
1160: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1161: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1162: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1163: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1164: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1165: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1166: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1167: l_msg_count number;
1168: l_msg_data varchar2(200);
1161: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1162: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1163: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1164: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1165: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1166: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1167: l_msg_count number;
1168: l_msg_data varchar2(200);
1169:
1162: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1163: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1164: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1165: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1166: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1167: l_msg_count number;
1168: l_msg_data varchar2(200);
1169:
1170: -- hyang: 2692785
1167: l_msg_count number;
1168: l_msg_data varchar2(200);
1169:
1170: -- hyang: 2692785
1171: lx_header_rec OE_Order_PUB.Header_Rec_Type;
1172:
1173: BEGIN
1174: -- Standard Start of API savepoint
1175: SAVEPOINT Book_Order_PUB;
1360:
1361:
1362:
1363:
1364: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
1365: OE_Order_PUB.G_MISS_REQUEST_TBL;
1366: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1367:
1368: l_control_rec OE_GLOBALS.Control_Rec_Type;
1361:
1362:
1363:
1364: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
1365: OE_Order_PUB.G_MISS_REQUEST_TBL;
1366: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1367:
1368: l_control_rec OE_GLOBALS.Control_Rec_Type;
1369: l_return_status VARCHAR2(1);
1366: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1367:
1368: l_control_rec OE_GLOBALS.Control_Rec_Type;
1369: l_return_status VARCHAR2(1);
1370: l_header_rec OE_Order_PUB.Header_Rec_Type;
1371: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1372: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1373: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1374: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1367:
1368: l_control_rec OE_GLOBALS.Control_Rec_Type;
1369: l_return_status VARCHAR2(1);
1370: l_header_rec OE_Order_PUB.Header_Rec_Type;
1371: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1372: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1373: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1374: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1375: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1368: l_control_rec OE_GLOBALS.Control_Rec_Type;
1369: l_return_status VARCHAR2(1);
1370: l_header_rec OE_Order_PUB.Header_Rec_Type;
1371: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1372: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1373: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1374: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1375: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1376: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1369: l_return_status VARCHAR2(1);
1370: l_header_rec OE_Order_PUB.Header_Rec_Type;
1371: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1372: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1373: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1374: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1375: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1376: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1377: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1370: l_header_rec OE_Order_PUB.Header_Rec_Type;
1371: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1372: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1373: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1374: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1375: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1376: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1377: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1378: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1371: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1372: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1373: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1374: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1375: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1376: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1377: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1378: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1379: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1372: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1373: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1374: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1375: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1376: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1377: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1378: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1379: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1380: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1373: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1374: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1375: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1376: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1377: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1378: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1379: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1380: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1381: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1374: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1375: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1376: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1377: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1378: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1379: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1380: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1381: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1382: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1375: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1376: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1377: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1378: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1379: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1380: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1381: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1382: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1383: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1376: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1377: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1378: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1379: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1380: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1381: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1382: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1383: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1384: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1377: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1378: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1379: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1380: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1381: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1382: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1383: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1384: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1385: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1378: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1379: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1380: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1381: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1382: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1383: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1384: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1385: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1386: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1379: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1380: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1381: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1382: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1383: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1384: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1385: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1386: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1387: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1380: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1381: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1382: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1383: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1384: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1385: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1386: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1387: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1388: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1381: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1382: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1383: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1384: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1385: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1386: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1387: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1388: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1389: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1382: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1383: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1384: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1385: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1386: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1387: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1388: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1389: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1390: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1383: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1384: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1385: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1386: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1387: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1388: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1389: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1390: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1391: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1384: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1385: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1386: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1387: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1388: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1389: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1390: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1391: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1392: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1385: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1386: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1387: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1388: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1389: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1390: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1391: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1392: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1393: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1386: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1387: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1388: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1389: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1390: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1391: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1392: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1393: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1394: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1387: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1388: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1389: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1390: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1391: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1392: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1393: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1394: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1395: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1388: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1389: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1390: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1391: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1392: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1393: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1394: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1395: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1396: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1389: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1390: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1391: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1392: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1393: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1394: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1395: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1396: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1397:
1390: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1391: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1392: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1393: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1394: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1395: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1396: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1397:
1398:
1391: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1392: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1393: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1394: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1395: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1396: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1397:
1398:
1399: l_return_values varchar2(50);
1392: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1393: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1394: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1395: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1396: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1397:
1398:
1399: l_return_values varchar2(50);
1400: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1396: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1397:
1398:
1399: l_return_values varchar2(50);
1400: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1401: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1402: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1403: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1404: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1397:
1398:
1399: l_return_values varchar2(50);
1400: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1401: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1402: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1403: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1404: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1405: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1398:
1399: l_return_values varchar2(50);
1400: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1401: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1402: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1403: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1404: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1405: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1406: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1399: l_return_values varchar2(50);
1400: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1401: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1402: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1403: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1404: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1405: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1406: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1407: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1400: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1401: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1402: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1403: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1404: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1405: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1406: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1407: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1408: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1401: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1402: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1403: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1404: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1405: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1406: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1407: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1408: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1409: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1402: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1403: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1404: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1405: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1406: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1407: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1408: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1409: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1410: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1403: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1404: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1405: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1406: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1407: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1408: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1409: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1410: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1411: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1404: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1405: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1406: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1407: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1408: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1409: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1410: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1411: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1412: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1405: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1406: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1407: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1408: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1409: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1410: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1411: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1412: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1413: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1406: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1407: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1408: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1409: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1410: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1411: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1412: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1413: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1414: l_msg_count number;
1407: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1408: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1409: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1410: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1411: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1412: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1413: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1414: l_msg_count number;
1415: l_msg_data varchar2(200);
1408: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1409: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1410: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1411: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1412: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1413: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1414: l_msg_count number;
1415: l_msg_data varchar2(200);
1416:
1409: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1410: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1411: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1412: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1413: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1414: l_msg_count number;
1415: l_msg_data varchar2(200);
1416:
1417: -- hyang: 2692785
1414: l_msg_count number;
1415: l_msg_data varchar2(200);
1416:
1417: -- hyang: 2692785
1418: lx_header_rec OE_Order_PUB.Header_Rec_Type;
1419:
1420: CURSOR C_cancel_reason IS
1421: SELECT lookup_code
1422: from oe_lookups
1663:
1664: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1665:
1666: -- header record types
1667: l_header_rec OE_Order_PUB.Header_Rec_Type;
1668: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1669: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1670: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1671: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1664: l_line_shipment_tbl ASO_QUOTE_PUB.Shipment_Tbl_Type;
1665:
1666: -- header record types
1667: l_header_rec OE_Order_PUB.Header_Rec_Type;
1668: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1669: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1670: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1671: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1672: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1665:
1666: -- header record types
1667: l_header_rec OE_Order_PUB.Header_Rec_Type;
1668: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1669: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1670: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1671: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1672: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1673: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1666: -- header record types
1667: l_header_rec OE_Order_PUB.Header_Rec_Type;
1668: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1669: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1670: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1671: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1672: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1673: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1674: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
1667: l_header_rec OE_Order_PUB.Header_Rec_Type;
1668: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1669: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1670: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1671: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1672: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1673: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1674: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
1675: -- line record types
1668: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1669: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1670: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1671: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1672: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1673: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1674: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
1675: -- line record types
1676: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1669: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1670: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1671: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1672: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1673: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1674: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
1675: -- line record types
1676: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1677: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1670: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1671: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1672: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1673: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1674: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
1675: -- line record types
1676: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1677: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1678: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1672: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1673: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1674: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
1675: -- line record types
1676: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1677: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1678: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1679: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1680: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1673: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1674: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
1675: -- line record types
1676: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1677: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1678: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1679: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1680: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1681: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1674: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
1675: -- line record types
1676: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1677: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1678: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1679: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1680: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1681: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1682: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1675: -- line record types
1676: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1677: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1678: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1679: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1680: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1681: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1682: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1683: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
1676: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
1677: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1678: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1679: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1680: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1681: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1682: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1683: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
1684:
1677: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1678: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1679: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1680: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1681: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1682: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1683: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
1684:
1685: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1678: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1679: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1680: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1681: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1682: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1683: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
1684:
1685: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1686: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1679: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1680: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1681: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1682: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1683: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
1684:
1685: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1686: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1687: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1681: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1682: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1683: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
1684:
1685: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1686: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1687: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1688: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1689: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1682: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1683: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
1684:
1685: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1686: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1687: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1688: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1689: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1690: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1683: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
1684:
1685: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1686: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1687: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1688: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1689: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1690: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1691: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1684:
1685: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1686: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1687: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1688: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1689: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1690: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1691: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1692: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1685: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1686: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1687: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1688: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1689: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1690: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1691: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1692: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1693: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1686: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
1687: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1688: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1689: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1690: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1691: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1692: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1693: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1694: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1687: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1688: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1689: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1690: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1691: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1692: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1693: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1694: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1695: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1688: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1689: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1690: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1691: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1692: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1693: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1694: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1695: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1696: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1689: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1690: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1691: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1692: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1693: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1694: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1695: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1696: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1690: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1691: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1692: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1693: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1694: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1695: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1696: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1698: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1691: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1692: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1693: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1694: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1695: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1696: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1698: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1699: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1692: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
1693: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1694: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1695: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1696: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1698: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1699: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1700:
1693: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1694: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1695: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1696: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1698: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1699: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1700:
1701: l_return_values varchar2(50);
1694: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1695: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1696: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1698: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1699: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1700:
1701: l_return_values varchar2(50);
1702: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1695: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1696: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1697: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1698: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1699: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1700:
1701: l_return_values varchar2(50);
1702: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1703: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1698: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1699: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1700:
1701: l_return_values varchar2(50);
1702: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1703: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1704: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1705: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1706: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1699: l_action_request_tbl OE_Order_PUB.Request_Tbl_Type;
1700:
1701: l_return_values varchar2(50);
1702: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1703: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1704: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1705: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1706: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1707: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1700:
1701: l_return_values varchar2(50);
1702: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1703: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1704: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1705: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1706: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1707: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1708: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1701: l_return_values varchar2(50);
1702: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1703: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1704: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1705: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1706: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1707: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1708: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1709: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1702: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1703: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1704: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1705: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1706: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1707: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1708: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1709: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1710: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1703: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
1704: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1705: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1706: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1707: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1708: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1709: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1710: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1711: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1704: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1705: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1706: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1707: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1708: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1709: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1710: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1711: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1712: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1705: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
1706: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1707: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1708: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1709: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1710: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1711: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1712: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1713: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1706: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1707: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1708: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1709: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1710: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1711: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1712: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1713: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1714: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1707: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
1708: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1709: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1710: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1711: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1712: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1713: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1714: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1715: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1708: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1709: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1710: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1711: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1712: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1713: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1714: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1715: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1716: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
1709: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
1710: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1711: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1712: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1713: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1714: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1715: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1716: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
1717: OE_Order_PUB.G_MISS_REQUEST_TBL;
1710: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1711: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1712: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1713: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1714: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1715: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1716: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
1717: OE_Order_PUB.G_MISS_REQUEST_TBL;
1718:
1711: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
1712: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1713: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1714: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1715: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1716: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
1717: OE_Order_PUB.G_MISS_REQUEST_TBL;
1718:
1719: -- hyang: bug 2692785
1712: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1713: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1714: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1715: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1716: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
1717: OE_Order_PUB.G_MISS_REQUEST_TBL;
1718:
1719: -- hyang: bug 2692785
1720: lx_header_rec OE_Order_PUB.Header_Rec_Type;
1713: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
1714: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1715: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
1716: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
1717: OE_Order_PUB.G_MISS_REQUEST_TBL;
1718:
1719: -- hyang: bug 2692785
1720: lx_header_rec OE_Order_PUB.Header_Rec_Type;
1721: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1716: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
1717: OE_Order_PUB.G_MISS_REQUEST_TBL;
1718:
1719: -- hyang: bug 2692785
1720: lx_header_rec OE_Order_PUB.Header_Rec_Type;
1721: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1722: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1723: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1724: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1717: OE_Order_PUB.G_MISS_REQUEST_TBL;
1718:
1719: -- hyang: bug 2692785
1720: lx_header_rec OE_Order_PUB.Header_Rec_Type;
1721: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1722: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1723: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1724: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1725: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1718:
1719: -- hyang: bug 2692785
1720: lx_header_rec OE_Order_PUB.Header_Rec_Type;
1721: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1722: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1723: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1724: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1725: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1726: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1719: -- hyang: bug 2692785
1720: lx_header_rec OE_Order_PUB.Header_Rec_Type;
1721: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1722: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1723: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1724: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1725: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1726: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1727: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
1720: lx_header_rec OE_Order_PUB.Header_Rec_Type;
1721: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1722: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1723: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1724: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1725: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1726: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1727: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
1728: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1721: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1722: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1723: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1724: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1725: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1726: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1727: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
1728: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1729: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1722: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
1723: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1724: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1725: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1726: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1727: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
1728: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1729: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1730: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1723: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
1724: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1725: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1726: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1727: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
1728: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1729: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1730: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1731: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1724: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
1725: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1726: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1727: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
1728: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1729: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1730: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1731: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1732: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1725: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1726: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1727: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
1728: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1729: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1730: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1731: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1732: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1733: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1726: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
1727: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
1728: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1729: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1730: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1731: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1732: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1733: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1734: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1727: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
1728: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1729: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1730: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1731: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1732: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1733: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1734: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1735:
1728: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1729: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1730: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1731: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1732: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1733: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1734: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1735:
1736: -- needed for fulfillment
1729: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
1730: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1731: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1732: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1733: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1734: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1735:
1736: -- needed for fulfillment
1737: fulfil_index NUMBER := 1;
1730: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
1731: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
1732: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1733: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1734: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
1735:
1736: -- needed for fulfillment
1737: fulfil_index NUMBER := 1;
1738: l_electronic_flag varchar2(1);
2477: l_api_version_number CONSTANT NUMBER := 1.0;
2478: l_api_name CONSTANT VARCHAR2(30):= 'Update_Order';
2479: l_control_rec OE_GLOBALS.Control_Rec_Type;
2480: l_return_status VARCHAR2(1);
2481: l_header_rec OE_Order_PUB.Header_Rec_Type;
2482: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2483: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2484: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2485: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2478: l_api_name CONSTANT VARCHAR2(30):= 'Update_Order';
2479: l_control_rec OE_GLOBALS.Control_Rec_Type;
2480: l_return_status VARCHAR2(1);
2481: l_header_rec OE_Order_PUB.Header_Rec_Type;
2482: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2483: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2484: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2485: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2486: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2479: l_control_rec OE_GLOBALS.Control_Rec_Type;
2480: l_return_status VARCHAR2(1);
2481: l_header_rec OE_Order_PUB.Header_Rec_Type;
2482: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2483: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2484: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2485: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2486: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2487: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2480: l_return_status VARCHAR2(1);
2481: l_header_rec OE_Order_PUB.Header_Rec_Type;
2482: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2483: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2484: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2485: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2486: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2487: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2488: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2481: l_header_rec OE_Order_PUB.Header_Rec_Type;
2482: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2483: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2484: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2485: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2486: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2487: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2488: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2489: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2482: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2483: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2484: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2485: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2486: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2487: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2488: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2489: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2490: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2483: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2484: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2485: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2486: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2487: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2488: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2489: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2490: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2491: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2484: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2485: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2486: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2487: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2488: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2489: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2490: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2491: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2492: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2485: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2486: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2487: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2488: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2489: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2490: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2491: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2492: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2493: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2486: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2487: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2488: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2489: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2490: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2491: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2492: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2493: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2494: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2487: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2488: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2489: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2490: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2491: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2492: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2493: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2494: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2488: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2489: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2490: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2491: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2492: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2493: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2494: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2496: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2489: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2490: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2491: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2492: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2493: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2494: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2496: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2497: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2490: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2491: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2492: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2493: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2494: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2496: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2497: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2498: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2491: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2492: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2493: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2494: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2496: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2497: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2498: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2499: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2492: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2493: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2494: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2496: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2497: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2498: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2499: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2500: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2493: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2494: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2496: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2497: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2498: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2499: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2500: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2501: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2494: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2495: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2496: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2497: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2498: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2499: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2500: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2501: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2502: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2495: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2496: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2497: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2498: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2499: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2500: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2501: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2502: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2503: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2496: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2497: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2498: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2499: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2500: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2501: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2502: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2503: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2504: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2497: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2498: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2499: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2500: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2501: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2502: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2503: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2504: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2505: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2498: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2499: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2500: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2501: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2502: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2503: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2504: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2505: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2506: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2499: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2500: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2501: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2502: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2503: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2504: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2505: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2506: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2507: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2500: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2501: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2502: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2503: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2504: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2505: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2506: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2507: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2508: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2501: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2502: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2503: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2504: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2505: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2506: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2507: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2508: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2509: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2502: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2503: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2504: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2505: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2506: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2507: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2508: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2509: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2510: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2503: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2504: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2505: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2506: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2507: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2508: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2509: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2510: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2511: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2504: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2505: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2506: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2507: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2508: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2509: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2510: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2511: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2512: OE_Order_PUB.G_MISS_REQUEST_TBL;
2505: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2506: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2507: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2508: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2509: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2510: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2511: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2512: OE_Order_PUB.G_MISS_REQUEST_TBL;
2513:
2506: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2507: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2508: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2509: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2510: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2511: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2512: OE_Order_PUB.G_MISS_REQUEST_TBL;
2513:
2514: l_return_values varchar2(50);
2507: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2508: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2509: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2510: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2511: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2512: OE_Order_PUB.G_MISS_REQUEST_TBL;
2513:
2514: l_return_values varchar2(50);
2515: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2508: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2509: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2510: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2511: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2512: OE_Order_PUB.G_MISS_REQUEST_TBL;
2513:
2514: l_return_values varchar2(50);
2515: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2516: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2511: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2512: OE_Order_PUB.G_MISS_REQUEST_TBL;
2513:
2514: l_return_values varchar2(50);
2515: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2516: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2517: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2518: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2519: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2512: OE_Order_PUB.G_MISS_REQUEST_TBL;
2513:
2514: l_return_values varchar2(50);
2515: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2516: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2517: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2518: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2519: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2520: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2513:
2514: l_return_values varchar2(50);
2515: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2516: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2517: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2518: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2519: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2520: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2521: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2514: l_return_values varchar2(50);
2515: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2516: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2517: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2518: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2519: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2520: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2521: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2522: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2515: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2516: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2517: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2518: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2519: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2520: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2521: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2522: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2523: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2516: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2517: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2518: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2519: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2520: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2521: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2522: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2523: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2524: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2517: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2518: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2519: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2520: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2521: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2522: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2523: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2524: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2525: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2518: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2519: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2520: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2521: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2522: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2523: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2524: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2525: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2526: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2519: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2520: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2521: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2522: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2523: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2524: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2525: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2526: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2527: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2520: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2521: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2522: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2523: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2524: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2525: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2526: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2527: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2528: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2521: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2522: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2523: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2524: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2525: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2526: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2527: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2528: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2529:
2522: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2523: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2524: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2525: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2526: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2527: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2528: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2529:
2530: -- hyang: bug 2692785
2523: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2524: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2525: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2526: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2527: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2528: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2529:
2530: -- hyang: bug 2692785
2531: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2524: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2525: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2526: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2527: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2528: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2529:
2530: -- hyang: bug 2692785
2531: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2532: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2527: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2528: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2529:
2530: -- hyang: bug 2692785
2531: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2532: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2533: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2534: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2535: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2528: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2529:
2530: -- hyang: bug 2692785
2531: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2532: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2533: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2534: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2535: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2536: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2529:
2530: -- hyang: bug 2692785
2531: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2532: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2533: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2534: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2535: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2536: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2537: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2530: -- hyang: bug 2692785
2531: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2532: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2533: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2534: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2535: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2536: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2537: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2538: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2531: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2532: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2533: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2534: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2535: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2536: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2537: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2538: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2539: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2532: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2533: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2534: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2535: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2536: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2537: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2538: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2539: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2540: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2533: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2534: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2535: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2536: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2537: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2538: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2539: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2540: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2541: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2534: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2535: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2536: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2537: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2538: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2539: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2540: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2541: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2542: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2535: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2536: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2537: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2538: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2539: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2540: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2541: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2542: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2543: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2536: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2537: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2538: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2539: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2540: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2541: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2542: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2543: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2544: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2537: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2538: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2539: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2540: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2541: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2542: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2543: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2544: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2545: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2538: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2539: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2540: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2541: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2542: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2543: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2544: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2545: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2546: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2539: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2540: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2541: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2542: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2543: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2544: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2545: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2546: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2547:
2540: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2541: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2542: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2543: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2544: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2545: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2546: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2547:
2548: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');
2541: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2542: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2543: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2544: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2545: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2546: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2547:
2548: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');
2549: l_CC_Auth_Prof VARCHAR2(2) := FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED');
2542: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2543: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2544: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2545: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2546: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2547:
2548: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');
2549: l_CC_Auth_Prof VARCHAR2(2) := FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED');
2550: l_Enable_Risk_Mgmt_Prof VARCHAR2(2);