APPS.WMS_DOCK_APPOINTMENTS_PUB dependencies on WSH_CARRIERS

Line 705: l_carrier_code WSH_CARRIERS.FREIGHT_CODE%TYPE;

701:
702: --Local variables
703: l_progress NUMBER; --Used to check progress of the procedure
704: l_no_trip_rec BOOLEAN := FALSE;
705: l_carrier_code WSH_CARRIERS.FREIGHT_CODE%TYPE;
706:
707: BEGIN
708:
709: l_progress :=10;

Line 800: --fetching the carrier code from wsh_carriers table

796:
797: l_progress := 30;
798:
799: --If carrier id is passed instead of carrier code,
800: --fetching the carrier code from wsh_carriers table
801: BEGIN
802: IF( p_carrier_code IS NULL AND p_carrier_id IS NOT NULL ) THEN
803: SELECT FREIGHT_CODE INTO l_carrier_code
804: FROM WSH_CARRIERS

Line 804: FROM WSH_CARRIERS

800: --fetching the carrier code from wsh_carriers table
801: BEGIN
802: IF( p_carrier_code IS NULL AND p_carrier_id IS NOT NULL ) THEN
803: SELECT FREIGHT_CODE INTO l_carrier_code
804: FROM WSH_CARRIERS
805: WHERE CARRIER_ID = p_carrier_id;
806: ELSIF (p_carrier_code IS NOT NULL) THEN
807: --If carrier code is passed then using the same carrier code
808: l_carrier_code := p_carrier_code;