[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);
2313: l_api_version_number CONSTANT NUMBER := 1.0;
2314: l_api_name CONSTANT VARCHAR2(30):= 'Update_Order';
2315: l_control_rec OE_GLOBALS.Control_Rec_Type;
2316: l_return_status VARCHAR2(1);
2317: l_header_rec OE_Order_PUB.Header_Rec_Type;
2318: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2319: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2320: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2321: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2314: l_api_name CONSTANT VARCHAR2(30):= 'Update_Order';
2315: l_control_rec OE_GLOBALS.Control_Rec_Type;
2316: l_return_status VARCHAR2(1);
2317: l_header_rec OE_Order_PUB.Header_Rec_Type;
2318: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2319: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2320: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2321: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2322: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2315: l_control_rec OE_GLOBALS.Control_Rec_Type;
2316: l_return_status VARCHAR2(1);
2317: l_header_rec OE_Order_PUB.Header_Rec_Type;
2318: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2319: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2320: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2321: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2322: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2323: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2316: l_return_status VARCHAR2(1);
2317: l_header_rec OE_Order_PUB.Header_Rec_Type;
2318: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2319: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2320: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2321: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2322: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2323: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2324: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2317: l_header_rec OE_Order_PUB.Header_Rec_Type;
2318: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2319: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2320: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2321: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2322: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2323: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2324: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2325: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2318: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2319: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2320: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2321: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2322: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2323: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2324: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2325: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2326: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2319: l_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2320: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2321: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2322: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2323: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2324: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2325: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2326: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2327: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2320: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2321: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2322: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2323: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2324: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2325: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2326: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2327: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2328: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2321: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2322: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2323: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2324: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2325: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2326: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2327: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2328: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2329: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2322: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2323: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2324: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2325: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2326: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2327: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2328: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2329: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2330: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2323: l_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2324: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2325: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2326: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2327: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2328: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2329: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2330: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2331: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2324: l_Header_Payment_val_tbl OE_Order_PUB.Header_Payment_Val_Tbl_Type;
2325: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2326: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2327: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2328: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2329: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2330: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2331: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2332: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2325: l_line_tbl OE_Order_PUB.Line_Tbl_Type;
2326: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2327: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2328: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2329: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2330: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2331: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2332: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2333: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2326: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2327: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2328: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2329: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2330: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2331: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2332: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2333: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2334: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2327: l_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2328: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2329: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2330: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2331: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2332: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2333: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2334: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2335: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2328: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2329: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2330: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2331: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2332: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2333: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2334: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2335: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2336: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2329: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2330: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2331: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2332: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2333: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2334: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2335: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2336: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2337: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2330: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2331: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2332: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2333: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2334: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2335: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2336: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2337: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2338: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2331: l_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2332: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2333: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2334: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2335: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2336: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2337: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2338: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2339: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2332: l_Line_Payment_val_tbl OE_Order_PUB.Line_Payment_Val_Tbl_Type;
2333: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2334: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2335: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2336: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2337: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2338: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2339: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2340: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2333: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2334: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2335: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2336: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2337: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2338: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2339: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2340: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2341: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2334: l_old_header_rec OE_Order_PUB.Header_Rec_Type;
2335: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2336: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2337: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2338: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2339: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2340: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2341: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2342: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2335: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2336: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2337: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2338: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2339: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2340: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2341: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2342: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2343: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2336: l_old_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2337: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2338: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2339: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2340: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2341: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2342: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2343: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2344: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2337: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2338: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2339: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2340: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2341: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2342: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2343: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2344: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2345: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2338: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2339: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2340: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2341: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2342: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2343: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2344: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2345: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2346: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2339: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2340: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2341: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2342: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2343: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2344: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2345: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2346: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2347: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2340: l_old_line_tbl OE_Order_PUB.Line_Tbl_Type;
2341: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2342: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2343: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2344: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2345: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2346: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2347: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2348: OE_Order_PUB.G_MISS_REQUEST_TBL;
2341: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2342: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2343: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2344: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2345: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2346: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2347: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2348: OE_Order_PUB.G_MISS_REQUEST_TBL;
2349:
2342: l_old_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2343: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2344: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2345: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2346: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2347: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2348: OE_Order_PUB.G_MISS_REQUEST_TBL;
2349:
2350: l_return_values varchar2(50);
2343: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2344: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2345: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2346: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2347: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2348: OE_Order_PUB.G_MISS_REQUEST_TBL;
2349:
2350: l_return_values varchar2(50);
2351: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2344: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2345: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2346: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2347: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2348: OE_Order_PUB.G_MISS_REQUEST_TBL;
2349:
2350: l_return_values varchar2(50);
2351: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2352: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2347: l_request_tbl OE_Order_PUB.Request_Tbl_Type :=
2348: OE_Order_PUB.G_MISS_REQUEST_TBL;
2349:
2350: l_return_values varchar2(50);
2351: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2352: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2353: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2354: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2355: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2348: OE_Order_PUB.G_MISS_REQUEST_TBL;
2349:
2350: l_return_values varchar2(50);
2351: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2352: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2353: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2354: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2355: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2356: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2349:
2350: l_return_values varchar2(50);
2351: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2352: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2353: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2354: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2355: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2356: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2357: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2350: l_return_values varchar2(50);
2351: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2352: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2353: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2354: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2355: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2356: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2357: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2358: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2351: l_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2352: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2353: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2354: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2355: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2356: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2357: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2358: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2359: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2352: l_old_header_val_rec OE_Order_PUB.Header_Val_Rec_Type;
2353: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2354: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2355: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2356: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2357: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2358: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2359: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2360: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2353: l_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2354: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2355: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2356: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2357: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2358: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2359: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2360: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2361: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2354: l_old_header_adj_val_tbl OE_Order_PUB.Header_Adj_Val_Tbl_Type;
2355: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2356: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2357: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2358: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2359: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2360: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2361: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2362: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2355: l_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2356: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2357: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2358: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2359: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2360: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2361: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2362: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2363: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2356: l_old_header_scredit_val_tbl OE_Order_PUB.Header_Scredit_Val_Tbl_Type;
2357: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2358: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2359: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2360: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2361: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2362: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2363: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2364: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2357: l_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2358: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2359: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2360: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2361: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2362: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2363: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2364: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2365:
2358: l_old_line_val_tbl OE_Order_PUB.Line_Val_Tbl_Type;
2359: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2360: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2361: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2362: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2363: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2364: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2365:
2366: -- hyang: bug 2692785
2359: l_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2360: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2361: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2362: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2363: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2364: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2365:
2366: -- hyang: bug 2692785
2367: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2360: l_old_line_adj_val_tbl OE_Order_PUB.Line_Adj_Val_Tbl_Type;
2361: l_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2362: l_old_line_scredit_val_tbl OE_Order_PUB.Line_Scredit_Val_Tbl_Type;
2363: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2364: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2365:
2366: -- hyang: bug 2692785
2367: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2368: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2363: l_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2364: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2365:
2366: -- hyang: bug 2692785
2367: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2368: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2369: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2370: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2371: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2364: l_old_lot_serial_val_tbl OE_Order_PUB.Lot_Serial_Val_Tbl_Type;
2365:
2366: -- hyang: bug 2692785
2367: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2368: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2369: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2370: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2371: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2372: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2365:
2366: -- hyang: bug 2692785
2367: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2368: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2369: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2370: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2371: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2372: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2373: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2366: -- hyang: bug 2692785
2367: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2368: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2369: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2370: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2371: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2372: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2373: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2374: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2367: lx_header_rec OE_Order_PUB.Header_Rec_Type;
2368: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2369: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2370: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2371: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2372: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2373: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2374: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2375: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2368: lx_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
2369: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2370: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2371: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2372: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2373: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2374: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2375: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2376: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2369: lx_Header_price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type ;
2370: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2371: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2372: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2373: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2374: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2375: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2376: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2377: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2370: lx_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type ;
2371: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2372: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2373: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2374: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2375: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2376: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2377: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2378: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2371: lx_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type ;
2372: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2373: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2374: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2375: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2376: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2377: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2378: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2379: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2372: lx_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
2373: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2374: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2375: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2376: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2377: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2378: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2379: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2380: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2373: lx_Header_Payment_tbl OE_Order_PUB.Header_Payment_Tbl_Type;
2374: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2375: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2376: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2377: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2378: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2379: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2380: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2381: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2374: lx_line_tbl OE_Order_PUB.Line_Tbl_Type;
2375: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2376: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2377: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2378: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2379: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2380: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2381: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2382: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2375: lx_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
2376: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2377: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2378: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2379: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2380: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2381: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2382: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2383:
2376: lx_Line_price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type ;
2377: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2378: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2379: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2380: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2381: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2382: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2383:
2384: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');
2377: lx_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type ;
2378: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2379: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2380: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2381: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2382: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2383:
2384: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');
2385: l_CC_Auth_Prof VARCHAR2(2) := FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED');
2378: lx_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type ;
2379: lx_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
2380: lx_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
2381: lx_Line_Payment_tbl OE_Order_PUB.Line_Payment_Tbl_Type;
2382: lx_request_tbl OE_Order_PUB.Request_Tbl_Type;
2383:
2384: l_split_pay_prof VARCHAR2(2) := FND_PROFILE.Value('ASO_ENABLE_SPLIT_PAYMENT');
2385: l_CC_Auth_Prof VARCHAR2(2) := FND_PROFILE.Value('ASO_CC_AUTHORIZATION_ENABLED');
2386: l_Enable_Risk_Mgmt_Prof VARCHAR2(2);