APPS.OKE_DTS_INTEGRATION_PKG dependencies on WSH_DELIVERY_DETAILS

Line 581: l_ship_rec wsh_delivery_details_pkg.delivery_details_rec_type;

577: P_DELIVERABLE_ID IN NUMBER,
578: X_DELVIERY_DETAIL_ID OUT NOCOPY NUMBER,
579: X_RETURN_STATUS OUT NOCOPY VARCHAR2) IS
580:
581: l_ship_rec wsh_delivery_details_pkg.delivery_details_rec_type;
582: l_return_status varchar2(1);
583: l_api_version CONSTANT NUMBER :=1;
584: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_SHIP_LINE';
585:

Line 2532: FROM wsh_delivery_details

2528: where deliverable_id = p_deliverable_id;
2529:
2530: CURSOR cancel_qty_c IS
2531: SELECT Nvl(Sum(CANCELLED_QUANTITY),0)
2532: FROM wsh_delivery_details
2533: where source_code = 'OKE'
2534: AND SOURCE_line_ID = p_deliverable_id
2535: START WITH DELIVERY_DETAIL_ID=l_shipping_request_id
2536: CONNECT BY PRIOR DELIVERY_DETAIL_ID = SPLIT_FROM_DELIVERY_DETAIL_ID;