APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_EXTERNAL_INTERFACE_SV

Line 6696: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

6692:
6693: IF l_is_del_eligible
6694: THEN
6695: --{
6696: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
6697: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
6698: x_return_status => l_return_status,
6699: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
6700: p_msg_display => 'N');

Line 6727: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

6723: END IF;
6724: --
6725: ELSIF ( p_action ='GEN-LOAD-SEQ' ) THEN
6726: IF ( l_status_code IN ('SR', 'SC') AND l_planned_flag IN ('Y','F') ) THEN
6727: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
6728: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
6729: x_return_status => l_return_status,
6730: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
6731: p_msg_display => 'N');

Line 6755: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

6751: Fetch del_to_det_cur into l_tpw_temp;
6752: close del_to_det_cur;
6753:
6754: IF ( l_tpw_temp is null ) THEN
6755: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
6756: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
6757: x_return_status => l_return_status,
6758: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
6759: p_msg_display => 'N');

Line 6776: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

6772: ELSE
6773: raise e_record_ineligible;
6774: END IF; -- IF ( l_tpw_temp is null )
6775: ELSE
6776: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
6777: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
6778: x_return_status => l_return_status,
6779: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
6780: p_msg_display => 'N');

Line 6795: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type (

6791: END IF;
6792: END IF; --IF ( l_status_code = 'CO' )
6793:
6794: ELSIF ( p_action ='CONFIRM' ) THEN
6795: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type (
6796: p_organization_id => p_dlvy_rec_tab(j).organization_id,
6797: x_return_status => l_return_status,
6798: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
6799: p_msg_display => 'N');

Line 6835: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

6831: x_valid_index_tab(j) := j;
6832: END IF; --IF ( nvl(l_wh_type,
6833:
6834: ELSIF (p_action IN ('OUTBOUND-DOCUMENT','TRANSACTION-HISTORY-UI') ) THEN
6835: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
6836: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
6837: x_return_status => l_return_status,
6838: p_delivery_id => p_dlvy_rec_tab(j).delivery_id);
6839:

Line 6894: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

6890: THEN
6891: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
6892: x_valid_index_tab(j) := j;
6893: ELSE
6894: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
6895: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
6896: x_return_status => l_return_status,
6897: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
6898: p_msg_display => 'N');

Line 6940: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

6936: IF ( l_atd_tpw_temp is not null ) THEN
6937: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
6938: x_valid_index_tab(j) := j;
6939: ELSE
6940: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
6941: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
6942: x_return_status => l_return_status,
6943: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
6944: p_msg_display => 'N');