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' or
175: ( wdd.released_status = 'X' and

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

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

Line 219: from wsh_delivery_details_ob_grp_v wdd

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

Line 234: FROM wsh_delivery_details wdd,

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

Line 253: FROM wsh_delivery_details_ob_grp_v wdd,

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

Line 350: FROM wsh_new_deliveries_ob_grp_v del, wsh_delivery_details_ob_grp_v dd,

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

Line 375: wsh_delivery_details_ob_grp_v dd,

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

Line 405: wsh_delivery_details_ob_grp_v dd,

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

Line 480: from wsh_delivery_details_ob_grp_v

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

Line 615: from wsh_delivery_assignments_v da,wsh_delivery_details_ob_grp_v dd

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

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

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

Line 664: , wsh_delivery_details_ob_grp_v wdd

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

Line 685: from wsh_delivery_details_ob_grp_v dd

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

Line 718: from wsh_delivery_details_ob_grp_v

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

Line 845: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

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

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

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

Line 863: wsh_delivery_details_pub.update_shipping_attributes

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

Line 875: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

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

Line 905: from wsh_delivery_details_ob_grp_v dd

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

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

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

Line 929: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

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

Line 1027: FROM wsh_delivery_details_ob_grp_v wdd

1023: END IF;
1024:
1025: SELECT lpn_id
1026: INTO l_lpn_id
1027: FROM wsh_delivery_details_ob_grp_v wdd
1028: WHERE delivery_detail_id = l_parent_delivery_detail_id;
1029:
1030: IF l_debug = 1 THEN
1031: debug('l_lpn_id: '|| l_lpn_id, 'INV_LINE_RETURN_TO_STOCK');

Line 1071: WSH_DELIVERY_DETAILS_PUB.split_line

1067: || ' requested : ' || l_requested_quantities_table(1)
1068: , 'INV_LINE_RETURN_TO_STOCK');
1069: END IF;
1070:
1071: WSH_DELIVERY_DETAILS_PUB.split_line
1072: (p_api_version => 1.0,
1073: p_init_msg_list => fnd_api.g_false,
1074: p_commit => p_commit_flag,
1075: x_return_status => l_return_status,

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

1081: x_split_quantity2 => l_dummy_num_var);
1082:
1083: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1084: IF l_debug = 1 THEN
1085: debug('WSH_DELIVERY_DETAILS_PUB.split_line failed',
1086: 'INV_LINE_RETURN_TO_STOCK');
1087: END IF;
1088:
1089: RAISE fnd_api.g_exc_unexpected_error;

Line 1096: wsh_delivery_details_pub.update_shipping_attributes

1092: l_detail_attributes(1).delivery_detail_id :=
1093: l_delivery_details_id_table(1);
1094: l_detail_attributes(1).shipped_quantity := p_shipped_quantity;
1095:
1096: wsh_delivery_details_pub.update_shipping_attributes
1097: (p_api_version_number => 1.0,
1098: p_init_msg_list => fnd_api.g_false,
1099: p_commit => p_commit_flag,
1100: x_return_status => l_return_status,

Line 1108: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',

1104: p_source_code => 'OE');
1105:
1106: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1107: IF l_debug = 1 THEN
1108: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',
1109: 'INV_LINE_RETURN_TO_STOCK');
1110: END IF;
1111:
1112: RAISE fnd_api.g_exc_unexpected_error;

Line 1206: from wsh_delivery_details_ob_grp_v dd

1202: /* Change the cursor to pick up secondary picked and requested quantities */
1203: cursor delivery_line(p_delivery_detail_id NUMBER) is
1204: select dd.delivery_detail_id, dd.requested_quantity, dd.picked_quantity,
1205: PICKED_QUANTITY2, REQUESTED_QUANTITY2
1206: from wsh_delivery_details_ob_grp_v dd
1207: WHERE dd.delivery_detail_id = p_delivery_detail_id;
1208:
1209: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
1210: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id

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

