APPS.WSH_SHIPMENT_REQUEST_PKG dependencies on WSH_CARRIERS

Line 5512: l_carrier_code WSH_CARRIERS.Freight_Code%TYPE;

5508:
5509: l_return_status VARCHAR2(1);
5510: l_temp_status VARCHAR2(1);
5511: l_tmp VARCHAR2(1);
5512: l_carrier_code WSH_CARRIERS.Freight_Code%TYPE;
5513: l_missing_attr VARCHAR2(1000);
5514: l_carrier_id NUMBER;
5515: l_header_id NUMBER;
5516: l_call_attr_changed BOOLEAN;

Line 5666: from wsh_carriers

5662: IF x_del_interface_rec.carrier_id is not null
5663: THEN
5664: select freight_code
5665: into l_carrier_code
5666: from wsh_carriers
5667: where carrier_id = x_del_interface_rec.carrier_id;
5668: ELSIF x_del_interface_rec.carrier_code is not null THEN
5669: select carrier_id
5670: into x_del_interface_rec.carrier_id

Line 5671: from wsh_carriers

5667: where carrier_id = x_del_interface_rec.carrier_id;
5668: ELSIF x_del_interface_rec.carrier_code is not null THEN
5669: select carrier_id
5670: into x_del_interface_rec.carrier_id
5671: from wsh_carriers
5672: where freight_code = x_del_interface_rec.carrier_code;
5673:
5674: l_carrier_id := x_del_interface_rec.carrier_id;
5675: l_carrier_code := x_del_interface_rec.carrier_code;