649:
650: IF c1.schedule_status_code is null THEN
651:
652: --4382036
653: /* OE_Line_Util.Query_Row( p_line_id => c1.line_id
654: ,x_line_rec => l_line_rec);
655: */
656:
657: OE_Line_Util.Lock_Row(p_line_id => c1.line_id,
653: /* OE_Line_Util.Query_Row( p_line_id => c1.line_id
654: ,x_line_rec => l_line_rec);
655: */
656:
657: OE_Line_Util.Lock_Row(p_line_id => c1.line_id,
658: p_x_line_rec => l_line_rec,
659: x_return_status => l_return_status);
660:
661:
739: oe_debug_pub.add( 'LINE_ID :' || C1.LINE_ID , 1 ) ;
740: END IF;
741:
742: -- 4382036
743: /* OE_Line_Util.Query_Row( p_line_id => c1.line_id
744: ,x_line_rec => l_line_rec);
745: */
746:
747: OE_Line_Util.Lock_Row(p_line_id => c1.line_id,
743: /* OE_Line_Util.Query_Row( p_line_id => c1.line_id
744: ,x_line_rec => l_line_rec);
745: */
746:
747: OE_Line_Util.Lock_Row(p_line_id => c1.line_id,
748: p_x_line_rec => l_line_rec,
749: x_return_status => l_return_status);
750:
751:
780: l_sales_order_id :=
781: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);
782: END IF;
783:
784: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
785:
786: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
787: ,p_line_id => l_line_rec.line_id
788: ,p_org_id => l_line_rec.ship_from_org_id
782: END IF;
783:
784: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
785:
786: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
787: ,p_line_id => l_line_rec.line_id
788: ,p_org_id => l_line_rec.ship_from_org_id
789: ,x_reserved_quantity => l_line_rec.reserved_quantity
790: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
791: );
792:
793:
794: /*l_line_rec.reserved_quantity :=
795: OE_LINE_UTIL.Get_Reserved_Quantity
796: (p_header_id => l_sales_order_id,
797: p_line_id => l_line_rec.line_id,
798: p_org_id => l_line_rec.ship_from_org_id); */
799:
802: l_line_rec.reserved_quantity := 0;
803: END IF;
804:
805: /*l_line_rec.reserved_quantity2 := -- INVCONV
806: OE_LINE_UTIL.Get_Reserved_Quantity2
807: (p_header_id => l_sales_order_id,
808: p_line_id => l_line_rec.line_id,
809: p_org_id => l_line_rec.ship_from_org_id);*/
810:
976:
977: IF l_debug_level > 0 THEN
978: oe_debug_pub.add( 'LINE SELECTED FOR ATP **** : ' || C1.LINE_ID , 1 ) ;
979: END IF;
980: OE_Line_Util.Query_Row( p_line_id => c1.line_id
981: ,x_line_rec => l_line_rec);
982:
983:
984: OE_MSG_PUB.set_msg_context
1034:
1035: IF x_line_tbl(I).schedule_status_code is not null
1036: AND nvl(x_line_tbl(I).shippable_flag,'N') = 'Y' THEN
1037:
1038: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
1039:
1040: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
1041: ,p_line_id => x_line_tbl(I).line_id
1042: ,p_org_id => x_line_tbl(I).ship_from_org_id
1036: AND nvl(x_line_tbl(I).shippable_flag,'N') = 'Y' THEN
1037:
1038: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
1039:
1040: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
1041: ,p_line_id => x_line_tbl(I).line_id
1042: ,p_org_id => x_line_tbl(I).ship_from_org_id
1043: ,x_reserved_quantity => x_line_tbl(I).reserved_quantity
1044: ,x_reserved_quantity2 => x_line_tbl(I).reserved_quantity2
1045: );
1046:
1047:
1048: /*x_line_tbl(I).reserved_quantity :=
1049: OE_LINE_UTIL.Get_Reserved_Quantity
1050: (p_header_id => l_sales_order_id,
1051: p_line_id => x_line_tbl(I).line_id,
1052: p_org_id => x_line_tbl(I).ship_from_org_id);
1053: x_line_tbl(I).reserved_quantity2 := -- INVCONV
1050: (p_header_id => l_sales_order_id,
1051: p_line_id => x_line_tbl(I).line_id,
1052: p_org_id => x_line_tbl(I).ship_from_org_id);
1053: x_line_tbl(I).reserved_quantity2 := -- INVCONV
1054: OE_LINE_UTIL.Get_Reserved_Quantity2
1055: (p_header_id => l_sales_order_id,
1056: p_line_id => x_line_tbl(I).line_id,
1057: p_org_id => x_line_tbl(I).ship_from_org_id); */
1058:
1111:
1112: ELSE
1113:
1114: -- 4382036
1115: /* OE_Line_Util.Query_Row( p_line_id => c2.line_id
1116: ,x_line_rec => l_line_rec);
1117: */
1118:
1119: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,
1115: /* OE_Line_Util.Query_Row( p_line_id => c2.line_id
1116: ,x_line_rec => l_line_rec);
1117: */
1118:
1119: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,
1120: p_x_line_rec => l_line_rec,
1121: x_return_status => l_return_status);
1122:
1123: OE_MSG_PUB.set_msg_context
1146: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);
1147: END IF;
1148:
1149:
1150: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
1151:
1152: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
1153: ,p_line_id => l_line_rec.line_id
1154: ,p_org_id => l_line_rec.ship_from_org_id
1148:
1149:
1150: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
1151:
1152: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
1153: ,p_line_id => l_line_rec.line_id
1154: ,p_org_id => l_line_rec.ship_from_org_id
1155: ,x_reserved_quantity => l_line_rec.reserved_quantity
1156: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
1157: );
1158:
1159:
1160: /*l_line_rec.reserved_quantity :=
1161: OE_LINE_UTIL.Get_Reserved_Quantity
1162: (p_header_id => l_sales_order_id,
1163: p_line_id => l_line_rec.line_id,
1164: p_org_id => l_line_rec.ship_from_org_id); */
1165:
1169: END IF;
1170:
1171:
1172: /*l_line_rec.reserved_quantity2 := -- INVCONV
1173: OE_LINE_UTIL.Get_Reserved_Quantity2
1174: (p_header_id => l_sales_order_id,
1175: p_line_id => l_line_rec.line_id,
1176: p_org_id => l_line_rec.ship_from_org_id); */
1177:
1261: oe_debug_pub.add( 'LINE SELECTED FOR UNSCH **** : ' || C2.LINE_ID , 1 ) ;
1262: END IF;
1263:
1264: -- 4382036
1265: /* OE_Line_Util.Query_Row( p_line_id => c2.line_id
1266: ,x_line_rec => l_line_rec);
1267: */
1268:
1269: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,
1265: /* OE_Line_Util.Query_Row( p_line_id => c2.line_id
1266: ,x_line_rec => l_line_rec);
1267: */
1268:
1269: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,
1270: p_x_line_rec => l_line_rec,
1271: x_return_status => l_return_status);
1272:
1273: OE_MSG_PUB.set_msg_context
1313: x_line_tbl(I).ship_set := x_line_tbl(I).ato_line_id;
1314: END IF;
1315:
1316: IF nvl(x_line_tbl(I).shippable_flag,'N') = 'Y' THEN
1317: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
1318:
1319: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
1320: ,p_line_id => x_line_tbl(I).line_id
1321: ,p_org_id => x_line_tbl(I).ship_from_org_id
1315:
1316: IF nvl(x_line_tbl(I).shippable_flag,'N') = 'Y' THEN
1317: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
1318:
1319: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
1320: ,p_line_id => x_line_tbl(I).line_id
1321: ,p_org_id => x_line_tbl(I).ship_from_org_id
1322: ,x_reserved_quantity => x_line_tbl(I).reserved_quantity
1323: ,x_reserved_quantity2 => x_line_tbl(I).reserved_quantity2
1323: ,x_reserved_quantity2 => x_line_tbl(I).reserved_quantity2
1324: );
1325:
1326: /*x_line_tbl(I).reserved_quantity :=
1327: OE_LINE_UTIL.Get_Reserved_Quantity
1328: (p_header_id => l_sales_order_id,
1329: p_line_id => x_line_tbl(I).line_id,
1330: p_org_id => x_line_tbl(I).ship_from_org_id);
1331: x_line_tbl(I).reserved_quantity2 := -- INVCONV
1328: (p_header_id => l_sales_order_id,
1329: p_line_id => x_line_tbl(I).line_id,
1330: p_org_id => x_line_tbl(I).ship_from_org_id);
1331: x_line_tbl(I).reserved_quantity2 := -- INVCONV
1332: OE_LINE_UTIL.Get_Reserved_Quantity2
1333: (p_header_id => l_sales_order_id,
1334: p_line_id => x_line_tbl(I).line_id,
1335: p_org_id => x_line_tbl(I).ship_from_org_id);*/
1336:
1685: ELSE
1686:
1687: IF l_schedule_status_code IS NULL THEN
1688: /*
1689: OE_Line_Util.Query_Row
1690: (p_line_id => l_line_id,
1691: x_line_rec => l_line_rec);
1692: */
1693: --4382036
1690: (p_line_id => l_line_id,
1691: x_line_rec => l_line_rec);
1692: */
1693: --4382036
1694: OE_LINE_UTIL.Lock_Row(p_line_id => l_line_id,
1695: p_x_line_rec => l_line_rec,
1696: x_return_status => l_return_status);
1697:
1698: l_line_rec.reserved_quantity := 0;
2041:
2042: END IF;
2043: ELSE
2044: -- 4382036
2045: OE_Line_Util.Lock_Row(p_line_id => l_line_id,
2046: p_x_line_rec => l_line_rec,
2047: x_return_status => l_return_status);
2048:
2049: /* OE_Line_Util.Query_Row
2045: OE_Line_Util.Lock_Row(p_line_id => l_line_id,
2046: p_x_line_rec => l_line_rec,
2047: x_return_status => l_return_status);
2048:
2049: /* OE_Line_Util.Query_Row
2050: (p_line_id => l_line_id,
2051: x_line_rec => l_line_rec);
2052: */
2053:
2059: (l_line_rec.header_id);
2060: END IF;
2061:
2062:
2063: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2064:
2065: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2066: ,p_line_id => l_line_rec.line_id
2067: ,p_org_id => l_line_rec.ship_from_org_id
2061:
2062:
2063: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2064:
2065: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2066: ,p_line_id => l_line_rec.line_id
2067: ,p_org_id => l_line_rec.ship_from_org_id
2068: ,x_reserved_quantity => l_line_rec.reserved_quantity
2069: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
2070: );
2071:
2072:
2073: /*l_line_rec.reserved_quantity :=
2074: OE_LINE_UTIL.Get_Reserved_Quantity
2075: (p_header_id => l_sales_order_id,
2076: p_line_id => l_line_rec.line_id,
2077: p_org_id => l_line_rec.ship_from_org_id);
2078: l_line_rec.reserved_quantity2 := -- INVCONV
2075: (p_header_id => l_sales_order_id,
2076: p_line_id => l_line_rec.line_id,
2077: p_org_id => l_line_rec.ship_from_org_id);
2078: l_line_rec.reserved_quantity2 := -- INVCONV
2079: OE_LINE_UTIL.Get_Reserved_Quantity2
2080: (p_header_id => l_sales_order_id,
2081: p_line_id => l_line_rec.line_id,
2082: p_org_id => l_line_rec.ship_from_org_id); */
2083:
2368: END IF;
2369: ELSE
2370:
2371: -- 4382036
2372: OE_Line_Util.Lock_Row(p_line_id => l_line_id,
2373: p_x_line_rec => l_line_rec,
2374: x_return_status => l_return_status);
2375:
2376: /* OE_Line_Util.Query_Row
2372: OE_Line_Util.Lock_Row(p_line_id => l_line_id,
2373: p_x_line_rec => l_line_rec,
2374: x_return_status => l_return_status);
2375:
2376: /* OE_Line_Util.Query_Row
2377: (p_line_id => l_line_id,
2378: x_line_rec => l_line_rec);
2379: */
2380:
2385: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2386: (l_line_rec.header_id);
2387: END IF;
2388:
2389: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2390:
2391: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2392: ,p_line_id => l_line_rec.line_id
2393: ,p_org_id => l_line_rec.ship_from_org_id
2387: END IF;
2388:
2389: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2390:
2391: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2392: ,p_line_id => l_line_rec.line_id
2393: ,p_org_id => l_line_rec.ship_from_org_id
2394: ,x_reserved_quantity => l_line_rec.reserved_quantity
2395: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
2395: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
2396: );
2397:
2398: /*l_line_rec.reserved_quantity :=
2399: OE_LINE_UTIL.Get_Reserved_Quantity
2400: (p_header_id => l_sales_order_id,
2401: p_line_id => l_line_rec.line_id,
2402: p_org_id => l_line_rec.ship_from_org_id);
2403: l_line_rec.reserved_quantity2 := -- INVCONV
2400: (p_header_id => l_sales_order_id,
2401: p_line_id => l_line_rec.line_id,
2402: p_org_id => l_line_rec.ship_from_org_id);
2403: l_line_rec.reserved_quantity2 := -- INVCONV
2404: OE_LINE_UTIL.Get_Reserved_Quantity2
2405: (p_header_id => l_sales_order_id,
2406: p_line_id => l_line_rec.line_id,
2407: p_org_id => l_line_rec.ship_from_org_id); */
2408: END IF;
2765: IF l_debug_level > 0 THEN
2766: oe_debug_pub.add( 'NEED TO RESERVE THE LINE' , 2 ) ;
2767: END IF;
2768:
2769: OE_Line_Util.Query_Row
2770: (p_line_id => l_config_id,
2771: x_line_rec => l_line_rec);
2772:
2773: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
2777: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2778: (l_line_rec.header_id);
2779: END IF;
2780:
2781: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2782:
2783: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2784: ,p_line_id => l_line_rec.line_id
2785: ,p_org_id => l_line_rec.ship_from_org_id
2779: END IF;
2780:
2781: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2782:
2783: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2784: ,p_line_id => l_line_rec.line_id
2785: ,p_org_id => l_line_rec.ship_from_org_id
2786: ,x_reserved_quantity => l_line_rec.reserved_quantity
2787: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
2787: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
2788: );
2789:
2790: /*l_line_rec.reserved_quantity :=
2791: OE_LINE_UTIL.Get_Reserved_Quantity
2792: (p_header_id => l_sales_order_id,
2793: p_line_id => l_line_rec.line_id,
2794: p_org_id => l_line_rec.ship_from_org_id);
2795: l_line_rec.reserved_quantity2 := -- INVCONV
2792: (p_header_id => l_sales_order_id,
2793: p_line_id => l_line_rec.line_id,
2794: p_org_id => l_line_rec.ship_from_org_id);
2795: l_line_rec.reserved_quantity2 := -- INVCONV
2796: OE_LINE_UTIL.Get_Reserved_Quantity2
2797: (p_header_id => l_sales_order_id,
2798: p_line_id => l_line_rec.line_id,
2799: p_org_id => l_line_rec.ship_from_org_id); */
2800:
2820: END IF;
2821: ELSE
2822:
2823: -- 4382036
2824: OE_Line_Util.Lock_Row(p_line_id => l_line_id,
2825: p_x_line_rec => l_line_rec,
2826: x_return_status => l_return_status);
2827:
2828: /* OE_Line_Util.Query_Row
2824: OE_Line_Util.Lock_Row(p_line_id => l_line_id,
2825: p_x_line_rec => l_line_rec,
2826: x_return_status => l_return_status);
2827:
2828: /* OE_Line_Util.Query_Row
2829: (p_line_id => l_line_id,
2830: x_line_rec => l_line_rec);
2831: */
2832:
2837: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2838: (l_line_rec.header_id);
2839: END IF;
2840:
2841: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2842:
2843: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2844: ,p_line_id => l_line_rec.line_id
2845: ,p_org_id => l_line_rec.ship_from_org_id
2839: END IF;
2840:
2841: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2842:
2843: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2844: ,p_line_id => l_line_rec.line_id
2845: ,p_org_id => l_line_rec.ship_from_org_id
2846: ,x_reserved_quantity => l_line_rec.reserved_quantity
2847: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
2847: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
2848: );
2849:
2850: /* l_line_rec.reserved_quantity :=
2851: OE_LINE_UTIL.Get_Reserved_Quantity
2852: (p_header_id => l_sales_order_id,
2853: p_line_id => l_line_rec.line_id,
2854: p_org_id => l_line_rec.ship_from_org_id);
2855: l_line_rec.reserved_quantity2 :=
2852: (p_header_id => l_sales_order_id,
2853: p_line_id => l_line_rec.line_id,
2854: p_org_id => l_line_rec.ship_from_org_id);
2855: l_line_rec.reserved_quantity2 :=
2856: OE_LINE_UTIL.Get_Reserved_Quantity2
2857: (p_header_id => l_sales_order_id,
2858: p_line_id => l_line_rec.line_id,
2859: p_org_id => l_line_rec.ship_from_org_id); */
2860:
3340: END IF;
3341: ELSE
3342:
3343:
3344: OE_Line_Util.Query_Row
3345: (p_line_id => l_line_id,
3346: x_line_rec => l_line_rec);
3347:
3348: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN
3353: (l_line_rec.header_id);
3354: END IF;
3355:
3356: l_line_rec.reserved_quantity :=
3357: OE_LINE_UTIL.Get_Reserved_Quantity
3358: (p_header_id => l_sales_order_id,
3359: p_line_id => l_line_rec.line_id,
3360: p_org_id => l_line_rec.ship_from_org_id);
3361: l_line_rec.reserved_quantity2 := -- INVCONV
3358: (p_header_id => l_sales_order_id,
3359: p_line_id => l_line_rec.line_id,
3360: p_org_id => l_line_rec.ship_from_org_id);
3361: l_line_rec.reserved_quantity2 := -- INVCONV
3362: OE_LINE_UTIL.Get_Reserved_Quantity
3363: (p_header_id => l_sales_order_id,
3364: p_line_id => l_line_rec.line_id,
3365: p_org_id => l_line_rec.ship_from_org_id);
3366: END IF;
4166: IF l_debug_level > 0 THEN
4167: oe_debug_pub.add( 'LINE IS SELECTED FOR PROCESSING ' || P_SCH_SET_TBL ( I ) .ENTITY_ID , 1 ) ;
4168: END IF;
4169: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
4170: OE_LINE_UTIL.Lock_Row(p_line_id => p_sch_set_tbl(I).entity_id,
4171: p_x_line_rec => l_line_rec,
4172: x_return_status => x_return_status);
4173:
4174: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN
4185: l_sales_order_id :=
4186: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_rec.header_id);
4187: END IF;
4188:
4189: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
4190:
4191: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
4192: ,p_line_id => l_line_rec.line_id
4193: ,p_org_id => l_line_rec.ship_from_org_id
4187: END IF;
4188:
4189: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
4190:
4191: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
4192: ,p_line_id => l_line_rec.line_id
4193: ,p_org_id => l_line_rec.ship_from_org_id
4194: ,x_reserved_quantity => l_line_rec.reserved_quantity
4195: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
4195: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
4196: );
4197:
4198: /*l_line_rec.reserved_quantity :=
4199: OE_LINE_UTIL.Get_Reserved_Quantity
4200: (p_header_id => l_sales_order_id,
4201: p_line_id => l_line_rec.line_id,
4202: p_org_id => l_line_rec.ship_from_org_id);
4203:
4201: p_line_id => l_line_rec.line_id,
4202: p_org_id => l_line_rec.ship_from_org_id);
4203:
4204: l_line_rec.reserved_quantity2 := -- INVCONV
4205: OE_LINE_UTIL.Get_Reserved_Quantity2
4206: (p_header_id => l_sales_order_id,
4207: p_line_id => l_line_rec.line_id,
4208: p_org_id => l_line_rec.ship_from_org_id); */
4209: END IF;
5838: -- of the set to see the change is set attributes so that we can
5839: -- update the set itself.
5840: /*
5841: l_old_line_rec := l_old_line_tbl(1);
5842: OE_Line_Util.Query_Row( p_line_id => l_old_line_rec.line_id,
5843: x_line_rec => l_line_rec);
5844:
5845: -- Update the set attributes.
5846: