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.INV_SHIPPING_TRANSACTION_PUB dependencies on WSH_DELIVERY_DETAILS

Line 171: FROM wsh_new_deliveries_ob_grp_v wnd, wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd

167: OPEN x_deliveryLOV for
168: SELECT distinct wnd.name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
169: wnd.waybill,
170: GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
171: FROM wsh_new_deliveries_ob_grp_v wnd, wsh_delivery_assignments_v wda,wsh_delivery_details_ob_grp_v wdd
172: WHERE wda.delivery_Detail_id = wdd.delivery_Detail_id
173: AND wda.delivery_id = wnd.delivery_id
174: and ( wdd.released_status = 'Y'
175: OR (wdd.released_status='X' and wdd.source_code='RTV') --RTV Change 16197273

Line 199: FROM wsh_new_deliveries_ob_grp_v wnd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd

195: OPEN x_deliveryLOV for
196: SELECT distinct wnd.name, wnd.delivery_id, wnd.gross_weight, wnd.weight_uom_code,
197: wnd.waybill,
198: GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
199: FROM wsh_new_deliveries_ob_grp_v wnd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd
200: WHERE wda.delivery_Detail_id = wdd.delivery_Detail_id
201: AND wda.delivery_id = wnd.delivery_id
202: and wdd.organization_id = p_organization_id
203: and wnd.name like (p_delivery_name);

Line 220: from wsh_delivery_details_ob_grp_v wdd

216: ( select wda.delivery_id
217: from wsh_delivery_assignments_v wda
218: where parent_delivery_detail_id =
219: ( select wdd.delivery_detail_id
220: from wsh_delivery_details_ob_grp_v wdd
221: where wdd.lpn_id = p_lpn_id
222: and wdd.organization_id = p_organization_id
223: )
224: )

Line 235: FROM wsh_delivery_details wdd,

231: GET_SHIPMETHOD_MEANING(wnd.ship_method_code)
232: FROM wsh_new_deliveries wnd
233: WHERE wnd.delivery_id IN
234: ( SELECT wda.delivery_id
235: FROM wsh_delivery_details wdd,
236: wsh_delivery_assignments wda
237: WHERE wdd.lpn_id = p_lpn_id
238: AND wdd.organization_id = p_organization_id
239: AND wda.parent_delivery_detail_id = wdd.delivery_detail_id

Line 254: FROM wsh_delivery_details_ob_grp_v wdd,

250: p_inventory_item_id IN NUMBER) IS
251: BEGIN
252: OPEN x_deliveryLineLOV for
253: SELECT wdd.delivery_detail_id
254: FROM wsh_delivery_details_ob_grp_v wdd,
255: wsh_delivery_assignments_v wda,
256: wsh_new_deliveries_ob_grp_v wnd
257: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
258: AND wda.delivery_id = wnd.delivery_id

Line 351: FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,

347: REQUESTED_QUANTITY_UOM2,
348: REQUESTED_QUANTITY2,
349: PICKED_QUANTITY2,
350: SHIPPED_QUANTITY2
351: FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,
352: wsh_delivery_assignments_v da, mtl_system_items_vl msiv
353: WHERE da.delivery_id = del.delivery_id
354: AND da.delivery_detail_id = dd.delivery_detail_id
355: AND ( dd.inventory_item_id = p_inventory_item_id or p_inventory_item_id = -1 )

Line 376: wsh_delivery_details_ob_grp_v dd,

372: --Adding picked_quantity as part of the return cursor.
373: dd.picked_quantity,
374: dd.shipped_quantity
375: FROM wsh_new_deliveries_ob_grp_v del,
376: wsh_delivery_details_ob_grp_v dd,
377: wsh_delivery_assignments_v da,
378: mtl_system_items_vl msiv
379: WHERE da.delivery_id = del.delivery_id
380: AND da.delivery_detail_id = dd.delivery_detail_id

Line 406: wsh_delivery_details_ob_grp_v dd,

402: all_items VARCHAR2(20000) := NULL;
403: cursor item_name is
404: select msik.concatenated_segments
405: from wsh_new_deliveries_ob_grp_v del,
406: wsh_delivery_details_ob_grp_v dd,
407: wsh_delivery_assignments_v da,
408: mtl_system_items_kfv msik
409: where da.delivery_id = del.delivery_id
410: AND da.delivery_detail_id = dd.delivery_detail_id

Line 481: from wsh_delivery_details_ob_grp_v

477: x_return_Status := 'C';
478: select inventory_item_id, subinventory, revision, locator_id,lot_number, transaction_temp_id, serial_number,picked_quantity
479: into l_inventory_item_id, l_subinventory_code, l_revision, l_locator_id, l_lot_number,
480: l_transaction_temp_id, l_serial_number,l_picked_quantity
481: from wsh_delivery_details_ob_grp_v
482: where delivery_detail_id = p_delivery_detail_id;
483:
484: IF ( l_serial_number IS NULL ) THEN
485: IF ( l_transaction_temp_id IS NULL ) THEN

Line 616: from wsh_delivery_assignments_v da,wsh_delivery_details_ob_grp_v dd

612: x_msg_count OUT NOCOPY NUMBER) IS
613:
614: cursor delivery_details_ids(p_delivery_id NUMBER) is
615: select dd.delivery_detail_id
616: from wsh_delivery_assignments_v da,wsh_delivery_details_ob_grp_v dd
617: where da.delivery_id = p_delivery_id
618: and da.delivery_detail_id = dd.delivery_detail_id
619: and dd.container_flag <>'Y';
620:

Line 623: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2

619: and dd.container_flag <>'Y';
620:
621: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
622: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
623: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
624: , wsh_delivery_assignments_v wda2
625: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
626: and wda.delivery_detail_id = wdd2.delivery_detail_id
627: and wdd2.delivery_detail_id = p_delivery_detail_id

Line 665: , wsh_delivery_details_ob_grp_v wdd

661: SELECT wdd.lpn_id, wdd.organization_id
662: FROM (SELECT delivery_detail_id
663: FROM wsh_delivery_assignments_v wda
664: WHERE wda.delivery_id = p_delivery_id ) wda
665: , wsh_delivery_details_ob_grp_v wdd
666: WHERE wda.delivery_detail_id = wdd.delivery_detail_id
667: AND wdd.lpn_id IS NOT NULL;
668:
669: BEGIN

Line 686: from wsh_delivery_details_ob_grp_v dd

682: END IF;
683:
684: select dd.requested_quantity, dd.picked_quantity,dd.requested_quantity2
685: INTO l_requested_quantity, l_picked_quantity, l_requested_quantity2
686: from wsh_delivery_details_ob_grp_v dd
687: where
688: dd.delivery_detail_id = l_delivery_details_id_table(l_table_index);
689:
690: l_backorder_quantities_table(l_table_index) :=

Line 719: from wsh_delivery_details_ob_grp_v

715: -- change the LPN context first since we changed the LPN context to
716: -- picked after pick confirm
717: select lpn_id
718: into l_lpn_id
719: from wsh_delivery_details_ob_grp_v
720: where delivery_detail_id = l_parent_delivery_detail_id;
721:
722: IF (l_debug = 1) THEN
723: debug('Change the context of LPNs to 1:'||l_lpn_id,'wshtxn');

Line 846: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

842: x_return_status OUT NOCOPY VARCHAR2,
843: x_msg_data OUT NOCOPY VARCHAR2,
844: x_msg_count OUT NOCOPY NUMBER) IS
845: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
846: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
847: l_details VARCHAR2(2000);
848: BEGIN
849:
850: --null;

Line 861: 'wsh_delivery_details_pub.update_shipping_attributes', 'INV_DELAY_SHIPMENT');

857: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
858:
859: IF l_debug = 1 THEN
860: debug('About to call Shipping ' ||
861: 'wsh_delivery_details_pub.update_shipping_attributes', 'INV_DELAY_SHIPMENT');
862: END IF;
863:
864: wsh_delivery_details_pub.update_shipping_attributes
865: (p_api_version_number => 1.0,

Line 864: wsh_delivery_details_pub.update_shipping_attributes

860: debug('About to call Shipping ' ||
861: 'wsh_delivery_details_pub.update_shipping_attributes', 'INV_DELAY_SHIPMENT');
862: END IF;
863:
864: wsh_delivery_details_pub.update_shipping_attributes
865: (p_api_version_number => 1.0,
866: p_init_msg_list => G_TRUE,
867: p_commit => G_FALSE,
868: x_return_status => x_return_status,

Line 876: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

872: p_source_code => 'OE');
873:
874: IF x_return_status <> G_RET_STS_SUCCESS THEN
875: IF l_debug = 1 THEN
876: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
877: || ' with status: ' || x_return_status, 'INV_DELAY_SHIPMENT');
878: END IF;
879: RAISE fnd_api.g_exc_unexpected_error;
880: END IF;

