APPS.WSH_CONC_UTIL_PKG dependencies on WSH_CARRIER_SERVICES

Line 29: from wsh_carriers wc, wsh_carrier_services wcs

25:
26:
27: cursor c_get_new_fgt_code (p_ship_method_code varchar2) is
28: select wc.freight_code, wc.carrier_id
29: from wsh_carriers wc, wsh_carrier_services wcs
30: where
31: wcs.ship_method_code = p_ship_method_code
32: and wcs.carrier_id = wc.carrier_id;
33:

Line 41: wsh_carrier_services wcs

37: select wcsm.ship_method_code , wcsm.organization_id , wcsm.freight_code
38: from wsh_carrier_ship_methods wcsm
39: where
40: not exists (select 'x' from wsh_carriers wc,
41: wsh_carrier_services wcs
42: where
43: wc.freight_code = wcsm.freight_code
44: and wc.carrier_id = wcs.carrier_id
45: and wcs.ship_method_code = wcsm.ship_method_code);

Line 505: -- Description: utility to lock/stamp WSH_CARRIER_SERVICES for ECO 5069719

501: END process_entity_sm;
502:
503:
504:
505: -- Description: utility to lock/stamp WSH_CARRIER_SERVICES for ECO 5069719
506: --
507: -- if ship method is pending in an active record, this
508: -- will be treated as locked.
509: --

Line 515: -- p_carrier_service_id = WSH_CARRIER_SERVICES record to update.

511: -- update this service as pending this request.
512: --
513: -- non-lock exceptions will be raised to callers.
514: -- Parameters:
515: -- p_carrier_service_id = WSH_CARRIER_SERVICES record to update.
516: -- p_new_state = value to set UPDATE_MOT_SL:
517: -- 'P' -- to be processed by this request
518: -- 'Y' -- needs update, available for next request
519: -- NULL -- completely processed

Line 527: FROM WSH_CARRIER_SERVICES

523:
524: CURSOR c_lock_service(p_id NUMBER) IS
525: SELECT update_mot_sl,
526: request_id
527: FROM WSH_CARRIER_SERVICES
528: WHERE carrier_service_id = p_id
529: AND update_mot_sl IN ('Y', 'P')
530: FOR UPDATE NOWAIT;
531:

Line 588: UPDATE WSH_CARRIER_SERVICES

584: END IF;
585:
586: IF l_found THEN
587: -- update this service for this request.
588: UPDATE WSH_CARRIER_SERVICES
589: SET update_mot_sl = p_new_state,
590: request_id = fnd_global.conc_request_id,
591: last_updated_by = fnd_global.user_id,
592: last_update_date = sysdate

Line 698: FROM WSH_CARRIER_SERVICES

694: ship_method_code,
695: carrier_id,
696: service_level,
697: mode_of_transport
698: FROM WSH_CARRIER_SERVICES
699: WHERE UPDATE_MOT_SL IN ('Y', 'P');
700:
701: -- inc = incompletely updated
702: -- nu = not updated because of locks

Line 716: l_sm_state WSH_CARRIER_SERVICES.UPDATE_MOT_SL%TYPE;

712:
713: l_count_dds NUMBER;
714: l_count_dds_nu NUMBER;
715:
716: l_sm_state WSH_CARRIER_SERVICES.UPDATE_MOT_SL%TYPE;
717:
718: BEGIN
719: l_count_sm := 0;
720: l_count_sm_inc := 0;