APPS.WSH_WV_PVT dependencies on WSH_DELIVERIES

Line 92: -- and, if update_flag is 'Y', updates the table WSH_DELIVERIES

88:
89:
90: -- Name dep_weight_volume
91: -- Purpose Computes departure net weight and volume
92: -- and, if update_flag is 'Y', updates the table WSH_DELIVERIES
93: -- Called by departure_weight_volume
94:
95: -- Arguments
96: -- source 'DPW' or 'SC'

Line 137: FROM wsh_deliveries

133: CURSOR delivery_recs(x_dep_id NUMBER) IS
134: SELECT delivery_id,
135: gross_weight, weight_uom_code,
136: volume, volume_uom_code
137: FROM wsh_deliveries
138: WHERE actual_departure_id = x_dep_id
139: AND status_code <> 'CA';
140:
141: -- bug 650601 fix: this cursor added to calculate tare weight

Line 252: UPDATE wsh_deliveries

248: END IF;
249:
250: IF update_flag = 'Y'
251: AND (x_gross_weight > 0 OR x_volume > 0) THEN
252: UPDATE wsh_deliveries
253: SET gross_weight = decode(x_gross_weight, 0, gross_weight,
254: x_gross_weight),
255: weight_uom_code = decode(x_gross_weight, 0, weight_uom_code,
256: master_weight_uom),

Line 707: wsh_deliveries d

703: CURSOR container_fill(x_dep_id NUMBER, x_o_id NUMBER, x_veh_id NUMBER) IS
704: SELECT SUM(pc.quantity / cl.max_load_quantity) * 100
705: FROM wsh_container_load cl,
706: wsh_packed_containers pc,
707: wsh_deliveries d
708: WHERE d.actual_departure_id = x_dep_id
709: AND d.delivery_id = pc.delivery_id
710: AND pc.container_inventory_item_id = cl.load_item_id
711: AND cl.container_item_id = x_veh_id

Line 820: -- and, if update_flag is 'Y', updates the table WSH_DELIVERIES

816:
817:
818: -- Name del_weight_volume
819: -- Purpose Computes one delivery's net weight and volume
820: -- and, if update_flag is 'Y', updates the table WSH_DELIVERIES
821:
822: -- Arguments
823: -- source 'DPW' or 'SC'
824: -- delivery_id

Line 826: -- update_flag 'Y' or 'N' (update WSH_DELIVERIES?)

822: -- Arguments
823: -- source 'DPW' or 'SC'
824: -- delivery_id
825: -- organization_id
826: -- update_flag 'Y' or 'N' (update WSH_DELIVERIES?)
827: -- menu_flag 'Y' or 'N' (indicates if invoked from
828: -- the menu by the user or not).
829: -- dpw_pack_flag 'Y' or 'N' to automatically pack containers
830: -- (valid only when source = 'DPW')

Line 892: UPDATE wsh_deliveries

888:
889: IF update_flag = 'Y' THEN
890: IF x_gross_weight > 0 AND x_volume > 0 THEN
891:
892: UPDATE wsh_deliveries
893: SET gross_weight = x_gross_weight,
894: weight_uom_code = x_master_weight_uom,
895: volume = x_volume,
896: volume_uom_code = x_master_volume_uom

Line 901: UPDATE wsh_deliveries

897: WHERE delivery_id = x_del_id;
898:
899: ELSIF x_gross_weight > 0 THEN
900:
901: UPDATE wsh_deliveries
902: SET gross_weight = x_gross_weight,
903: weight_uom_code = x_master_weight_uom
904: WHERE delivery_id = x_del_id;
905:

Line 908: UPDATE wsh_deliveries

904: WHERE delivery_id = x_del_id;
905:
906: ELSIF x_volume > 0 THEN
907:
908: UPDATE wsh_deliveries
909: SET volume = x_volume,
910: volume_uom_code = x_master_volume_uom
911: WHERE delivery_id = x_del_id;
912: