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 517: -- Description: utility to lock/stamp WSH_CARRIER_SERVICES for ECO 5069719

513: END process_entity_sm;
514:
515:
516:
517: -- Description: utility to lock/stamp WSH_CARRIER_SERVICES for ECO 5069719
518: --
519: -- if ship method is pending in an active record, this
520: -- will be treated as locked.
521: --

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

523: -- update this service as pending this request.
524: --
525: -- non-lock exceptions will be raised to callers.
526: -- Parameters:
527: -- p_carrier_service_id = WSH_CARRIER_SERVICES record to update.
528: -- p_new_state = value to set UPDATE_MOT_SL:
529: -- 'P' -- to be processed by this request
530: -- 'Y' -- needs update, available for next request
531: -- NULL -- completely processed

Line 539: FROM WSH_CARRIER_SERVICES

535:
536: CURSOR c_lock_service(p_id NUMBER) IS
537: SELECT update_mot_sl,
538: request_id
539: FROM WSH_CARRIER_SERVICES
540: WHERE carrier_service_id = p_id
541: AND update_mot_sl IN ('Y', 'P')
542: FOR UPDATE NOWAIT;
543:

Line 600: UPDATE WSH_CARRIER_SERVICES

596: END IF;
597:
598: IF l_found THEN
599: -- update this service for this request.
600: UPDATE WSH_CARRIER_SERVICES
601: SET update_mot_sl = p_new_state,
602: request_id = fnd_global.conc_request_id,
603: last_updated_by = fnd_global.user_id,
604: last_update_date = sysdate

Line 710: FROM WSH_CARRIER_SERVICES

706: ship_method_code,
707: carrier_id,
708: service_level,
709: mode_of_transport
710: FROM WSH_CARRIER_SERVICES
711: WHERE UPDATE_MOT_SL IN ('Y', 'P');
712:
713: -- inc = incompletely updated
714: -- nu = not updated because of locks

Line 728: l_sm_state WSH_CARRIER_SERVICES.UPDATE_MOT_SL%TYPE;

724:
725: l_count_dds NUMBER;
726: l_count_dds_nu NUMBER;
727:
728: l_sm_state WSH_CARRIER_SERVICES.UPDATE_MOT_SL%TYPE;
729:
730: BEGIN
731: l_count_sm := 0;
732: l_count_sm_inc := 0;