[Home] [Help]
PACKAGE: APPS.WSH_TRIP_STOPS_ACTIONS
Source
1 PACKAGE WSH_TRIP_STOPS_ACTIONS as
2 /* $Header: WSHSTACS.pls 120.0.12000000.1 2007/01/16 05:50:40 appldev ship $ */
3
4
5 --
6 -- Procedure: Confirm_Stop
7 -- Parameters: p_stop_id, p_action_flag, p_intransit_flag,
8 -- p_close_flag, p_stage_del_flag, p_report_set_id, p_ship_method,
9 -- p_actual_dep_date, p_bol_flag, p_defer_interface_flag,
10 -- x_return_status
11 -- Description: If there are any Open en Pickup Deliveries for the Stop, then these
12 -- deliveries are selected and these are passed to Confirm_Delivery API
13 -- After this, the Change_Status API is called to Close the Stop.
14
15
16 PROCEDURE Confirm_Stop (
17 p_stop_id IN NUMBER,
18 p_action_flag IN VARCHAR2,
19 p_intransit_flag IN VARCHAR2,
20 p_close_flag IN VARCHAR2,
21 p_stage_del_flag IN VARCHAR2,
22 p_report_set_id IN NUMBER,
23 p_ship_method IN VARCHAR2,
24 p_actual_dep_date IN DATE,
25 p_bol_flag IN VARCHAR2,
26 p_defer_interface_flag IN VARCHAR2,
27 x_return_status OUT NOCOPY VARCHAR2 ) ;
28
29
30
31 --
32 -- Procedure: Check_Update_Stops
33 -- Parameters: p_stop_rows, x_return_status
34 -- Description: Checks if the stops selected do not belong to the same
35 -- trip and if there are any Open or Packed deliveries on the stop
36 -- p_stop_rows - a table of stop_ids
37 -- p_action - 'CLOSE', 'ARRIVE'
38
39 PROCEDURE Check_Update_Stops (
40 p_stop_rows IN wsh_util_core.id_tab_type,
41 p_action IN VARCHAR2,
42 p_caller IN VARCHAR2 DEFAULT NULL,
43 x_return_status OUT NOCOPY VARCHAR2);
44
45
46 --
47 -- Procedure: Change_Status
48 -- Parameters: p_stop_rows, p_action, p_actual_date,
49 -- p_defer_interface_flag (bug 1578251)
50 -- x_return_status
51 -- Description: Sets the status code of the trip to p_action after
52 -- performing status code checks.
53 -- p_stop_rows - a table of stop_ids
54
55 PROCEDURE Change_Status (
56 p_stop_rows IN wsh_util_core.id_tab_type,
57 p_action IN VARCHAR2,
58 p_actual_date IN DATE,
59 p_defer_interface_flag IN VARCHAR2,
60 x_return_status OUT NOCOPY VARCHAR2,
61 p_caller IN VARCHAR2 DEFAULT NULL);
62
63
64
65 --
66 -- Procedure: Plan
67 -- Parameters: p_stop_rows, x_return_status
68 -- Description: Plans deliveries on stops
69 -- p_stop_rows - a table of stop_ids
70
71 PROCEDURE Plan (
72 p_stop_rows IN wsh_util_core.id_tab_type,
73 p_action IN VARCHAR2,
74 p_caller IN VARCHAR2 DEFAULT NULL,
75 x_return_status OUT NOCOPY VARCHAR2);
76
77 --
78 -- Procedure: Calc_Stop_Weight_Volume
79 -- Parameters: p_trip_id,p_override_flag, x_return_status
80 -- Description: Finds the trip,
81 -- calculates weight/vol.of stop recursively
82
83 PROCEDURE calc_stop_weight_volume( p_stop_rows IN wsh_util_core.id_tab_type,
84 p_override_flag IN VARCHAR2,
85 p_calc_wv_if_frozen IN VARCHAR2 DEFAULT 'Y',
86 x_return_status OUT NOCOPY VARCHAR2,
87 p_caller IN VARCHAR2 DEFAULT NULL);
88
89
90 -- J-IB-NPARIKH-{
91 --
92 --
93 PROCEDURE autoCloseOpen
94 (
95 p_in_rec IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type,
96 p_reopenStop IN BOOLEAN DEFAULT FALSE,
97 x_stop_processed OUT NOCOPY VARCHAR2,
98 x_return_status OUT NOCOPY VARCHAR2
99 );
100 --
101 --
102 PROCEDURE setClose
103 (
104 p_in_rec IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type,
105 p_in_rec1 IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type,
106 p_defer_interface_Flag IN VARCHAR2,
107 x_return_status OUT NOCOPY VARCHAR2
108 );
109 --
110 --
111 PROCEDURE setOpen
112 (
113 p_in_rec IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_in_rec_type,
114 p_in_rec1 IN WSH_TRIP_STOPS_VALIDATIONS.chkClose_out_rec_type,
115 x_return_status OUT NOCOPY VARCHAR2
116 );
117 --
118 --
119 -- J-IB-NPARIKH-}
120
121 PROCEDURE RESET_STOP_SEQ_NUMBERS
122 ( p_stop_details_rec IN OUT NOCOPY WSH_TRIP_STOPS_VALIDATIONS.stop_details,
123 x_return_status OUT NOCOPY VARCHAR2
124 );
125
126 END WSH_TRIP_STOPS_ACTIONS;