Line 906: from wsh_delivery_details_ob_grp_v dd

902: p_relieve_rsv IN VARCHAR2 DEFAULT 'Y')
903: IS
904: cursor delivery_line(p_delivery_detail_id NUMBER) is
905: select dd.delivery_detail_id, dd.requested_quantity, dd.picked_quantity
906: from wsh_delivery_details_ob_grp_v dd
907: WHERE dd.delivery_detail_id = p_delivery_detail_id;
908:
909: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
910: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id

Line 911: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2

907: WHERE dd.delivery_detail_id = p_delivery_detail_id;
908:
909: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
910: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
911: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
912: , wsh_delivery_assignments_v wda2
913: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
914: and wda.delivery_detail_id = wdd2.delivery_detail_id
915: and wdd2.delivery_detail_id = p_delivery_detail_id

Line 930: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

926: l_requested_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
927: l_overpicked_quantities_table WSH_UTIL_CORE.ID_TAB_TYPE;
928: l_dummy_table wsh_util_core.id_tab_type;
929: l_out_rows wsh_util_core.id_tab_type;
930: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
931: l_dummy_num_var NUMBER := NULL;
932: l_table_index NUMBER := 1;
933:
934: l_picked_quantity NUMBER;

Line 1046: FROM wsh_delivery_details_ob_grp_v wdd

1042: END IF;
1043:
1044: SELECT lpn_id
1045: INTO l_lpn_id
1046: FROM wsh_delivery_details_ob_grp_v wdd
1047: WHERE delivery_detail_id = l_parent_delivery_detail_id;
1048:
1049: IF l_debug = 1 THEN
1050: debug('l_lpn_id: '|| l_lpn_id, 'INV_LINE_RETURN_TO_STOCK');

Line 1090: WSH_DELIVERY_DETAILS_PUB.split_line

1086: || ' requested : ' || l_requested_quantities_table(1)
1087: , 'INV_LINE_RETURN_TO_STOCK');
1088: END IF;
1089:
1090: WSH_DELIVERY_DETAILS_PUB.split_line
1091: (p_api_version => 1.0,
1092: p_init_msg_list => fnd_api.g_false,
1093: p_commit => p_commit_flag,
1094: x_return_status => l_return_status,

Line 1104: debug('WSH_DELIVERY_DETAILS_PUB.split_line failed',

1100: x_split_quantity2 => l_dummy_num_var);
1101:
1102: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1103: IF l_debug = 1 THEN
1104: debug('WSH_DELIVERY_DETAILS_PUB.split_line failed',
1105: 'INV_LINE_RETURN_TO_STOCK');
1106: END IF;
1107:
1108: RAISE fnd_api.g_exc_unexpected_error;

Line 1115: wsh_delivery_details_pub.update_shipping_attributes

1111: l_detail_attributes(1).delivery_detail_id :=
1112: l_delivery_details_id_table(1);
1113: l_detail_attributes(1).shipped_quantity := p_shipped_quantity;
1114:
1115: wsh_delivery_details_pub.update_shipping_attributes
1116: (p_api_version_number => 1.0,
1117: p_init_msg_list => fnd_api.g_false,
1118: p_commit => p_commit_flag,
1119: x_return_status => l_return_status,

Line 1127: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',

1123: p_source_code => 'OE');
1124:
1125: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1126: IF l_debug = 1 THEN
1127: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',
1128: 'INV_LINE_RETURN_TO_STOCK');
1129: END IF;
1130:
1131: RAISE fnd_api.g_exc_unexpected_error;

Line 1225: from wsh_delivery_details_ob_grp_v dd

1221: /* Change the cursor to pick up secondary picked and requested quantities */
1222: cursor delivery_line(p_delivery_detail_id NUMBER) is
1223: select dd.delivery_detail_id, dd.requested_quantity, dd.picked_quantity,
1224: PICKED_QUANTITY2, REQUESTED_QUANTITY2
1225: from wsh_delivery_details_ob_grp_v dd
1226: WHERE dd.delivery_detail_id = p_delivery_detail_id;
1227:
1228: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
1229: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id

Line 1230: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2

1226: WHERE dd.delivery_detail_id = p_delivery_detail_id;
1227:
1228: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
1229: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
1230: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
1231: , wsh_delivery_assignments_v wda2
1232: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
1233: and wda.delivery_detail_id = wdd2.delivery_detail_id
1234: and wdd2.delivery_detail_id = p_delivery_detail_id

Line 1252: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

1248: l_sec_req_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1249: l_sec_ovpk_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1250: l_dummy_table wsh_util_core.id_tab_type;
1251: l_out_rows wsh_util_core.id_tab_type;
1252: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
1253: l_dummy_num_var NUMBER := NULL;
1254: l_table_index NUMBER := 1;
1255:
1256: l_picked_quantity NUMBER;

Line 1333: FROM wsh_delivery_details_ob_grp_v wdd

1329: EXIT WHEN lpn_csr%NOTFOUND;
1330:
1331: SELECT lpn_id
1332: INTO l_lpn_id
1333: FROM wsh_delivery_details_ob_grp_v wdd
1334: WHERE delivery_detail_id = l_parent_delivery_detail_id;
1335:
1336: --update LPN(s) context to Resides in Inventory
1337: FOR l_par_lpn_id IN nested_parent_lpn_cursor(l_lpn_id) LOOP

Line 1365: WSH_DELIVERY_DETAILS_PUB.split_line

1361: || ' requested : ' || l_requested_quantities_table(1)
1362: , 'INV_LINE_RETURN_TO_STOCK');
1363: END IF;
1364:
1365: WSH_DELIVERY_DETAILS_PUB.split_line
1366: (p_api_version => 1.0,
1367: p_init_msg_list => fnd_api.g_false,
1368: p_commit => p_commit_flag,
1369: x_return_status => l_return_status,

Line 1379: debug('WSH_DELIVERY_DETAILS_PUB.split_line failed',

1375: x_split_quantity2 => l_sec_bck_qtys_table(1));
1376:
1377: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1378: IF l_debug = 1 THEN
1379: debug('WSH_DELIVERY_DETAILS_PUB.split_line failed',
1380: 'INV_LINE_RETURN_TO_STOCK');
1381: END IF;
1382:
1383: RAISE fnd_api.g_exc_unexpected_error;

Line 1393: wsh_delivery_details_pub.update_shipping_attributes

1389:
1390: /* set secondary shipped quantity into the delivery details attribute set */
1391: l_detail_attributes(1).shipped_quantity2 := p_sec_shipped_quantity;
1392:
1393: wsh_delivery_details_pub.update_shipping_attributes
1394: (p_api_version_number => 1.0,
1395: p_init_msg_list => fnd_api.g_false,
1396: p_commit => p_commit_flag,
1397: x_return_status => l_return_status,

Line 1405: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',

1401: p_source_code => 'OE');
1402:
1403: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1404: IF l_debug = 1 THEN
1405: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',
1406: 'INV_LINE_RETURN_TO_STOCK');
1407: END IF;
1408:
1409: RAISE fnd_api.g_exc_unexpected_error;

Line 1480: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1476: x_return_status OUT NOCOPY VARCHAR2,
1477: x_msg_data OUT NOCOPY VARCHAR2,
1478: x_msg_count OUT NOCOPY NUMBER) IS
1479: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1480: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1481: l_details VARCHAR2(2000);
1482: BEGIN
1483: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1484: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;

Line 1487: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',

1483: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1484: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
1485:
1486: IF l_debug = 1 THEN
1487: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1488: 'INV_REPORT_MISSING_QTY');
1489: END IF;
1490: wsh_delivery_details_pub.update_shipping_attributes
1491: (p_api_version_number => 1.0,

Line 1490: wsh_delivery_details_pub.update_shipping_attributes

1486: IF l_debug = 1 THEN
1487: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1488: 'INV_REPORT_MISSING_QTY');
1489: END IF;
1490: wsh_delivery_details_pub.update_shipping_attributes
1491: (p_api_version_number => 1.0,
1492: p_init_msg_list => G_TRUE,
1493: p_commit => G_FALSE,
1494: x_return_status => x_return_status,

Line 1502: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1498: p_source_code => 'OE');
1499:
1500: IF x_return_status <> G_RET_STS_SUCCESS THEN
1501: IF l_debug = 1 THEN
1502: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1503: || ' with status: ' || x_return_status, 'INV_REPORT_MISSING_QTY');
1504: END IF;
1505: RAISE fnd_api.g_exc_unexpected_error;
1506: END IF;

Line 1534: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1530: x_return_status OUT NOCOPY VARCHAR2,
1531: x_msg_data OUT NOCOPY VARCHAR2,
1532: x_msg_count OUT NOCOPY NUMBER) IS
1533: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1534: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1535: l_details VARCHAR2(2000);
1536: BEGIN
1537: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1538:

Line 1550: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',

1546: 'INV_REPORT_MISSING_QTY');
1547: END IF;
1548:
1549: IF l_debug = 1 THEN
1550: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1551: 'INV_REPORT_MISSING_QTY');
1552: END IF;
1553: wsh_delivery_details_pub.update_shipping_attributes
1554: (p_api_version_number => 1.0,

Line 1553: wsh_delivery_details_pub.update_shipping_attributes

1549: IF l_debug = 1 THEN
1550: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1551: 'INV_REPORT_MISSING_QTY');
1552: END IF;
1553: wsh_delivery_details_pub.update_shipping_attributes
1554: (p_api_version_number => 1.0,
1555: p_init_msg_list => G_TRUE,
1556: p_commit => G_FALSE,
1557: x_return_status => x_return_status,

Line 1565: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1561: p_source_code => 'OE');
1562:
1563: IF x_return_status <> G_RET_STS_SUCCESS THEN
1564: IF l_debug = 1 THEN
1565: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1566: || ' with status: ' || x_return_status, 'INV_REPORT_MISSING_QTY');
1567: END IF;
1568: RAISE fnd_api.g_exc_unexpected_error;
1569: END IF;

Line 1591: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1587: x_return_status OUT NOCOPY VARCHAR2,
1588: x_msg_data OUT NOCOPY VARCHAR2,
1589: x_msg_count OUT NOCOPY NUMBER ) IS
1590: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1591: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1592:
1593:
1594: l_details VARCHAR2(2000);
1595:

Line 1600: FROM WSH_DELIVERY_DETAILS_OB_GRP_V

1596: CURSOR c_weight_vol_info IS
1597: SELECT unit_weight,
1598: unit_volume,
1599: nvl(wv_frozen_flag ,'N') wv_frozen_flag
1600: FROM WSH_DELIVERY_DETAILS_OB_GRP_V
1601: WHERE delivery_detail_id = p_delivery_line_id;
1602:
1603: l_weight_vol_info c_weight_vol_info%ROWTYPE;
1604:

Line 1663: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',

1659:
1660: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
1661:
1662: IF l_debug = 1 THEN
1663: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1664: 'SUBMIT_DELIVERY_LINE');
1665: END IF;
1666:
1667: wsh_delivery_details_pub.update_shipping_attributes

Line 1667: wsh_delivery_details_pub.update_shipping_attributes

1663: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1664: 'SUBMIT_DELIVERY_LINE');
1665: END IF;
1666:
1667: wsh_delivery_details_pub.update_shipping_attributes
1668: (p_api_version_number => 1.0,
1669: p_init_msg_list => G_TRUE,
1670: p_commit => G_TRUE,
1671: x_return_status => x_return_status,

Line 1683: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1679: END IF;
1680:
1681: IF x_return_status <> G_RET_STS_SUCCESS THEN
1682: IF l_debug = 1 THEN
1683: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1684: || ' with status: ' || x_return_status, 'SUBMIT_DELIVERY_LINE');
1685: END IF;
1686: RAISE fnd_api.g_exc_unexpected_error;
1687: END IF;

Line 1716: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1712: x_return_status OUT NOCOPY VARCHAR2,
1713: x_msg_data OUT NOCOPY VARCHAR2,
1714: x_msg_count OUT NOCOPY NUMBER ) IS
1715: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1716: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1717:
1718:
1719: l_details VARCHAR2(2000);
1720:

Line 1725: FROM WSH_DELIVERY_DETAILS_OB_GRP_V

