APPS.WSH_OTM_OUTBOUND dependencies on WSH_OTM_DET_TAB

Line 13: PROCEDURE GET_DEL_DETAILS( p_all_details IN WSH_OTM_DET_TAB,

9: l_debugfile varchar2(2000);
10:
11:
12:
13: PROCEDURE GET_DEL_DETAILS( p_all_details IN WSH_OTM_DET_TAB,
14: p_delivery_id IN NUMBER,
15: x_del_details IN OUT NOCOPY WSH_OTM_DET_TAB) IS
16:
17: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_DEL_DETAILS';

Line 15: x_del_details IN OUT NOCOPY WSH_OTM_DET_TAB) IS

11:
12:
13: PROCEDURE GET_DEL_DETAILS( p_all_details IN WSH_OTM_DET_TAB,
14: p_delivery_id IN NUMBER,
15: x_del_details IN OUT NOCOPY WSH_OTM_DET_TAB) IS
16:
17: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_DEL_DETAILS';
18:
19: BEGIN

Line 855: l_all_details wsh_otm_det_tab;

851: -- Declare local variables
852:
853: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_DELIVERY_OBJECTS';
854: l_dlv_tab wsh_otm_dlv_tab;
855: l_all_details wsh_otm_det_tab;
856: l_del_details wsh_otm_det_tab;
857: l_rl_details wsh_otm_det_tab;
858: l_lpn_tab wsh_otm_lpn_tab;
859: l_packed_items WSH_OTM_LPN_CONT_TAB;

Line 856: l_del_details wsh_otm_det_tab;

852:
853: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_DELIVERY_OBJECTS';
854: l_dlv_tab wsh_otm_dlv_tab;
855: l_all_details wsh_otm_det_tab;
856: l_del_details wsh_otm_det_tab;
857: l_rl_details wsh_otm_det_tab;
858: l_lpn_tab wsh_otm_lpn_tab;
859: l_packed_items WSH_OTM_LPN_CONT_TAB;
860: l_loose_items_ids WSH_OTM_ID_TAB;

Line 857: l_rl_details wsh_otm_det_tab;

853: l_sub_module_name CONSTANT VARCHAR2(100) := 'wsh.plsql.' || G_PKG_NAME || '.' || 'GET_DELIVERY_OBJECTS';
854: l_dlv_tab wsh_otm_dlv_tab;
855: l_all_details wsh_otm_det_tab;
856: l_del_details wsh_otm_det_tab;
857: l_rl_details wsh_otm_det_tab;
858: l_lpn_tab wsh_otm_lpn_tab;
859: l_packed_items WSH_OTM_LPN_CONT_TAB;
860: l_loose_items_ids WSH_OTM_ID_TAB;
861: l_dlv_obj wsh_otm_dlv_obj;

Line 1091: l_all_details := wsh_otm_det_tab();

1087: WSH_UTIL_CORE.OpenDynamicCursor(c_deliveries, l_deliveries_sql, bind_col_tab);
1088: l_count := 1;
1089: l_dlv_tab := wsh_otm_dlv_tab();
1090: --l_all_details - contains the delivery details of all the deliveries queried.
1091: l_all_details := wsh_otm_det_tab();
1092: -- 6922924
1093: l_good_dlv_tab := wsh_otm_dlv_tab();
1094:
1095: --l_dlv_obj := wsh_otm_dlv_obj();

Line 1217: l_del_details := wsh_otm_det_tab();

1213:
1214:
1215: --l_del_details - contains the delivery details of the delivery l_dlv_tab(i).delivery_id
1216:
1217: l_del_details := wsh_otm_det_tab();
1218: get_del_details(l_all_details,l_dlv_tab(i).delivery_id,l_del_details);
1219:
1220:
1221:

Line 1223: l_rl_details := wsh_otm_det_tab();

1219:
1220:
1221:
1222:
1223: l_rl_details := wsh_otm_det_tab();
1224: l_lpn_tab := wsh_otm_lpn_tab();
1225: l_all_lpn_tab := l_dummy_lpn_tab;
1226: l_total_quantity := 0;
1227: