APPS.WSH_SC_DELIVERY_PVT dependencies on WSH_DEPARTURES

Line 110: FROM wsh_departures

106: -- if freight carrier at the delivery is null, update it from the departure
107: IF freight_carrier IS NULL and dep_id IS NOT NULL THEN
108: SELECT freight_carrier_code
109: INTO dep_freight_carrier
110: FROM wsh_departures
111: WHERE departure_id = dep_id;
112:
113: UPDATE wsh_deliveries
114: SET freight_carrier_code = dep_freight_carrier

Line 164: update wsh_departures

160: volume => X_volume,
161: status => X_status);
162: if (X_status = 0) then
163:
164: update wsh_departures
165: set net_weight = X_net_weight,
166: fill_percent = 0
167: where departure_id = dep_id;
168: end if;

Line 946: x_bol WSH_DEPARTURES.BILL_OF_LADING%TYPE;

942: RETURN NUMBER IS
943:
944: -- declare local variables
945: dep_id Number;
946: x_bol WSH_DEPARTURES.BILL_OF_LADING%TYPE;
947: rep_id number;
948: BEGIN
949:
950: -- Get the new departure id from the sequence

Line 951: select WSH_DEPARTURES_S.nextval into dep_id

947: rep_id number;
948: BEGIN
949:
950: -- Get the new departure id from the sequence
951: select WSH_DEPARTURES_S.nextval into dep_id
952: FROM DUAL;
953:
954: IF ( bol IS NULL) THEN
955: x_bol := WSH_External_Custom.Bill_Of_Lading( dep_id);

Line 965: INSERT INTO WSH_DEPARTURES (

961:
962:
963: -- Now go ahead and to the Insert
964:
965: INSERT INTO WSH_DEPARTURES (
966: ORGANIZATION_ID
967: ,DEPARTURE_ID
968: ,NAME
969: ,SOURCE_CODE