eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WSH_ASN_RECEIPT_PVT dependencies on WSH_UTIL_CORE

Line 128: -- del_ids IN wsh_util_core.id_tab_type

124: -- Function :
125: -- Pre-reqs : None.
126: -- Parameters :
127: -- IN :
128: -- del_ids IN wsh_util_core.id_tab_type
129: -- OUT :
130: -- x_return_status OUT VARCHAR2
131: -- ==============================================================================
132: PROCEDURE Unassign_open_det_from_del(

Line 133: p_del_ids IN wsh_util_core.id_tab_type,

129: -- OUT :
130: -- x_return_status OUT VARCHAR2
131: -- ==============================================================================
132: PROCEDURE Unassign_open_det_from_del(
133: p_del_ids IN wsh_util_core.id_tab_type,
134: p_action_prms IN wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
135: p_shipment_header_id IN NUMBER,
136: x_return_status OUT NOCOPY VARCHAR2 );
137:

Line 146: -- p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

142: -- Function :
143: -- Pre-reqs : None.
144: -- Parameters :
145: -- p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
146: -- p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
147: -- p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
148: -- p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
149: -- p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
150: -- p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 147: -- p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

143: -- Pre-reqs : None.
144: -- Parameters :
145: -- p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
146: -- p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
147: -- p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
148: -- p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
149: -- p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
150: -- p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
151: -- p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 148: -- p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

144: -- Parameters :
145: -- p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
146: -- p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
147: -- p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
148: -- p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
149: -- p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
150: -- p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
151: -- p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
152: -- p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE

Line 149: -- p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

145: -- p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
146: -- p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
147: -- p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
148: -- p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
149: -- p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
150: -- p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
151: -- p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
152: -- p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE
153: -- p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.action_parameters_rec_type

Line 150: -- p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

146: -- p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
147: -- p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
148: -- p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
149: -- p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
150: -- p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
151: -- p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
152: -- p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE
153: -- p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.action_parameters_rec_type
154: -- x_return_status OUT NOCOPY VARCHAR2

Line 151: -- p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

147: -- p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
148: -- p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
149: -- p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
150: -- p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
151: -- p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
152: -- p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE
153: -- p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.action_parameters_rec_type
154: -- x_return_status OUT NOCOPY VARCHAR2
155: -- =============================================================================

Line 152: -- p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE

148: -- p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
149: -- p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
150: -- p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
151: -- p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
152: -- p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE
153: -- p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.action_parameters_rec_type
154: -- x_return_status OUT NOCOPY VARCHAR2
155: -- =============================================================================
156: PROCEDURE initialize_txns(

Line 158: p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

154: -- x_return_status OUT NOCOPY VARCHAR2
155: -- =============================================================================
156: PROCEDURE initialize_txns(
157: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
158: p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
159: p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
160: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
161: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
162: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 159: p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

155: -- =============================================================================
156: PROCEDURE initialize_txns(
157: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
158: p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
159: p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
160: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
161: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
162: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
163: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 160: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

156: PROCEDURE initialize_txns(
157: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
158: p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
159: p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
160: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
161: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
162: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
163: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
164: p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

Line 161: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

157: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
158: p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
159: p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
160: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
161: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
162: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
163: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
164: p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
165: p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,

Line 162: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

158: p_index_dd_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
159: p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
160: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
161: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
162: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
163: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
164: p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
165: p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
166: p_shipment_header_id IN NUMBER,

Line 163: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

159: p_index_dd_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
160: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
161: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
162: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
163: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
164: p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
165: p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
166: p_shipment_header_id IN NUMBER,
167: x_return_status OUT NOCOPY VARCHAR2 );

Line 164: p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,

160: p_index_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
161: p_index_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
162: p_del_ids_del_ids_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
163: p_del_ids_del_ids_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
164: p_uniq_del_ids_tab IN OUT NOCOPY WSH_UTIL_CORE.ID_TAB_TYPE,
165: p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
166: p_shipment_header_id IN NUMBER,
167: x_return_status OUT NOCOPY VARCHAR2 );
168:

Line 181: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

177: -- =============================================================================
178: PROCEDURE reconfigure_del_trips(
179: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
180: p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
181: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
182: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
183: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
184: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
185: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 182: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

178: PROCEDURE reconfigure_del_trips(
179: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
180: p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
181: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
182: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
183: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
184: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
185: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
186: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 183: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

179: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
180: p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
181: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
182: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
183: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
184: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
185: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
186: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
187: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 184: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

180: p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
181: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
182: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
183: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
184: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
185: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
186: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
187: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
188: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 185: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

181: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
182: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
183: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
184: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
185: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
186: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
187: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
188: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
189: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 186: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

182: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
183: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
184: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
185: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
186: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
187: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
188: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
189: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
190: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 187: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

183: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
184: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
185: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
186: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
187: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
188: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
189: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
190: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
191: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 188: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

184: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
185: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
186: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
187: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
188: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
189: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
190: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
191: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
192: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 189: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

185: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
186: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
187: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
188: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
189: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
190: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
191: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
192: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
193: p_shipment_header_id IN NUMBER,

Line 190: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

186: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
187: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
188: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
189: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
190: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
191: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
192: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
193: p_shipment_header_id IN NUMBER,
194: x_return_status OUT NOCOPY VARCHAR2);

Line 191: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

187: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
188: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
189: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
190: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
191: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
192: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
193: p_shipment_header_id IN NUMBER,
194: x_return_status OUT NOCOPY VARCHAR2);
195:

Line 192: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

188: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
189: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
190: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
191: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
192: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
193: p_shipment_header_id IN NUMBER,
194: x_return_status OUT NOCOPY VARCHAR2);
195:
196: --=============================================================================

Line 234: -- p_del_ids IN wsh_util_core.id_tab_type

230: -- Function :
231: -- Pre-reqs : None.
232: -- Parameters :
233: -- action_code IN VARCHAR2
234: -- p_del_ids IN wsh_util_core.id_tab_type
235: -- p_trip_ids IN wsh_util_core.id_tab_type
236: -- p_stop_ids IN wsh_util_core.id_tab_type
237: -- p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
238: -- p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type

Line 235: -- p_trip_ids IN wsh_util_core.id_tab_type

231: -- Pre-reqs : None.
232: -- Parameters :
233: -- action_code IN VARCHAR2
234: -- p_del_ids IN wsh_util_core.id_tab_type
235: -- p_trip_ids IN wsh_util_core.id_tab_type
236: -- p_stop_ids IN wsh_util_core.id_tab_type
237: -- p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
238: -- p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type
239: -- p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type

Line 236: -- p_stop_ids IN wsh_util_core.id_tab_type

232: -- Parameters :
233: -- action_code IN VARCHAR2
234: -- p_del_ids IN wsh_util_core.id_tab_type
235: -- p_trip_ids IN wsh_util_core.id_tab_type
236: -- p_stop_ids IN wsh_util_core.id_tab_type
237: -- p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
238: -- p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type
239: -- p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type
240: -- p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,

Line 237: -- p_shipment_header_id_tab IN wsh_util_core.id_tab_type,

233: -- action_code IN VARCHAR2
234: -- p_del_ids IN wsh_util_core.id_tab_type
235: -- p_trip_ids IN wsh_util_core.id_tab_type
236: -- p_stop_ids IN wsh_util_core.id_tab_type
237: -- p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
238: -- p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type
239: -- p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type
240: -- p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
241: -- x_return_status OUT VARCHAR2

Line 238: -- p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type

234: -- p_del_ids IN wsh_util_core.id_tab_type
235: -- p_trip_ids IN wsh_util_core.id_tab_type
236: -- p_stop_ids IN wsh_util_core.id_tab_type
237: -- p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
238: -- p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type
239: -- p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type
240: -- p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
241: -- x_return_status OUT VARCHAR2
242: -- ============================================================================

Line 239: -- p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type

235: -- p_trip_ids IN wsh_util_core.id_tab_type
236: -- p_stop_ids IN wsh_util_core.id_tab_type
237: -- p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
238: -- p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type
239: -- p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type
240: -- p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
241: -- x_return_status OUT VARCHAR2
242: -- ============================================================================
243:

Line 246: p_del_ids IN wsh_util_core.id_tab_type,

242: -- ============================================================================
243:
244: PROCEDURE update_status (
245: p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
246: p_del_ids IN wsh_util_core.id_tab_type,
247: p_trip_ids IN wsh_util_core.id_tab_type,
248: p_stop_ids IN wsh_util_core.id_tab_type,
249: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
250: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,

Line 247: p_trip_ids IN wsh_util_core.id_tab_type,

243:
244: PROCEDURE update_status (
245: p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
246: p_del_ids IN wsh_util_core.id_tab_type,
247: p_trip_ids IN wsh_util_core.id_tab_type,
248: p_stop_ids IN wsh_util_core.id_tab_type,
249: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
250: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
251: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,

Line 248: p_stop_ids IN wsh_util_core.id_tab_type,

244: PROCEDURE update_status (
245: p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
246: p_del_ids IN wsh_util_core.id_tab_type,
247: p_trip_ids IN wsh_util_core.id_tab_type,
248: p_stop_ids IN wsh_util_core.id_tab_type,
249: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
250: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
251: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
252: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,

Line 249: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,

245: p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
246: p_del_ids IN wsh_util_core.id_tab_type,
247: p_trip_ids IN wsh_util_core.id_tab_type,
248: p_stop_ids IN wsh_util_core.id_tab_type,
249: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
250: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
251: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
252: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
253: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,

Line 250: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,

246: p_del_ids IN wsh_util_core.id_tab_type,
247: p_trip_ids IN wsh_util_core.id_tab_type,
248: p_stop_ids IN wsh_util_core.id_tab_type,
249: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
250: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
251: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
252: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
253: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
254: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 251: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,

247: p_trip_ids IN wsh_util_core.id_tab_type,
248: p_stop_ids IN wsh_util_core.id_tab_type,
249: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
250: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
251: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
252: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
253: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
254: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
255: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 252: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,

248: p_stop_ids IN wsh_util_core.id_tab_type,
249: p_shipment_header_id_tab IN wsh_util_core.id_tab_type,
250: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
251: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
252: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
253: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
254: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
255: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
256: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 254: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

250: p_initial_pickup_date_tab IN wsh_util_core.Date_Tab_Type ,
251: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
252: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
253: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
254: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
255: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
256: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
257: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
258: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 255: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

251: p_expected_receipt_date_tab IN wsh_util_core.Date_Tab_Type ,
252: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
253: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
254: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
255: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
256: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
257: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
258: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
259: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 256: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

252: p_rcv_carrier_id_tab IN wsh_util_core.Id_Tab_Type,
253: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
254: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
255: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
256: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
257: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
258: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
259: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
260: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 257: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

253: p_local_dd_rec IN LOCAL_DD_REC_TABLE_TYPE,
254: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
255: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
256: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
257: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
258: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
259: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
260: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
261: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 258: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

254: x_lpnGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
255: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
256: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
257: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
258: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
259: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
260: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
261: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
262: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 259: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

255: x_lpnGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
256: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
257: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
258: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
259: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
260: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
261: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
262: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
263: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 260: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

256: x_lpnNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
257: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
258: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
259: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
260: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
261: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
262: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
263: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
264: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 261: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

257: x_lpnNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
258: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
259: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
260: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
261: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
262: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
263: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
264: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
265: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

Line 262: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

258: x_lpnVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
259: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
260: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
261: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
262: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
263: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
264: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
265: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
266: x_return_status OUT NOCOPY VARCHAR2) ;

Line 263: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

259: x_lpnVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
260: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
261: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
262: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
263: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
264: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
265: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
266: x_return_status OUT NOCOPY VARCHAR2) ;
267:

Line 264: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

260: x_dlvyGWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
261: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
262: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
263: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
264: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
265: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
266: x_return_status OUT NOCOPY VARCHAR2) ;
267:
268: --=============================================================================

Line 265: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

261: x_dlvyGWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
262: x_dlvyNWTcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
263: x_dlvyNWTcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
264: x_dlvyVOLcachetbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
265: x_dlvyVOLcacheExttbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
266: x_return_status OUT NOCOPY VARCHAR2) ;
267:
268: --=============================================================================
269: -- API name : consolidate_qty

Line 275: -- p_sli_qty_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type

271: -- Function :
272: -- Pre-reqs : None.
273: -- Parameters :
274: -- p_consolidate_qty_rec IN OUT WSH_ASN_RECEIPT_PVT.consolidate_qty_rec_type
275: -- p_sli_qty_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
276: -- p_sli_qty_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
277: -- p_remaining_qty IN NUMBER
278: -- po_shipment_line_id IN NUMBER
279: -- x_return_status OUT VARCHAR2

Line 276: -- p_sli_qty_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type

272: -- Pre-reqs : None.
273: -- Parameters :
274: -- p_consolidate_qty_rec IN OUT WSH_ASN_RECEIPT_PVT.consolidate_qty_rec_type
275: -- p_sli_qty_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
276: -- p_sli_qty_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type
277: -- p_remaining_qty IN NUMBER
278: -- po_shipment_line_id IN NUMBER
279: -- x_return_status OUT VARCHAR2
280: -- ============================================================================

Line 283: p_sli_qty_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

279: -- x_return_status OUT VARCHAR2
280: -- ============================================================================
281:
282: PROCEDURE consolidate_qty(
283: p_sli_qty_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
284: p_sli_qty_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
285: p_remaining_qty IN OUT NOCOPY NUMBER,
286: po_shipment_line_id IN NUMBER,
287: x_return_status OUT NOCOPY VARCHAR2);

Line 284: p_sli_qty_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

280: -- ============================================================================
281:
282: PROCEDURE consolidate_qty(
283: p_sli_qty_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
284: p_sli_qty_ext_cache IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
285: p_remaining_qty IN OUT NOCOPY NUMBER,
286: po_shipment_line_id IN NUMBER,
287: x_return_status OUT NOCOPY VARCHAR2);
288:

Line 298: x_lpnIdCacheTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

294: p_net_weight IN NUMBER DEFAULT NULL,
295: p_volume IN NUMBER DEFAULT NULL,
296: x_release_status IN VARCHAR2,
297: l_update_dd_rec IN OUT NOCOPY update_dd_rec_type,
298: x_lpnIdCacheTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
299: x_lpnIdCacheExtTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
300: x_return_status OUT NOCOPY VARCHAR2);
301:
302:

Line 299: x_lpnIdCacheExtTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,

295: p_volume IN NUMBER DEFAULT NULL,
296: x_release_status IN VARCHAR2,
297: l_update_dd_rec IN OUT NOCOPY update_dd_rec_type,
298: x_lpnIdCacheTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
299: x_lpnIdCacheExtTbl IN OUT NOCOPY WSH_UTIL_CORE.key_value_tab_type,
300: x_return_status OUT NOCOPY VARCHAR2);
301:
302:
303: ---

Line 312: -- pack_ids IN OUT WSH_UTIL_CORE.id_tab_type

308: -- Pre-reqs : None.
309: -- Parameters :
310: -- p_local_dd_rec IN OUT LOCAL_DD_REC_TABLE_TYPE
311: -- l_loop_index IN NUMBER
312: -- pack_ids IN OUT WSH_UTIL_CORE.id_tab_type
313: -- curr_del IN OUT NUMBER
314: -- curr_bol IN OUT VARCHAR2
315: -- curr_lpn IN OUT NUMBER
316: -- l_psno IN OUT VARCHAR2

Line 322: -- temp_trips IN OUT WSH_UTIL_CORE.id_tab_type

318: -- l_use_lpns IN OUT NUMBER
319: -- l_psno_flag IN OUT NUMBER
320: -- l_trigger IN OUT NUMBER
321: -- l_waybill_flag IN OUT NUMBER
322: -- temp_trips IN OUT WSH_UTIL_CORE.id_tab_type
323: -- temp_dels IN OUT temp_dels_type
324: -- x_return_status OUT VARCHAR2
325: -- ============================================================================
326:

Line 331: pack_ids IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

327:
328: PROCEDURE create_update_waybill_psno_bol(
329: p_local_dd_rec IN OUT NOCOPY LOCAL_DD_REC_TABLE_TYPE,
330: l_loop_index IN NUMBER,
331: pack_ids IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
332: curr_del IN OUT NOCOPY NUMBER,
333: curr_bol IN OUT NOCOPY VARCHAR2,
334: curr_lpn IN OUT NOCOPY NUMBER,
335: curr_lpn_name IN OUT NOCOPY VARCHAR2,

Line 342: temp_dels IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,

338: l_waybill IN OUT NOCOPY VARCHAR2,
339: l_psno_flag IN OUT NOCOPY NUMBER,
340: l_trigger IN OUT NOCOPY NUMBER,
341: l_waybill_flag IN OUT NOCOPY NUMBER,
342: temp_dels IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
343: p_action_prms IN OUT NOCOPY wsh_glbl_var_strct_grp.dd_action_parameters_rec_type,
344: x_return_status OUT NOCOPY VARCHAR2
345: );
346: