eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OE_GROUP_SCH_UTIL dependencies on OE_LINE_UTIL

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

656:
657: IF c1.schedule_status_code is null THEN
658:
659: --4382036
660: /* OE_Line_Util.Query_Row( p_line_id => c1.line_id
661: ,x_line_rec => l_line_rec);
662: */
663:
664: OE_Line_Util.Lock_Row(p_line_id => c1.line_id,

Line 664: OE_Line_Util.Lock_Row(p_line_id => c1.line_id,

660: /* OE_Line_Util.Query_Row( p_line_id => c1.line_id
661: ,x_line_rec => l_line_rec);
662: */
663:
664: OE_Line_Util.Lock_Row(p_line_id => c1.line_id,
665: p_x_line_rec => l_line_rec,
666: x_return_status => l_return_status);
667:
668:

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

746: oe_debug_pub.add( 'LINE_ID :' || C1.LINE_ID , 1 ) ;
747: END IF;
748:
749: -- 4382036
750: /* OE_Line_Util.Query_Row( p_line_id => c1.line_id
751: ,x_line_rec => l_line_rec);
752: */
753:
754: OE_Line_Util.Lock_Row(p_line_id => c1.line_id,

Line 754: OE_Line_Util.Lock_Row(p_line_id => c1.line_id,

750: /* OE_Line_Util.Query_Row( p_line_id => c1.line_id
751: ,x_line_rec => l_line_rec);
752: */
753:
754: OE_Line_Util.Lock_Row(p_line_id => c1.line_id,
755: p_x_line_rec => l_line_rec,
756: x_return_status => l_return_status);
757:
758:

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

787: l_sales_order_id :=
788: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);
789: END IF;
790:
791: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
792:
793: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
794: ,p_line_id => l_line_rec.line_id
795: ,p_org_id => l_line_rec.ship_from_org_id

Line 793: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

789: END IF;
790:
791: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
792:
793: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
794: ,p_line_id => l_line_rec.line_id
795: ,p_org_id => l_line_rec.ship_from_org_id
796: ,x_reserved_quantity => l_line_rec.reserved_quantity
797: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2

Line 802: OE_LINE_UTIL.Get_Reserved_Quantity

798: );
799:
800:
801: /*l_line_rec.reserved_quantity :=
802: OE_LINE_UTIL.Get_Reserved_Quantity
803: (p_header_id => l_sales_order_id,
804: p_line_id => l_line_rec.line_id,
805: p_org_id => l_line_rec.ship_from_org_id); */
806:

Line 813: OE_LINE_UTIL.Get_Reserved_Quantity2

809: l_line_rec.reserved_quantity := 0;
810: END IF;
811:
812: /*l_line_rec.reserved_quantity2 := -- INVCONV
813: OE_LINE_UTIL.Get_Reserved_Quantity2
814: (p_header_id => l_sales_order_id,
815: p_line_id => l_line_rec.line_id,
816: p_org_id => l_line_rec.ship_from_org_id);*/
817:

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

983:
984: IF l_debug_level > 0 THEN
985: oe_debug_pub.add( 'LINE SELECTED FOR ATP **** : ' || C1.LINE_ID , 1 ) ;
986: END IF;
987: OE_Line_Util.Query_Row( p_line_id => c1.line_id
988: ,x_line_rec => l_line_rec);
989:
990:
991: OE_MSG_PUB.set_msg_context

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

1041:
1042: IF x_line_tbl(I).schedule_status_code is not null
1043: AND nvl(x_line_tbl(I).shippable_flag,'N') = 'Y' THEN
1044:
1045: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
1046:
1047: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
1048: ,p_line_id => x_line_tbl(I).line_id
1049: ,p_org_id => x_line_tbl(I).ship_from_org_id

Line 1047: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

1043: AND nvl(x_line_tbl(I).shippable_flag,'N') = 'Y' THEN
1044:
1045: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
1046:
1047: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
1048: ,p_line_id => x_line_tbl(I).line_id
1049: ,p_org_id => x_line_tbl(I).ship_from_org_id
1050: ,x_reserved_quantity => x_line_tbl(I).reserved_quantity
1051: ,x_reserved_quantity2 => x_line_tbl(I).reserved_quantity2

Line 1056: OE_LINE_UTIL.Get_Reserved_Quantity

1052: );
1053:
1054:
1055: /*x_line_tbl(I).reserved_quantity :=
1056: OE_LINE_UTIL.Get_Reserved_Quantity
1057: (p_header_id => l_sales_order_id,
1058: p_line_id => x_line_tbl(I).line_id,
1059: p_org_id => x_line_tbl(I).ship_from_org_id);
1060: x_line_tbl(I).reserved_quantity2 := -- INVCONV

Line 1061: OE_LINE_UTIL.Get_Reserved_Quantity2

1057: (p_header_id => l_sales_order_id,
1058: p_line_id => x_line_tbl(I).line_id,
1059: p_org_id => x_line_tbl(I).ship_from_org_id);
1060: x_line_tbl(I).reserved_quantity2 := -- INVCONV
1061: OE_LINE_UTIL.Get_Reserved_Quantity2
1062: (p_header_id => l_sales_order_id,
1063: p_line_id => x_line_tbl(I).line_id,
1064: p_org_id => x_line_tbl(I).ship_from_org_id); */
1065:

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

1118:
1119: ELSE
1120:
1121: -- 4382036
1122: /* OE_Line_Util.Query_Row( p_line_id => c2.line_id
1123: ,x_line_rec => l_line_rec);
1124: */
1125:
1126: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,

Line 1126: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,

1122: /* OE_Line_Util.Query_Row( p_line_id => c2.line_id
1123: ,x_line_rec => l_line_rec);
1124: */
1125:
1126: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,
1127: p_x_line_rec => l_line_rec,
1128: x_return_status => l_return_status);
1129:
1130: OE_MSG_PUB.set_msg_context

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

1153: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(p_header_id);
1154: END IF;
1155:
1156:
1157: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
1158:
1159: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
1160: ,p_line_id => l_line_rec.line_id
1161: ,p_org_id => l_line_rec.ship_from_org_id

Line 1159: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

1155:
1156:
1157: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
1158:
1159: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
1160: ,p_line_id => l_line_rec.line_id
1161: ,p_org_id => l_line_rec.ship_from_org_id
1162: ,x_reserved_quantity => l_line_rec.reserved_quantity
1163: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2

Line 1168: OE_LINE_UTIL.Get_Reserved_Quantity

1164: );
1165:
1166:
1167: /*l_line_rec.reserved_quantity :=
1168: OE_LINE_UTIL.Get_Reserved_Quantity
1169: (p_header_id => l_sales_order_id,
1170: p_line_id => l_line_rec.line_id,
1171: p_org_id => l_line_rec.ship_from_org_id); */
1172:

Line 1180: OE_LINE_UTIL.Get_Reserved_Quantity2

1176: END IF;
1177:
1178:
1179: /*l_line_rec.reserved_quantity2 := -- INVCONV
1180: OE_LINE_UTIL.Get_Reserved_Quantity2
1181: (p_header_id => l_sales_order_id,
1182: p_line_id => l_line_rec.line_id,
1183: p_org_id => l_line_rec.ship_from_org_id); */
1184:

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

1268: oe_debug_pub.add( 'LINE SELECTED FOR UNSCH **** : ' || C2.LINE_ID , 1 ) ;
1269: END IF;
1270:
1271: -- 4382036
1272: /* OE_Line_Util.Query_Row( p_line_id => c2.line_id
1273: ,x_line_rec => l_line_rec);
1274: */
1275:
1276: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,

Line 1276: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,

1272: /* OE_Line_Util.Query_Row( p_line_id => c2.line_id
1273: ,x_line_rec => l_line_rec);
1274: */
1275:
1276: OE_Line_Util.Lock_Row(p_line_id => c2.line_id,
1277: p_x_line_rec => l_line_rec,
1278: x_return_status => l_return_status);
1279:
1280: OE_MSG_PUB.set_msg_context

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

1320: x_line_tbl(I).ship_set := x_line_tbl(I).ato_line_id;
1321: END IF;
1322:
1323: IF nvl(x_line_tbl(I).shippable_flag,'N') = 'Y' THEN
1324: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
1325:
1326: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
1327: ,p_line_id => x_line_tbl(I).line_id
1328: ,p_org_id => x_line_tbl(I).ship_from_org_id

Line 1326: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

1322:
1323: IF nvl(x_line_tbl(I).shippable_flag,'N') = 'Y' THEN
1324: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
1325:
1326: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
1327: ,p_line_id => x_line_tbl(I).line_id
1328: ,p_org_id => x_line_tbl(I).ship_from_org_id
1329: ,x_reserved_quantity => x_line_tbl(I).reserved_quantity
1330: ,x_reserved_quantity2 => x_line_tbl(I).reserved_quantity2

Line 1334: OE_LINE_UTIL.Get_Reserved_Quantity

1330: ,x_reserved_quantity2 => x_line_tbl(I).reserved_quantity2
1331: );
1332:
1333: /*x_line_tbl(I).reserved_quantity :=
1334: OE_LINE_UTIL.Get_Reserved_Quantity
1335: (p_header_id => l_sales_order_id,
1336: p_line_id => x_line_tbl(I).line_id,
1337: p_org_id => x_line_tbl(I).ship_from_org_id);
1338: x_line_tbl(I).reserved_quantity2 := -- INVCONV

Line 1339: OE_LINE_UTIL.Get_Reserved_Quantity2

1335: (p_header_id => l_sales_order_id,
1336: p_line_id => x_line_tbl(I).line_id,
1337: p_org_id => x_line_tbl(I).ship_from_org_id);
1338: x_line_tbl(I).reserved_quantity2 := -- INVCONV
1339: OE_LINE_UTIL.Get_Reserved_Quantity2
1340: (p_header_id => l_sales_order_id,
1341: p_line_id => x_line_tbl(I).line_id,
1342: p_org_id => x_line_tbl(I).ship_from_org_id);*/
1343:

Line 1560: OE_Line_Util.Query_Row

1556: oe_debug_pub.add( 'log schedule set delayed request');
1557: END IF;
1558:
1559:
1560: OE_Line_Util.Query_Row
1561: (p_line_id => l_line_id,
1562: x_line_rec => l_set_line_rec);
1563:
1564: oe_schedule_util.Log_Set_Request

Line 1730: OE_Line_Util.Query_Row

1726: ELSE
1727:
1728: IF l_schedule_status_code IS NULL THEN
1729: /*
1730: OE_Line_Util.Query_Row
1731: (p_line_id => l_line_id,
1732: x_line_rec => l_line_rec);
1733: */
1734: --4382036

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

1731: (p_line_id => l_line_id,
1732: x_line_rec => l_line_rec);
1733: */
1734: --4382036
1735: OE_LINE_UTIL.Lock_Row(p_line_id => l_line_id,
1736: p_x_line_rec => l_line_rec,
1737: x_return_status => l_return_status);
1738:
1739: l_line_rec.reserved_quantity := 0;

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

2089:
2090: END IF;
2091: ELSE
2092: -- 4382036
2093: OE_Line_Util.Lock_Row(p_line_id => l_line_id,
2094: p_x_line_rec => l_line_rec,
2095: x_return_status => l_return_status);
2096:
2097: /* OE_Line_Util.Query_Row

Line 2097: /* OE_Line_Util.Query_Row

2093: OE_Line_Util.Lock_Row(p_line_id => l_line_id,
2094: p_x_line_rec => l_line_rec,
2095: x_return_status => l_return_status);
2096:
2097: /* OE_Line_Util.Query_Row
2098: (p_line_id => l_line_id,
2099: x_line_rec => l_line_rec);
2100: */
2101:

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

2107: (l_line_rec.header_id);
2108: END IF;
2109:
2110:
2111: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2112:
2113: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2114: ,p_line_id => l_line_rec.line_id
2115: ,p_org_id => l_line_rec.ship_from_org_id

Line 2113: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

2109:
2110:
2111: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2112:
2113: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2114: ,p_line_id => l_line_rec.line_id
2115: ,p_org_id => l_line_rec.ship_from_org_id
2116: ,x_reserved_quantity => l_line_rec.reserved_quantity
2117: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2