1207: WHERE dd.delivery_detail_id = p_delivery_detail_id;
1208:
1209: cursor lpn_csr(p_delivery_detail_id in NUMBER) is
1210: select wdd.delivery_detail_id, wda.delivery_assignment_id,wda2.delivery_assignment_id
1211: from wsh_delivery_details_ob_grp_v wdd, wsh_delivery_assignments_v wda, wsh_delivery_details_ob_grp_v wdd2
1212: , wsh_delivery_assignments_v wda2
1213: where wdd.delivery_detail_id = wda.parent_delivery_detail_id
1214: and wda.delivery_detail_id = wdd2.delivery_detail_id
1215: and wdd2.delivery_detail_id = p_delivery_detail_id

Line 1233: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;

1229: l_sec_req_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1230: l_sec_ovpk_qtys_table WSH_UTIL_CORE.ID_TAB_TYPE;
1231: l_dummy_table wsh_util_core.id_tab_type;
1232: l_out_rows wsh_util_core.id_tab_type;
1233: l_detail_attributes wsh_delivery_details_pub.ChangedAttributeTabType;
1234: l_dummy_num_var NUMBER := NULL;
1235: l_table_index NUMBER := 1;
1236:
1237: l_picked_quantity NUMBER;

Line 1314: FROM wsh_delivery_details_ob_grp_v wdd

1310: EXIT WHEN lpn_csr%NOTFOUND;
1311:
1312: SELECT lpn_id
1313: INTO l_lpn_id
1314: FROM wsh_delivery_details_ob_grp_v wdd
1315: WHERE delivery_detail_id = l_parent_delivery_detail_id;
1316:
1317: --update LPN(s) context to Resides in Inventory
1318: FOR l_par_lpn_id IN nested_parent_lpn_cursor(l_lpn_id) LOOP

Line 1346: WSH_DELIVERY_DETAILS_PUB.split_line

1342: || ' requested : ' || l_requested_quantities_table(1)
1343: , 'INV_LINE_RETURN_TO_STOCK');
1344: END IF;
1345:
1346: WSH_DELIVERY_DETAILS_PUB.split_line
1347: (p_api_version => 1.0,
1348: p_init_msg_list => fnd_api.g_false,
1349: p_commit => p_commit_flag,
1350: x_return_status => l_return_status,

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

1356: x_split_quantity2 => l_sec_bck_qtys_table(1));
1357:
1358: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1359: IF l_debug = 1 THEN
1360: debug('WSH_DELIVERY_DETAILS_PUB.split_line failed',
1361: 'INV_LINE_RETURN_TO_STOCK');
1362: END IF;
1363:
1364: RAISE fnd_api.g_exc_unexpected_error;

Line 1374: wsh_delivery_details_pub.update_shipping_attributes

1370:
1371: /* set secondary shipped quantity into the delivery details attribute set */
1372: l_detail_attributes(1).shipped_quantity2 := p_sec_shipped_quantity;
1373:
1374: wsh_delivery_details_pub.update_shipping_attributes
1375: (p_api_version_number => 1.0,
1376: p_init_msg_list => fnd_api.g_false,
1377: p_commit => p_commit_flag,
1378: x_return_status => l_return_status,

Line 1386: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',

1382: p_source_code => 'OE');
1383:
1384: IF l_return_status <> fnd_api.g_ret_sts_success THEN
1385: IF l_debug = 1 THEN
1386: debug('wsh_delivery_details_pub.update_shipping_attributesfailed',
1387: 'INV_LINE_RETURN_TO_STOCK');
1388: END IF;
1389:
1390: RAISE fnd_api.g_exc_unexpected_error;

Line 1461: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1457: x_return_status OUT NOCOPY VARCHAR2,
1458: x_msg_data OUT NOCOPY VARCHAR2,
1459: x_msg_count OUT NOCOPY NUMBER) IS
1460: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1461: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1462: l_details VARCHAR2(2000);
1463: BEGIN
1464: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1465: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;

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

