DBA Data[Home] [Help]

APPS.WSH_PROCESS_INTERFACED_PKG dependencies on WSH_DELIVERY_DETAILS_INV

Line 1876: wsh_delivery_details_inv.validate_subinventory (p_subinventory => delivery_detail_rec.subinventory,

1872: IF (p_document_type = 'SR')
1873: THEN
1874: IF (delivery_detail_rec.subinventory IS NOT NULL)
1875: THEN
1876: wsh_delivery_details_inv.validate_subinventory (p_subinventory => delivery_detail_rec.subinventory,
1877: p_organization_id => l_det_org_id,
1878: p_inventory_item_id => l_inventory_item_id,
1879: x_return_status => x_return_status,
1880: x_result => x_result);

Line 1892: wsh_delivery_details_inv.validate_revision (delivery_detail_rec.revision,

1888: END IF;
1889:
1890: IF (delivery_detail_rec.revision IS NOT NULL)
1891: THEN
1892: wsh_delivery_details_inv.validate_revision (delivery_detail_rec.revision,
1893: l_det_org_id,
1894: l_inventory_item_id,
1895: x_return_status,
1896: x_result

Line 1909: wsh_delivery_details_inv.validate_lot_number (p_lot_number => delivery_detail_rec.lot_number,

1905: END IF;
1906:
1907: IF (delivery_detail_rec.lot_number IS NOT NULL)
1908: THEN
1909: wsh_delivery_details_inv.validate_lot_number (p_lot_number => delivery_detail_rec.lot_number,
1910: p_organization_id => l_det_org_id,
1911: p_inventory_item_id => l_inventory_item_id,
1912: p_subinventory => delivery_detail_rec.subinventory,
1913: p_revision => delivery_detail_rec.revision,

Line 1964: p_api_name => 'wsh_delivery_details_inv.validate_lot_number',

1960: interface_errors_rec.p_interface_table_name := 'WSH_DEL_DETAILS_INTERFACE';
1961: interface_errors_rec.p_interface_id := delivery_detail_rec.delivery_detail_interface_id;
1962: wsh_interface_validations_pkg.log_interface_errors (
1963: p_interface_errors_rec =>interface_errors_rec,
1964: p_api_name => 'wsh_delivery_details_inv.validate_lot_number',
1965: x_return_status =>x_return_status);
1966: IF l_debug_on THEN
1967: wsh_debug_sv.log (l_module_name, 'log_interface_errors x_return_status', x_return_status);
1968: END IF;

Line 1980: l_org_loc_code := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_org_id);

1976: OPEN Get_Inv_Controls (L_Inventory_Item_ID,L_Det_org_ID);
1977: FETCH Get_Inv_Controls INTO l_loc_flag,l_restrict_loc_code,l_restrict_sub_code,l_location_control_code,l_reservable_type,l_txn_enabled_flag ;
1978: CLOSE Get_Inv_Controls;
1979:
1980: l_org_loc_code := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_org_id);
1981: l_sub_loc_code := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (delivery_detail_rec.subinventory,l_org_id);
1982: l_loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(l_org_id,
1983: l_restrict_loc_code,
1984: l_org_loc_code,

Line 1981: l_sub_loc_code := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (delivery_detail_rec.subinventory,l_org_id);

1977: FETCH Get_Inv_Controls INTO l_loc_flag,l_restrict_loc_code,l_restrict_sub_code,l_location_control_code,l_reservable_type,l_txn_enabled_flag ;
1978: CLOSE Get_Inv_Controls;
1979:
1980: l_org_loc_code := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_org_id);
1981: l_sub_loc_code := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (delivery_detail_rec.subinventory,l_org_id);
1982: l_loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(l_org_id,
1983: l_restrict_loc_code,
1984: l_org_loc_code,
1985: l_sub_loc_code,

Line 1982: l_loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(l_org_id,

1978: CLOSE Get_Inv_Controls;
1979:
1980: l_org_loc_code := WSH_DELIVERY_DETAILS_INV.Get_Org_Loc (l_org_id);
1981: l_sub_loc_code := WSH_DELIVERY_DETAILS_INV.Sub_Loc_Ctl (delivery_detail_rec.subinventory,l_org_id);
1982: l_loc_ctl_code := WSH_DELIVERY_DETAILS_INV.Locator_Ctl_Code(l_org_id,
1983: l_restrict_loc_code,
1984: l_org_loc_code,
1985: l_sub_loc_code,
1986: l_location_control_code);