[Home] [Help]
PACKAGE: APPS.WSH_BATCH_PROCESS
Source
1 PACKAGE WSH_BATCH_PROCESS as
2 /* $Header: WSHBHPSS.pls 120.1 2006/02/23 18:12:07 wrudge noship $ */
3
4 TYPE Brief_Del_Info_Rec IS RECORD (
5 delivery_id NUMBER,
6 organization_id NUMBER,
7 initial_pickup_location_id NUMBER);
8
9
10 TYPE Del_Info_Tab IS TABLE OF Brief_Del_Info_Rec INDEX BY BINARY_INTEGER;
11
12
13
14 TYPE Results_Summary_Rec IS RECORD (
15 success NUMBER,
16 warning NUMBER,
17 failure NUMBER,
18 report_req_id NUMBER);
19
20 TYPE Select_Criteria_Rec IS RECORD (
21 process_mode VARCHAR2(30),
22 organization_id NUMBER ,
23 pr_batch_id NUMBER ,
24 ap_batch_id NUMBER ,
25 delivery_name_lo VARCHAR2(30),
26 delivery_name_hi VARCHAR2(30),
27 bol_number_lo VARCHAR2(50),
28 bol_number_hi VARCHAR2(50),
29 planned_flag VARCHAR2(1),
30 ship_from_loc_id NUMBER ,
31 ship_to_loc_id NUMBER ,
32 intmed_ship_to_loc_id NUMBER ,
33 pooled_ship_to_loc_id NUMBER ,
34 customer_id NUMBER ,
35 ship_method_code VARCHAR2(30),
36 fob_code VARCHAR2(30),
37 freight_terms_code VARCHAR2(30),
38 pickup_date_lo VARCHAR2(30),
39 pickup_date_hi VARCHAR2(30),
40 dropoff_date_lo VARCHAR2(30),
41 dropoff_date_hi VARCHAR2(30),
42 log_level NUMBER ,
43 delivery_lines_status VARCHAR2(30),
44 scheduled_ship_date_lo VARCHAR2(30),
45 scheduled_ship_date_hi VARCHAR2(30),
46 source_code VARCHAR2(30));
47
48 CURSOR G_GET_SHIP_CONFIRM_RULE (c_ship_confirm_rule_id NUMBER ) IS
49 SELECT SHIP_CONFIRM_RULE_ID,
50 NAME,
51 ACTION_FLAG,
52 STAGE_DEL_FLAG,
53 SHIP_METHOD_CODE,
54 NVL(SHIP_METHOD_DEFAULT_FLAG, 'R') SHIP_METHOD_DEFAULT_FLAG,
55 AC_ACTUAL_DEP_DATE_DEFAULT,
56 AC_INTRANSIT_FLAG,
57 AC_CLOSE_TRIP_FLAG,
58 AC_BOL_FLAG,
59 AC_DEFER_INTERFACE_FLAG,
60 MC_INTRANSIT_FLAG,
61 MC_CLOSE_TRIP_FLAG,
62 MC_BOL_FLAG,
63 MC_DEFER_INTERFACE_FLAG,
64 REPORT_SET_ID,
65 SEND_945_FLAG
66 FROM WSH_SHIP_CONFIRM_RULES
67 WHERE SHIP_CONFIRM_RULE_ID = c_ship_confirm_rule_id AND
68 NVL(EFFECTIVE_START_DATE, sysdate) <= sysdate AND
69 NVL(EFFECTIVE_END_DATE, sysdate ) >= sysdate ;
70
71 PROCEDURE Auto_Pack_A_Delivery(
72 p_delivery_id IN NUMBER,
73 p_ap_batch_id IN NUMBER,
74 p_auto_pack_level IN NUMBER,
75 p_log_level IN NUMBER,
76 x_return_status OUT NOCOPY VARCHAR2);
77
78 PROCEDURE Ship_Confirm_A_Delivery(
79 p_delivery_id IN NUMBER,
80 p_sc_batch_id IN NUMBER,
81 p_ship_confirm_rule_rec IN G_GET_SHIP_CONFIRM_RULE%ROWTYPE,
82 p_log_level IN NUMBER,
83 p_actual_departure_date IN DATE,
84 x_return_status OUT NOCOPY VARCHAR2);
85
86 PROCEDURE Close_A_Stop (
87 p_stop_id IN NUMBER,
88 p_actual_date IN DATE,
89 p_defer_interface_flag IN VARCHAR2,
90 x_return_status OUT NOCOPY VARCHAR2);
91
92 PROCEDURE Select_Deliveries (
93 p_input_info IN WSH_BATCH_PROCESS.Select_Criteria_Rec,
94 p_batch_rec IN OUT NOCOPY WSH_PICKING_BATCHES%ROWTYPE,
95 x_selected_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,
96 x_return_status OUT NOCOPY VARCHAR2 );
97
98 PROCEDURE Ship_Confirm_Batch(
99 p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,
100 p_sc_batch_id IN NUMBER,
101 p_log_level IN NUMBER,
102 x_confirmed_del_tab OUT NOCOPY WSH_UTIL_CORE.Id_Tab_Type,
103 x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,
104 x_return_status OUT NOCOPY VARCHAR2,
105 p_commit IN VARCHAR2); -- BugFix #4001135
106
107 PROCEDURE Auto_Pack_Deliveries_Batch(
108 p_del_tab IN WSH_BATCH_PROCESS.Del_Info_Tab,
109 p_ap_batch_id IN NUMBER,
110 p_auto_pack_level IN NUMBER,
111 p_log_level IN NUMBER,
112 x_packed_del_tab OUT NOCOPY WSH_BATCH_PROCESS.Del_Info_Tab,
113 x_results_summary OUT NOCOPY WSH_BATCH_PROCESS.Results_Summary_Rec,
114 x_return_status OUT NOCOPY VARCHAR2,
115 p_commit IN VARCHAR2); -- BugFix #4001135
116
117 PROCEDURE Confirm_Delivery_SRS(
118 errbuf OUT NOCOPY VARCHAR2,
119 retcode OUT NOCOPY VARCHAR2,
120 p_ship_confirm_rule_id IN NUMBER,
121 p_actual_departure_date IN VARCHAR2,
122 p_sc_batch_prefix IN VARCHAR2,
123 p_organization_id IN NUMBER,
124 p_pr_batch_id IN NUMBER,
125 p_ap_batch_id IN NUMBER,
126 p_delivery_name_lo IN VARCHAR2,
127 p_delivery_name_hi IN VARCHAR2,
128 p_bol_number_lo IN VARCHAR2,
129 p_bol_number_hi IN VARCHAR2,
130 p_planned_flag IN VARCHAR2,
131 p_ship_from_loc_id IN NUMBER,
132 p_ship_to_loc_id IN NUMBER,
133 p_intmed_ship_to_loc_id IN NUMBER,
134 p_pooled_ship_to_loc_id IN NUMBER,
135 p_customer_id IN NUMBER,
136 p_ship_method_code IN VARCHAR2,
137 p_fob_code IN VARCHAR2,
138 p_freight_terms_code IN VARCHAR2,
139 p_pickup_date_lo IN VARCHAR2,
140 p_pickup_date_hi IN VARCHAR2,
141 p_dropoff_date_lo IN VARCHAR2,
142 p_dropoff_date_hi IN VARCHAR2,
143 p_log_level IN NUMBER);
144
145
146
147 PROCEDURE Auto_Pack_Deliveries_SRS(
148 errbuf OUT NOCOPY VARCHAR2,
149 retcode OUT NOCOPY VARCHAR2,
150 p_auto_pack_level IN NUMBER,
151 p_ap_batch_prefix IN VARCHAR2,
152 p_organization_id IN NUMBER,
153 p_pr_batch_id IN NUMBER,
154 p_delivery_name_lo IN VARCHAR2,
155 p_delivery_name_hi IN VARCHAR2,
156 p_bol_number_lo IN VARCHAR2,
157 p_bol_number_hi IN VARCHAR2,
158 p_planned_flag IN VARCHAR2,
159 p_ship_from_loc_id IN NUMBER,
160 p_ship_to_loc_id IN NUMBER,
161 p_intmed_ship_to_loc_id IN NUMBER,
162 p_pooled_ship_to_loc_id IN NUMBER,
163 p_customer_id IN NUMBER,
164 p_ship_method_code IN VARCHAR2,
165 p_fob_code IN VARCHAR2,
166 p_freight_terms_code IN VARCHAR2,
167 p_pickup_date_lo IN VARCHAR2,
168 p_pickup_date_hi IN VARCHAR2,
169 p_dropoff_date_lo IN VARCHAR2,
170 p_dropoff_date_hi IN VARCHAR2,
171 p_log_level IN NUMBER );
172
173 Procedure log_batch_messages(p_batch_id IN NUMBER,
174 p_delivery_id IN NUMBER,
175 p_stop_id IN NUMBER,
176 p_exception_location_id IN NUMBER,
177 p_error_status IN VARCHAR2);
178
179
180 PROCEDURE Process_Deliveries_SRS(
181 errbuf OUT NOCOPY VARCHAR2,
182 retcode OUT NOCOPY VARCHAR2,
183 p_entity_type IN VARCHAR2,
184 p_delivery_lines_status IN VARCHAR2,
185 p_deliveries_status IN VARCHAR2,
186 p_scheduled_ship_date_lo IN VARCHAR2,
187 p_scheduled_ship_date_hi IN VARCHAR2,
188 p_source_system IN VARCHAR2,
189 p_pickup_date_lo IN VARCHAR2,
190 p_pickup_date_hi IN VARCHAR2,
191 p_dropoff_date_lo IN VARCHAR2,
192 p_dropoff_date_hi IN VARCHAR2,
193 p_organization_id IN NUMBER,
194 p_customer_id IN VARCHAR2,
195 p_ship_to_loc_id IN NUMBER,
196 p_ship_method_code IN VARCHAR2,
197 p_autocreate_deliveries IN VARCHAR2,
198 p_ac_del_criteria IN VARCHAR2,
199 p_append_deliveries IN VARCHAR2,
200 p_grp_ship_method IN VARCHAR2,
201 p_grp_ship_from IN VARCHAR2,
202 p_max_del_number IN NUMBER,
203 p_log_level IN NUMBER );
204
205 END WSH_BATCH_PROCESS;