DBA Data[Home] [Help]

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_TRIPS

Line 1: PACKAGE WSH_TRIPS_ACTIONS AUTHID CURRENT_USER as

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;

Line 10: Trip_id wsh_trips.trip_id%TYPE,

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,

Line 11: Trip_name wsh_trips.name%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,

Line 12: Planned_flag wsh_trips.planned_flag%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,

Line 13: Status_code wsh_trips.status_code%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,

Line 14: Carrier_id wsh_trips.carrier_id%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,

Line 15: Mode_of_transport wsh_trips.mode_of_transport%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,

Line 16: Service_level wsh_trips.service_level%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,

Line 17: Ship_method_code wsh_trips.ship_method_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,

Line 18: --Track_only_flag wsh_trips.track_only_flag%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,

Line 19: Consignee_car_ac_no wsh_trips.consignee_carrier_ac_no%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);

Line 20: Freight_terms_code wsh_trips.freight_terms_code%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:

Line 21: Load_tender_status wsh_trips.load_tender_status%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:
25: TYPE cs_trip_tab_type IS TABLE OF cs_trip_rec_type INDEX BY BINARY_INTEGER;

Line 22: Lane_id wsh_trips.lane_id%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;
26:

Line 23: Rank_id wsh_trips.rank_id%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:
27: TYPE cs_stop_rec_type IS RECORD (

Line 58: x_def_rec IN OUT NOCOPY WSH_TRIPS_GRP.default_parameters_rectype,

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

Line 365: p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,

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:

Line 366: p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type,

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

Line 408: END WSH_TRIPS_ACTIONS;

404: p_caller IN VARCHAR2,
405: x_return_status OUT NOCOPY VARCHAR2);
406:
407:
408: END WSH_TRIPS_ACTIONS;