DBA Data[Home] [Help]

APPS.ASO_ORDER_FEEDBACK_GET_PVT dependencies on OE_ORDER_PUB

Line 22: x_header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type

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

Line 28: x_header_rec := OE_Order_PUB.G_MISS_HEADER_REC;

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;

Line 187: x_header_adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Tbl_Type

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:

Line 194: x_header_adj_tbl := OE_Order_PUB.G_MISS_HEADER_ADJ_TBL;

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;

Line 277: x_header_price_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_Tbl_Type

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:

Line 284: x_header_price_att_tbl := OE_Order_PUB.G_MISS_HEADER_PRICE_ATT_TBL;

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;

Line 437: x_header_adj_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_Tbl_Type

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:

Line 444: x_header_adj_att_tbl := OE_Order_PUB.G_MISS_HEADER_ADJ_ATT_TBL;

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;

Line 484: x_header_adj_assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_Tbl_Type

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:

Line 491: x_header_adj_assoc_tbl := OE_Order_PUB.G_MISS_HEADER_ADJ_ASSOC_TBL;

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;

Line 527: x_header_scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_Tbl_Type

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:

Line 534: x_header_scredit_tbl := OE_Order_PUB.G_MISS_HEADER_SCREDIT_TBL;

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;

Line 587: x_line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Tbl_Type

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:

Line 594: x_line_tbl := OE_Order_PUB.G_MISS_LINE_TBL;

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;

Line 919: x_line_adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Tbl_Type

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:

Line 926: x_line_adj_tbl := OE_Order_PUB.G_MISS_LINE_ADJ_TBL;

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;

Line 1009: x_line_price_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_Tbl_Type

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:

Line 1016: x_line_price_att_tbl := OE_Order_PUB.G_MISS_LINE_PRICE_ATT_TBL;

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;

Line 1169: x_line_adj_att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_Tbl_Type

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:

Line 1176: x_line_adj_att_tbl := OE_Order_PUB.G_MISS_LINE_ADJ_ATT_TBL;

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;

Line 1216: x_line_adj_assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_Tbl_Type

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:

Line 1223: x_line_adj_assoc_tbl := OE_Order_PUB.G_MISS_LINE_ADJ_ASSOC_TBL;

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;

Line 1259: x_line_scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_Tbl_Type

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:

Line 1266: x_line_scredit_tbl := OE_Order_PUB.G_MISS_LINE_SCREDIT_TBL;

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;

Line 1320: x_lot_serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_Tbl_Type

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:

Line 1327: x_lot_serial_tbl := OE_Order_PUB.G_MISS_LOT_SERIAL_TBL;

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;

Line 1381: x_action_request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_Tbl_Type

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:

Line 1388: x_action_request_tbl := OE_Order_PUB.G_MISS_REQUEST_TBL;

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;

Line 1478: -- x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type

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

Line 1479: -- x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_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

Line 1480: -- x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_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

Line 1481: -- x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_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

Line 1482: -- x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_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

Line 1483: -- x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_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

Line 1484: -- x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_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

Line 1485: -- x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_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

Line 1486: -- x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_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

Line 1487: -- x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_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

Line 1488: -- x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_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

Line 1489: -- x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_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

Line 1490: -- x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_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

Line 1491: -- x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_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

Line 1492: -- x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_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

Line 1493: -- x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_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

Line 1494: -- x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_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

Line 1495: -- x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_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

Line 1496: -- x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_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

Line 1497: -- x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_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

Line 1498: -- x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_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

Line 1499: -- x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_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

Line 1500: -- x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_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

Line 1501: -- x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_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: --

Line 1502: -- x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_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: --
1506: --

Line 1503: -- x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_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: --
1507: -- Version : Current version 1.0

Line 1504: -- x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_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
1508: -- Initial version 1.0

Line 1527: x_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_Type,

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,

Line 1528: x_old_Header_rec OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Rec_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,

Line 1529: x_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_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,

Line 1530: x_old_Header_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_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,

Line 1531: x_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_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,

Line 1532: x_old_Header_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Price_Att_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,

Line 1533: x_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_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,

Line 1534: x_old_Header_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Att_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,

Line 1535: x_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_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,

Line 1536: x_old_Header_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Adj_Assoc_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,

Line 1537: x_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_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,

Line 1538: x_old_Header_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Header_Scredit_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,

Line 1539: x_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_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,

Line 1540: x_old_Line_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_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,

Line 1541: x_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_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,

Line 1542: x_old_Line_Adj_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_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,

Line 1543: x_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_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,

Line 1544: x_old_Line_Price_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Price_Att_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,

Line 1545: x_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_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,

Line 1546: x_old_Line_Adj_Att_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Att_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,

Line 1547: x_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_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,

Line 1548: x_old_Line_Adj_Assoc_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Adj_Assoc_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,

Line 1549: x_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_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

Line 1550: x_old_Line_Scredit_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Line_Scredit_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

Line 1551: x_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_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
1555: i number;

Line 1552: x_old_Lot_Serial_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Lot_Serial_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;
1556: l_api_name CONSTANT VARCHAR2(30) := 'GET_NOTICE';

Line 1553: x_Action_Request_tbl OUT NOCOPY /* file.sql.39 change */ OE_Order_PUB.Request_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';
1557: l_api_version CONSTANT NUMBER := 1.0;

Line 1563: l_Header_rec OE_Order_PUB.Header_Rec_Type;

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;

Line 1564: l_old_Header_rec OE_Order_PUB.Header_Rec_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;

Line 1565: l_Header_Adj_tbl OE_Order_PUB.Header_Adj_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;

Line 1566: l_old_Header_Adj_tbl OE_Order_PUB.Header_Adj_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;

Line 1567: l_Header_Price_Att_tbl OE_Order_PUB.Header_Price_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;

Line 1568: l_old_Header_Price_Att_tbl OE_Order_PUB.Header_Price_Att_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;

Line 1569: l_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_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;

Line 1570: l_old_Header_Adj_Att_tbl OE_Order_PUB.Header_Adj_Att_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;

Line 1571: l_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_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;

Line 1572: l_old_Header_Adj_Assoc_tbl OE_Order_PUB.Header_Adj_Assoc_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;

Line 1573: l_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_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;

Line 1574: l_old_Header_Scredit_tbl OE_Order_PUB.Header_Scredit_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;

Line 1575: l_Line_tbl OE_Order_PUB.Line_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;

Line 1576: l_old_Line_tbl OE_Order_PUB.Line_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;

Line 1577: l_Line_Adj_tbl OE_Order_PUB.Line_Adj_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;

Line 1578: l_old_Line_Adj_tbl OE_Order_PUB.Line_Adj_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;

Line 1579: l_Line_Price_Att_tbl OE_Order_PUB.Line_Price_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;

Line 1580: l_old_Line_Price_Att_tbl OE_Order_PUB.Line_Price_Att_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;

Line 1581: l_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_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;

Line 1582: l_old_Line_Adj_Att_tbl OE_Order_PUB.Line_Adj_Att_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;

Line 1583: l_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_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;

Line 1584: l_old_Line_Adj_Assoc_tbl OE_Order_PUB.Line_Adj_Assoc_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;

Line 1585: l_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_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;

Line 1586: l_old_Line_Scredit_tbl OE_Order_PUB.Line_Scredit_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;

Line 1587: l_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_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;
1591: pragma EXCEPTION_INIT(no_message, -25228);

Line 1588: l_old_Lot_Serial_tbl OE_Order_PUB.Lot_Serial_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);
1592:

Line 1589: l_Action_Request_tbl OE_Order_PUB.Request_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:
1593: BEGIN