1464: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1465: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
1466:
1467: IF l_debug = 1 THEN
1468: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1469: 'INV_REPORT_MISSING_QTY');
1470: END IF;
1471: wsh_delivery_details_pub.update_shipping_attributes
1472: (p_api_version_number => 1.0,

Line 1471: wsh_delivery_details_pub.update_shipping_attributes

1467: IF l_debug = 1 THEN
1468: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1469: 'INV_REPORT_MISSING_QTY');
1470: END IF;
1471: wsh_delivery_details_pub.update_shipping_attributes
1472: (p_api_version_number => 1.0,
1473: p_init_msg_list => G_TRUE,
1474: p_commit => G_FALSE,
1475: x_return_status => x_return_status,

Line 1483: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1479: p_source_code => 'OE');
1480:
1481: IF x_return_status <> G_RET_STS_SUCCESS THEN
1482: IF l_debug = 1 THEN
1483: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1484: || ' with status: ' || x_return_status, 'INV_REPORT_MISSING_QTY');
1485: END IF;
1486: RAISE fnd_api.g_exc_unexpected_error;
1487: END IF;

Line 1515: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1511: x_return_status OUT NOCOPY VARCHAR2,
1512: x_msg_data OUT NOCOPY VARCHAR2,
1513: x_msg_count OUT NOCOPY NUMBER) IS
1514: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1515: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1516: l_details VARCHAR2(2000);
1517: BEGIN
1518: l_detail_attributes(1).cycle_count_quantity := p_missing_quantity;
1519:

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

1527: 'INV_REPORT_MISSING_QTY');
1528: END IF;
1529:
1530: IF l_debug = 1 THEN
1531: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1532: 'INV_REPORT_MISSING_QTY');
1533: END IF;
1534: wsh_delivery_details_pub.update_shipping_attributes
1535: (p_api_version_number => 1.0,

Line 1534: wsh_delivery_details_pub.update_shipping_attributes

1530: IF l_debug = 1 THEN
1531: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1532: 'INV_REPORT_MISSING_QTY');
1533: END IF;
1534: wsh_delivery_details_pub.update_shipping_attributes
1535: (p_api_version_number => 1.0,
1536: p_init_msg_list => G_TRUE,
1537: p_commit => G_FALSE,
1538: x_return_status => x_return_status,

Line 1546: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1542: p_source_code => 'OE');
1543:
1544: IF x_return_status <> G_RET_STS_SUCCESS THEN
1545: IF l_debug = 1 THEN
1546: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1547: || ' with status: ' || x_return_status, 'INV_REPORT_MISSING_QTY');
1548: END IF;
1549: RAISE fnd_api.g_exc_unexpected_error;
1550: END IF;

Line 1572: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1568: x_return_status OUT NOCOPY VARCHAR2,
1569: x_msg_data OUT NOCOPY VARCHAR2,
1570: x_msg_count OUT NOCOPY NUMBER ) IS
1571: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1572: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1573:
1574:
1575: l_details VARCHAR2(2000);
1576:

Line 1581: FROM WSH_DELIVERY_DETAILS_OB_GRP_V

1577: CURSOR c_weight_vol_info IS
1578: SELECT unit_weight,
1579: unit_volume,
1580: nvl(wv_frozen_flag ,'N') wv_frozen_flag
1581: FROM WSH_DELIVERY_DETAILS_OB_GRP_V
1582: WHERE delivery_detail_id = p_delivery_line_id;
1583:
1584: l_weight_vol_info c_weight_vol_info%ROWTYPE;
1585:

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

1640:
1641: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
1642:
1643: IF l_debug = 1 THEN
1644: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1645: 'SUBMIT_DELIVERY_LINE');
1646: END IF;
1647:
1648: wsh_delivery_details_pub.update_shipping_attributes

Line 1648: wsh_delivery_details_pub.update_shipping_attributes

1644: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1645: 'SUBMIT_DELIVERY_LINE');
1646: END IF;
1647:
1648: wsh_delivery_details_pub.update_shipping_attributes
1649: (p_api_version_number => 1.0,
1650: p_init_msg_list => G_TRUE,
1651: p_commit => G_TRUE,
1652: x_return_status => x_return_status,

Line 1664: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1660: END IF;
1661:
1662: IF x_return_status <> G_RET_STS_SUCCESS THEN
1663: IF l_debug = 1 THEN
1664: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1665: || ' with status: ' || x_return_status, 'SUBMIT_DELIVERY_LINE');
1666: END IF;
1667: RAISE fnd_api.g_exc_unexpected_error;
1668: END IF;

Line 1697: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;