Line 2122: OE_LINE_UTIL.Get_Reserved_Quantity

2118: );
2119:
2120:
2121: /*l_line_rec.reserved_quantity :=
2122: OE_LINE_UTIL.Get_Reserved_Quantity
2123: (p_header_id => l_sales_order_id,
2124: p_line_id => l_line_rec.line_id,
2125: p_org_id => l_line_rec.ship_from_org_id);
2126: l_line_rec.reserved_quantity2 := -- INVCONV

Line 2127: OE_LINE_UTIL.Get_Reserved_Quantity2

2123: (p_header_id => l_sales_order_id,
2124: p_line_id => l_line_rec.line_id,
2125: p_org_id => l_line_rec.ship_from_org_id);
2126: l_line_rec.reserved_quantity2 := -- INVCONV
2127: OE_LINE_UTIL.Get_Reserved_Quantity2
2128: (p_header_id => l_sales_order_id,
2129: p_line_id => l_line_rec.line_id,
2130: p_org_id => l_line_rec.ship_from_org_id); */
2131:

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

2416: END IF;
2417: ELSE
2418:
2419: -- 4382036
2420: OE_Line_Util.Lock_Row(p_line_id => l_line_id,
2421: p_x_line_rec => l_line_rec,
2422: x_return_status => l_return_status);
2423:
2424: /* OE_Line_Util.Query_Row

Line 2424: /* OE_Line_Util.Query_Row

2420: OE_Line_Util.Lock_Row(p_line_id => l_line_id,
2421: p_x_line_rec => l_line_rec,
2422: x_return_status => l_return_status);
2423:
2424: /* OE_Line_Util.Query_Row
2425: (p_line_id => l_line_id,
2426: x_line_rec => l_line_rec);
2427: */
2428:

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

2433: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2434: (l_line_rec.header_id);
2435: END IF;
2436:
2437: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2438:
2439: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2440: ,p_line_id => l_line_rec.line_id
2441: ,p_org_id => l_line_rec.ship_from_org_id

Line 2439: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

2435: END IF;
2436:
2437: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2438:
2439: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2440: ,p_line_id => l_line_rec.line_id
2441: ,p_org_id => l_line_rec.ship_from_org_id
2442: ,x_reserved_quantity => l_line_rec.reserved_quantity
2443: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2

Line 2447: OE_LINE_UTIL.Get_Reserved_Quantity

2443: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
2444: );
2445:
2446: /*l_line_rec.reserved_quantity :=
2447: OE_LINE_UTIL.Get_Reserved_Quantity
2448: (p_header_id => l_sales_order_id,
2449: p_line_id => l_line_rec.line_id,
2450: p_org_id => l_line_rec.ship_from_org_id);
2451: l_line_rec.reserved_quantity2 := -- INVCONV

Line 2452: OE_LINE_UTIL.Get_Reserved_Quantity2

2448: (p_header_id => l_sales_order_id,
2449: p_line_id => l_line_rec.line_id,
2450: p_org_id => l_line_rec.ship_from_org_id);
2451: l_line_rec.reserved_quantity2 := -- INVCONV
2452: OE_LINE_UTIL.Get_Reserved_Quantity2
2453: (p_header_id => l_sales_order_id,
2454: p_line_id => l_line_rec.line_id,
2455: p_org_id => l_line_rec.ship_from_org_id); */
2456: END IF;

Line 2694: OE_Line_Util.Query_Row

2690: oe_debug_pub.add( 'log schedule set delayed request');
2691: END IF;
2692:
2693:
2694: OE_Line_Util.Query_Row
2695: (p_line_id => l_line_id,
2696: x_line_rec => l_set_line_rec);
2697:
2698: oe_schedule_util.Log_Set_Request

Line 2848: OE_Line_Util.Query_Row

2844: IF l_debug_level > 0 THEN
2845: oe_debug_pub.add( 'NEED TO RESERVE THE LINE' , 2 ) ;
2846: END IF;
2847:
2848: OE_Line_Util.Query_Row
2849: (p_line_id => l_config_id,
2850: x_line_rec => l_line_rec);
2851:
2852: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN

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

2856: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2857: (l_line_rec.header_id);
2858: END IF;
2859:
2860: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2861:
2862: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2863: ,p_line_id => l_line_rec.line_id
2864: ,p_org_id => l_line_rec.ship_from_org_id

Line 2862: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

2858: END IF;
2859:
2860: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2861:
2862: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2863: ,p_line_id => l_line_rec.line_id
2864: ,p_org_id => l_line_rec.ship_from_org_id
2865: ,x_reserved_quantity => l_line_rec.reserved_quantity
2866: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2

Line 2870: OE_LINE_UTIL.Get_Reserved_Quantity

2866: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
2867: );
2868:
2869: /*l_line_rec.reserved_quantity :=
2870: OE_LINE_UTIL.Get_Reserved_Quantity
2871: (p_header_id => l_sales_order_id,
2872: p_line_id => l_line_rec.line_id,
2873: p_org_id => l_line_rec.ship_from_org_id);
2874: l_line_rec.reserved_quantity2 := -- INVCONV

Line 2875: OE_LINE_UTIL.Get_Reserved_Quantity2

2871: (p_header_id => l_sales_order_id,
2872: p_line_id => l_line_rec.line_id,
2873: p_org_id => l_line_rec.ship_from_org_id);
2874: l_line_rec.reserved_quantity2 := -- INVCONV
2875: OE_LINE_UTIL.Get_Reserved_Quantity2
2876: (p_header_id => l_sales_order_id,
2877: p_line_id => l_line_rec.line_id,
2878: p_org_id => l_line_rec.ship_from_org_id); */
2879:

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

2899: END IF;
2900: ELSE
2901:
2902: -- 4382036
2903: OE_Line_Util.Lock_Row(p_line_id => l_line_id,
2904: p_x_line_rec => l_line_rec,
2905: x_return_status => l_return_status);
2906:
2907: /* OE_Line_Util.Query_Row

Line 2907: /* OE_Line_Util.Query_Row

2903: OE_Line_Util.Lock_Row(p_line_id => l_line_id,
2904: p_x_line_rec => l_line_rec,
2905: x_return_status => l_return_status);
2906:
2907: /* OE_Line_Util.Query_Row
2908: (p_line_id => l_line_id,
2909: x_line_rec => l_line_rec);
2910: */
2911:

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

2916: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id
2917: (l_line_rec.header_id);
2918: END IF;
2919:
2920: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2921:
2922: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2923: ,p_line_id => l_line_rec.line_id
2924: ,p_org_id => l_line_rec.ship_from_org_id

Line 2922: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

2918: END IF;
2919:
2920: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
2921:
2922: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
2923: ,p_line_id => l_line_rec.line_id
2924: ,p_org_id => l_line_rec.ship_from_org_id
2925: ,x_reserved_quantity => l_line_rec.reserved_quantity
2926: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2

Line 2930: OE_LINE_UTIL.Get_Reserved_Quantity

2926: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
2927: );
2928:
2929: /* l_line_rec.reserved_quantity :=
2930: OE_LINE_UTIL.Get_Reserved_Quantity
2931: (p_header_id => l_sales_order_id,
2932: p_line_id => l_line_rec.line_id,
2933: p_org_id => l_line_rec.ship_from_org_id);
2934: l_line_rec.reserved_quantity2 :=

Line 2935: OE_LINE_UTIL.Get_Reserved_Quantity2

2931: (p_header_id => l_sales_order_id,
2932: p_line_id => l_line_rec.line_id,
2933: p_org_id => l_line_rec.ship_from_org_id);
2934: l_line_rec.reserved_quantity2 :=
2935: OE_LINE_UTIL.Get_Reserved_Quantity2
2936: (p_header_id => l_sales_order_id,
2937: p_line_id => l_line_rec.line_id,
2938: p_org_id => l_line_rec.ship_from_org_id); */
2939:

Line 3428: OE_Line_Util.Query_Row

3424: END IF;
3425: ELSE
3426:
3427:
3428: OE_Line_Util.Query_Row
3429: (p_line_id => l_line_id,
3430: x_line_rec => l_line_rec);
3431:
3432: IF nvl(l_line_rec.shippable_flag,'N') = 'Y' THEN

Line 3441: OE_LINE_UTIL.Get_Reserved_Quantity

3437: (l_line_rec.header_id);
3438: END IF;
3439:
3440: l_line_rec.reserved_quantity :=
3441: OE_LINE_UTIL.Get_Reserved_Quantity
3442: (p_header_id => l_sales_order_id,
3443: p_line_id => l_line_rec.line_id,
3444: p_org_id => l_line_rec.ship_from_org_id);
3445: l_line_rec.reserved_quantity2 := -- INVCONV

Line 3446: OE_LINE_UTIL.Get_Reserved_Quantity

3442: (p_header_id => l_sales_order_id,
3443: p_line_id => l_line_rec.line_id,
3444: p_org_id => l_line_rec.ship_from_org_id);
3445: l_line_rec.reserved_quantity2 := -- INVCONV
3446: OE_LINE_UTIL.Get_Reserved_Quantity
3447: (p_header_id => l_sales_order_id,
3448: p_line_id => l_line_rec.line_id,
3449: p_org_id => l_line_rec.ship_from_org_id);
3450: END IF;

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

4250: IF l_debug_level > 0 THEN
4251: oe_debug_pub.add( 'LINE IS SELECTED FOR PROCESSING ' || P_SCH_SET_TBL ( I ) .ENTITY_ID , 1 ) ;
4252: END IF;
4253: l_line_rec := OE_ORDER_PUB.G_MISS_LINE_REC;
4254: OE_LINE_UTIL.Lock_Row(p_line_id => p_sch_set_tbl(I).entity_id,
4255: p_x_line_rec => l_line_rec,
4256: x_return_status => x_return_status);
4257:
4258: IF x_return_status = FND_API.G_RET_STS_UNEXP_ERROR THEN

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

4269: l_sales_order_id :=
4270: OE_SCHEDULE_UTIL.Get_mtl_sales_order_id(l_line_rec.header_id);
4271: END IF;
4272:
4273: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
4274:
4275: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
4276: ,p_line_id => l_line_rec.line_id
4277: ,p_org_id => l_line_rec.ship_from_org_id

Line 4275: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id

4271: END IF;
4272:
4273: -- INVCONV - MERGED CALLS FOR OE_LINE_UTIL.Get_Reserved_Quantity and OE_LINE_UTIL.Get_Reserved_Quantity2
4274:
4275: OE_LINE_UTIL.Get_Reserved_Quantities(p_header_id => l_sales_order_id
4276: ,p_line_id => l_line_rec.line_id
4277: ,p_org_id => l_line_rec.ship_from_org_id
4278: ,x_reserved_quantity => l_line_rec.reserved_quantity
4279: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2

Line 4283: OE_LINE_UTIL.Get_Reserved_Quantity

4279: ,x_reserved_quantity2 => l_line_rec.reserved_quantity2
4280: );
4281:
4282: /*l_line_rec.reserved_quantity :=
4283: OE_LINE_UTIL.Get_Reserved_Quantity
4284: (p_header_id => l_sales_order_id,
4285: p_line_id => l_line_rec.line_id,
4286: p_org_id => l_line_rec.ship_from_org_id);
4287:

Line 4289: OE_LINE_UTIL.Get_Reserved_Quantity2

4285: p_line_id => l_line_rec.line_id,
4286: p_org_id => l_line_rec.ship_from_org_id);
4287:
4288: l_line_rec.reserved_quantity2 := -- INVCONV
4289: OE_LINE_UTIL.Get_Reserved_Quantity2
4290: (p_header_id => l_sales_order_id,
4291: p_line_id => l_line_rec.line_id,
4292: p_org_id => l_line_rec.ship_from_org_id); */
4293: END IF;

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

5904: -- of the set to see the change is set attributes so that we can
5905: -- update the set itself.
5906: /*
5907: l_old_line_rec := l_old_line_tbl(1);
5908: OE_Line_Util.Query_Row( p_line_id => l_old_line_rec.line_id,
5909: x_line_rec => l_line_rec);
5910:
5911: -- Update the set attributes.
5912: