1 PACKAGE FTE_TP_GRP AUTHID CURRENT_USER as
2 /* $Header: FTETPGPS.pls 115.2 2003/09/05 19:36:26 wrudge noship $ */
3
4 --
5 -- Procedure: lookup_cm_info
6 -- Parameters:
7 -- p_trip_id trip_id to look up its continuous move segment
8 -- x_cm_info_rec attributes of continuous move and segment
9 -- x_return_status return status
10 --
11 -- Description:
12 -- Looks up continuous move information associated with the trip
13 -- to be displayed in shipping UIs.
14 --
15 --
16
17 PROCEDURE lookup_cm_info (
18 p_trip_id IN NUMBER,
19 x_cm_info_rec OUT NOCOPY WSH_FTE_TP_INTEGRATION.cm_info_rec_type,
20 x_return_status OUT NOCOPY VARCHAR2);
21
22
23
24 --
25 -- Procedure: trip_callback
26 -- Parameters:
27 -- p_api_version_number known api version (1.0)
28 -- p_init_msg_list FND_API.G_TRUE to reset list
29 -- x_return_status return status
30 -- x_msg_count number of messages in the list
31 -- x_msg_data text of messages
32 -- p_actions_prms action parameters record
33 -- used to identify the action triggering
34 -- the callback to FTE.
35 -- p_rec_attr_tab table of trip records to process
36 --
37 -- Description:
38 -- take care of continuous moves based on the action being
39 -- performed on the trips.
40 --
41
42 PROCEDURE trip_callback (
43 p_api_version_number IN NUMBER,
44 p_init_msg_list IN VARCHAR2,
45 x_return_status OUT NOCOPY VARCHAR2,
46 x_msg_count OUT NOCOPY NUMBER,
47 x_msg_data OUT NOCOPY VARCHAR2,
48 p_action_prms IN WSH_TRIPS_GRP.action_parameters_rectype,
49 p_rec_attr_tab IN WSH_TRIPS_PVT.Trip_Attr_Tbl_Type);
50
51
52
53
54 --
55 -- Procedure: stop_callback
56 -- Parameters:
57 -- p_api_version_number known api version (1.0)
58 -- p_init_msg_list FND_API.G_TRUE to reset list
59 -- x_return_status return status
60 -- x_msg_count number of messages in the list
61 -- x_msg_data text of messages
62 -- p_actions_prms action parameters record
63 -- used to identify the action triggering
64 -- the callback to FTE.
65 -- p_rec_attr_tab table of stop records to process
66 --
67 -- Description:
68 -- take care of continuous moves based on the action being performed
69 -- on the stops.
70 --
71
72 PROCEDURE stop_callback (
73 p_api_version_number IN NUMBER,
74 p_init_msg_list IN VARCHAR2,
75 x_return_status OUT NOCOPY VARCHAR2,
76 x_msg_count OUT NOCOPY NUMBER,
77 x_msg_data OUT NOCOPY VARCHAR2,
78 p_action_prms IN WSH_TRIP_STOPS_GRP.action_parameters_rectype,
79 p_rec_attr_tab IN WSH_TRIP_STOPS_PVT.stop_attr_tbl_type);
80
81
82
83 --
84 -- Procedure: map_moves
85 -- Parameters:
86 -- x_context context in this session
87 -- x_plan_trips list of trips mapped to interface trips
88 -- x_plan_trip_moves list of continuous move segments
89 -- x_plan_moves list of continuous moves
90 -- x_obsoleted_trip_moves list of continous move segments that need to be deleted
91 -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
92 -- x_return_status return status
93 --
94 -- Description:
95 -- Part of TP release process
96 -- Maps the plan's continuous moves: generate and lock candidates
97 -- x_obsoleted_trip_moves will have the obsoleted move segments.
98 --
99
100 PROCEDURE map_moves(
101 x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
102 x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
103 x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
104 x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
105 x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,
106 x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
107 x_return_status OUT NOCOPY VARCHAR2
108 );
109
110
111 --
112 -- Procedure: reconciliate_moves
113 -- Parameters:
114 -- x_context context in this session
115 -- x_plan_trips list of trips mapped to interface trips
116 -- x_plan_trip_moves list of continuous move segments
117 -- x_plan_moves list of continuous moves
118 -- x_obsoleted_trip_moves list of continous move segments that need to be deleted
119 -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
120 -- x_return_status return status
121 --
122 -- Description:
123 -- Part of TP release process
124 -- Create or update continous moves and their segments and firm them as needed.
125 -- x_obsoleted_trip_moves will have the obsoleted move segments.
126 --
127
128 PROCEDURE reconciliate_moves(
129 x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
130 x_plan_trips IN OUT NOCOPY WSH_TP_RELEASE_INT.plan_trip_tab_type,
131 x_plan_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_trip_move_tab_type,
132 x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
133 x_obsoleted_trip_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.obsoleted_trip_move_tab_type,
134 x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
135 x_return_status OUT NOCOPY VARCHAR2
136 );
137
138
139
140 --
141 -- Procedure: tp_firm_moves
142 -- Parameters:
143 -- x_context context in this session
144 -- x_plan_trips list of trips mapped to interface trips
145 -- x_plan_trip_moves list of continuous move segments
146 -- x_plan_moves list of continuous moves
147 -- x_obsoleted_trip_moves list of continous move segments that need to be deleted
148 -- x_errors_tab list of errors to insert into wsh_interface_errors at the end
149 -- x_return_status return status
150 --
151 -- Description:
152 -- Part of TP release process
153 -- Upgrade continuous moves' PLANNED_FLAG based on the plan
154 --
155
156 PROCEDURE tp_firm_moves(
157 x_context IN OUT NOCOPY WSH_TP_RELEASE_INT.context_rec_type,
158 x_plan_moves IN OUT NOCOPY WSH_FTE_TP_INTEGRATION.plan_move_tab_type,
159 x_errors_tab IN OUT NOCOPY WSH_TP_RELEASE_INT.interface_errors_tab_type,
160 x_return_status OUT NOCOPY VARCHAR2
161 );
162
163
164
165 --
166 -- Procedure: purge_interface_tables
167 -- Parameters:
168 -- p_group_ids list of group_ids to purge
169 -- FTE interface tables (based on WSH_TRIPS_INTERFACE.GROUP_ID)
170 -- x_return_status return status
171 --
172 -- Description:
173 -- Part of TP release process
174 -- Delete the records from FTE interface tables:
175 -- FTE_MOVES_INTERFACE
176 -- FTE_TRIP_MOVES_INTERFACE
177 --
178 PROCEDURE purge_interface_tables(
179 p_group_ids IN WSH_TP_RELEASE_GRP.ID_TAB_TYPE,
180 x_return_status OUT NOCOPY VARCHAR2);
181
182
183
184
185 END FTE_TP_GRP;