1693: x_return_status OUT NOCOPY VARCHAR2,
1694: x_msg_data OUT NOCOPY VARCHAR2,
1695: x_msg_count OUT NOCOPY NUMBER ) IS
1696: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
1697: l_detail_attributes WSH_DELIVERY_DETAILS_PUB.ChangedAttributeTabType;
1698:
1699:
1700: l_details VARCHAR2(2000);
1701:

Line 1706: FROM WSH_DELIVERY_DETAILS_OB_GRP_V

1702: CURSOR c_weight_vol_info IS
1703: SELECT unit_weight,
1704: unit_volume,
1705: nvl(wv_frozen_flag ,'N') wv_frozen_flag
1706: FROM WSH_DELIVERY_DETAILS_OB_GRP_V
1707: WHERE delivery_detail_id = p_delivery_line_id;
1708:
1709: l_weight_vol_info c_weight_vol_info%ROWTYPE;
1710:

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

1774:
1775: l_detail_attributes(1).delivery_detail_id := p_delivery_line_id;
1776:
1777: IF l_debug = 1 THEN
1778: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1779: 'SUBMIT_DELIVERY_LINE');
1780: END IF;
1781:
1782: wsh_delivery_details_pub.update_shipping_attributes

Line 1782: wsh_delivery_details_pub.update_shipping_attributes

