eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_TP_RELEASE_INT dependencies on WSH_TRIP_STOPS

Line 292: x_stop_attrs_rec OUT NOCOPY wsh_trip_stops_pvt.trip_stop_rec_type

288:
289: PROCEDURE copy_stop_record(
290: p_plan_stop_rec IN plan_stop_rec_type,
291: p_plan_trips IN plan_trip_tab_type,
292: x_stop_attrs_rec OUT NOCOPY wsh_trip_stops_pvt.trip_stop_rec_type
293: );
294:
295: PROCEDURE create_update_plan_trips(
296: p_phase IN NUMBER,

Line 695: wsh_trip_stops_interface wtsi,

691: delete from wsh_del_details_interface wddi
692: where wddi.delivery_detail_interface_id in (
693: select wdai.delivery_detail_interface_id
694: from wsh_trips_interface wti,
695: wsh_trip_stops_interface wtsi,
696: wsh_del_legs_interface wdli,
697: wsh_del_assgn_interface wdai
698: where wti.group_id = p_group_ids(i)
699: and wti.trip_interface_id = wtsi.trip_interface_id

Line 716: wsh_trip_stops_interface wtsi,

712: delete from wsh_del_assgn_interface wdai
713: where wdai.delivery_interface_id in (
714: select wdli.delivery_interface_id
715: from wsh_trips_interface wti,
716: wsh_trip_stops_interface wtsi,
717: wsh_del_legs_interface wdli
718: where wti.group_id = p_group_ids(i)
719: and wti.trip_interface_id = wtsi.trip_interface_id
720: and wti.interface_action_code = G_TP_RELEASE_CODE

Line 734: wsh_trip_stops_interface wtsi,

730: delete from wsh_new_del_interface wndi
731: where wndi.delivery_interface_id in (
732: select wdli.delivery_interface_id
733: from wsh_trips_interface wti,
734: wsh_trip_stops_interface wtsi,
735: wsh_del_legs_interface wdli
736: where wti.group_id = p_group_ids(i)
737: and wti.trip_interface_id = wtsi.trip_interface_id
738: and wti.interface_action_code = G_TP_RELEASE_CODE

Line 751: wsh_trip_stops_interface wtsi

747: delete from wsh_del_legs_interface wdli
748: where wdli.pick_up_stop_interface_id in (
749: select wtsi.stop_interface_id
750: from wsh_trips_interface wti,
751: wsh_trip_stops_interface wtsi
752: where wti.group_id = p_group_ids(i)
753: and wti.trip_interface_id = wtsi.trip_interface_id
754: and wti.interface_action_code = G_TP_RELEASE_CODE
755: and wtsi.interface_action_code = G_TP_RELEASE_CODE)

Line 758: -- Purge wsh_trip_stops_interface

754: and wti.interface_action_code = G_TP_RELEASE_CODE
755: and wtsi.interface_action_code = G_TP_RELEASE_CODE)
756: and wdli.interface_action_code = G_TP_RELEASE_CODE;
757:
758: -- Purge wsh_trip_stops_interface
759:
760: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
761: delete from wsh_trip_stops_interface wtsi
762: where wtsi.trip_interface_id in (

Line 761: delete from wsh_trip_stops_interface wtsi

757:
758: -- Purge wsh_trip_stops_interface
759:
760: FORALL i in p_group_ids.FIRST ..p_group_ids.LAST
761: delete from wsh_trip_stops_interface wtsi
762: where wtsi.trip_interface_id in (
763: select wtsi.stop_interface_id
764: from wsh_trips_interface wti
765: where wti.group_id = p_group_ids(i)

Line 994: wsh_trip_stops_interface wtsi,

990: wddi.source_line_id,
991: wddi.source_line_set_id,
992: wndi.tp_delivery_number
993: from wsh_trips_interface wti,
994: wsh_trip_stops_interface wtsi,
995: wsh_del_legs_interface wdli,
996: wsh_del_assgn_interface wdai,
997: wsh_del_details_interface wddi,
998: wsh_new_del_interface wndi

Line 1125: wsh_trip_stops_interface wtsi,

1121: -- Bug 4274651: It also checks for existence of cancelled lines.
1122: cursor c_tp_dangling_conts (p_group_id in number) is
1123: select wddi.delivery_detail_id
1124: from wsh_trips_interface wti,
1125: wsh_trip_stops_interface wtsi,
1126: wsh_del_legs_interface wdli,
1127: wsh_del_assgn_interface wdai,
1128: wsh_del_details_interface wddi,
1129: wsh_new_del_interface wndi

Line 1592: wsh_trip_stops_interface wtsi,

1588: wddi.src_requested_quantity_uom,
1589: wndi.delivery_id,
1590: wndi.delivery_interface_id
1591: FROM wsh_trips_interface wti,
1592: wsh_trip_stops_interface wtsi,
1593: wsh_del_legs_interface wdli,
1594: wsh_new_del_interface wndi,
1595: wsh_del_assgn_interface wdai,
1596: wsh_del_details_interface wddi

Line 1685: wsh_trip_stops_interface wtsi,

1681: wndi.pooled_ship_to_location_id,
1682: wndi.dock_code,
1683: wnd.wv_frozen_flag -- WV changes
1684: FROM wsh_trips_interface wti,
1685: wsh_trip_stops_interface wtsi,
1686: wsh_del_legs_interface wdli,
1687: wsh_new_del_interface wndi,
1688: wsh_new_deliveries wnd
1689: WHERE wti.group_id = p_group_id

Line 1777: FROM wsh_trip_stops_interface wtsi

1773: wtsi.departure_fill_percent,
1774: wtsi.wkend_layover_stops,
1775: wtsi.wkday_layover_stops,
1776: wtsi.shipments_type_flag
1777: FROM wsh_trip_stops_interface wtsi
1778: WHERE wtsi.trip_interface_id = p_trip_interface_id
1779: AND wtsi.interface_action_code = G_TP_RELEASE_CODE
1780: ORDER BY wtsi.stop_sequence_number
1781: ;

Line 1793: FROM wsh_trip_stops wts

1789: p_planned_arrival_date IN DATE,
1790: p_planned_departure_date IN DATE) IS
1791: SELECT wts.stop_id,
1792: wv_frozen_flag -- WV changes
1793: FROM wsh_trip_stops wts
1794: WHERE wts.trip_id = p_trip_id
1795: AND wts.stop_location_id = p_stop_location_id
1796: AND wts.planned_arrival_date = p_planned_arrival_date
1797: AND wts.planned_departure_date = p_planned_departure_date

Line 1801: FROM wsh_trip_stops wts

1797: AND wts.planned_departure_date = p_planned_departure_date
1798: AND wts.status_code = 'OP'
1799: UNION
1800: SELECT wts.stop_id, wv_frozen_flag
1801: FROM wsh_trip_stops wts
1802: WHERE wts.trip_id = p_trip_id
1803: AND wts.physical_location_id = p_stop_location_id
1804: AND wts.physical_stop_id IS NULL
1805: AND wts.planned_arrival_date = p_planned_arrival_date

Line 1837: wsh_trip_stops wts_pu,

1833: wts_do.planned_arrival_date do_planned_arrival_date,
1834: wts_do.planned_departure_date do_planned_departure_date,
1835: wts_do.wv_frozen_flag do_wv_flag
1836: FROM wsh_delivery_legs wdl,
1837: wsh_trip_stops wts_pu,
1838: wsh_trip_stops wts_do,
1839: wsh_trips wt
1840: WHERE wdl.delivery_id = p_delivery_id
1841: AND wts_pu.stop_id = wdl.pick_up_stop_id

Line 1838: wsh_trip_stops wts_do,

1834: wts_do.planned_departure_date do_planned_departure_date,
1835: wts_do.wv_frozen_flag do_wv_flag
1836: FROM wsh_delivery_legs wdl,
1837: wsh_trip_stops wts_pu,
1838: wsh_trip_stops wts_do,
1839: wsh_trips wt
1840: WHERE wdl.delivery_id = p_delivery_id
1841: AND wts_pu.stop_id = wdl.pick_up_stop_id
1842: AND wts_do.stop_id = wdl.drop_off_stop_id

Line 1874: FROM wsh_trip_stops wts

1870: CURSOR c_physical_stop(p_stop_id IN NUMBER) IS
1871: SELECT planned_arrival_date,
1872: planned_departure_date,
1873: wv_frozen_flag
1874: FROM wsh_trip_stops wts
1875: WHERE wts.stop_id = p_stop_id;
1876:
1877:
1878: -- c_tp_interface_legs makes a list of interface legs.

Line 1886: wsh_trip_stops_interface wtsi_pu

1882: wdli.pick_up_stop_interface_id,
1883: wdli.drop_off_stop_interface_id,
1884: wtsi_pu.trip_interface_id
1885: FROM wsh_del_legs_interface wdli,
1886: wsh_trip_stops_interface wtsi_pu
1887: WHERE wdli.delivery_interface_id = p_delivery_interface_id
1888: AND wdli.interface_action_code = G_TP_RELEASE_CODE
1889: AND wtsi_pu.stop_interface_id = wdli.pick_up_stop_interface_id
1890: AND wtsi_pu.interface_action_code = G_TP_RELEASE_CODE

Line 3674: wsh_trip_stops_pvt.lock_trip_stop_no_compare(

3670: x_plan_stops(l_stop_index).wv_frozen_flag := l_map_stop_rec.wv_frozen_flag; -- WV changes
3671:
3672: -- lock stop
3673: BEGIN
3674: wsh_trip_stops_pvt.lock_trip_stop_no_compare(
3675: p_stop_id => x_plan_stops(l_stop_index).stop_id);
3676: EXCEPTION
3677: WHEN OTHERS THEN
3678: stamp_interface_error(

Line 3680: p_entity_table_name => 'WSH_TRIP_STOPS_INTERFACE',

3676: EXCEPTION
3677: WHEN OTHERS THEN
3678: stamp_interface_error(
3679: p_group_id => x_context.group_id,
3680: p_entity_table_name => 'WSH_TRIP_STOPS_INTERFACE',
3681: p_entity_interface_id => istop.stop_interface_id,
3682: p_message_name => 'WSH_TP_F_NO_LOCK_STOP',
3683: p_token_1_name => 'TRIP_NAME',
3684: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_new_index).trip_id),

Line 4124: wsh_trip_stops_pvt.lock_trip_stop_no_compare(

4120: x_plan_stops(l_stop_index).stop_id := l_map_stop_rec.stop_id;
4121:
4122: -- lock stop
4123: BEGIN
4124: wsh_trip_stops_pvt.lock_trip_stop_no_compare(
4125: p_stop_id => x_plan_stops(l_stop_index).stop_id);
4126: EXCEPTION
4127: WHEN OTHERS THEN
4128: stamp_interface_error(

Line 4130: p_entity_table_name => 'WSH_TRIP_STOPS_INTERFACE',

4126: EXCEPTION
4127: WHEN OTHERS THEN
4128: stamp_interface_error(
4129: p_group_id => x_context.group_id,
4130: p_entity_table_name => 'WSH_TRIP_STOPS_INTERFACE',
4131: p_entity_interface_id => x_plan_stops(l_stop_index).stop_interface_id,
4132: p_message_name => 'WSH_TP_F_NO_LOCK_STOP',
4133: p_token_1_name => 'TRIP_NAME',
4134: p_token_1_value => WSH_TRIPS_PVT.get_name(x_plan_trips(l_trip_index).trip_id),

Line 4713: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;

4709: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
4710: l_del_in_rec WSH_DELIVERIES_GRP.DEL_IN_REC_TYPE;
4711: l_del_out_tab WSH_DELIVERIES_GRP.DEL_OUT_TBL_TYPE;
4712:
4713: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
4714: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
4715: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
4716: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
4717: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;

Line 4714: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

4710: l_del_in_rec WSH_DELIVERIES_GRP.DEL_IN_REC_TYPE;
4711: l_del_out_tab WSH_DELIVERIES_GRP.DEL_OUT_TBL_TYPE;
4712:
4713: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
4714: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
4715: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
4716: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
4717: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
4718: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

Line 4715: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;

4711: l_del_out_tab WSH_DELIVERIES_GRP.DEL_OUT_TBL_TYPE;
4712:
4713: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
4714: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
4715: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
4716: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
4717: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
4718: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
4719: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;

Line 4716: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;

4712:
4713: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
4714: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
4715: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
4716: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
4717: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
4718: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
4719: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;
4720:

Line 4717: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;

4713: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
4714: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
4715: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
4716: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
4717: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
4718: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
4719: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;
4720:
4721: l_trip_attrs WSH_TRIPS_PVT.trip_attr_tbl_type;

Line 4718: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;

4714: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
4715: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
4716: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
4717: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
4718: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
4719: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;
4720:
4721: l_trip_attrs WSH_TRIPS_PVT.trip_attr_tbl_type;
4722: l_trip_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

Line 4719: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;

4715: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
4716: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
4717: l_stop_in_rec WSH_TRIP_STOPS_GRP.stopInRecType;
4718: l_stop_out_tab WSH_TRIP_STOPS_GRP.stop_out_tab_type;
4719: l_stop_wt_vol_out_tab WSH_TRIP_STOPS_GRP.stop_wt_vol_tab_type;
4720:
4721: l_trip_attrs WSH_TRIPS_PVT.trip_attr_tbl_type;
4722: l_trip_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
4723: l_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

Line 4744: from wsh_trip_stops s,

4740: cursor c_check_stop_wv_frozen(p_trip_id in NUMBER,
4741: p_pickup_stop_id in NUMBER,
4742: p_dropoff_stop_id in NUMBER) IS
4743: select s.stop_id, s.stop_location_id
4744: from wsh_trip_stops s,
4745: wsh_trip_stops spu,
4746: wsh_trip_stops sdo
4747: where s.wv_frozen_flag = 'Y'
4748: and (s.stop_sequence_number between

Line 4745: wsh_trip_stops spu,

4741: p_pickup_stop_id in NUMBER,
4742: p_dropoff_stop_id in NUMBER) IS
4743: select s.stop_id, s.stop_location_id
4744: from wsh_trip_stops s,
4745: wsh_trip_stops spu,
4746: wsh_trip_stops sdo
4747: where s.wv_frozen_flag = 'Y'
4748: and (s.stop_sequence_number between
4749: spu.stop_sequence_number

Line 4746: wsh_trip_stops sdo

4742: p_dropoff_stop_id in NUMBER) IS
4743: select s.stop_id, s.stop_location_id
4744: from wsh_trip_stops s,
4745: wsh_trip_stops spu,
4746: wsh_trip_stops sdo
4747: where s.wv_frozen_flag = 'Y'
4748: and (s.stop_sequence_number between
4749: spu.stop_sequence_number
4750: and

Line 4764: wsh_trip_stops wts,

4760: -- Used when unassigning from delivery.
4761: cursor c_check_del_stop_wv_frozen(p_delivery_id in number) IS
4762: select wts.stop_id, wts.stop_location_id
4763: from wsh_delivery_legs wdl,
4764: wsh_trip_stops wts,
4765: wsh_trip_stops wtspu,
4766: wsh_trip_stops wtsdo
4767: where wdl.delivery_id = p_delivery_id
4768: and (wts.stop_sequence_number between

Line 4765: wsh_trip_stops wtspu,

4761: cursor c_check_del_stop_wv_frozen(p_delivery_id in number) IS
4762: select wts.stop_id, wts.stop_location_id
4763: from wsh_delivery_legs wdl,
4764: wsh_trip_stops wts,
4765: wsh_trip_stops wtspu,
4766: wsh_trip_stops wtsdo
4767: where wdl.delivery_id = p_delivery_id
4768: and (wts.stop_sequence_number between
4769: wtspu.stop_sequence_number

Line 4766: wsh_trip_stops wtsdo

4762: select wts.stop_id, wts.stop_location_id
4763: from wsh_delivery_legs wdl,
4764: wsh_trip_stops wts,
4765: wsh_trip_stops wtspu,
4766: wsh_trip_stops wtsdo
4767: where wdl.delivery_id = p_delivery_id
4768: and (wts.stop_sequence_number between
4769: wtspu.stop_sequence_number
4770: and

Line 4787: from wsh_trip_stops wts

4783: (p_trip_id in number,
4784: p_pickup_seq_number in number,
4785: p_dropoff_seq_number in number) is
4786: select wts.stop_id, wts.stop_location_id
4787: from wsh_trip_stops wts
4788: where wts.stop_sequence_number < p_dropoff_seq_number
4789: and wts.stop_sequence_number > p_pickup_seq_number
4790: and wts.trip_id = p_trip_id
4791: and wts.wv_frozen_flag = 'Y';

Line 5119: WSH_TRIP_STOPS_GRP.stop_action(

5115:
5116: l_stop_action_prms.caller := 'WSH_TP_RELEASE';
5117: l_stop_action_prms.action_code := 'DELETE';
5118:
5119: WSH_TRIP_STOPS_GRP.stop_action(
5120: p_api_version_number => 1.0,
5121: p_init_msg_list => FND_API.G_TRUE,
5122: p_commit => FND_API.G_FALSE,
5123: p_action_prms => l_stop_action_prms,

Line 5175: wsh_trip_stops_grp.Create_Update_Stop(

5171: l_stop_in_rec.action_code := 'UPDATE';
5172: l_message_name := 'WSH_TP_F_UPDATE_STOP';
5173: END IF;
5174:
5175: wsh_trip_stops_grp.Create_Update_Stop(
5176: p_api_version_number => 1.0,
5177: p_init_msg_list => FND_API.G_FALSE,
5178: p_commit => FND_API.G_FALSE,
5179: p_in_rec => l_stop_in_rec,

Line 5188: l_interface_entity := 'WSH_TRIP_STOPS_INTERFACE';

5184: x_msg_data => l_msg_data,
5185: x_stop_wt_vol_out_tab => l_stop_wt_vol_out_tab
5186: );
5187:
5188: l_interface_entity := 'WSH_TRIP_STOPS_INTERFACE';
5189: l_interface_id := x_plan_stops(l_index).stop_interface_id;
5190:
5191: wsh_util_core.api_post_call(
5192: p_return_status => l_return_status,

Line 6588: wsh_trip_stops wts

6584: wdl.pick_up_stop_id,
6585: wdl.drop_off_stop_id,
6586: wts.trip_id
6587: from wsh_delivery_legs wdl,
6588: wsh_trip_stops wts
6589: where wdl.delivery_id = p_del_id
6590: and wts.stop_id = wdl.pick_up_stop_id;
6591:
6592: l_del_checked_flag VARCHAR2(1);

Line 6603: from wsh_trip_stops s,

6599: -- look up initial pick up stop's departure date for the delivery.
6600: cursor c_initial_pu_date (p_delivery_id in number,
6601: p_init_pu_loc_id in number) is
6602: select s.planned_departure_date
6603: from wsh_trip_stops s,
6604: wsh_delivery_legs l
6605: where s.stop_location_id = p_init_pu_loc_id
6606: and s.stop_id = l.pick_up_stop_id
6607: and l.delivery_id = p_delivery_id;

Line 6613: from wsh_trip_stops s,

6609: -- look up ultimate drop off stop's arrival date for the delivery.
6610: cursor c_final_do_date(p_delivery_id in number,
6611: p_ult_do_loc_id in number) is
6612: select s.planned_arrival_date
6613: from wsh_trip_stops s,
6614: wsh_delivery_legs l
6615: where s.stop_location_id = p_ult_do_loc_id
6616: and s.stop_id = l.drop_off_stop_id
6617: and l.delivery_id = p_delivery_id;

Line 6624: from wsh_trip_stops s,

6620: -- when its ultimate drop off location is dummy.
6621: cursor c_final_do_date_dummy(p_delivery_id in number,
6622: p_ult_do_loc_id in number) is
6623: select s.planned_arrival_date
6624: from wsh_trip_stops s,
6625: wsh_delivery_legs l
6626: where s.stop_location_id = p_ult_do_loc_id
6627: and s.stop_id = l.drop_off_stop_id
6628: and l.delivery_id = p_delivery_id

Line 6632: from wsh_trip_stops s,

6628: and l.delivery_id = p_delivery_id
6629: and s.physical_stop_id IS NOT NULL
6630: UNION
6631: select phys_s.planned_arrival_date
6632: from wsh_trip_stops s,
6633: wsh_trip_stops phys_s,
6634: wsh_delivery_legs l
6635: where s.stop_location_id = p_ult_do_loc_id
6636: and s.stop_id = l.drop_off_stop_id

Line 6633: wsh_trip_stops phys_s,

6629: and s.physical_stop_id IS NOT NULL
6630: UNION
6631: select phys_s.planned_arrival_date
6632: from wsh_trip_stops s,
6633: wsh_trip_stops phys_s,
6634: wsh_delivery_legs l
6635: where s.stop_location_id = p_ult_do_loc_id
6636: and s.stop_id = l.drop_off_stop_id
6637: and l.delivery_id = p_delivery_id

Line 6662: FROM WSH_TRIP_STOPS wts

6658:
6659: -- check if trip has at least one remaining stop
6660: CURSOR c_exist_stop(p_trip_id NUMBER) IS
6661: SELECT wts.stop_id
6662: FROM WSH_TRIP_STOPS wts
6663: WHERE wts.trip_id = p_trip_id
6664: AND rownum = 1;
6665:
6666: -- check if trip has deliveries assigned.

Line 6670: WSH_TRIP_STOPS wts

6666: -- check if trip has deliveries assigned.
6667: CURSOR c_exist_dels(p_trip_id NUMBER) IS
6668: SELECT wdl.delivery_leg_id
6669: FROM WSH_DELIVERY_LEGS wdl,
6670: WSH_TRIP_STOPS wts
6671: WHERE wdl.pick_up_stop_id = wts.stop_id
6672: AND wts.trip_id = p_trip_id
6673: AND rownum = 1
6674: UNION

Line 6677: WSH_TRIP_STOPS wts

6673: AND rownum = 1
6674: UNION
6675: SELECT wdl.delivery_leg_id
6676: FROM WSH_DELIVERY_LEGS wdl,
6677: WSH_TRIP_STOPS wts
6678: WHERE wdl.drop_off_stop_id = wts.stop_id
6679: AND wts.trip_id = p_trip_id
6680: AND rownum = 1;
6681:

Line 6686: from wsh_trip_stops

6682: -- WV changes
6683: -- Look for stops that have their wv frozen.
6684: CURSOR c_check_stop_wv_frozen(p_stop_id in NUMBER) IS
6685: select stop_location_id
6686: from wsh_trip_stops
6687: where wv_frozen_flag = 'Y'
6688: and stop_id = p_stop_id;
6689:
6690: -- CM Cleanup

Line 6694: FROM wsh_trip_stops

6690: -- CM Cleanup
6691: -- Look for stops on this trip
6692: CURSOR c_trip_stops(p_trip_id in NUMBER) IS
6693: SELECT stop_id
6694: FROM wsh_trip_stops
6695: WHERE trip_id = p_trip_id;
6696:
6697:
6698: -- physical stop lookup to use primary stop

Line 6701: FROM WSH_TRIP_STOPS wts

6697:
6698: -- physical stop lookup to use primary stop
6699: CURSOR c_lookup_physical_stop(p_stop_id IN NUMBER) IS
6700: SELECT NVL(wts.physical_stop_id, wts.stop_id)
6701: FROM WSH_TRIP_STOPS wts
6702: WHERE wts.stop_id = p_stop_id;
6703:
6704:
6705: l_location_id NUMBER;

Line 6731: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;

6727: l_del_action_prms WSH_DELIVERIES_GRP.action_parameters_rectype;
6728: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
6729: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
6730:
6731: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
6732: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
6733: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
6734: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
6735:

Line 6732: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;

6728: l_del_action_rec WSH_DELIVERIES_GRP.delivery_action_out_rec_type;
6729: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
6730:
6731: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
6732: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
6733: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
6734: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
6735:
6736: l_trip_attrs WSH_TRIPS_PVT.trip_attr_tbl_type;

Line 6733: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;

6729: l_del_defaults WSH_DELIVERIES_GRP.default_parameters_rectype;
6730:
6731: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
6732: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
6733: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
6734: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
6735:
6736: l_trip_attrs WSH_TRIPS_PVT.trip_attr_tbl_type;
6737: l_trip_action_prms WSH_TRIPS_GRP.action_parameters_rectype;

Line 6734: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;

6730:
6731: l_stop_attrs WSH_TRIP_STOPS_PVT.stop_attr_tbl_type;
6732: l_stop_action_prms WSH_TRIP_STOPS_GRP.action_parameters_rectype;
6733: l_stop_action_rec WSH_TRIP_STOPS_GRP.StopActionOutRecType;
6734: l_stop_defaults WSH_TRIP_STOPS_GRP.default_parameters_rectype;
6735:
6736: l_trip_attrs WSH_TRIPS_PVT.trip_attr_tbl_type;
6737: l_trip_action_prms WSH_TRIPS_GRP.action_parameters_rectype;
6738: l_trip_in_rec WSH_TRIPS_GRP.TripInRecType;

Line 7193: WSH_TRIP_STOPS_PVT.lock_trip_stop_no_compare(trip.stop_id);

7189: FOR trip in c_trip_stops(x_trip_unassigns(i).trip_id) LOOP
7190:
7191: BEGIN
7192: -- Lock the stop
7193: WSH_TRIP_STOPS_PVT.lock_trip_stop_no_compare(trip.stop_id);
7194: examine_stop(p_stop_id => trip.stop_id,
7195: p_trip_id => x_trip_unassigns(i).trip_id);
7196: EXCEPTION
7197: WHEN OTHERS THEN

Line 7250: WSH_TRIP_STOPS_GRP.stop_action(

7246:
7247: l_stop_action_prms.caller := 'WSH_TP_RELEASE';
7248: l_stop_action_prms.action_code := 'DELETE';
7249:
7250: WSH_TRIP_STOPS_GRP.stop_action(
7251: p_api_version_number => 1.0,
7252: p_init_msg_list => FND_API.G_TRUE,
7253: p_commit => FND_API.G_FALSE,
7254: p_action_prms => l_stop_action_prms,

Line 7440: UPDATE wsh_trip_stops_interface

7436: WSH_DEBUG_SV.log(l_module_name, 'Bulk update stops: count', l_interface_ids.COUNT);
7437: END IF;
7438:
7439: FORALL i in 1..l_interface_ids.count
7440: UPDATE wsh_trip_stops_interface
7441: SET stop_id = l_ids(i)
7442: WHERE stop_interface_id = l_interface_ids(i);
7443:
7444:

Line 8888: FROM wsh_trip_stops ts

8884: SELECT ts.stop_id,
8885: ts.physical_location_id,
8886: ts.physical_stop_id,
8887: ts.planned_arrival_date
8888: FROM wsh_trip_stops ts
8889: WHERE ts.trip_id = p_trip_id
8890: AND ts.status_code = 'OP'
8891: ORDER BY ts.stop_sequence_number;
8892:

Line 9020: wsh_trip_stops_pvt.lock_trip_stop_no_compare(

9016: WSH_DEBUG_SV.log(l_module_name,'matching linked stop', s.stop_id);
9017: END IF;
9018:
9019: BEGIN
9020: wsh_trip_stops_pvt.lock_trip_stop_no_compare(
9021: p_stop_id => s.stop_id);
9022: EXCEPTION
9023: WHEN OTHERS THEN
9024: stamp_interface_error(

Line 9067: wsh_trip_stops_pvt.lock_trip_stop_no_compare(

9063: END IF;
9064:
9065: -- Lock the stop.
9066: BEGIN
9067: wsh_trip_stops_pvt.lock_trip_stop_no_compare(
9068: p_stop_id => s.stop_id);
9069: EXCEPTION
9070: WHEN OTHERS THEN
9071: stamp_interface_error(

Line 10016: x_stop_attrs_rec OUT NOCOPY wsh_trip_stops_pvt.trip_stop_rec_type

10012:
10013: PROCEDURE copy_stop_record(
10014: p_plan_stop_rec IN plan_stop_rec_type,
10015: p_plan_trips IN plan_trip_tab_type,
10016: x_stop_attrs_rec OUT NOCOPY wsh_trip_stops_pvt.trip_stop_rec_type
10017: ) IS
10018: l_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'COPY_STOP_RECORD';
10019: --
10020: l_debug_on BOOLEAN;

Line 10029: FROM wsh_trip_stops

10025: weight_uom_code,
10026: departure_volume,
10027: volume_uom_code,
10028: departure_fill_percent
10029: FROM wsh_trip_stops
10030: WHERE stop_id = x_stop_id;
10031:
10032: l_stop_info c_stop_info%ROWTYPE;
10033: