1: PACKAGE WSH_TRIPS_ACTIONS AUTHID CURRENT_USER as
2: /* $Header: WSHTRACS.pls 120.2.12000000.1 2007/01/16 05:51:31 appldev ship $ */
3:
4: -- trip stops are created 10 minutes apart
5: C_TEN_MINUTES CONSTANT NUMBER := 1/144;
6: C_TEN_SECONDS CONSTANT NUMBER := 1/8640;
7:
8:
9: TYPE cs_trip_rec_type IS RECORD (
10: Trip_id wsh_trips.trip_id%TYPE,
11: Trip_name wsh_trips.name%TYPE,
12: Planned_flag wsh_trips.planned_flag%TYPE,
13: Status_code wsh_trips.status_code%TYPE,
14: Carrier_id wsh_trips.carrier_id%TYPE,
7:
8:
9: TYPE cs_trip_rec_type IS RECORD (
10: Trip_id wsh_trips.trip_id%TYPE,
11: Trip_name wsh_trips.name%TYPE,
12: Planned_flag wsh_trips.planned_flag%TYPE,
13: Status_code wsh_trips.status_code%TYPE,
14: Carrier_id wsh_trips.carrier_id%TYPE,
15: Mode_of_transport wsh_trips.mode_of_transport%TYPE,
8:
9: TYPE cs_trip_rec_type IS RECORD (
10: Trip_id wsh_trips.trip_id%TYPE,
11: Trip_name wsh_trips.name%TYPE,
12: Planned_flag wsh_trips.planned_flag%TYPE,
13: Status_code wsh_trips.status_code%TYPE,
14: Carrier_id wsh_trips.carrier_id%TYPE,
15: Mode_of_transport wsh_trips.mode_of_transport%TYPE,
16: Service_level wsh_trips.service_level%TYPE,
9: TYPE cs_trip_rec_type IS RECORD (
10: Trip_id wsh_trips.trip_id%TYPE,
11: Trip_name wsh_trips.name%TYPE,
12: Planned_flag wsh_trips.planned_flag%TYPE,
13: Status_code wsh_trips.status_code%TYPE,
14: Carrier_id wsh_trips.carrier_id%TYPE,
15: Mode_of_transport wsh_trips.mode_of_transport%TYPE,
16: Service_level wsh_trips.service_level%TYPE,
17: Ship_method_code wsh_trips.ship_method_code%TYPE,
10: Trip_id wsh_trips.trip_id%TYPE,
11: Trip_name wsh_trips.name%TYPE,
12: Planned_flag wsh_trips.planned_flag%TYPE,
13: Status_code wsh_trips.status_code%TYPE,
14: Carrier_id wsh_trips.carrier_id%TYPE,
15: Mode_of_transport wsh_trips.mode_of_transport%TYPE,
16: Service_level wsh_trips.service_level%TYPE,
17: Ship_method_code wsh_trips.ship_method_code%TYPE,
18: --Track_only_flag wsh_trips.track_only_flag%TYPE,
11: Trip_name wsh_trips.name%TYPE,
12: Planned_flag wsh_trips.planned_flag%TYPE,
13: Status_code wsh_trips.status_code%TYPE,
14: Carrier_id wsh_trips.carrier_id%TYPE,
15: Mode_of_transport wsh_trips.mode_of_transport%TYPE,
16: Service_level wsh_trips.service_level%TYPE,
17: Ship_method_code wsh_trips.ship_method_code%TYPE,
18: --Track_only_flag wsh_trips.track_only_flag%TYPE,
19: Consignee_car_ac_no wsh_trips.consignee_carrier_ac_no%TYPE,
12: Planned_flag wsh_trips.planned_flag%TYPE,
13: Status_code wsh_trips.status_code%TYPE,
14: Carrier_id wsh_trips.carrier_id%TYPE,
15: Mode_of_transport wsh_trips.mode_of_transport%TYPE,
16: Service_level wsh_trips.service_level%TYPE,
17: Ship_method_code wsh_trips.ship_method_code%TYPE,
18: --Track_only_flag wsh_trips.track_only_flag%TYPE,
19: Consignee_car_ac_no wsh_trips.consignee_carrier_ac_no%TYPE,
20: Freight_terms_code wsh_trips.freight_terms_code%TYPE,
13: Status_code wsh_trips.status_code%TYPE,
14: Carrier_id wsh_trips.carrier_id%TYPE,
15: Mode_of_transport wsh_trips.mode_of_transport%TYPE,
16: Service_level wsh_trips.service_level%TYPE,
17: Ship_method_code wsh_trips.ship_method_code%TYPE,
18: --Track_only_flag wsh_trips.track_only_flag%TYPE,
19: Consignee_car_ac_no wsh_trips.consignee_carrier_ac_no%TYPE,
20: Freight_terms_code wsh_trips.freight_terms_code%TYPE,
21: Load_tender_status wsh_trips.load_tender_status%TYPE,
14: Carrier_id wsh_trips.carrier_id%TYPE,
15: Mode_of_transport wsh_trips.mode_of_transport%TYPE,
16: Service_level wsh_trips.service_level%TYPE,
17: Ship_method_code wsh_trips.ship_method_code%TYPE,
18: --Track_only_flag wsh_trips.track_only_flag%TYPE,
19: Consignee_car_ac_no wsh_trips.consignee_carrier_ac_no%TYPE,
20: Freight_terms_code wsh_trips.freight_terms_code%TYPE,
21: Load_tender_status wsh_trips.load_tender_status%TYPE,
22: Lane_id wsh_trips.lane_id%TYPE,
15: Mode_of_transport wsh_trips.mode_of_transport%TYPE,
16: Service_level wsh_trips.service_level%TYPE,
17: Ship_method_code wsh_trips.ship_method_code%TYPE,
18: --Track_only_flag wsh_trips.track_only_flag%TYPE,
19: Consignee_car_ac_no wsh_trips.consignee_carrier_ac_no%TYPE,
20: Freight_terms_code wsh_trips.freight_terms_code%TYPE,
21: Load_tender_status wsh_trips.load_tender_status%TYPE,
22: Lane_id wsh_trips.lane_id%TYPE,
23: Rank_id wsh_trips.rank_id%TYPE);
16: Service_level wsh_trips.service_level%TYPE,
17: Ship_method_code wsh_trips.ship_method_code%TYPE,
18: --Track_only_flag wsh_trips.track_only_flag%TYPE,
19: Consignee_car_ac_no wsh_trips.consignee_carrier_ac_no%TYPE,
20: Freight_terms_code wsh_trips.freight_terms_code%TYPE,
21: Load_tender_status wsh_trips.load_tender_status%TYPE,
22: Lane_id wsh_trips.lane_id%TYPE,
23: Rank_id wsh_trips.rank_id%TYPE);
24:
17: Ship_method_code wsh_trips.ship_method_code%TYPE,
18: --Track_only_flag wsh_trips.track_only_flag%TYPE,
19: Consignee_car_ac_no wsh_trips.consignee_carrier_ac_no%TYPE,
20: Freight_terms_code wsh_trips.freight_terms_code%TYPE,
21: Load_tender_status wsh_trips.load_tender_status%TYPE,
22: Lane_id wsh_trips.lane_id%TYPE,
23: Rank_id wsh_trips.rank_id%TYPE);
24:
25: TYPE cs_trip_tab_type IS TABLE OF cs_trip_rec_type INDEX BY BINARY_INTEGER;
18: --Track_only_flag wsh_trips.track_only_flag%TYPE,
19: Consignee_car_ac_no wsh_trips.consignee_carrier_ac_no%TYPE,
20: Freight_terms_code wsh_trips.freight_terms_code%TYPE,
21: Load_tender_status wsh_trips.load_tender_status%TYPE,
22: Lane_id wsh_trips.lane_id%TYPE,
23: Rank_id wsh_trips.rank_id%TYPE);
24:
25: TYPE cs_trip_tab_type IS TABLE OF cs_trip_rec_type INDEX BY BINARY_INTEGER;
26:
19: Consignee_car_ac_no wsh_trips.consignee_carrier_ac_no%TYPE,
20: Freight_terms_code wsh_trips.freight_terms_code%TYPE,
21: Load_tender_status wsh_trips.load_tender_status%TYPE,
22: Lane_id wsh_trips.lane_id%TYPE,
23: Rank_id wsh_trips.rank_id%TYPE);
24:
25: TYPE cs_trip_tab_type IS TABLE OF cs_trip_rec_type INDEX BY BINARY_INTEGER;
26:
27: TYPE cs_stop_rec_type IS RECORD (
54: -- This procedure will return a record of trip defaults used for trip confirmation
55:
56: PROCEDURE Get_Trip_Defaults(p_trip_id in NUMBER,
57: p_trip_name in VARCHAR2 DEFAULT NULL,
58: x_def_rec IN OUT NOCOPY WSH_TRIPS_GRP.default_parameters_rectype,
59: x_return_Status OUT NOCOPY varchar2 ) ;
60:
61: --
62: -- Procedure: Confirm_Trip
361: x_return_status OUT NOCOPY VARCHAR2);
362:
363: PROCEDURE generateRoutingResponse
364: (
365: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,
366: p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
367: x_return_status OUT NOCOPY VARCHAR2
368: );
369:
362:
363: PROCEDURE generateRoutingResponse
364: (
365: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,
366: p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,
367: x_return_status OUT NOCOPY VARCHAR2
368: );
369:
370: -- bug 3516052
404: p_caller IN VARCHAR2,
405: x_return_status OUT NOCOPY VARCHAR2);
406:
407:
408: END WSH_TRIPS_ACTIONS;