1778: debug('About to call wsh_delivery_details_pub.update_shipping_attributes',
1779: 'SUBMIT_DELIVERY_LINE');
1780: END IF;
1781:
1782: wsh_delivery_details_pub.update_shipping_attributes
1783: (p_api_version_number => 1.0,
1784: p_init_msg_list => G_TRUE,
1785: p_commit => G_TRUE,
1786: x_return_status => x_return_status,

Line 1798: debug('wsh_delivery_details_pub.update_shipping_attributes failed'

1794: END IF;
1795:
1796: IF x_return_status <> G_RET_STS_SUCCESS THEN
1797: IF l_debug = 1 THEN
1798: debug('wsh_delivery_details_pub.update_shipping_attributes failed'
1799: || ' with status: ' || x_return_status, 'SUBMIT_DELIVERY_LINE');
1800: END IF;
1801: RAISE fnd_api.g_exc_unexpected_error;
1802: END IF;

Line 1946: FROM wsh_delivery_details_ob_grp_v

1942: BEGIN
1943:
1944: SELECT source_line_id
1945: INTO l_source_line_id
1946: FROM wsh_delivery_details_ob_grp_v
1947: WHERE delivery_detail_id = p_delivery_detail_id;
1948:
1949: RETURN GET_LINE_TRANSACTION_TYPE(l_source_line_id,x_trx_source_type_id,
1950: x_trx_action_id,x_return_status);

Line 1969: from wsh_delivery_details_ob_grp_v dd,

1965: IS
1966:
1967: CURSOR c_delivery_details is
1968: SELECT dd.*
1969: from wsh_delivery_details_ob_grp_v dd,
1970: wsh_delivery_assignments_v da
1971: where
1972: da.delivery_id = p_delivery_id
1973: and da.delivery_detail_id = dd.delivery_detail_id

Line 2095: FROM wsh_delivery_details_ob_grp_v wdd,

2091: unshipped_count NUMBER;
2092:
2093: CURSOR specified_ship_set IS
2094: SELECT wdd.ship_set_id
2095: FROM wsh_delivery_details_ob_grp_v wdd,
2096: wsh_delivery_assignments_v wda
2097: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2098: AND EXISTS (SELECT 'x'
2099: FROM wsh_delivery_details_ob_grp_v wdd2

Line 2099: FROM wsh_delivery_details_ob_grp_v wdd2

2095: FROM wsh_delivery_details_ob_grp_v wdd,
2096: wsh_delivery_assignments_v wda
2097: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2098: AND EXISTS (SELECT 'x'
2099: FROM wsh_delivery_details_ob_grp_v wdd2
2100: WHERE wdd2.delivery_detail_id = wdd.delivery_detail_id
2101: AND wdd2.ship_set_id is not null
2102: AND wdd2.shipped_quantity is not null)
2103: AND wda.delivery_id = p_delivery_id;

Line 2113: FROM wsh_delivery_details_ob_grp_v wdd,

2109: FETCH specified_ship_set INTO l_ship_set_id;
2110: EXIT WHEN specified_ship_set%NOTFOUND;
2111: SELECT count(*)
2112: INTO unshipped_count
2113: FROM wsh_delivery_details_ob_grp_v wdd,
2114: wsh_delivery_assignments_v wda,
2115: wsh_new_deliveries_ob_grp_v wnd
2116: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2117: AND wda.delivery_id = wnd.delivery_id

Line 2155: from wsh_delivery_details_ob_grp_v wdd,

2151: select 1
2152: into exist_unspecified
2153: from dual
2154: where exists (select 1
2155: from wsh_delivery_details_ob_grp_v wdd,
2156: wsh_delivery_assignments_v wda
2157: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2158: AND wdd.shipped_quantity is null
2159: AND wdd.container_flag = 'N'

Line 2178: from wsh_delivery_details_ob_grp_v wdd,

2174: l_return_status VARCHAR2(1);
2175:
2176: CURSOR delivery_details IS
2177: select wdd.delivery_detail_id
2178: from wsh_delivery_details_ob_grp_v wdd,
2179: wsh_delivery_assignments_v wda,
2180: wsh_new_deliveries_ob_grp_v wnd
2181: where wdd.delivery_detail_id = wda.delivery_detail_id
2182: AND wda.delivery_id = wnd.delivery_id

Line 2191: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(

2187: l_delivery_detail_id delivery_details%ROWTYPE;
2188: BEGIN
2189: for l_delivery_detail_id in delivery_details
2190: loop
2191: WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Detail_from_Delivery(
2192: l_delivery_detail_id.delivery_detail_id,
2193: l_return_status);
2194: exit when l_return_status<>FND_API.G_RET_STS_SUCCESS;
2195: end loop;

Line 2210: from wsh_delivery_details_ob_grp_v wdd,

2206: select 1
2207: into exist_unqualified
2208: from dual
2209: where exists (select 1
2210: from wsh_delivery_details_ob_grp_v wdd,
2211: wsh_delivery_assignments_v wda
2212: WHERE wdd.delivery_detail_id = wda.delivery_detail_id
2213: AND wda.delivery_id = p_delivery_id
2214: AND wdd.container_flag='N'

Line 2621: From wsh_delivery_details_ob_grp_v

2617: l_return_status := 'S';
2618:
2619: select transaction_temp_id
2620: into l_transaction_temp_id
2621: From wsh_delivery_details_ob_grp_v
2622: where delivery_detail_id = l_delivery_detail_id;
2623:
2624: l_delay_quantity := l_requested_quantity - l_shipped_quantity;
2625:

Line 2626: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details

2622: where delivery_detail_id = l_delivery_detail_id;
2623:
2624: l_delay_quantity := l_requested_quantity - l_shipped_quantity;
2625:
2626: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details
2627: (p_from_detail_id => l_delivery_detail_id,
2628: p_req_quantity => l_delay_quantity,
2629: x_new_detail_id => l_new_delivery_line_id,
2630: x_return_status => l_return_status

Line 2638: from wsh_delivery_details_ob_grp_v

2634: end if;
2635:
2636: select transaction_temp_id
2637: into l_new_transaction_temp_id
2638: from wsh_delivery_details_ob_grp_v
2639: where delivery_detail_id = l_new_delivery_line_id;
2640:
2641: IF (l_debug = 1) THEN
2642: debug('new transaction_temp_id is ' || l_new_transaction_temp_id,

Line 2765: From wsh_delivery_details_ob_grp_v

2761: l_return_status := 'S';
2762:
2763: select transaction_temp_id
2764: into l_transaction_temp_id
2765: From wsh_delivery_details_ob_grp_v
2766: where delivery_detail_id = l_delivery_detail_id;
2767:
2768: l_delay_quantity := l_requested_quantity - l_shipped_quantity;
2769:

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

2769:
2770: /* Calculate the value for l_sec_delay_quantity */
2771: l_sec_delay_quantity := p_sec_requested_quantity - p_sec_ship_quantity;
2772:
2773: /* Changes in call to WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details */
2774: IF l_sec_delay_quantity IS NOT NULL THEN
2775: IF l_debug = 1 THEN
2776: debug('Setting Secondary Delay Quantity: ' || l_sec_delay_quantity,'INV_SPLIT_DELIVERY_LINE');
2777: END IF;

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

2775: IF l_debug = 1 THEN
2776: debug('Setting Secondary Delay Quantity: ' || l_sec_delay_quantity,'INV_SPLIT_DELIVERY_LINE');
2777: END IF;
2778:
2779: /* pass on the secondary delay quantity to WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details */
2780:
2781: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details
2782: (p_from_detail_id => l_delivery_detail_id,
2783: p_req_quantity => l_delay_quantity,

Line 2781: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details

2777: END IF;
2778:
2779: /* pass on the secondary delay quantity to WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details */
2780:
2781: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details
2782: (p_from_detail_id => l_delivery_detail_id,
2783: p_req_quantity => l_delay_quantity,
2784: p_req_quantity2 => l_sec_delay_quantity,
2785: x_new_detail_id => l_new_delivery_line_id,

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

2785: x_new_detail_id => l_new_delivery_line_id,
2786: x_return_status => l_return_status
2787: );
2788: ELSE
2789: /* call WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details without secondary delay quantity */
2790: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details
2791: (p_from_detail_id => l_delivery_detail_id,
2792: p_req_quantity => l_delay_quantity,
2793: x_new_detail_id => l_new_delivery_line_id,

Line 2790: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details

2786: x_return_status => l_return_status
2787: );
2788: ELSE
2789: /* call WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details without secondary delay quantity */
2790: WSH_DELIVERY_DETAILS_ACTIONS.split_delivery_details
2791: (p_from_detail_id => l_delivery_detail_id,
2792: p_req_quantity => l_delay_quantity,
2793: x_new_detail_id => l_new_delivery_line_id,
2794: x_return_status => l_return_status

Line 2805: from wsh_delivery_details_ob_grp_v

2801: end if;
2802:
2803: select transaction_temp_id
2804: into l_new_transaction_temp_id
2805: from wsh_delivery_details_ob_grp_v
2806: where delivery_detail_id = l_new_delivery_line_id;
2807:
2808: IF (l_debug = 1) THEN
2809: debug('new transaction_temp_id is ' || l_new_transaction_temp_id,

Line 2889: from mtl_serial_numbers_temp msnt, wsh_delivery_details_ob_grp_v wdd

2885: l_count NUMBER;
2886: BEGIN
2887: select count(*)
2888: into l_count
2889: from mtl_serial_numbers_temp msnt, wsh_delivery_details_ob_grp_v wdd
2890: where msnt.transaction_temp_id = wdd.transaction_temp_id
2891: and wdd.delivery_detail_id = l_delivery_detail_id
2892: and wdd.transaction_temp_id = l_transaction_temp_id;
2893:

Line 2897: From wsh_delivery_details_ob_grp_v

2893:
2894: if( l_count > 0 ) then
2895: delete from mtl_serial_numbers_temp
2896: where transaction_temp_id in (select transaction_temp_id
2897: From wsh_delivery_details_ob_grp_v
2898: where transaction_temp_id = l_transaction_temp_id
2899: And delivery_detail_id = l_delivery_detail_id);
2900: end if;
2901: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3053: FROM wsh_delivery_details

3049: l_lot_number VARCHAR2(80) := null;
3050: BEGIN
3051:
3052: SELECT lot_number INTO l_lot_number
3053: FROM wsh_delivery_details
3054: WHERE delivery_detail_id = p_delivery_detail_id
3055: AND lot_number IS NOT NULL;
3056:
3057: BEGIN

Line 3062: , wsh_delivery_details wdd

3058: /* If this returns values, that means no lot_specific conversion defined, so return 0*/
3059: SELECT wdd.lot_number INTO l_lot_number
3060: FROM mtl_lot_uom_class_conversions lsc
3061: , mtl_uom_class_conversions uc
3062: , wsh_delivery_details wdd
3063: WHERE lsc.inventory_item_id = uc.inventory_item_id
3064: AND uc.from_uom_code = lsc.from_uom_code
3065: AND uc.to_uom_code = lsc.to_uom_code
3066: AND uc.conversion_rate = lsc.conversion_rate