DBA Data[Home] [Help]

APPS.OE_GROUP_SCH_UTIL dependencies on OE_LINE_UTIL

Line 653: /* OE_Line_Util.Query_Row( p_line_id => c1.line_id

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,

Line 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:

Line 743: /* OE_Line_Util.Query_Row( p_line_id => c1.line_id

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,

Line 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:

Line 784: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

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

Line 786: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_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

Line 795: OE_LINE_UTIL.Get_Reserved_Quantity

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:

Line 806: OE_LINE_UTIL.Get_Reserved_Quantity2

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:

Line 980: OE_Line_Util.Query_Row( p_line_id => c1.line_id

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

Line 1038: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

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

Line 1040: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_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

Line 1049: OE_LINE_UTIL.Get_Reserved_Quantity

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

Line 1054: OE_LINE_UTIL.Get_Reserved_Quantity2

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:

Line 1115: /* OE_Line_Util.Query_Row( p_line_id => c2.line_id

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,

Line 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

Line 1150: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

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

Line 1152: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_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

Line 1161: OE_LINE_UTIL.Get_Reserved_Quantity

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:

Line 1173: OE_LINE_UTIL.Get_Reserved_Quantity2

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:

Line 1265: /* OE_Line_Util.Query_Row( p_line_id => c2.line_id

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,

Line 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

Line 1317: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

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

Line 1319: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_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

Line 1327: OE_LINE_UTIL.Get_Reserved_Quantity

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

Line 1332: OE_LINE_UTIL.Get_Reserved_Quantity2

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:

Line 1689: OE_Line_Util.Query_Row

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

Line 1694: OE_LINE_UTIL.Lock_Row(p_line_id => l_line_id,

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;

Line 2045: OE_Line_Util.Lock_Row(p_line_id => l_line_id,

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

Line 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:

Line 2063: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

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

Line 2065: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_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

Line 2074: OE_LINE_UTIL.Get_Reserved_Quantity

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

Line 2079: OE_LINE_UTIL.Get_Reserved_Quantity2

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:

Line 2372: OE_Line_Util.Lock_Row(p_line_id => l_line_id,

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

Line 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:

Line 2389: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

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

Line 2391: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_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

Line 2399: OE_LINE_UTIL.Get_Reserved_Quantity

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

Line 2404: OE_LINE_UTIL.Get_Reserved_Quantity2

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;

Line 2769: OE_Line_Util.Query_Row

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

Line 2781: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

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

Line 2783: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_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

Line 2791: OE_LINE_UTIL.Get_Reserved_Quantity

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

Line 2796: OE_LINE_UTIL.Get_Reserved_Quantity2

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:

Line 2824: OE_Line_Util.Lock_Row(p_line_id => l_line_id,

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

Line 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:

Line 2841: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

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

Line 2843: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_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

Line 2851: OE_LINE_UTIL.Get_Reserved_Quantity

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 :=

Line 2856: OE_LINE_UTIL.Get_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:

Line 3344: OE_Line_Util.Query_Row

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

Line 3357: OE_LINE_UTIL.Get_Reserved_Quantity

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

Line 3362: 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
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;

Line 4170: OE_LINE_UTIL.Lock_Row(p_line_id => p_sch_set_tbl(I).entity_id,

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

Line 4189: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2

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

Line 4191: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_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

Line 4199: OE_LINE_UTIL.Get_Reserved_Quantity

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:

Line 4205: OE_LINE_UTIL.Get_Reserved_Quantity2

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;

Line 5842: OE_Line_Util.Query_Row( p_line_id => l_old_line_rec.line_id,

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: