18:
19: PROCEDURE Header_Type_To_Rec
20: (
21: p_header_type IN SYSTEM.ASO_Header_Type,
22: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
23: )
24: IS
25:
26: BEGIN
24: IS
25:
26: BEGIN
27: IF p_header_type is NULL THEN
28: x_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;
29: return;
30: END IF;
31:
32: x_header_rec.accounting_rule_id := p_header_type.accounting_rule_id;
183:
184: PROCEDURE Header_Adj_Var_To_Tbl
185: (
186: p_header_adj_varray IN SYSTEM.ASO_Header_Adj_Var_Type,
187: x_header_adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
188: )
189: IS
190: i NUMBER;
191:
190: i NUMBER;
191:
192: BEGIN
193: IF p_header_adj_varray is NULL THEN
194: x_header_adj_tbl := OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;
195: return;
196: END IF;
197:
198: i := p_header_adj_varray.FIRST;
273:
274: PROCEDURE Header_Price_Att_Var_To_Tbl
275: (
276: p_header_price_att_varray IN SYSTEM.ASO_Header_Price_Att_Var_Type,
277: x_header_price_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
278: )
279: IS
280: i NUMBER;
281:
280: i NUMBER;
281:
282: BEGIN
283: IF p_header_price_att_varray is NULL THEN
284: x_header_price_att_tbl := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;
285: return;
286: END IF;
287:
288: i := p_header_price_att_varray.FIRST;
433:
434: PROCEDURE Header_Adj_Att_Var_To_Tbl
435: (
436: p_header_adj_att_varray IN SYSTEM.ASO_Header_Adj_Att_Var_Type,
437: x_header_adj_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
438: )
439: IS
440: i NUMBER;
441:
440: i NUMBER;
441:
442: BEGIN
443: IF p_header_adj_att_varray is NULL THEN
444: x_header_adj_att_tbl := OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;
445: return;
446: END IF;
447:
448: i := p_header_adj_att_varray.FIRST;
480:
481: PROCEDURE Header_Adj_Assoc_Var_To_Tbl
482: (
483: p_header_adj_assoc_varray IN SYSTEM.ASO_Header_Adj_Assoc_Var_Type,
484: x_header_adj_assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
485: )
486: IS
487: i NUMBER;
488:
487: i NUMBER;
488:
489: BEGIN
490: IF p_header_adj_assoc_varray is NULL THEN
491: x_header_adj_assoc_tbl := OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;
492: return;
493: END IF;
494:
495: i := p_header_adj_assoc_varray.FIRST;
523:
524: PROCEDURE Header_Scredit_Var_To_Tbl
525: (
526: p_header_scredit_varray IN SYSTEM.ASO_Header_Scredit_Var_Type,
527: x_header_scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
528: )
529: IS
530: i NUMBER;
531:
530: i NUMBER;
531:
532: BEGIN
533: IF p_header_scredit_varray is NULL THEN
534: x_header_scredit_tbl := OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;
535: return;
536: END IF;
537:
538: i := p_header_scredit_varray.FIRST;
583:
584: PROCEDURE Line_Var_To_Tbl
585: (
586: p_line_varray IN SYSTEM.ASO_Line_Var_Type,
587: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
588: )
589: IS
590: i NUMBER;
591:
590: i NUMBER;
591:
592: BEGIN
593: IF p_line_varray is NULL THEN
594: x_line_tbl := OE_Order_PUB.G_MISS_LINE_TBL;
595: return;
596: END IF;
597:
598: i := p_line_varray.FIRST;
915:
916: PROCEDURE Line_Adj_Var_To_Tbl
917: (
918: p_line_adj_varray IN SYSTEM.ASO_Line_Adj_Var_Type,
919: x_line_adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
920: )
921: IS
922: i NUMBER;
923:
922: i NUMBER;
923:
924: BEGIN
925: IF p_line_adj_varray is NULL THEN
926: x_line_adj_tbl := OE_Order_PUB.G_MISS_LINE_ADJ_TBL;
927: return;
928: END IF;
929:
930: i := p_line_adj_varray.FIRST;
1005:
1006: PROCEDURE Line_Price_Att_Var_To_Tbl
1007: (
1008: p_line_price_att_varray IN SYSTEM.ASO_Line_Price_Att_Var_Type,
1009: x_line_price_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1010: )
1011: IS
1012: i NUMBER;
1013:
1012: i NUMBER;
1013:
1014: BEGIN
1015: IF p_line_price_att_varray is NULL THEN
1016: x_line_price_att_tbl := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;
1017: return;
1018: END IF;
1019:
1020: i := p_line_price_att_varray.FIRST;
1165:
1166: PROCEDURE Line_Adj_Att_Var_To_Tbl
1167: (
1168: p_line_adj_att_varray IN SYSTEM.ASO_Line_Adj_Att_Var_Type,
1169: x_line_adj_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1170: )
1171: IS
1172: i NUMBER;
1173:
1172: i NUMBER;
1173:
1174: BEGIN
1175: IF p_line_adj_att_varray is NULL THEN
1176: x_line_adj_att_tbl := OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;
1177: return;
1178: END IF;
1179:
1180: i := p_line_adj_att_varray.FIRST;
1212:
1213: PROCEDURE Line_Adj_Assoc_Var_To_Tbl
1214: (
1215: p_line_adj_assoc_varray IN SYSTEM.ASO_Line_Adj_Assoc_Var_Type,
1216: x_line_adj_assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1217: )
1218: IS
1219: i NUMBER;
1220:
1219: i NUMBER;
1220:
1221: BEGIN
1222: IF p_line_adj_assoc_varray is NULL THEN
1223: x_line_adj_assoc_tbl := OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;
1224: return;
1225: END IF;
1226:
1227: i := p_line_adj_assoc_varray.FIRST;
1255:
1256: PROCEDURE Line_Scredit_Var_To_Tbl
1257: (
1258: p_line_scredit_varray IN SYSTEM.ASO_Line_Scredit_Var_Type,
1259: x_line_scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1260: )
1261: IS
1262: i NUMBER;
1263:
1262: i NUMBER;
1263:
1264: BEGIN
1265: IF p_line_scredit_varray is NULL THEN
1266: x_line_scredit_tbl := OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;
1267: return;
1268: END IF;
1269:
1270: i := p_line_scredit_varray.FIRST;
1316:
1317: PROCEDURE Lot_Serial_Var_To_Tbl
1318: (
1319: p_lot_serial_varray IN SYSTEM.ASO_Lot_Serial_Var_Type,
1320: x_lot_serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1321: )
1322: IS
1323: i NUMBER;
1324:
1323: i NUMBER;
1324:
1325: BEGIN
1326: IF p_lot_serial_varray is NULL THEN
1327: x_lot_serial_tbl := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;
1328: return;
1329: END IF;
1330:
1331: i := p_lot_serial_varray.FIRST;
1377:
1378: PROCEDURE Action_Request_Var_To_Tbl
1379: (
1380: p_action_request_varray IN SYSTEM.ASO_Request_Var_Type,
1381: x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1382: )
1383: IS
1384: i NUMBER;
1385:
1384: i NUMBER;
1385:
1386: BEGIN
1387: IF p_action_request_varray is NULL THEN
1388: x_action_request_tbl := OE_Order_PUB.G_MISS_REQUEST_TBL;
1389: return;
1390: END IF;
1391:
1392: i := p_action_request_varray.FIRST;
1474: --
1475: -- GET_NOTICE API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
1476: --
1477: -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1478: -- x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
1479: -- x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
1480: -- x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1481: -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1482: -- x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1475: -- GET_NOTICE API specific OUT NOCOPY /* file.sql.39 change */ Parameters:
1476: --
1477: -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1478: -- x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
1479: -- x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
1480: -- x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1481: -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1482: -- x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1483: -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1476: --
1477: -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1478: -- x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
1479: -- x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
1480: -- x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1481: -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1482: -- x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1483: -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1484: -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1477: -- x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2
1478: -- x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
1479: -- x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
1480: -- x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1481: -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1482: -- x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1483: -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1484: -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1485: -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1478: -- x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
1479: -- x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
1480: -- x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1481: -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1482: -- x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1483: -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1484: -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1485: -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1486: -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1479: -- x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type
1480: -- x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1481: -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1482: -- x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1483: -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1484: -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1485: -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1486: -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1487: -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1480: -- x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1481: -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1482: -- x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1483: -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1484: -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1485: -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1486: -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1487: -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1488: -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1481: -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type
1482: -- x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1483: -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1484: -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1485: -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1486: -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1487: -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1488: -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1489: -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1482: -- x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1483: -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1484: -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1485: -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1486: -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1487: -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1488: -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1489: -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1490: -- x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1483: -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type
1484: -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1485: -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1486: -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1487: -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1488: -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1489: -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1490: -- x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1491: -- x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1484: -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1485: -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1486: -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1487: -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1488: -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1489: -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1490: -- x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1491: -- x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1492: -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1485: -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type
1486: -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1487: -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1488: -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1489: -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1490: -- x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1491: -- x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1492: -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1493: -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1486: -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1487: -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1488: -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1489: -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1490: -- x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1491: -- x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1492: -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1493: -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1494: -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1487: -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type
1488: -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1489: -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1490: -- x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1491: -- x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1492: -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1493: -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1494: -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1495: -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1488: -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1489: -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1490: -- x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1491: -- x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1492: -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1493: -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1494: -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1495: -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1496: -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1489: -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type
1490: -- x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1491: -- x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1492: -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1493: -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1494: -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1495: -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1496: -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1497: -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1490: -- x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1491: -- x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1492: -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1493: -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1494: -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1495: -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1496: -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1497: -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1498: -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1491: -- x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type
1492: -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1493: -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1494: -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1495: -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1496: -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1497: -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1498: -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1499: -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1492: -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1493: -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1494: -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1495: -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1496: -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1497: -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1498: -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1499: -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1500: -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1493: -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type
1494: -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1495: -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1496: -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1497: -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1498: -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1499: -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1500: -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1501: -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1494: -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1495: -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1496: -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1497: -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1498: -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1499: -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1500: -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1501: -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1502: -- x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1495: -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type
1496: -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1497: -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1498: -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1499: -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1500: -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1501: -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1502: -- x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1503: -- x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1496: -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1497: -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1498: -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1499: -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1500: -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1501: -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1502: -- x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1503: -- x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1504: -- x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1497: -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type
1498: -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1499: -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1500: -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1501: -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1502: -- x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1503: -- x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1504: -- x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1505: --
1498: -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1499: -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1500: -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1501: -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1502: -- x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1503: -- x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1504: -- x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1505: --
1506: --
1499: -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type
1500: -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1501: -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1502: -- x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1503: -- x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1504: -- x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1505: --
1506: --
1507: -- Version : Current version 1.0
1500: -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1501: -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type
1502: -- x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1503: -- x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type
1504: -- x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1505: --
1506: --
1507: -- Version : Current version 1.0
1508: -- Initial version 1.0
1523: p_dequeue_mode IN NUMBER DEFAULT DBMS_AQ.REMOVE,
1524: p_navigation IN NUMBER DEFAULT DBMS_AQ.FIRST_MESSAGE,
1525: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
1526: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1527: x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1528: x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1529: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1530: x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1531: x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1524: p_navigation IN NUMBER DEFAULT DBMS_AQ.FIRST_MESSAGE,
1525: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
1526: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1527: x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1528: x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1529: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1530: x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1531: x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1532: x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1525: p_wait IN NUMBER DEFAULT DBMS_AQ.NO_WAIT,
1526: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1527: x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1528: x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1529: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1530: x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1531: x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1532: x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1533: x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1526: x_no_more_messages OUT NOCOPY /* file.sql.39 change */ VARCHAR2,
1527: x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1528: x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1529: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1530: x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1531: x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1532: x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1533: x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1534: x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1527: x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1528: x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1529: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1530: x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1531: x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1532: x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1533: x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1534: x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1535: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1528: x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,
1529: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1530: x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1531: x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1532: x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1533: x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1534: x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1535: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1536: x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1529: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1530: x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1531: x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1532: x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1533: x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1534: x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1535: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1536: x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1537: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1530: x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type,
1531: x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1532: x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1533: x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1534: x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1535: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1536: x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1537: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1538: x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1531: x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1532: x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1533: x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1534: x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1535: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1536: x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1537: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1538: x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1539: x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1532: x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type,
1533: x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1534: x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1535: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1536: x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1537: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1538: x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1539: x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1540: x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1533: x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1534: x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1535: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1536: x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1537: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1538: x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1539: x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1540: x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1541: x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1534: x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type,
1535: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1536: x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1537: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1538: x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1539: x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1540: x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1541: x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1542: x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1535: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1536: x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1537: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1538: x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1539: x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1540: x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1541: x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1542: x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1543: x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1536: x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type,
1537: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1538: x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1539: x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1540: x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1541: x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1542: x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1543: x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1544: x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1537: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1538: x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1539: x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1540: x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1541: x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1542: x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1543: x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1544: x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1545: x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1538: x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type,
1539: x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1540: x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1541: x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1542: x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1543: x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1544: x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1545: x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1546: x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1539: x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1540: x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1541: x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1542: x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1543: x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1544: x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1545: x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1546: x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1547: x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1540: x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type,
1541: x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1542: x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1543: x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1544: x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1545: x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1546: x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1547: x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1548: x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1541: x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1542: x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1543: x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1544: x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1545: x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1546: x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1547: x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1548: x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1549: x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1542: x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type,
1543: x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1544: x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1545: x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1546: x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1547: x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1548: x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1549: x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1550: x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1543: x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1544: x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1545: x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1546: x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1547: x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1548: x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1549: x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1550: x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1551: x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1544: x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type,
1545: x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1546: x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1547: x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1548: x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1549: x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1550: x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1551: x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1552: x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1545: x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1546: x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1547: x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1548: x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1549: x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1550: x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1551: x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1552: x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1553: x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1546: x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type,
1547: x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1548: x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1549: x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1550: x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1551: x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1552: x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1553: x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1554: ) IS
1547: x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1548: x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1549: x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1550: x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1551: x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1552: x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1553: x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1554: ) IS
1555: i number;
1548: x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type,
1549: x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1550: x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1551: x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1552: x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1553: x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1554: ) IS
1555: i number;
1556: l_api_name CONSTANT VARCHAR2(30) := 'GET_NOTICE';
1549: x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1550: x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type,
1551: x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1552: x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type,
1553: x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type
1554: ) IS
1555: i number;
1556: l_api_name CONSTANT VARCHAR2(30) := 'GET_NOTICE';
1557: l_api_version CONSTANT NUMBER := 1.0;
1559: l_dequeue_options dbms_aq.dequeue_options_t;
1560: l_message_properties dbms_aq.message_properties_t;
1561: l_msg_id RAW(16);
1562: l_message SYSTEM.ASO_Order_Feedback_Type;
1563: l_Header_rec OE_Order_PUB.Header_Rec_Type;
1564: l_old_Header_rec OE_Order_PUB.Header_Rec_Type;
1565: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1566: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1567: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1560: l_message_properties dbms_aq.message_properties_t;
1561: l_msg_id RAW(16);
1562: l_message SYSTEM.ASO_Order_Feedback_Type;
1563: l_Header_rec OE_Order_PUB.Header_Rec_Type;
1564: l_old_Header_rec OE_Order_PUB.Header_Rec_Type;
1565: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1566: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1567: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1568: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1561: l_msg_id RAW(16);
1562: l_message SYSTEM.ASO_Order_Feedback_Type;
1563: l_Header_rec OE_Order_PUB.Header_Rec_Type;
1564: l_old_Header_rec OE_Order_PUB.Header_Rec_Type;
1565: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1566: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1567: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1568: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1569: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1562: l_message SYSTEM.ASO_Order_Feedback_Type;
1563: l_Header_rec OE_Order_PUB.Header_Rec_Type;
1564: l_old_Header_rec OE_Order_PUB.Header_Rec_Type;
1565: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1566: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1567: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1568: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1569: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1570: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1563: l_Header_rec OE_Order_PUB.Header_Rec_Type;
1564: l_old_Header_rec OE_Order_PUB.Header_Rec_Type;
1565: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1566: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1567: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1568: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1569: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1570: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1571: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1564: l_old_Header_rec OE_Order_PUB.Header_Rec_Type;
1565: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1566: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1567: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1568: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1569: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1570: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1571: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1572: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1565: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1566: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1567: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1568: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1569: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1570: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1571: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1572: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1573: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1566: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_Tbl_Type;
1567: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1568: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1569: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1570: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1571: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1572: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1573: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1574: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1567: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1568: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1569: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1570: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1571: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1572: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1573: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1574: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1575: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1568: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_Tbl_Type;
1569: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1570: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1571: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1572: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1573: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1574: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1575: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1576: l_old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1569: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1570: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1571: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1572: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1573: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1574: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1575: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1576: l_old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1577: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1570: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_Tbl_Type;
1571: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1572: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1573: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1574: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1575: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1576: l_old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1577: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1578: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1571: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1572: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1573: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1574: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1575: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1576: l_old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1577: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1578: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1579: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1572: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_Tbl_Type;
1573: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1574: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1575: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1576: l_old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1577: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1578: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1579: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1580: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1573: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1574: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1575: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1576: l_old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1577: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1578: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1579: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1580: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1581: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1574: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_Tbl_Type;
1575: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1576: l_old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1577: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1578: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1579: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1580: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1581: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1582: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1575: l_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1576: l_old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1577: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1578: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1579: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1580: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1581: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1582: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1583: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1576: l_old_Line_tbl OE_Order_PUB.Line_Tbl_Type;
1577: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1578: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1579: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1580: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1581: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1582: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1583: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1584: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1577: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1578: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1579: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1580: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1581: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1582: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1583: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1584: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1585: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1578: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_Tbl_Type;
1579: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1580: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1581: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1582: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1583: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1584: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1585: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1586: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1579: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1580: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1581: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1582: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1583: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1584: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1585: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1586: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1587: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1580: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_Tbl_Type;
1581: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1582: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1583: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1584: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1585: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1586: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1587: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1588: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1581: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1582: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1583: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1584: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1585: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1586: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1587: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1588: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1589: l_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1582: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_Tbl_Type;
1583: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1584: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1585: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1586: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1587: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1588: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1589: l_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1590: no_message EXCEPTION;
1583: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1584: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1585: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1586: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1587: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1588: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1589: l_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1590: no_message EXCEPTION;
1591: pragma EXCEPTION_INIT(no_message, -25228);
1584: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_Tbl_Type;
1585: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1586: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1587: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1588: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1589: l_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1590: no_message EXCEPTION;
1591: pragma EXCEPTION_INIT(no_message, -25228);
1592:
1585: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1586: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_Tbl_Type;
1587: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1588: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_Tbl_Type;
1589: l_Action_Request_tbl OE_Order_PUB.Request_Tbl_Type;
1590: no_message EXCEPTION;
1591: pragma EXCEPTION_INIT(no_message, -25228);
1592:
1593: BEGIN