APPS.WSH_DELIVERY_VALIDATIONS dependencies on WSH_EXTERNAL_INTERFACE_SV

Line 6871: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

6867:
6868: IF l_is_del_eligible
6869: THEN
6870: --{
6871: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
6872: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
6873: x_return_status => l_return_status,
6874: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
6875: p_msg_display => 'N');

Line 6902: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

6898: END IF;
6899: --
6900: ELSIF ( p_action ='GEN-LOAD-SEQ' ) THEN
6901: IF ( l_status_code IN ('SR', 'SC') AND l_planned_flag IN ('Y','F') ) THEN
6902: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
6903: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
6904: x_return_status => l_return_status,
6905: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
6906: p_msg_display => 'N');

Line 6930: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

6926: Fetch del_to_det_cur into l_tpw_temp;
6927: close del_to_det_cur;
6928:
6929: IF ( l_tpw_temp is null ) THEN
6930: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
6931: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
6932: x_return_status => l_return_status,
6933: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
6934: p_msg_display => 'N');

Line 6951: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

6947: ELSE
6948: raise e_record_ineligible;
6949: END IF; -- IF ( l_tpw_temp is null )
6950: ELSE
6951: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
6952: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
6953: x_return_status => l_return_status,
6954: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
6955: p_msg_display => 'N');

Line 6970: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type (

6966: END IF;
6967: END IF; --IF ( l_status_code = 'CO' )
6968:
6969: ELSIF ( p_action ='CONFIRM' ) THEN
6970: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type (
6971: p_organization_id => p_dlvy_rec_tab(j).organization_id,
6972: x_return_status => l_return_status,
6973: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
6974: p_msg_display => 'N');

Line 7019: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

7015: --R12.1.1 STANDALONE PROJECT
7016: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
7017: x_valid_index_tab(j) := j;
7018: ELSE
7019: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
7020: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
7021: x_return_status => l_return_status,
7022: p_delivery_id => p_dlvy_rec_tab(j).delivery_id);
7023:

Line 7094: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

7090: THEN
7091: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
7092: x_valid_index_tab(j) := j;
7093: ELSE
7094: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
7095: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
7096: x_return_status => l_return_status,
7097: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
7098: p_msg_display => 'N');

Line 7140: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type

7136: IF ( l_atd_tpw_temp is not null ) THEN
7137: x_valid_ids(x_valid_ids.COUNT + 1) := p_dlvy_rec_tab(j).delivery_id;
7138: x_valid_index_tab(j) := j;
7139: ELSE
7140: l_wh_type := WSH_EXTERNAL_INTERFACE_SV.Get_Warehouse_Type
7141: (p_organization_id => p_dlvy_rec_tab(j).organization_id,
7142: x_return_status => l_return_status,
7143: p_delivery_id => p_dlvy_rec_tab(j).delivery_id,
7144: p_msg_display => 'N');