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