1721: CURSOR c_weight_vol_info IS
1722: SELECT unit_weight,
1723: unit_volume,
1724: nvl(wv_frozen_flag ,'N') wv_frozen_flag
1725: FROM WSH_DELIVERY_DETAILS_OB_GRP_V
1726: WHERE delivery_detail_id = p_delivery_line_id;
1727:
1728: l_weight_vol_info c_weight_vol_info%ROWTYPE;
1729:

Line 1797: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',

1793:
1794: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
1795:
1796: IF l_debug = 1 THEN
1797: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1798: 'SUBMIT_DELIVERY_LINE');
1799: END IF;
1800:
1801: wsh_delivery_details_pub.update_shipping_attributes

Line 1801: wsh_delivery_details_pub.update_shipping_attributes

1797: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1798: 'SUBMIT_DELIVERY_LINE');
1799: END IF;
1800:
1801: wsh_delivery_details_pub.update_shipping_attributes
1802: (p_api_version_number => 1.0,
1803: p_init_msg_list => G_TRUE,
1804: p_commit => G_TRUE,
1805: x_return_status => x_return_status,

Line 1817: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1813: END IF;
1814:
1815: IF x_return_status <> G_RET_STS_SUCCESS THEN
1816: IF l_debug = 1 THEN
1817: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1818: || ' with status: ' || x_return_status, 'SUBMIT_DELIVERY_LINE');
1819: END IF;
1820: RAISE fnd_api.g_exc_unexpected_error;
1821: END IF;

Line 1965: FROM wsh_delivery_details_ob_grp_v

1961: BEGIN
1962:
1963: SELECT source_line_id
1964: INTO l_source_line_id
1965: FROM wsh_delivery_details_ob_grp_v
1966: WHERE delivery_detail_id = p_delivery_detail_id;
1967:
1968: RETURN GET_LINE_TRANSACTION_TYPE(l_source_line_id,x_trx_source_type_id,
1969: x_trx_action_id,x_return_status);

Line 1988: from wsh_delivery_details_ob_grp_v dd,

1984: IS
1985:
1986: CURSOR c_delivery_details is
1987: SELECT dd.*
1988: from wsh_delivery_details_ob_grp_v dd,
1989: wsh_delivery_assignments_v da
1990: where
1991: da.delivery_id = p_delivery_id
1992: and da.delivery_detail_id = dd.delivery_detail_id

Line 1997: from wsh_delivery_details wdd1,

1993: and dd.lpn_id is null;
1994:
1995: CURSOR get_lpn_id_wdd(l_delivery_detail_id NUMBER) IS --16482236
1996: SELECT wdd1.lpn_id
1997: from wsh_delivery_details wdd1,
1998: wsh_delivery_details wdd2,
1999: wsh_delivery_assignments wda
2000: WHERE wdd2.delivery_detail_id = l_delivery_detail_id
2001: AND wdd2.delivery_detail_id = wda.delivery_detail_id

Line 1998: wsh_delivery_details wdd2,

1994:
1995: CURSOR get_lpn_id_wdd(l_delivery_detail_id NUMBER) IS --16482236
1996: SELECT wdd1.lpn_id
1997: from wsh_delivery_details wdd1,
1998: wsh_delivery_details wdd2,
1999: wsh_delivery_assignments wda
2000: WHERE wdd2.delivery_detail_id = l_delivery_detail_id
2001: AND wdd2.delivery_detail_id = wda.delivery_detail_id
2002: AND wda.parent_delivery_detail_id IS NOT NULL

Line 2139: FROM wsh_delivery_details_ob_grp_v wdd,

2135: unshipped_count NUMBER;
2136:
2137: CURSOR specified_ship_set IS
2138: SELECT wdd.ship_set_id
2139: FROM wsh_delivery_details_ob_grp_v wdd,
2140: wsh_delivery_assignments_v wda
2141: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2142: AND EXISTS (SELECT 'x'
2143: FROM wsh_delivery_details_ob_grp_v wdd2

Line 2143: FROM wsh_delivery_details_ob_grp_v wdd2

2139: FROM wsh_delivery_details_ob_grp_v wdd,
2140: wsh_delivery_assignments_v wda
2141: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2142: AND EXISTS (SELECT 'x'
2143: FROM wsh_delivery_details_ob_grp_v wdd2
2144: WHERE wdd2.delivery_detail_id = wdd.delivery_detail_id
2145: AND wdd2.ship_set_id is not null
2146: AND wdd2.shipped_quantity is not null)
2147: AND wda.delivery_id = p_delivery_id;

Line 2157: FROM wsh_delivery_details_ob_grp_v wdd,

2153: FETCH specified_ship_set INTO l_ship_set_id;
2154: EXIT WHEN specified_ship_set%NOTFOUND;
2155: SELECT count(*)
2156: INTO unshipped_count
2157: FROM wsh_delivery_details_ob_grp_v wdd,
2158: wsh_delivery_assignments_v wda,
2159: wsh_new_deliveries_ob_grp_v wnd
2160: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2161: AND wda.delivery_id = wnd.delivery_id

Line 2199: from wsh_delivery_details_ob_grp_v wdd,

2195: select 1
2196: into exist_unspecified
2197: from dual
2198: where exists (select 1
2199: from wsh_delivery_details_ob_grp_v wdd,
2200: wsh_delivery_assignments_v wda
2201: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2202: AND wdd.shipped_quantity is null
2203: AND wdd.container_flag = 'N'

Line 2222: from wsh_delivery_details_ob_grp_v wdd,

2218: l_return_status VARCHAR2(1);
2219:
2220: CURSOR delivery_details IS
2221: select wdd.delivery_detail_id
2222: from wsh_delivery_details_ob_grp_v wdd,
2223: wsh_delivery_assignments_v wda,
2224: wsh_new_deliveries_ob_grp_v wnd
2225: where wdd.delivery_detail_id = wda.delivery_detail_id
2226: AND wda.delivery_id = wnd.delivery_id

Line 2235: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(

2231: l_delivery_detail_id delivery_details%ROWTYPE;
2232: BEGIN
2233: for l_delivery_detail_id in delivery_details
2234: loop
2235: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(
2236: l_delivery_detail_id.delivery_detail_id,
2237: l_return_status);
2238: exit when l_return_status<>FND_API.G_RET_STS_SUCCESS;
2239: end loop;

Line 2254: FROM wsh_delivery_details_ob_grp_v wdd,

2250: SELECT 1
2251: INTO exist_unqualified
2252: FROM dual
2253: WHERE EXISTS (SELECT 1
2254: FROM wsh_delivery_details_ob_grp_v wdd,
2255: wsh_delivery_assignments_v wda
2256: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2257: AND wda.delivery_id = p_delivery_id
2258: AND wdd.container_flag = 'N'

Line 2775: From wsh_delivery_details_ob_grp_v

2771: l_return_status := 'S';
2772:
2773: select transaction_temp_id
2774: into l_transaction_temp_id
2775: From wsh_delivery_details_ob_grp_v
2776: where delivery_detail_id = l_delivery_detail_id;
2777:
2778: l_delay_quantity := l_requested_quantity - l_shipped_quantity;
2779:

Line 2780: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details

2776: where delivery_detail_id = l_delivery_detail_id;
2777:
2778: l_delay_quantity := l_requested_quantity - l_shipped_quantity;
2779:
2780: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details
2781: (p_from_detail_id => l_delivery_detail_id,
2782: p_req_quantity => l_delay_quantity,
2783: x_new_detail_id => l_new_delivery_line_id,
2784: x_return_status => l_return_status

Line 2792: from wsh_delivery_details_ob_grp_v

2788: end if;
2789:
2790: select transaction_temp_id
2791: into l_new_transaction_temp_id
2792: from wsh_delivery_details_ob_grp_v
2793: where delivery_detail_id = l_new_delivery_line_id;
2794:
2795: IF (l_debug = 1) THEN
2796: debug('new transaction_temp_id is ' || l_new_transaction_temp_id,

Line 2920: From wsh_delivery_details_ob_grp_v

2916: l_return_status := 'S';
2917:
2918: select transaction_temp_id
2919: into l_transaction_temp_id
2920: From wsh_delivery_details_ob_grp_v
2921: where delivery_detail_id = l_delivery_detail_id;
2922:
2923: l_delay_quantity := l_requested_quantity - l_shipped_quantity;
2924:

Line 2928: /* Changes in call to WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details */

2924:
2925: /* Calculate the value for l_sec_delay_quantity */
2926: l_sec_delay_quantity := p_sec_requested_quantity - p_sec_ship_quantity;
2927:
2928: /* Changes in call to WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details */
2929: IF l_sec_delay_quantity IS NOT NULL THEN
2930: IF l_debug = 1 THEN
2931: debug('Setting Secondary Delay Quantity: ' || l_sec_delay_quantity,'INV_SPLIT_DELIVERY_LINE');
2932: END IF;

Line 2934: /* pass on the secondary delay quantity to WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details */

2930: IF l_debug = 1 THEN
2931: debug('Setting Secondary Delay Quantity: ' || l_sec_delay_quantity,'INV_SPLIT_DELIVERY_LINE');
2932: END IF;
2933:
2934: /* pass on the secondary delay quantity to WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details */
2935:
2936: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details
2937: (p_from_detail_id => l_delivery_detail_id,
2938: p_req_quantity => l_delay_quantity,

Line 2936: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details

2932: END IF;
2933:
2934: /* pass on the secondary delay quantity to WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details */
2935:
2936: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details
2937: (p_from_detail_id => l_delivery_detail_id,
2938: p_req_quantity => l_delay_quantity,
2939: p_req_quantity2 => l_sec_delay_quantity,
2940: x_new_detail_id => l_new_delivery_line_id,

Line 2944: /* call WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details without secondary delay quantity */

2940: x_new_detail_id => l_new_delivery_line_id,
2941: x_return_status => l_return_status
2942: );
2943: ELSE
2944: /* call WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details without secondary delay quantity */
2945: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details
2946: (p_from_detail_id => l_delivery_detail_id,
2947: p_req_quantity => l_delay_quantity,
2948: x_new_detail_id => l_new_delivery_line_id,

Line 2945: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details

2941: x_return_status => l_return_status
2942: );
2943: ELSE
2944: /* call WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details without secondary delay quantity */
2945: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details
2946: (p_from_detail_id => l_delivery_detail_id,
2947: p_req_quantity => l_delay_quantity,
2948: x_new_detail_id => l_new_delivery_line_id,
2949: x_return_status => l_return_status

Line 2960: from wsh_delivery_details_ob_grp_v

2956: end if;
2957:
2958: select transaction_temp_id
2959: into l_new_transaction_temp_id
2960: from wsh_delivery_details_ob_grp_v
2961: where delivery_detail_id = l_new_delivery_line_id;
2962:
2963: IF (l_debug = 1) THEN
2964: debug('new transaction_temp_id is ' || l_new_transaction_temp_id,

Line 3044: from mtl_serial_numbers_temp msnt, wsh_delivery_details_ob_grp_v wdd

3040: l_count NUMBER;
3041: BEGIN
3042: select count(*)
3043: into l_count
3044: from mtl_serial_numbers_temp msnt, wsh_delivery_details_ob_grp_v wdd
3045: where msnt.transaction_temp_id = wdd.transaction_temp_id
3046: and wdd.delivery_detail_id = l_delivery_detail_id
3047: and wdd.transaction_temp_id = l_transaction_temp_id;
3048:

Line 3052: From wsh_delivery_details_ob_grp_v

3048:
3049: if( l_count > 0 ) then
3050: delete from mtl_serial_numbers_temp
3051: where transaction_temp_id in (select transaction_temp_id
3052: From wsh_delivery_details_ob_grp_v
3053: where transaction_temp_id = l_transaction_temp_id
3054: And delivery_detail_id = l_delivery_detail_id);
3055: end if;
3056: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3208: FROM wsh_delivery_details

3204: l_lot_number VARCHAR2(80) := null;
3205: BEGIN
3206:
3207: SELECT lot_number INTO l_lot_number
3208: FROM wsh_delivery_details
3209: WHERE delivery_detail_id = p_delivery_detail_id
3210: AND lot_number IS NOT NULL;
3211:
3212: BEGIN

Line 3217: , wsh_delivery_details wdd

3213: /* If this returns values, that means no lot_specific conversion defined, so return 0*/
3214: SELECT wdd.lot_number INTO l_lot_number
3215: FROM mtl_lot_uom_class_conversions lsc
3216: , mtl_uom_class_conversions uc
3217: , wsh_delivery_details wdd
3218: WHERE lsc.inventory_item_id = uc.inventory_item_id
3219: AND uc.from_uom_code = lsc.from_uom_code
3220: AND uc.to_uom_code = lsc.to_uom_code
3221: AND uc.conversion_rate = lsc.conversion_rate